Merge lp:~laurynas-biveinis/percona-server/bug714925-5.6 into lp:percona-server/5.6
- bug714925-5.6
- Merge into 5.6
Proposed by
Laurynas Biveinis
Status: | Merged | ||||
---|---|---|---|---|---|
Merged at revision: | 370 | ||||
Proposed branch: | lp:~laurynas-biveinis/percona-server/bug714925-5.6 | ||||
Merge into: | lp:percona-server/5.6 | ||||
Diff against target: |
748 lines (+346/-270) 2 files modified
Percona-Server/mysql-test/suite/funcs_1/r/is_columns_is.result (+136/-136) Percona-Server/sql/sql_show.cc (+210/-134) |
||||
To merge this branch: | bzr merge lp:~laurynas-biveinis/percona-server/bug714925-5.6 | ||||
Related bugs: |
|
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Vlad Lesin (community) | Approve | ||
Review via email: mp+166643@code.launchpad.net |
Commit message
Description of the change
Merge bug 714925 fix.
ST 32205.
http://
To post a comment you must log in.
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote : | # |
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote : | # |
Revision history for this message
Vlad Lesin (vlad-lesin) : | # |
review:
Approve
Preview Diff
[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1 | === modified file 'Percona-Server/mysql-test/suite/funcs_1/r/is_columns_is.result' | |||
2 | --- Percona-Server/mysql-test/suite/funcs_1/r/is_columns_is.result 2013-05-10 09:39:17 +0000 | |||
3 | +++ Percona-Server/mysql-test/suite/funcs_1/r/is_columns_is.result 2013-05-31 04:35:35 +0000 | |||
4 | @@ -7,28 +7,28 @@ | |||
5 | 7 | def information_schema CHARACTER_SETS DEFAULT_COLLATE_NAME 2 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select | 7 | def information_schema CHARACTER_SETS DEFAULT_COLLATE_NAME 2 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select |
6 | 8 | def information_schema CHARACTER_SETS DESCRIPTION 3 NO varchar 60 180 NULL NULL NULL utf8 utf8_general_ci varchar(60) select | 8 | def information_schema CHARACTER_SETS DESCRIPTION 3 NO varchar 60 180 NULL NULL NULL utf8 utf8_general_ci varchar(60) select |
7 | 9 | def information_schema CHARACTER_SETS MAXLEN 4 0 NO bigint NULL NULL 19 0 NULL NULL NULL bigint(3) select | 9 | def information_schema CHARACTER_SETS MAXLEN 4 0 NO bigint NULL NULL 19 0 NULL NULL NULL bigint(3) select |
13 | 10 | def information_schema CLIENT_STATISTICS ACCESS_DENIED 20 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 10 | def information_schema CLIENT_STATISTICS ACCESS_DENIED 20 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
14 | 11 | def information_schema CLIENT_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 11 | def information_schema CLIENT_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
15 | 12 | def information_schema CLIENT_STATISTICS BUSY_TIME 5 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 12 | def information_schema CLIENT_STATISTICS BUSY_TIME 5 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
16 | 13 | def information_schema CLIENT_STATISTICS BYTES_RECEIVED 7 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 13 | def information_schema CLIENT_STATISTICS BYTES_RECEIVED 7 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
17 | 14 | def information_schema CLIENT_STATISTICS BYTES_SENT 8 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 14 | def information_schema CLIENT_STATISTICS BYTES_SENT 8 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
18 | 15 | def information_schema CLIENT_STATISTICS CLIENT 1 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select | 15 | def information_schema CLIENT_STATISTICS CLIENT 1 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select |
35 | 16 | def information_schema CLIENT_STATISTICS COMMIT_TRANSACTIONS 16 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 16 | def information_schema CLIENT_STATISTICS COMMIT_TRANSACTIONS 16 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
36 | 17 | def information_schema CLIENT_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 17 | def information_schema CLIENT_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
37 | 18 | def information_schema CLIENT_STATISTICS CONNECTED_TIME 4 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 18 | def information_schema CLIENT_STATISTICS CONNECTED_TIME 4 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
38 | 19 | def information_schema CLIENT_STATISTICS CPU_TIME 6 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 19 | def information_schema CLIENT_STATISTICS CPU_TIME 6 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
39 | 20 | def information_schema CLIENT_STATISTICS DENIED_CONNECTIONS 18 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 20 | def information_schema CLIENT_STATISTICS DENIED_CONNECTIONS 18 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
40 | 21 | def information_schema CLIENT_STATISTICS EMPTY_QUERIES 21 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 21 | def information_schema CLIENT_STATISTICS EMPTY_QUERIES 21 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
41 | 22 | def information_schema CLIENT_STATISTICS LOST_CONNECTIONS 19 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 22 | def information_schema CLIENT_STATISTICS LOST_CONNECTIONS 19 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
42 | 23 | def information_schema CLIENT_STATISTICS OTHER_COMMANDS 15 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 23 | def information_schema CLIENT_STATISTICS OTHER_COMMANDS 15 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
43 | 24 | def information_schema CLIENT_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 24 | def information_schema CLIENT_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
44 | 25 | def information_schema CLIENT_STATISTICS ROWS_FETCHED 10 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 25 | def information_schema CLIENT_STATISTICS ROWS_FETCHED 10 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
45 | 26 | def information_schema CLIENT_STATISTICS ROWS_UPDATED 11 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 26 | def information_schema CLIENT_STATISTICS ROWS_UPDATED 11 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
46 | 27 | def information_schema CLIENT_STATISTICS SELECT_COMMANDS 13 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 27 | def information_schema CLIENT_STATISTICS SELECT_COMMANDS 13 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
47 | 28 | def information_schema CLIENT_STATISTICS TABLE_ROWS_READ 12 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 28 | def information_schema CLIENT_STATISTICS TABLE_ROWS_READ 12 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
48 | 29 | def information_schema CLIENT_STATISTICS TOTAL_CONNECTIONS 2 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 29 | def information_schema CLIENT_STATISTICS TOTAL_CONNECTIONS 2 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
49 | 30 | def information_schema CLIENT_STATISTICS TOTAL_SSL_CONNECTIONS 22 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 30 | def information_schema CLIENT_STATISTICS TOTAL_SSL_CONNECTIONS 22 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
50 | 31 | def information_schema CLIENT_STATISTICS UPDATE_COMMANDS 14 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 31 | def information_schema CLIENT_STATISTICS UPDATE_COMMANDS 14 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
51 | 32 | def information_schema COLLATIONS CHARACTER_SET_NAME 2 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select | 32 | def information_schema COLLATIONS CHARACTER_SET_NAME 2 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select |
52 | 33 | def information_schema COLLATIONS COLLATION_NAME 1 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select | 33 | def information_schema COLLATIONS COLLATION_NAME 1 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select |
53 | 34 | def information_schema COLLATIONS ID 3 0 NO bigint NULL NULL 19 0 NULL NULL NULL bigint(11) select | 34 | def information_schema COLLATIONS ID 3 0 NO bigint NULL NULL 19 0 NULL NULL NULL bigint(11) select |
54 | @@ -148,7 +148,7 @@ | |||
55 | 148 | def information_schema GLOBAL_VARIABLES VARIABLE_NAME 1 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select | 148 | def information_schema GLOBAL_VARIABLES VARIABLE_NAME 1 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select |
56 | 149 | def information_schema GLOBAL_VARIABLES VARIABLE_VALUE 2 NULL YES varchar 1024 3072 NULL NULL NULL utf8 utf8_general_ci varchar(1024) select | 149 | def information_schema GLOBAL_VARIABLES VARIABLE_VALUE 2 NULL YES varchar 1024 3072 NULL NULL NULL utf8 utf8_general_ci varchar(1024) select |
57 | 150 | def information_schema INDEX_STATISTICS INDEX_NAME 3 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select | 150 | def information_schema INDEX_STATISTICS INDEX_NAME 3 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select |
59 | 151 | def information_schema INDEX_STATISTICS ROWS_READ 4 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 151 | def information_schema INDEX_STATISTICS ROWS_READ 4 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
60 | 152 | def information_schema INDEX_STATISTICS TABLE_NAME 2 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select | 152 | def information_schema INDEX_STATISTICS TABLE_NAME 2 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select |
61 | 153 | def information_schema INDEX_STATISTICS TABLE_SCHEMA 1 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select | 153 | def information_schema INDEX_STATISTICS TABLE_SCHEMA 1 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select |
62 | 154 | def information_schema KEY_COLUMN_USAGE COLUMN_NAME 7 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select | 154 | def information_schema KEY_COLUMN_USAGE COLUMN_NAME 7 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select |
63 | @@ -344,9 +344,9 @@ | |||
64 | 344 | def information_schema TABLE_PRIVILEGES TABLE_CATALOG 2 NO varchar 512 1536 NULL NULL NULL utf8 utf8_general_ci varchar(512) select | 344 | def information_schema TABLE_PRIVILEGES TABLE_CATALOG 2 NO varchar 512 1536 NULL NULL NULL utf8 utf8_general_ci varchar(512) select |
65 | 345 | def information_schema TABLE_PRIVILEGES TABLE_NAME 4 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select | 345 | def information_schema TABLE_PRIVILEGES TABLE_NAME 4 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select |
66 | 346 | def information_schema TABLE_PRIVILEGES TABLE_SCHEMA 3 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select | 346 | def information_schema TABLE_PRIVILEGES TABLE_SCHEMA 3 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select |
70 | 347 | def information_schema TABLE_STATISTICS ROWS_CHANGED 4 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 347 | def information_schema TABLE_STATISTICS ROWS_CHANGED 4 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
71 | 348 | def information_schema TABLE_STATISTICS ROWS_CHANGED_X_INDEXES 5 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 348 | def information_schema TABLE_STATISTICS ROWS_CHANGED_X_INDEXES 5 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
72 | 349 | def information_schema TABLE_STATISTICS ROWS_READ 3 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 349 | def information_schema TABLE_STATISTICS ROWS_READ 3 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
73 | 350 | def information_schema TABLE_STATISTICS TABLE_NAME 2 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select | 350 | def information_schema TABLE_STATISTICS TABLE_NAME 2 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select |
74 | 351 | def information_schema TABLE_STATISTICS TABLE_SCHEMA 1 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select | 351 | def information_schema TABLE_STATISTICS TABLE_SCHEMA 1 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select |
75 | 352 | def information_schema TEMPORARY_TABLES AVG_ROW_LENGTH 7 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select | 352 | def information_schema TEMPORARY_TABLES AVG_ROW_LENGTH 7 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
76 | @@ -360,28 +360,28 @@ | |||
77 | 360 | def information_schema TEMPORARY_TABLES TABLE_ROWS 6 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select | 360 | def information_schema TEMPORARY_TABLES TABLE_ROWS 6 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
78 | 361 | def information_schema TEMPORARY_TABLES TABLE_SCHEMA 2 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select | 361 | def information_schema TEMPORARY_TABLES TABLE_SCHEMA 2 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select |
79 | 362 | def information_schema TEMPORARY_TABLES UPDATE_TIME 11 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select | 362 | def information_schema TEMPORARY_TABLES UPDATE_TIME 11 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select |
102 | 363 | def information_schema THREAD_STATISTICS ACCESS_DENIED 20 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 363 | def information_schema THREAD_STATISTICS ACCESS_DENIED 20 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
103 | 364 | def information_schema THREAD_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 364 | def information_schema THREAD_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
104 | 365 | def information_schema THREAD_STATISTICS BUSY_TIME 5 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 365 | def information_schema THREAD_STATISTICS BUSY_TIME 5 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
105 | 366 | def information_schema THREAD_STATISTICS BYTES_RECEIVED 7 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 366 | def information_schema THREAD_STATISTICS BYTES_RECEIVED 7 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
106 | 367 | def information_schema THREAD_STATISTICS BYTES_SENT 8 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 367 | def information_schema THREAD_STATISTICS BYTES_SENT 8 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
107 | 368 | def information_schema THREAD_STATISTICS COMMIT_TRANSACTIONS 16 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 368 | def information_schema THREAD_STATISTICS COMMIT_TRANSACTIONS 16 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
108 | 369 | def information_schema THREAD_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 369 | def information_schema THREAD_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
109 | 370 | def information_schema THREAD_STATISTICS CONNECTED_TIME 4 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 370 | def information_schema THREAD_STATISTICS CONNECTED_TIME 4 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
110 | 371 | def information_schema THREAD_STATISTICS CPU_TIME 6 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 371 | def information_schema THREAD_STATISTICS CPU_TIME 6 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
111 | 372 | def information_schema THREAD_STATISTICS DENIED_CONNECTIONS 18 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 372 | def information_schema THREAD_STATISTICS DENIED_CONNECTIONS 18 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
112 | 373 | def information_schema THREAD_STATISTICS EMPTY_QUERIES 21 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 373 | def information_schema THREAD_STATISTICS EMPTY_QUERIES 21 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
113 | 374 | def information_schema THREAD_STATISTICS LOST_CONNECTIONS 19 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 374 | def information_schema THREAD_STATISTICS LOST_CONNECTIONS 19 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
114 | 375 | def information_schema THREAD_STATISTICS OTHER_COMMANDS 15 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 375 | def information_schema THREAD_STATISTICS OTHER_COMMANDS 15 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
115 | 376 | def information_schema THREAD_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 376 | def information_schema THREAD_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
116 | 377 | def information_schema THREAD_STATISTICS ROWS_FETCHED 10 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 377 | def information_schema THREAD_STATISTICS ROWS_FETCHED 10 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
117 | 378 | def information_schema THREAD_STATISTICS ROWS_UPDATED 11 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 378 | def information_schema THREAD_STATISTICS ROWS_UPDATED 11 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
118 | 379 | def information_schema THREAD_STATISTICS SELECT_COMMANDS 13 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 379 | def information_schema THREAD_STATISTICS SELECT_COMMANDS 13 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
119 | 380 | def information_schema THREAD_STATISTICS TABLE_ROWS_READ 12 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 380 | def information_schema THREAD_STATISTICS TABLE_ROWS_READ 12 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
120 | 381 | def information_schema THREAD_STATISTICS THREAD_ID 1 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 381 | def information_schema THREAD_STATISTICS THREAD_ID 1 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
121 | 382 | def information_schema THREAD_STATISTICS TOTAL_CONNECTIONS 2 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 382 | def information_schema THREAD_STATISTICS TOTAL_CONNECTIONS 2 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
122 | 383 | def information_schema THREAD_STATISTICS TOTAL_SSL_CONNECTIONS 22 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 383 | def information_schema THREAD_STATISTICS TOTAL_SSL_CONNECTIONS 22 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
123 | 384 | def information_schema THREAD_STATISTICS UPDATE_COMMANDS 14 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 384 | def information_schema THREAD_STATISTICS UPDATE_COMMANDS 14 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
124 | 385 | def information_schema TRIGGERS ACTION_CONDITION 9 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8 utf8_general_ci longtext select | 385 | def information_schema TRIGGERS ACTION_CONDITION 9 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8 utf8_general_ci longtext select |
125 | 386 | def information_schema TRIGGERS ACTION_ORDER 8 0 NO bigint NULL NULL 19 0 NULL NULL NULL bigint(4) select | 386 | def information_schema TRIGGERS ACTION_ORDER 8 0 NO bigint NULL NULL 19 0 NULL NULL NULL bigint(4) select |
126 | 387 | def information_schema TRIGGERS ACTION_ORIENTATION 11 NO varchar 9 27 NULL NULL NULL utf8 utf8_general_ci varchar(9) select | 387 | def information_schema TRIGGERS ACTION_ORIENTATION 11 NO varchar 9 27 NULL NULL NULL utf8 utf8_general_ci varchar(9) select |
127 | @@ -408,27 +408,27 @@ | |||
128 | 408 | def information_schema USER_PRIVILEGES IS_GRANTABLE 4 NO varchar 3 9 NULL NULL NULL utf8 utf8_general_ci varchar(3) select | 408 | def information_schema USER_PRIVILEGES IS_GRANTABLE 4 NO varchar 3 9 NULL NULL NULL utf8 utf8_general_ci varchar(3) select |
129 | 409 | def information_schema USER_PRIVILEGES PRIVILEGE_TYPE 3 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select | 409 | def information_schema USER_PRIVILEGES PRIVILEGE_TYPE 3 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select |
130 | 410 | def information_schema USER_PRIVILEGES TABLE_CATALOG 2 NO varchar 512 1536 NULL NULL NULL utf8 utf8_general_ci varchar(512) select | 410 | def information_schema USER_PRIVILEGES TABLE_CATALOG 2 NO varchar 512 1536 NULL NULL NULL utf8 utf8_general_ci varchar(512) select |
152 | 411 | def information_schema USER_STATISTICS ACCESS_DENIED 20 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 411 | def information_schema USER_STATISTICS ACCESS_DENIED 20 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
153 | 412 | def information_schema USER_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 412 | def information_schema USER_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
154 | 413 | def information_schema USER_STATISTICS BUSY_TIME 5 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 413 | def information_schema USER_STATISTICS BUSY_TIME 5 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
155 | 414 | def information_schema USER_STATISTICS BYTES_RECEIVED 7 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 414 | def information_schema USER_STATISTICS BYTES_RECEIVED 7 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
156 | 415 | def information_schema USER_STATISTICS BYTES_SENT 8 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 415 | def information_schema USER_STATISTICS BYTES_SENT 8 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
157 | 416 | def information_schema USER_STATISTICS COMMIT_TRANSACTIONS 16 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 416 | def information_schema USER_STATISTICS COMMIT_TRANSACTIONS 16 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
158 | 417 | def information_schema USER_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 417 | def information_schema USER_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
159 | 418 | def information_schema USER_STATISTICS CONNECTED_TIME 4 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 418 | def information_schema USER_STATISTICS CONNECTED_TIME 4 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
160 | 419 | def information_schema USER_STATISTICS CPU_TIME 6 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 419 | def information_schema USER_STATISTICS CPU_TIME 6 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
161 | 420 | def information_schema USER_STATISTICS DENIED_CONNECTIONS 18 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 420 | def information_schema USER_STATISTICS DENIED_CONNECTIONS 18 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
162 | 421 | def information_schema USER_STATISTICS EMPTY_QUERIES 21 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 421 | def information_schema USER_STATISTICS EMPTY_QUERIES 21 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
163 | 422 | def information_schema USER_STATISTICS LOST_CONNECTIONS 19 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 422 | def information_schema USER_STATISTICS LOST_CONNECTIONS 19 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
164 | 423 | def information_schema USER_STATISTICS OTHER_COMMANDS 15 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 423 | def information_schema USER_STATISTICS OTHER_COMMANDS 15 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
165 | 424 | def information_schema USER_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 424 | def information_schema USER_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
166 | 425 | def information_schema USER_STATISTICS ROWS_FETCHED 10 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 425 | def information_schema USER_STATISTICS ROWS_FETCHED 10 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
167 | 426 | def information_schema USER_STATISTICS ROWS_UPDATED 11 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 426 | def information_schema USER_STATISTICS ROWS_UPDATED 11 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
168 | 427 | def information_schema USER_STATISTICS SELECT_COMMANDS 13 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 427 | def information_schema USER_STATISTICS SELECT_COMMANDS 13 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
169 | 428 | def information_schema USER_STATISTICS TABLE_ROWS_READ 12 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 428 | def information_schema USER_STATISTICS TABLE_ROWS_READ 12 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
170 | 429 | def information_schema USER_STATISTICS TOTAL_CONNECTIONS 2 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 429 | def information_schema USER_STATISTICS TOTAL_CONNECTIONS 2 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
171 | 430 | def information_schema USER_STATISTICS TOTAL_SSL_CONNECTIONS 22 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 430 | def information_schema USER_STATISTICS TOTAL_SSL_CONNECTIONS 22 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
172 | 431 | def information_schema USER_STATISTICS UPDATE_COMMANDS 14 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select | 431 | def information_schema USER_STATISTICS UPDATE_COMMANDS 14 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select |
173 | 432 | def information_schema USER_STATISTICS USER 1 NO varchar 48 144 NULL NULL NULL utf8 utf8_general_ci varchar(48) select | 432 | def information_schema USER_STATISTICS USER 1 NO varchar 48 144 NULL NULL NULL utf8 utf8_general_ci varchar(48) select |
174 | 433 | def information_schema VIEWS CHARACTER_SET_CLIENT 9 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select | 433 | def information_schema VIEWS CHARACTER_SET_CLIENT 9 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select |
175 | 434 | def information_schema VIEWS CHECK_OPTION 5 NO varchar 8 24 NULL NULL NULL utf8 utf8_general_ci varchar(8) select | 434 | def information_schema VIEWS CHECK_OPTION 5 NO varchar 8 24 NULL NULL NULL utf8 utf8_general_ci varchar(8) select |
176 | @@ -518,27 +518,27 @@ | |||
177 | 518 | 3.0000 information_schema CHARACTER_SETS DESCRIPTION varchar 60 180 utf8 utf8_general_ci varchar(60) | 518 | 3.0000 information_schema CHARACTER_SETS DESCRIPTION varchar 60 180 utf8 utf8_general_ci varchar(60) |
178 | 519 | NULL information_schema CHARACTER_SETS MAXLEN bigint NULL NULL NULL NULL bigint(3) | 519 | NULL information_schema CHARACTER_SETS MAXLEN bigint NULL NULL NULL NULL bigint(3) |
179 | 520 | 3.0000 information_schema CLIENT_STATISTICS CLIENT varchar 64 192 utf8 utf8_general_ci varchar(64) | 520 | 3.0000 information_schema CLIENT_STATISTICS CLIENT varchar 64 192 utf8 utf8_general_ci varchar(64) |
201 | 521 | NULL information_schema CLIENT_STATISTICS TOTAL_CONNECTIONS int NULL NULL NULL NULL int(21) | 521 | NULL information_schema CLIENT_STATISTICS TOTAL_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
202 | 522 | NULL information_schema CLIENT_STATISTICS CONCURRENT_CONNECTIONS int NULL NULL NULL NULL int(21) | 522 | NULL information_schema CLIENT_STATISTICS CONCURRENT_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
203 | 523 | NULL information_schema CLIENT_STATISTICS CONNECTED_TIME int NULL NULL NULL NULL int(21) | 523 | NULL information_schema CLIENT_STATISTICS CONNECTED_TIME bigint NULL NULL NULL NULL bigint(21) unsigned |
204 | 524 | NULL information_schema CLIENT_STATISTICS BUSY_TIME int NULL NULL NULL NULL int(21) | 524 | NULL information_schema CLIENT_STATISTICS BUSY_TIME bigint NULL NULL NULL NULL bigint(21) unsigned |
205 | 525 | NULL information_schema CLIENT_STATISTICS CPU_TIME int NULL NULL NULL NULL int(21) | 525 | NULL information_schema CLIENT_STATISTICS CPU_TIME bigint NULL NULL NULL NULL bigint(21) unsigned |
206 | 526 | NULL information_schema CLIENT_STATISTICS BYTES_RECEIVED int NULL NULL NULL NULL int(21) | 526 | NULL information_schema CLIENT_STATISTICS BYTES_RECEIVED bigint NULL NULL NULL NULL bigint(21) unsigned |
207 | 527 | NULL information_schema CLIENT_STATISTICS BYTES_SENT int NULL NULL NULL NULL int(21) | 527 | NULL information_schema CLIENT_STATISTICS BYTES_SENT bigint NULL NULL NULL NULL bigint(21) unsigned |
208 | 528 | NULL information_schema CLIENT_STATISTICS BINLOG_BYTES_WRITTEN int NULL NULL NULL NULL int(21) | 528 | NULL information_schema CLIENT_STATISTICS BINLOG_BYTES_WRITTEN bigint NULL NULL NULL NULL bigint(21) unsigned |
209 | 529 | NULL information_schema CLIENT_STATISTICS ROWS_FETCHED int NULL NULL NULL NULL int(21) | 529 | NULL information_schema CLIENT_STATISTICS ROWS_FETCHED bigint NULL NULL NULL NULL bigint(21) unsigned |
210 | 530 | NULL information_schema CLIENT_STATISTICS ROWS_UPDATED int NULL NULL NULL NULL int(21) | 530 | NULL information_schema CLIENT_STATISTICS ROWS_UPDATED bigint NULL NULL NULL NULL bigint(21) unsigned |
211 | 531 | NULL information_schema CLIENT_STATISTICS TABLE_ROWS_READ int NULL NULL NULL NULL int(21) | 531 | NULL information_schema CLIENT_STATISTICS TABLE_ROWS_READ bigint NULL NULL NULL NULL bigint(21) unsigned |
212 | 532 | NULL information_schema CLIENT_STATISTICS SELECT_COMMANDS int NULL NULL NULL NULL int(21) | 532 | NULL information_schema CLIENT_STATISTICS SELECT_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned |
213 | 533 | NULL information_schema CLIENT_STATISTICS UPDATE_COMMANDS int NULL NULL NULL NULL int(21) | 533 | NULL information_schema CLIENT_STATISTICS UPDATE_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned |
214 | 534 | NULL information_schema CLIENT_STATISTICS OTHER_COMMANDS int NULL NULL NULL NULL int(21) | 534 | NULL information_schema CLIENT_STATISTICS OTHER_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned |
215 | 535 | NULL information_schema CLIENT_STATISTICS COMMIT_TRANSACTIONS int NULL NULL NULL NULL int(21) | 535 | NULL information_schema CLIENT_STATISTICS COMMIT_TRANSACTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
216 | 536 | NULL information_schema CLIENT_STATISTICS ROLLBACK_TRANSACTIONS int NULL NULL NULL NULL int(21) | 536 | NULL information_schema CLIENT_STATISTICS ROLLBACK_TRANSACTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
217 | 537 | NULL information_schema CLIENT_STATISTICS DENIED_CONNECTIONS int NULL NULL NULL NULL int(21) | 537 | NULL information_schema CLIENT_STATISTICS DENIED_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
218 | 538 | NULL information_schema CLIENT_STATISTICS LOST_CONNECTIONS int NULL NULL NULL NULL int(21) | 538 | NULL information_schema CLIENT_STATISTICS LOST_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
219 | 539 | NULL information_schema CLIENT_STATISTICS ACCESS_DENIED int NULL NULL NULL NULL int(21) | 539 | NULL information_schema CLIENT_STATISTICS ACCESS_DENIED bigint NULL NULL NULL NULL bigint(21) unsigned |
220 | 540 | NULL information_schema CLIENT_STATISTICS EMPTY_QUERIES int NULL NULL NULL NULL int(21) | 540 | NULL information_schema CLIENT_STATISTICS EMPTY_QUERIES bigint NULL NULL NULL NULL bigint(21) unsigned |
221 | 541 | NULL information_schema CLIENT_STATISTICS TOTAL_SSL_CONNECTIONS int NULL NULL NULL NULL int(21) | 541 | NULL information_schema CLIENT_STATISTICS TOTAL_SSL_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
222 | 542 | 3.0000 information_schema COLLATIONS COLLATION_NAME varchar 32 96 utf8 utf8_general_ci varchar(32) | 542 | 3.0000 information_schema COLLATIONS COLLATION_NAME varchar 32 96 utf8 utf8_general_ci varchar(32) |
223 | 543 | 3.0000 information_schema COLLATIONS CHARACTER_SET_NAME varchar 32 96 utf8 utf8_general_ci varchar(32) | 543 | 3.0000 information_schema COLLATIONS CHARACTER_SET_NAME varchar 32 96 utf8 utf8_general_ci varchar(32) |
224 | 544 | NULL information_schema COLLATIONS ID bigint NULL NULL NULL NULL bigint(11) | 544 | NULL information_schema COLLATIONS ID bigint NULL NULL NULL NULL bigint(11) |
225 | @@ -660,7 +660,7 @@ | |||
226 | 660 | 3.0000 information_schema INDEX_STATISTICS TABLE_SCHEMA varchar 192 576 utf8 utf8_general_ci varchar(192) | 660 | 3.0000 information_schema INDEX_STATISTICS TABLE_SCHEMA varchar 192 576 utf8 utf8_general_ci varchar(192) |
227 | 661 | 3.0000 information_schema INDEX_STATISTICS TABLE_NAME varchar 192 576 utf8 utf8_general_ci varchar(192) | 661 | 3.0000 information_schema INDEX_STATISTICS TABLE_NAME varchar 192 576 utf8 utf8_general_ci varchar(192) |
228 | 662 | 3.0000 information_schema INDEX_STATISTICS INDEX_NAME varchar 192 576 utf8 utf8_general_ci varchar(192) | 662 | 3.0000 information_schema INDEX_STATISTICS INDEX_NAME varchar 192 576 utf8 utf8_general_ci varchar(192) |
230 | 663 | NULL information_schema INDEX_STATISTICS ROWS_READ int NULL NULL NULL NULL int(21) | 663 | NULL information_schema INDEX_STATISTICS ROWS_READ bigint NULL NULL NULL NULL bigint(21) unsigned |
231 | 664 | 3.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512) | 664 | 3.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512) |
232 | 665 | 3.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64) | 665 | 3.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64) |
233 | 666 | 3.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_NAME varchar 64 192 utf8 utf8_general_ci varchar(64) | 666 | 3.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_NAME varchar 64 192 utf8 utf8_general_ci varchar(64) |
234 | @@ -856,9 +856,9 @@ | |||
235 | 856 | 3.0000 information_schema TABLE_PRIVILEGES IS_GRANTABLE varchar 3 9 utf8 utf8_general_ci varchar(3) | 856 | 3.0000 information_schema TABLE_PRIVILEGES IS_GRANTABLE varchar 3 9 utf8 utf8_general_ci varchar(3) |
236 | 857 | 3.0000 information_schema TABLE_STATISTICS TABLE_SCHEMA varchar 192 576 utf8 utf8_general_ci varchar(192) | 857 | 3.0000 information_schema TABLE_STATISTICS TABLE_SCHEMA varchar 192 576 utf8 utf8_general_ci varchar(192) |
237 | 858 | 3.0000 information_schema TABLE_STATISTICS TABLE_NAME varchar 192 576 utf8 utf8_general_ci varchar(192) | 858 | 3.0000 information_schema TABLE_STATISTICS TABLE_NAME varchar 192 576 utf8 utf8_general_ci varchar(192) |
241 | 859 | NULL information_schema TABLE_STATISTICS ROWS_READ int NULL NULL NULL NULL int(21) | 859 | NULL information_schema TABLE_STATISTICS ROWS_READ bigint NULL NULL NULL NULL bigint(21) unsigned |
242 | 860 | NULL information_schema TABLE_STATISTICS ROWS_CHANGED int NULL NULL NULL NULL int(21) | 860 | NULL information_schema TABLE_STATISTICS ROWS_CHANGED bigint NULL NULL NULL NULL bigint(21) unsigned |
243 | 861 | NULL information_schema TABLE_STATISTICS ROWS_CHANGED_X_INDEXES int NULL NULL NULL NULL int(21) | 861 | NULL information_schema TABLE_STATISTICS ROWS_CHANGED_X_INDEXES bigint NULL NULL NULL NULL bigint(21) unsigned |
244 | 862 | NULL information_schema TEMPORARY_TABLES SESSION_ID bigint NULL NULL NULL NULL bigint(4) | 862 | NULL information_schema TEMPORARY_TABLES SESSION_ID bigint NULL NULL NULL NULL bigint(4) |
245 | 863 | 3.0000 information_schema TEMPORARY_TABLES TABLE_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64) | 863 | 3.0000 information_schema TEMPORARY_TABLES TABLE_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64) |
246 | 864 | 3.0000 information_schema TEMPORARY_TABLES TABLE_NAME varchar 64 192 utf8 utf8_general_ci varchar(64) | 864 | 3.0000 information_schema TEMPORARY_TABLES TABLE_NAME varchar 64 192 utf8 utf8_general_ci varchar(64) |
247 | @@ -870,28 +870,28 @@ | |||
248 | 870 | NULL information_schema TEMPORARY_TABLES INDEX_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned | 870 | NULL information_schema TEMPORARY_TABLES INDEX_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned |
249 | 871 | NULL information_schema TEMPORARY_TABLES CREATE_TIME datetime NULL NULL NULL NULL datetime | 871 | NULL information_schema TEMPORARY_TABLES CREATE_TIME datetime NULL NULL NULL NULL datetime |
250 | 872 | NULL information_schema TEMPORARY_TABLES UPDATE_TIME datetime NULL NULL NULL NULL datetime | 872 | NULL information_schema TEMPORARY_TABLES UPDATE_TIME datetime NULL NULL NULL NULL datetime |
273 | 873 | NULL information_schema THREAD_STATISTICS THREAD_ID int NULL NULL NULL NULL int(21) | 873 | NULL information_schema THREAD_STATISTICS THREAD_ID bigint NULL NULL NULL NULL bigint(21) unsigned |
274 | 874 | NULL information_schema THREAD_STATISTICS TOTAL_CONNECTIONS int NULL NULL NULL NULL int(21) | 874 | NULL information_schema THREAD_STATISTICS TOTAL_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
275 | 875 | NULL information_schema THREAD_STATISTICS CONCURRENT_CONNECTIONS int NULL NULL NULL NULL int(21) | 875 | NULL information_schema THREAD_STATISTICS CONCURRENT_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
276 | 876 | NULL information_schema THREAD_STATISTICS CONNECTED_TIME int NULL NULL NULL NULL int(21) | 876 | NULL information_schema THREAD_STATISTICS CONNECTED_TIME bigint NULL NULL NULL NULL bigint(21) unsigned |
277 | 877 | NULL information_schema THREAD_STATISTICS BUSY_TIME int NULL NULL NULL NULL int(21) | 877 | NULL information_schema THREAD_STATISTICS BUSY_TIME bigint NULL NULL NULL NULL bigint(21) unsigned |
278 | 878 | NULL information_schema THREAD_STATISTICS CPU_TIME int NULL NULL NULL NULL int(21) | 878 | NULL information_schema THREAD_STATISTICS CPU_TIME bigint NULL NULL NULL NULL bigint(21) unsigned |
279 | 879 | NULL information_schema THREAD_STATISTICS BYTES_RECEIVED int NULL NULL NULL NULL int(21) | 879 | NULL information_schema THREAD_STATISTICS BYTES_RECEIVED bigint NULL NULL NULL NULL bigint(21) unsigned |
280 | 880 | NULL information_schema THREAD_STATISTICS BYTES_SENT int NULL NULL NULL NULL int(21) | 880 | NULL information_schema THREAD_STATISTICS BYTES_SENT bigint NULL NULL NULL NULL bigint(21) unsigned |
281 | 881 | NULL information_schema THREAD_STATISTICS BINLOG_BYTES_WRITTEN int NULL NULL NULL NULL int(21) | 881 | NULL information_schema THREAD_STATISTICS BINLOG_BYTES_WRITTEN bigint NULL NULL NULL NULL bigint(21) unsigned |
282 | 882 | NULL information_schema THREAD_STATISTICS ROWS_FETCHED int NULL NULL NULL NULL int(21) | 882 | NULL information_schema THREAD_STATISTICS ROWS_FETCHED bigint NULL NULL NULL NULL bigint(21) unsigned |
283 | 883 | NULL information_schema THREAD_STATISTICS ROWS_UPDATED int NULL NULL NULL NULL int(21) | 883 | NULL information_schema THREAD_STATISTICS ROWS_UPDATED bigint NULL NULL NULL NULL bigint(21) unsigned |
284 | 884 | NULL information_schema THREAD_STATISTICS TABLE_ROWS_READ int NULL NULL NULL NULL int(21) | 884 | NULL information_schema THREAD_STATISTICS TABLE_ROWS_READ bigint NULL NULL NULL NULL bigint(21) unsigned |
285 | 885 | NULL information_schema THREAD_STATISTICS SELECT_COMMANDS int NULL NULL NULL NULL int(21) | 885 | NULL information_schema THREAD_STATISTICS SELECT_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned |
286 | 886 | NULL information_schema THREAD_STATISTICS UPDATE_COMMANDS int NULL NULL NULL NULL int(21) | 886 | NULL information_schema THREAD_STATISTICS UPDATE_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned |
287 | 887 | NULL information_schema THREAD_STATISTICS OTHER_COMMANDS int NULL NULL NULL NULL int(21) | 887 | NULL information_schema THREAD_STATISTICS OTHER_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned |
288 | 888 | NULL information_schema THREAD_STATISTICS COMMIT_TRANSACTIONS int NULL NULL NULL NULL int(21) | 888 | NULL information_schema THREAD_STATISTICS COMMIT_TRANSACTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
289 | 889 | NULL information_schema THREAD_STATISTICS ROLLBACK_TRANSACTIONS int NULL NULL NULL NULL int(21) | 889 | NULL information_schema THREAD_STATISTICS ROLLBACK_TRANSACTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
290 | 890 | NULL information_schema THREAD_STATISTICS DENIED_CONNECTIONS int NULL NULL NULL NULL int(21) | 890 | NULL information_schema THREAD_STATISTICS DENIED_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
291 | 891 | NULL information_schema THREAD_STATISTICS LOST_CONNECTIONS int NULL NULL NULL NULL int(21) | 891 | NULL information_schema THREAD_STATISTICS LOST_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
292 | 892 | NULL information_schema THREAD_STATISTICS ACCESS_DENIED int NULL NULL NULL NULL int(21) | 892 | NULL information_schema THREAD_STATISTICS ACCESS_DENIED bigint NULL NULL NULL NULL bigint(21) unsigned |
293 | 893 | NULL information_schema THREAD_STATISTICS EMPTY_QUERIES int NULL NULL NULL NULL int(21) | 893 | NULL information_schema THREAD_STATISTICS EMPTY_QUERIES bigint NULL NULL NULL NULL bigint(21) unsigned |
294 | 894 | NULL information_schema THREAD_STATISTICS TOTAL_SSL_CONNECTIONS int NULL NULL NULL NULL int(21) | 894 | NULL information_schema THREAD_STATISTICS TOTAL_SSL_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
295 | 895 | 3.0000 information_schema TRIGGERS TRIGGER_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512) | 895 | 3.0000 information_schema TRIGGERS TRIGGER_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512) |
296 | 896 | 3.0000 information_schema TRIGGERS TRIGGER_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64) | 896 | 3.0000 information_schema TRIGGERS TRIGGER_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64) |
297 | 897 | 3.0000 information_schema TRIGGERS TRIGGER_NAME varchar 64 192 utf8 utf8_general_ci varchar(64) | 897 | 3.0000 information_schema TRIGGERS TRIGGER_NAME varchar 64 192 utf8 utf8_general_ci varchar(64) |
298 | @@ -919,27 +919,27 @@ | |||
299 | 919 | 3.0000 information_schema USER_PRIVILEGES PRIVILEGE_TYPE varchar 64 192 utf8 utf8_general_ci varchar(64) | 919 | 3.0000 information_schema USER_PRIVILEGES PRIVILEGE_TYPE varchar 64 192 utf8 utf8_general_ci varchar(64) |
300 | 920 | 3.0000 information_schema USER_PRIVILEGES IS_GRANTABLE varchar 3 9 utf8 utf8_general_ci varchar(3) | 920 | 3.0000 information_schema USER_PRIVILEGES IS_GRANTABLE varchar 3 9 utf8 utf8_general_ci varchar(3) |
301 | 921 | 3.0000 information_schema USER_STATISTICS USER varchar 48 144 utf8 utf8_general_ci varchar(48) | 921 | 3.0000 information_schema USER_STATISTICS USER varchar 48 144 utf8 utf8_general_ci varchar(48) |
323 | 922 | NULL information_schema USER_STATISTICS TOTAL_CONNECTIONS int NULL NULL NULL NULL int(21) | 922 | NULL information_schema USER_STATISTICS TOTAL_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
324 | 923 | NULL information_schema USER_STATISTICS CONCURRENT_CONNECTIONS int NULL NULL NULL NULL int(21) | 923 | NULL information_schema USER_STATISTICS CONCURRENT_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
325 | 924 | NULL information_schema USER_STATISTICS CONNECTED_TIME int NULL NULL NULL NULL int(21) | 924 | NULL information_schema USER_STATISTICS CONNECTED_TIME bigint NULL NULL NULL NULL bigint(21) unsigned |
326 | 925 | NULL information_schema USER_STATISTICS BUSY_TIME int NULL NULL NULL NULL int(21) | 925 | NULL information_schema USER_STATISTICS BUSY_TIME bigint NULL NULL NULL NULL bigint(21) unsigned |
327 | 926 | NULL information_schema USER_STATISTICS CPU_TIME int NULL NULL NULL NULL int(21) | 926 | NULL information_schema USER_STATISTICS CPU_TIME bigint NULL NULL NULL NULL bigint(21) unsigned |
328 | 927 | NULL information_schema USER_STATISTICS BYTES_RECEIVED int NULL NULL NULL NULL int(21) | 927 | NULL information_schema USER_STATISTICS BYTES_RECEIVED bigint NULL NULL NULL NULL bigint(21) unsigned |
329 | 928 | NULL information_schema USER_STATISTICS BYTES_SENT int NULL NULL NULL NULL int(21) | 928 | NULL information_schema USER_STATISTICS BYTES_SENT bigint NULL NULL NULL NULL bigint(21) unsigned |
330 | 929 | NULL information_schema USER_STATISTICS BINLOG_BYTES_WRITTEN int NULL NULL NULL NULL int(21) | 929 | NULL information_schema USER_STATISTICS BINLOG_BYTES_WRITTEN bigint NULL NULL NULL NULL bigint(21) unsigned |
331 | 930 | NULL information_schema USER_STATISTICS ROWS_FETCHED int NULL NULL NULL NULL int(21) | 930 | NULL information_schema USER_STATISTICS ROWS_FETCHED bigint NULL NULL NULL NULL bigint(21) unsigned |
332 | 931 | NULL information_schema USER_STATISTICS ROWS_UPDATED int NULL NULL NULL NULL int(21) | 931 | NULL information_schema USER_STATISTICS ROWS_UPDATED bigint NULL NULL NULL NULL bigint(21) unsigned |
333 | 932 | NULL information_schema USER_STATISTICS TABLE_ROWS_READ int NULL NULL NULL NULL int(21) | 932 | NULL information_schema USER_STATISTICS TABLE_ROWS_READ bigint NULL NULL NULL NULL bigint(21) unsigned |
334 | 933 | NULL information_schema USER_STATISTICS SELECT_COMMANDS int NULL NULL NULL NULL int(21) | 933 | NULL information_schema USER_STATISTICS SELECT_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned |
335 | 934 | NULL information_schema USER_STATISTICS UPDATE_COMMANDS int NULL NULL NULL NULL int(21) | 934 | NULL information_schema USER_STATISTICS UPDATE_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned |
336 | 935 | NULL information_schema USER_STATISTICS OTHER_COMMANDS int NULL NULL NULL NULL int(21) | 935 | NULL information_schema USER_STATISTICS OTHER_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned |
337 | 936 | NULL information_schema USER_STATISTICS COMMIT_TRANSACTIONS int NULL NULL NULL NULL int(21) | 936 | NULL information_schema USER_STATISTICS COMMIT_TRANSACTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
338 | 937 | NULL information_schema USER_STATISTICS ROLLBACK_TRANSACTIONS int NULL NULL NULL NULL int(21) | 937 | NULL information_schema USER_STATISTICS ROLLBACK_TRANSACTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
339 | 938 | NULL information_schema USER_STATISTICS DENIED_CONNECTIONS int NULL NULL NULL NULL int(21) | 938 | NULL information_schema USER_STATISTICS DENIED_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
340 | 939 | NULL information_schema USER_STATISTICS LOST_CONNECTIONS int NULL NULL NULL NULL int(21) | 939 | NULL information_schema USER_STATISTICS LOST_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
341 | 940 | NULL information_schema USER_STATISTICS ACCESS_DENIED int NULL NULL NULL NULL int(21) | 940 | NULL information_schema USER_STATISTICS ACCESS_DENIED bigint NULL NULL NULL NULL bigint(21) unsigned |
342 | 941 | NULL information_schema USER_STATISTICS EMPTY_QUERIES int NULL NULL NULL NULL int(21) | 941 | NULL information_schema USER_STATISTICS EMPTY_QUERIES bigint NULL NULL NULL NULL bigint(21) unsigned |
343 | 942 | NULL information_schema USER_STATISTICS TOTAL_SSL_CONNECTIONS int NULL NULL NULL NULL int(21) | 942 | NULL information_schema USER_STATISTICS TOTAL_SSL_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned |
344 | 943 | 3.0000 information_schema VIEWS TABLE_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512) | 943 | 3.0000 information_schema VIEWS TABLE_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512) |
345 | 944 | 3.0000 information_schema VIEWS TABLE_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64) | 944 | 3.0000 information_schema VIEWS TABLE_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64) |
346 | 945 | 3.0000 information_schema VIEWS TABLE_NAME varchar 64 192 utf8 utf8_general_ci varchar(64) | 945 | 3.0000 information_schema VIEWS TABLE_NAME varchar 64 192 utf8 utf8_general_ci varchar(64) |
347 | 946 | 946 | ||
348 | === modified file 'Percona-Server/sql/sql_show.cc' | |||
349 | --- Percona-Server/sql/sql_show.cc 2013-05-26 10:55:00 +0000 | |||
350 | +++ Percona-Server/sql/sql_show.cc 2013-05-31 04:35:35 +0000 | |||
351 | @@ -2634,34 +2634,35 @@ | |||
352 | 2634 | for (uint i = 0; i < all_user_stats->records; ++i) | 2634 | for (uint i = 0; i < all_user_stats->records; ++i) |
353 | 2635 | { | 2635 | { |
354 | 2636 | restore_record(table, s->default_values); | 2636 | restore_record(table, s->default_values); |
383 | 2637 | USER_STATS *user_stats = (USER_STATS *) my_hash_element(all_user_stats, i); | 2637 | USER_STATS *user_stats = (USER_STATS*) my_hash_element(all_user_stats, i); |
384 | 2638 | table->field[0]->store(user_stats->user, strlen(user_stats->user), system_charset_info); | 2638 | table->field[0]->store(user_stats->user, strlen(user_stats->user), |
385 | 2639 | table->field[1]->store((longlong)user_stats->total_connections); | 2639 | system_charset_info); |
386 | 2640 | table->field[2]->store((longlong)user_stats->concurrent_connections); | 2640 | table->field[1]->store(user_stats->total_connections, true); |
387 | 2641 | table->field[3]->store((longlong)user_stats->connected_time); | 2641 | table->field[2]->store(user_stats->concurrent_connections, true); |
388 | 2642 | table->field[4]->store((longlong)user_stats->busy_time); | 2642 | table->field[3]->store(user_stats->connected_time, true); |
389 | 2643 | table->field[5]->store((longlong)user_stats->cpu_time); | 2643 | table->field[4]->store((ulonglong)user_stats->busy_time, true); |
390 | 2644 | table->field[6]->store((longlong)user_stats->bytes_received); | 2644 | table->field[5]->store((ulonglong)user_stats->cpu_time, true); |
391 | 2645 | table->field[7]->store((longlong)user_stats->bytes_sent); | 2645 | table->field[6]->store(user_stats->bytes_received, true); |
392 | 2646 | table->field[8]->store((longlong)user_stats->binlog_bytes_written); | 2646 | table->field[7]->store(user_stats->bytes_sent, true); |
393 | 2647 | table->field[9]->store((longlong)user_stats->rows_fetched); | 2647 | table->field[8]->store(user_stats->binlog_bytes_written, true); |
394 | 2648 | table->field[10]->store((longlong)user_stats->rows_updated); | 2648 | table->field[9]->store(user_stats->rows_fetched, true); |
395 | 2649 | table->field[11]->store((longlong)user_stats->rows_read); | 2649 | table->field[10]->store(user_stats->rows_updated, true); |
396 | 2650 | table->field[12]->store((longlong)user_stats->select_commands); | 2650 | table->field[11]->store(user_stats->rows_read, true); |
397 | 2651 | table->field[13]->store((longlong)user_stats->update_commands); | 2651 | table->field[12]->store(user_stats->select_commands, true); |
398 | 2652 | table->field[14]->store((longlong)user_stats->other_commands); | 2652 | table->field[13]->store(user_stats->update_commands, true); |
399 | 2653 | table->field[15]->store((longlong)user_stats->commit_trans); | 2653 | table->field[14]->store(user_stats->other_commands, true); |
400 | 2654 | table->field[16]->store((longlong)user_stats->rollback_trans); | 2654 | table->field[15]->store(user_stats->commit_trans, true); |
401 | 2655 | table->field[17]->store((longlong)user_stats->denied_connections); | 2655 | table->field[16]->store(user_stats->rollback_trans, true); |
402 | 2656 | table->field[18]->store((longlong)user_stats->lost_connections); | 2656 | table->field[17]->store(user_stats->denied_connections, true); |
403 | 2657 | table->field[19]->store((longlong)user_stats->access_denied_errors); | 2657 | table->field[18]->store(user_stats->lost_connections, true); |
404 | 2658 | table->field[20]->store((longlong)user_stats->empty_queries); | 2658 | table->field[19]->store(user_stats->access_denied_errors, true); |
405 | 2659 | table->field[21]->store((longlong)user_stats->total_ssl_connections); | 2659 | table->field[20]->store(user_stats->empty_queries, true); |
406 | 2660 | if (schema_table_store_record(thd, table)) | 2660 | table->field[21]->store(user_stats->total_ssl_connections, true); |
407 | 2661 | { | 2661 | if (schema_table_store_record(thd, table)) |
408 | 2662 | DBUG_PRINT("error", ("store record error")); | 2662 | { |
409 | 2663 | DBUG_RETURN(1); | 2663 | DBUG_PRINT("error", ("store record error")); |
410 | 2664 | } | 2664 | DBUG_RETURN(1); |
411 | 2665 | } | ||
412 | 2665 | } | 2666 | } |
413 | 2666 | DBUG_RETURN(0); | 2667 | DBUG_RETURN(0); |
414 | 2667 | } | 2668 | } |
415 | @@ -2672,34 +2673,35 @@ | |||
416 | 2672 | for (uint i = 0; i < all_thread_stats->records; ++i) | 2673 | for (uint i = 0; i < all_thread_stats->records; ++i) |
417 | 2673 | { | 2674 | { |
418 | 2674 | restore_record(table, s->default_values); | 2675 | restore_record(table, s->default_values); |
447 | 2675 | THREAD_STATS *user_stats = (THREAD_STATS *) my_hash_element(all_thread_stats, i); | 2676 | THREAD_STATS *user_stats |
448 | 2676 | table->field[0]->store((longlong)user_stats->id); | 2677 | = (THREAD_STATS*)my_hash_element(all_thread_stats, i); |
449 | 2677 | table->field[1]->store((longlong)user_stats->total_connections); | 2678 | table->field[0]->store(user_stats->id, true); |
450 | 2678 | table->field[2]->store((longlong)user_stats->concurrent_connections); | 2679 | table->field[1]->store(user_stats->total_connections, true); |
451 | 2679 | table->field[3]->store((longlong)user_stats->connected_time); | 2680 | table->field[2]->store(user_stats->concurrent_connections, true); |
452 | 2680 | table->field[4]->store((longlong)user_stats->busy_time); | 2681 | table->field[3]->store(user_stats->connected_time, true); |
453 | 2681 | table->field[5]->store((longlong)user_stats->cpu_time); | 2682 | table->field[4]->store((ulonglong)user_stats->busy_time, true); |
454 | 2682 | table->field[6]->store((longlong)user_stats->bytes_received); | 2683 | table->field[5]->store((ulonglong)user_stats->cpu_time, true); |
455 | 2683 | table->field[7]->store((longlong)user_stats->bytes_sent); | 2684 | table->field[6]->store(user_stats->bytes_received, true); |
456 | 2684 | table->field[8]->store((longlong)user_stats->binlog_bytes_written); | 2685 | table->field[7]->store(user_stats->bytes_sent, true); |
457 | 2685 | table->field[9]->store((longlong)user_stats->rows_fetched); | 2686 | table->field[8]->store(user_stats->binlog_bytes_written, true); |
458 | 2686 | table->field[10]->store((longlong)user_stats->rows_updated); | 2687 | table->field[9]->store(user_stats->rows_fetched, true); |
459 | 2687 | table->field[11]->store((longlong)user_stats->rows_read); | 2688 | table->field[10]->store(user_stats->rows_updated, true); |
460 | 2688 | table->field[12]->store((longlong)user_stats->select_commands); | 2689 | table->field[11]->store(user_stats->rows_read, true); |
461 | 2689 | table->field[13]->store((longlong)user_stats->update_commands); | 2690 | table->field[12]->store(user_stats->select_commands, true); |
462 | 2690 | table->field[14]->store((longlong)user_stats->other_commands); | 2691 | table->field[13]->store(user_stats->update_commands, true); |
463 | 2691 | table->field[15]->store((longlong)user_stats->commit_trans); | 2692 | table->field[14]->store(user_stats->other_commands, true); |
464 | 2692 | table->field[16]->store((longlong)user_stats->rollback_trans); | 2693 | table->field[15]->store(user_stats->commit_trans, true); |
465 | 2693 | table->field[17]->store((longlong)user_stats->denied_connections); | 2694 | table->field[16]->store(user_stats->rollback_trans, true); |
466 | 2694 | table->field[18]->store((longlong)user_stats->lost_connections); | 2695 | table->field[17]->store(user_stats->denied_connections, true); |
467 | 2695 | table->field[19]->store((longlong)user_stats->access_denied_errors); | 2696 | table->field[18]->store(user_stats->lost_connections, true); |
468 | 2696 | table->field[20]->store((longlong)user_stats->empty_queries); | 2697 | table->field[19]->store(user_stats->access_denied_errors, true); |
469 | 2697 | table->field[21]->store((longlong)user_stats->total_ssl_connections); | 2698 | table->field[20]->store(user_stats->empty_queries, true); |
470 | 2698 | if (schema_table_store_record(thd, table)) | 2699 | table->field[21]->store(user_stats->total_ssl_connections, true); |
471 | 2699 | { | 2700 | if (schema_table_store_record(thd, table)) |
472 | 2700 | DBUG_PRINT("error", ("store record error")); | 2701 | { |
473 | 2701 | DBUG_RETURN(1); | 2702 | DBUG_PRINT("error", ("store record error")); |
474 | 2702 | } | 2703 | DBUG_RETURN(1); |
475 | 2704 | } | ||
476 | 2703 | } | 2705 | } |
477 | 2704 | DBUG_RETURN(0); | 2706 | DBUG_RETURN(0); |
478 | 2705 | } | 2707 | } |
479 | @@ -2838,9 +2840,9 @@ | |||
480 | 2838 | 2840 | ||
481 | 2839 | table->field[0]->store(table_schema, strlen(table_schema), system_charset_info); | 2841 | table->field[0]->store(table_schema, strlen(table_schema), system_charset_info); |
482 | 2840 | table->field[1]->store(table_full_name, strlen(table_full_name), system_charset_info); | 2842 | table->field[1]->store(table_full_name, strlen(table_full_name), system_charset_info); |
486 | 2841 | table->field[2]->store((longlong)table_stats->rows_read, TRUE); | 2843 | table->field[2]->store(table_stats->rows_read, true); |
487 | 2842 | table->field[3]->store((longlong)table_stats->rows_changed, TRUE); | 2844 | table->field[3]->store(table_stats->rows_changed, true); |
488 | 2843 | table->field[4]->store((longlong)table_stats->rows_changed_x_indexes, TRUE); | 2845 | table->field[4]->store(table_stats->rows_changed_x_indexes, true); |
489 | 2844 | 2846 | ||
490 | 2845 | if (schema_table_store_record(thd, table)) | 2847 | if (schema_table_store_record(thd, table)) |
491 | 2846 | { | 2848 | { |
492 | @@ -2884,7 +2886,7 @@ | |||
493 | 2884 | table->field[0]->store(table_schema, strlen(table_schema), system_charset_info); | 2886 | table->field[0]->store(table_schema, strlen(table_schema), system_charset_info); |
494 | 2885 | table->field[1]->store(table_name, strlen(table_name), system_charset_info); | 2887 | table->field[1]->store(table_name, strlen(table_name), system_charset_info); |
495 | 2886 | table->field[2]->store(index_full_name, strlen(index_full_name), system_charset_info); | 2888 | table->field[2]->store(index_full_name, strlen(index_full_name), system_charset_info); |
497 | 2887 | table->field[3]->store((longlong)index_stats->rows_read, TRUE); | 2889 | table->field[3]->store(index_stats->rows_read, true); |
498 | 2888 | 2890 | ||
499 | 2889 | if (schema_table_store_record(thd, table)) | 2891 | if (schema_table_store_record(thd, table)) |
500 | 2890 | { | 2892 | { |
501 | @@ -8317,100 +8319,174 @@ | |||
502 | 8317 | ST_FIELD_INFO user_stats_fields_info[]= | 8319 | ST_FIELD_INFO user_stats_fields_info[]= |
503 | 8318 | { | 8320 | { |
504 | 8319 | {"USER", USERNAME_LENGTH, MYSQL_TYPE_STRING, 0, 0, "User", SKIP_OPEN_TABLE}, | 8321 | {"USER", USERNAME_LENGTH, MYSQL_TYPE_STRING, 0, 0, "User", SKIP_OPEN_TABLE}, |
526 | 8320 | {"TOTAL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Total_connections", SKIP_OPEN_TABLE}, | 8322 | {"TOTAL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
527 | 8321 | {"CONCURRENT_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Concurrent_connections", SKIP_OPEN_TABLE}, | 8323 | MY_I_S_UNSIGNED, "Total_connections", SKIP_OPEN_TABLE}, |
528 | 8322 | {"CONNECTED_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Connected_time", SKIP_OPEN_TABLE}, | 8324 | {"CONCURRENT_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, |
529 | 8323 | {"BUSY_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Busy_time", SKIP_OPEN_TABLE}, | 8325 | 0, MY_I_S_UNSIGNED, "Concurrent_connections", SKIP_OPEN_TABLE}, |
530 | 8324 | {"CPU_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Cpu_time", SKIP_OPEN_TABLE}, | 8326 | {"CONNECTED_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
531 | 8325 | {"BYTES_RECEIVED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Bytes_received", SKIP_OPEN_TABLE}, | 8327 | MY_I_S_UNSIGNED, "Connected_time", SKIP_OPEN_TABLE}, |
532 | 8326 | {"BYTES_SENT", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Bytes_sent", SKIP_OPEN_TABLE}, | 8328 | {"BUSY_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
533 | 8327 | {"BINLOG_BYTES_WRITTEN", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Binlog_bytes_written", SKIP_OPEN_TABLE}, | 8329 | MY_I_S_UNSIGNED, "Busy_time", SKIP_OPEN_TABLE}, |
534 | 8328 | {"ROWS_FETCHED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_fetched", SKIP_OPEN_TABLE}, | 8330 | {"CPU_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
535 | 8329 | {"ROWS_UPDATED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_updated", SKIP_OPEN_TABLE}, | 8331 | MY_I_S_UNSIGNED, "Cpu_time", SKIP_OPEN_TABLE}, |
536 | 8330 | {"TABLE_ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Table_rows_read", SKIP_OPEN_TABLE}, | 8332 | {"BYTES_RECEIVED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
537 | 8331 | {"SELECT_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Select_commands", SKIP_OPEN_TABLE}, | 8333 | MY_I_S_UNSIGNED, "Bytes_received", SKIP_OPEN_TABLE}, |
538 | 8332 | {"UPDATE_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Update_commands", SKIP_OPEN_TABLE}, | 8334 | {"BYTES_SENT", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
539 | 8333 | {"OTHER_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Other_commands", SKIP_OPEN_TABLE}, | 8335 | MY_I_S_UNSIGNED, "Bytes_sent", SKIP_OPEN_TABLE}, |
540 | 8334 | {"COMMIT_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Commit_transactions", SKIP_OPEN_TABLE}, | 8336 | {"BINLOG_BYTES_WRITTEN", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, |
541 | 8335 | {"ROLLBACK_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rollback_transactions", SKIP_OPEN_TABLE}, | 8337 | 0, MY_I_S_UNSIGNED, "Binlog_bytes_written", SKIP_OPEN_TABLE}, |
542 | 8336 | {"DENIED_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Denied_connections", SKIP_OPEN_TABLE}, | 8338 | {"ROWS_FETCHED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
543 | 8337 | {"LOST_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Lost_connections", SKIP_OPEN_TABLE}, | 8339 | MY_I_S_UNSIGNED, "Rows_fetched", SKIP_OPEN_TABLE}, |
544 | 8338 | {"ACCESS_DENIED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Access_denied", SKIP_OPEN_TABLE}, | 8340 | {"ROWS_UPDATED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
545 | 8339 | {"EMPTY_QUERIES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Empty_queries", SKIP_OPEN_TABLE}, | 8341 | MY_I_S_UNSIGNED, "Rows_updated", SKIP_OPEN_TABLE}, |
546 | 8340 | {"TOTAL_SSL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Total_ssl_connections", SKIP_OPEN_TABLE}, | 8342 | {"TABLE_ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
547 | 8343 | MY_I_S_UNSIGNED, "Table_rows_read", SKIP_OPEN_TABLE}, | ||
548 | 8344 | {"SELECT_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
549 | 8345 | MY_I_S_UNSIGNED, "Select_commands", SKIP_OPEN_TABLE}, | ||
550 | 8346 | {"UPDATE_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
551 | 8347 | MY_I_S_UNSIGNED, "Update_commands", SKIP_OPEN_TABLE}, | ||
552 | 8348 | {"OTHER_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
553 | 8349 | MY_I_S_UNSIGNED, "Other_commands", SKIP_OPEN_TABLE}, | ||
554 | 8350 | {"COMMIT_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
555 | 8351 | MY_I_S_UNSIGNED, "Commit_transactions", SKIP_OPEN_TABLE}, | ||
556 | 8352 | {"ROLLBACK_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, | ||
557 | 8353 | 0, MY_I_S_UNSIGNED, "Rollback_transactions", SKIP_OPEN_TABLE}, | ||
558 | 8354 | {"DENIED_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
559 | 8355 | MY_I_S_UNSIGNED, "Denied_connections", SKIP_OPEN_TABLE}, | ||
560 | 8356 | {"LOST_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
561 | 8357 | MY_I_S_UNSIGNED, "Lost_connections", SKIP_OPEN_TABLE}, | ||
562 | 8358 | {"ACCESS_DENIED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
563 | 8359 | MY_I_S_UNSIGNED, "Access_denied", SKIP_OPEN_TABLE}, | ||
564 | 8360 | {"EMPTY_QUERIES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
565 | 8361 | MY_I_S_UNSIGNED, "Empty_queries", SKIP_OPEN_TABLE}, | ||
566 | 8362 | {"TOTAL_SSL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, | ||
567 | 8363 | 0, MY_I_S_UNSIGNED, "Total_ssl_connections", SKIP_OPEN_TABLE}, | ||
568 | 8341 | {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0} | 8364 | {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0} |
569 | 8342 | }; | 8365 | }; |
570 | 8343 | 8366 | ||
571 | 8344 | ST_FIELD_INFO client_stats_fields_info[]= | 8367 | ST_FIELD_INFO client_stats_fields_info[]= |
572 | 8345 | { | 8368 | { |
595 | 8346 | {"CLIENT", LIST_PROCESS_HOST_LEN, MYSQL_TYPE_STRING, 0, 0, "Client", SKIP_OPEN_TABLE}, | 8369 | {"CLIENT", LIST_PROCESS_HOST_LEN, MYSQL_TYPE_STRING, 0, 0, "Client", |
596 | 8347 | {"TOTAL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Total_connections", SKIP_OPEN_TABLE}, | 8370 | SKIP_OPEN_TABLE}, |
597 | 8348 | {"CONCURRENT_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Concurrent_connections", SKIP_OPEN_TABLE}, | 8371 | {"TOTAL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
598 | 8349 | {"CONNECTED_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Connected_time", SKIP_OPEN_TABLE}, | 8372 | MY_I_S_UNSIGNED, "Total_connections", SKIP_OPEN_TABLE}, |
599 | 8350 | {"BUSY_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Busy_time", SKIP_OPEN_TABLE}, | 8373 | {"CONCURRENT_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, |
600 | 8351 | {"CPU_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Cpu_time", SKIP_OPEN_TABLE}, | 8374 | 0, MY_I_S_UNSIGNED, "Concurrent_connections", SKIP_OPEN_TABLE}, |
601 | 8352 | {"BYTES_RECEIVED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Bytes_received", SKIP_OPEN_TABLE}, | 8375 | {"CONNECTED_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
602 | 8353 | {"BYTES_SENT", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Bytes_sent", SKIP_OPEN_TABLE}, | 8376 | MY_I_S_UNSIGNED, "Connected_time", SKIP_OPEN_TABLE}, |
603 | 8354 | {"BINLOG_BYTES_WRITTEN", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Binlog_bytes_written", SKIP_OPEN_TABLE}, | 8377 | {"BUSY_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
604 | 8355 | {"ROWS_FETCHED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_fetched", SKIP_OPEN_TABLE}, | 8378 | MY_I_S_UNSIGNED, "Busy_time", SKIP_OPEN_TABLE}, |
605 | 8356 | {"ROWS_UPDATED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_updated", SKIP_OPEN_TABLE}, | 8379 | {"CPU_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
606 | 8357 | {"TABLE_ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Table_rows_read", SKIP_OPEN_TABLE}, | 8380 | MY_I_S_UNSIGNED, "Cpu_time", SKIP_OPEN_TABLE}, |
607 | 8358 | {"SELECT_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Select_commands", SKIP_OPEN_TABLE}, | 8381 | {"BYTES_RECEIVED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
608 | 8359 | {"UPDATE_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Update_commands", SKIP_OPEN_TABLE}, | 8382 | MY_I_S_UNSIGNED, "Bytes_received", SKIP_OPEN_TABLE}, |
609 | 8360 | {"OTHER_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Other_commands", SKIP_OPEN_TABLE}, | 8383 | {"BYTES_SENT", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
610 | 8361 | {"COMMIT_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Commit_transactions", SKIP_OPEN_TABLE}, | 8384 | MY_I_S_UNSIGNED, "Bytes_sent", SKIP_OPEN_TABLE}, |
611 | 8362 | {"ROLLBACK_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rollback_transactions", SKIP_OPEN_TABLE}, | 8385 | {"BINLOG_BYTES_WRITTEN", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, |
612 | 8363 | {"DENIED_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Denied_connections", SKIP_OPEN_TABLE}, | 8386 | 0, MY_I_S_UNSIGNED, "Binlog_bytes_written", SKIP_OPEN_TABLE}, |
613 | 8364 | {"LOST_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Lost_connections", SKIP_OPEN_TABLE}, | 8387 | {"ROWS_FETCHED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
614 | 8365 | {"ACCESS_DENIED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Access_denied", SKIP_OPEN_TABLE}, | 8388 | MY_I_S_UNSIGNED, "Rows_fetched", SKIP_OPEN_TABLE}, |
615 | 8366 | {"EMPTY_QUERIES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Empty_queries", SKIP_OPEN_TABLE}, | 8389 | {"ROWS_UPDATED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
616 | 8367 | {"TOTAL_SSL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Total_ssl_connections", SKIP_OPEN_TABLE}, | 8390 | MY_I_S_UNSIGNED, "Rows_updated", SKIP_OPEN_TABLE}, |
617 | 8391 | {"TABLE_ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
618 | 8392 | MY_I_S_UNSIGNED, "Table_rows_read", SKIP_OPEN_TABLE}, | ||
619 | 8393 | {"SELECT_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
620 | 8394 | MY_I_S_UNSIGNED, "Select_commands", SKIP_OPEN_TABLE}, | ||
621 | 8395 | {"UPDATE_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
622 | 8396 | MY_I_S_UNSIGNED, "Update_commands", SKIP_OPEN_TABLE}, | ||
623 | 8397 | {"OTHER_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
624 | 8398 | MY_I_S_UNSIGNED, "Other_commands", SKIP_OPEN_TABLE}, | ||
625 | 8399 | {"COMMIT_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
626 | 8400 | MY_I_S_UNSIGNED, "Commit_transactions", SKIP_OPEN_TABLE}, | ||
627 | 8401 | {"ROLLBACK_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, | ||
628 | 8402 | 0, MY_I_S_UNSIGNED, "Rollback_transactions", SKIP_OPEN_TABLE}, | ||
629 | 8403 | {"DENIED_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
630 | 8404 | MY_I_S_UNSIGNED, "Denied_connections", SKIP_OPEN_TABLE}, | ||
631 | 8405 | {"LOST_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
632 | 8406 | MY_I_S_UNSIGNED, "Lost_connections", SKIP_OPEN_TABLE}, | ||
633 | 8407 | {"ACCESS_DENIED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
634 | 8408 | MY_I_S_UNSIGNED, "Access_denied", SKIP_OPEN_TABLE}, | ||
635 | 8409 | {"EMPTY_QUERIES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
636 | 8410 | MY_I_S_UNSIGNED, "Empty_queries", SKIP_OPEN_TABLE}, | ||
637 | 8411 | {"TOTAL_SSL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, | ||
638 | 8412 | 0, MY_I_S_UNSIGNED, "Total_ssl_connections", SKIP_OPEN_TABLE}, | ||
639 | 8368 | {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0} | 8413 | {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0} |
640 | 8369 | }; | 8414 | }; |
641 | 8370 | 8415 | ||
642 | 8371 | ST_FIELD_INFO thread_stats_fields_info[]= | 8416 | ST_FIELD_INFO thread_stats_fields_info[]= |
643 | 8372 | { | 8417 | { |
666 | 8373 | {"THREAD_ID", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Thread_id", SKIP_OPEN_TABLE}, | 8418 | {"THREAD_ID", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
667 | 8374 | {"TOTAL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Total_connections", SKIP_OPEN_TABLE}, | 8419 | MY_I_S_UNSIGNED, "Thread_id", SKIP_OPEN_TABLE}, |
668 | 8375 | {"CONCURRENT_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Concurrent_connections", SKIP_OPEN_TABLE}, | 8420 | {"TOTAL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
669 | 8376 | {"CONNECTED_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Connected_time", SKIP_OPEN_TABLE}, | 8421 | MY_I_S_UNSIGNED, "Total_connections", SKIP_OPEN_TABLE}, |
670 | 8377 | {"BUSY_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Busy_time", SKIP_OPEN_TABLE}, | 8422 | {"CONCURRENT_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, |
671 | 8378 | {"CPU_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Cpu_time", SKIP_OPEN_TABLE}, | 8423 | 0, MY_I_S_UNSIGNED, "Concurrent_connections", SKIP_OPEN_TABLE}, |
672 | 8379 | {"BYTES_RECEIVED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Bytes_received", SKIP_OPEN_TABLE}, | 8424 | {"CONNECTED_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
673 | 8380 | {"BYTES_SENT", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Bytes_sent", SKIP_OPEN_TABLE}, | 8425 | MY_I_S_UNSIGNED, "Connected_time", SKIP_OPEN_TABLE}, |
674 | 8381 | {"BINLOG_BYTES_WRITTEN", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Binlog_bytes_written", SKIP_OPEN_TABLE}, | 8426 | {"BUSY_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
675 | 8382 | {"ROWS_FETCHED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_fetched", SKIP_OPEN_TABLE}, | 8427 | MY_I_S_UNSIGNED, "Busy_time", SKIP_OPEN_TABLE}, |
676 | 8383 | {"ROWS_UPDATED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_updated", SKIP_OPEN_TABLE}, | 8428 | {"CPU_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
677 | 8384 | {"TABLE_ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Table_rows_read", SKIP_OPEN_TABLE}, | 8429 | MY_I_S_UNSIGNED, "Cpu_time", SKIP_OPEN_TABLE}, |
678 | 8385 | {"SELECT_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Select_commands", SKIP_OPEN_TABLE}, | 8430 | {"BYTES_RECEIVED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
679 | 8386 | {"UPDATE_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Update_commands", SKIP_OPEN_TABLE}, | 8431 | MY_I_S_UNSIGNED, "Bytes_received", SKIP_OPEN_TABLE}, |
680 | 8387 | {"OTHER_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Other_commands", SKIP_OPEN_TABLE}, | 8432 | {"BYTES_SENT", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
681 | 8388 | {"COMMIT_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Commit_transactions", SKIP_OPEN_TABLE}, | 8433 | MY_I_S_UNSIGNED, "Bytes_sent", SKIP_OPEN_TABLE}, |
682 | 8389 | {"ROLLBACK_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rollback_transactions", SKIP_OPEN_TABLE}, | 8434 | {"BINLOG_BYTES_WRITTEN", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
683 | 8390 | {"DENIED_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Denied_connections", SKIP_OPEN_TABLE}, | 8435 | MY_I_S_UNSIGNED, "Binlog_bytes_written", SKIP_OPEN_TABLE}, |
684 | 8391 | {"LOST_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Lost_connections", SKIP_OPEN_TABLE}, | 8436 | {"ROWS_FETCHED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
685 | 8392 | {"ACCESS_DENIED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Access_denied", SKIP_OPEN_TABLE}, | 8437 | MY_I_S_UNSIGNED, "Rows_fetched", SKIP_OPEN_TABLE}, |
686 | 8393 | {"EMPTY_QUERIES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Empty_queries", SKIP_OPEN_TABLE}, | 8438 | {"ROWS_UPDATED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
687 | 8394 | {"TOTAL_SSL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Total_ssl_connections", SKIP_OPEN_TABLE}, | 8439 | MY_I_S_UNSIGNED, "Rows_updated", SKIP_OPEN_TABLE}, |
688 | 8440 | {"TABLE_ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
689 | 8441 | MY_I_S_UNSIGNED, "Table_rows_read", SKIP_OPEN_TABLE}, | ||
690 | 8442 | {"SELECT_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
691 | 8443 | MY_I_S_UNSIGNED, "Select_commands", SKIP_OPEN_TABLE}, | ||
692 | 8444 | {"UPDATE_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
693 | 8445 | MY_I_S_UNSIGNED, "Update_commands", SKIP_OPEN_TABLE}, | ||
694 | 8446 | {"OTHER_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
695 | 8447 | MY_I_S_UNSIGNED, "Other_commands", SKIP_OPEN_TABLE}, | ||
696 | 8448 | {"COMMIT_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
697 | 8449 | MY_I_S_UNSIGNED, "Commit_transactions", SKIP_OPEN_TABLE}, | ||
698 | 8450 | {"ROLLBACK_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, | ||
699 | 8451 | 0, MY_I_S_UNSIGNED, "Rollback_transactions", SKIP_OPEN_TABLE}, | ||
700 | 8452 | {"DENIED_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
701 | 8453 | MY_I_S_UNSIGNED, "Denied_connections", SKIP_OPEN_TABLE}, | ||
702 | 8454 | {"LOST_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
703 | 8455 | MY_I_S_UNSIGNED, "Lost_connections", SKIP_OPEN_TABLE}, | ||
704 | 8456 | {"ACCESS_DENIED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
705 | 8457 | MY_I_S_UNSIGNED, "Access_denied", SKIP_OPEN_TABLE}, | ||
706 | 8458 | {"EMPTY_QUERIES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
707 | 8459 | MY_I_S_UNSIGNED, "Empty_queries", SKIP_OPEN_TABLE}, | ||
708 | 8460 | {"TOTAL_SSL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, | ||
709 | 8461 | 0, MY_I_S_UNSIGNED, "Total_ssl_connections", SKIP_OPEN_TABLE}, | ||
710 | 8395 | {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0} | 8462 | {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0} |
711 | 8396 | }; | 8463 | }; |
712 | 8397 | 8464 | ||
713 | 8398 | ST_FIELD_INFO table_stats_fields_info[]= | 8465 | ST_FIELD_INFO table_stats_fields_info[]= |
714 | 8399 | { | 8466 | { |
720 | 8400 | {"TABLE_SCHEMA", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Table_schema", SKIP_OPEN_TABLE}, | 8467 | {"TABLE_SCHEMA", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Table_schema", |
721 | 8401 | {"TABLE_NAME", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Table_name", SKIP_OPEN_TABLE}, | 8468 | SKIP_OPEN_TABLE}, |
722 | 8402 | {"ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_read", SKIP_OPEN_TABLE}, | 8469 | {"TABLE_NAME", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Table_name", |
723 | 8403 | {"ROWS_CHANGED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_changed", SKIP_OPEN_TABLE}, | 8470 | SKIP_OPEN_TABLE}, |
724 | 8404 | {"ROWS_CHANGED_X_INDEXES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_changed_x_#indexes", SKIP_OPEN_TABLE}, | 8471 | {"ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, |
725 | 8472 | MY_I_S_UNSIGNED, "Rows_read", SKIP_OPEN_TABLE}, | ||
726 | 8473 | {"ROWS_CHANGED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
727 | 8474 | MY_I_S_UNSIGNED, "Rows_changed", SKIP_OPEN_TABLE}, | ||
728 | 8475 | {"ROWS_CHANGED_X_INDEXES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, | ||
729 | 8476 | 0, MY_I_S_UNSIGNED, "Rows_changed_x_#indexes", SKIP_OPEN_TABLE}, | ||
730 | 8405 | {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0} | 8477 | {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0} |
731 | 8406 | }; | 8478 | }; |
732 | 8407 | 8479 | ||
733 | 8408 | ST_FIELD_INFO index_stats_fields_info[]= | 8480 | ST_FIELD_INFO index_stats_fields_info[]= |
734 | 8409 | { | 8481 | { |
739 | 8410 | {"TABLE_SCHEMA", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Table_schema", SKIP_OPEN_TABLE}, | 8482 | {"TABLE_SCHEMA", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Table_schema", |
740 | 8411 | {"TABLE_NAME", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Table_name", SKIP_OPEN_TABLE}, | 8483 | SKIP_OPEN_TABLE}, |
741 | 8412 | {"INDEX_NAME", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Index_name", SKIP_OPEN_TABLE}, | 8484 | {"TABLE_NAME", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Table_name", |
742 | 8413 | {"ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_read", SKIP_OPEN_TABLE}, | 8485 | SKIP_OPEN_TABLE}, |
743 | 8486 | {"INDEX_NAME", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Index_name", | ||
744 | 8487 | SKIP_OPEN_TABLE}, | ||
745 | 8488 | {"ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0, | ||
746 | 8489 | MY_I_S_UNSIGNED, "Rows_read", SKIP_OPEN_TABLE}, | ||
747 | 8414 | {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0} | 8490 | {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0} |
748 | 8415 | }; | 8491 | }; |
749 | 8416 | 8492 |
Argh, wires crossed, that's wrong Jenkins. Jenkins job for this one hasn't completed yet.