Merge lp:~laurynas-biveinis/percona-server/bug714925-5.6 into lp:percona-server/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
Reviewer Review Type Date Requested Status
Vlad Lesin (community) Approve
Review via email: mp+166643@code.launchpad.net

Description of the change

To post a comment you must log in.
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

Argh, wires crossed, that's wrong Jenkins. Jenkins job for this one hasn't completed yet.

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 def information_schema CHARACTER_SETS DEFAULT_COLLATE_NAME 2 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select
6 def information_schema CHARACTER_SETS DESCRIPTION 3 NO varchar 60 180 NULL NULL NULL utf8 utf8_general_ci varchar(60) select
7 def information_schema CHARACTER_SETS MAXLEN 4 0 NO bigint NULL NULL 19 0 NULL NULL NULL bigint(3) select
8-def information_schema CLIENT_STATISTICS ACCESS_DENIED 20 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
9-def information_schema CLIENT_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
10-def information_schema CLIENT_STATISTICS BUSY_TIME 5 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
11-def information_schema CLIENT_STATISTICS BYTES_RECEIVED 7 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
12-def information_schema CLIENT_STATISTICS BYTES_SENT 8 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
13+def information_schema CLIENT_STATISTICS ACCESS_DENIED 20 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
14+def information_schema CLIENT_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
15+def information_schema CLIENT_STATISTICS BUSY_TIME 5 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
16+def information_schema CLIENT_STATISTICS BYTES_RECEIVED 7 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
17+def information_schema CLIENT_STATISTICS BYTES_SENT 8 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
18 def information_schema CLIENT_STATISTICS CLIENT 1 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select
19-def information_schema CLIENT_STATISTICS COMMIT_TRANSACTIONS 16 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
20-def information_schema CLIENT_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
21-def information_schema CLIENT_STATISTICS CONNECTED_TIME 4 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
22-def information_schema CLIENT_STATISTICS CPU_TIME 6 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
23-def information_schema CLIENT_STATISTICS DENIED_CONNECTIONS 18 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
24-def information_schema CLIENT_STATISTICS EMPTY_QUERIES 21 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
25-def information_schema CLIENT_STATISTICS LOST_CONNECTIONS 19 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
26-def information_schema CLIENT_STATISTICS OTHER_COMMANDS 15 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
27-def information_schema CLIENT_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
28-def information_schema CLIENT_STATISTICS ROWS_FETCHED 10 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
29-def information_schema CLIENT_STATISTICS ROWS_UPDATED 11 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
30-def information_schema CLIENT_STATISTICS SELECT_COMMANDS 13 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
31-def information_schema CLIENT_STATISTICS TABLE_ROWS_READ 12 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
32-def information_schema CLIENT_STATISTICS TOTAL_CONNECTIONS 2 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
33-def information_schema CLIENT_STATISTICS TOTAL_SSL_CONNECTIONS 22 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
34-def information_schema CLIENT_STATISTICS UPDATE_COMMANDS 14 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
35+def information_schema CLIENT_STATISTICS COMMIT_TRANSACTIONS 16 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
36+def information_schema CLIENT_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
37+def information_schema CLIENT_STATISTICS CONNECTED_TIME 4 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
38+def information_schema CLIENT_STATISTICS CPU_TIME 6 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
39+def information_schema CLIENT_STATISTICS DENIED_CONNECTIONS 18 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
40+def information_schema CLIENT_STATISTICS EMPTY_QUERIES 21 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
41+def information_schema CLIENT_STATISTICS LOST_CONNECTIONS 19 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
42+def information_schema CLIENT_STATISTICS OTHER_COMMANDS 15 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
43+def information_schema CLIENT_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
44+def information_schema CLIENT_STATISTICS ROWS_FETCHED 10 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
45+def information_schema CLIENT_STATISTICS ROWS_UPDATED 11 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
46+def information_schema CLIENT_STATISTICS SELECT_COMMANDS 13 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
47+def information_schema CLIENT_STATISTICS TABLE_ROWS_READ 12 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
48+def information_schema CLIENT_STATISTICS TOTAL_CONNECTIONS 2 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
49+def information_schema CLIENT_STATISTICS TOTAL_SSL_CONNECTIONS 22 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
50+def information_schema CLIENT_STATISTICS UPDATE_COMMANDS 14 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
51 def information_schema COLLATIONS CHARACTER_SET_NAME 2 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select
52 def information_schema COLLATIONS COLLATION_NAME 1 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select
53 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 def information_schema GLOBAL_VARIABLES VARIABLE_NAME 1 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select
56 def information_schema GLOBAL_VARIABLES VARIABLE_VALUE 2 NULL YES varchar 1024 3072 NULL NULL NULL utf8 utf8_general_ci varchar(1024) select
57 def information_schema INDEX_STATISTICS INDEX_NAME 3 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select
58-def information_schema INDEX_STATISTICS ROWS_READ 4 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
59+def information_schema INDEX_STATISTICS ROWS_READ 4 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
60 def information_schema INDEX_STATISTICS TABLE_NAME 2 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select
61 def information_schema INDEX_STATISTICS TABLE_SCHEMA 1 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select
62 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 def information_schema TABLE_PRIVILEGES TABLE_CATALOG 2 NO varchar 512 1536 NULL NULL NULL utf8 utf8_general_ci varchar(512) select
65 def information_schema TABLE_PRIVILEGES TABLE_NAME 4 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select
66 def information_schema TABLE_PRIVILEGES TABLE_SCHEMA 3 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select
67-def information_schema TABLE_STATISTICS ROWS_CHANGED 4 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
68-def information_schema TABLE_STATISTICS ROWS_CHANGED_X_INDEXES 5 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
69-def information_schema TABLE_STATISTICS ROWS_READ 3 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
70+def information_schema TABLE_STATISTICS ROWS_CHANGED 4 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
71+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+def information_schema TABLE_STATISTICS ROWS_READ 3 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
73 def information_schema TABLE_STATISTICS TABLE_NAME 2 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select
74 def information_schema TABLE_STATISTICS TABLE_SCHEMA 1 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select
75 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 def information_schema TEMPORARY_TABLES TABLE_ROWS 6 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
78 def information_schema TEMPORARY_TABLES TABLE_SCHEMA 2 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select
79 def information_schema TEMPORARY_TABLES UPDATE_TIME 11 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select
80-def information_schema THREAD_STATISTICS ACCESS_DENIED 20 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
81-def information_schema THREAD_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
82-def information_schema THREAD_STATISTICS BUSY_TIME 5 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
83-def information_schema THREAD_STATISTICS BYTES_RECEIVED 7 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
84-def information_schema THREAD_STATISTICS BYTES_SENT 8 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
85-def information_schema THREAD_STATISTICS COMMIT_TRANSACTIONS 16 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
86-def information_schema THREAD_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
87-def information_schema THREAD_STATISTICS CONNECTED_TIME 4 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
88-def information_schema THREAD_STATISTICS CPU_TIME 6 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
89-def information_schema THREAD_STATISTICS DENIED_CONNECTIONS 18 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
90-def information_schema THREAD_STATISTICS EMPTY_QUERIES 21 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
91-def information_schema THREAD_STATISTICS LOST_CONNECTIONS 19 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
92-def information_schema THREAD_STATISTICS OTHER_COMMANDS 15 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
93-def information_schema THREAD_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
94-def information_schema THREAD_STATISTICS ROWS_FETCHED 10 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
95-def information_schema THREAD_STATISTICS ROWS_UPDATED 11 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
96-def information_schema THREAD_STATISTICS SELECT_COMMANDS 13 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
97-def information_schema THREAD_STATISTICS TABLE_ROWS_READ 12 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
98-def information_schema THREAD_STATISTICS THREAD_ID 1 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
99-def information_schema THREAD_STATISTICS TOTAL_CONNECTIONS 2 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
100-def information_schema THREAD_STATISTICS TOTAL_SSL_CONNECTIONS 22 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
101-def information_schema THREAD_STATISTICS UPDATE_COMMANDS 14 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
102+def information_schema THREAD_STATISTICS ACCESS_DENIED 20 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
103+def information_schema THREAD_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
104+def information_schema THREAD_STATISTICS BUSY_TIME 5 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
105+def information_schema THREAD_STATISTICS BYTES_RECEIVED 7 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
106+def information_schema THREAD_STATISTICS BYTES_SENT 8 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
107+def information_schema THREAD_STATISTICS COMMIT_TRANSACTIONS 16 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
108+def information_schema THREAD_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
109+def information_schema THREAD_STATISTICS CONNECTED_TIME 4 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
110+def information_schema THREAD_STATISTICS CPU_TIME 6 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
111+def information_schema THREAD_STATISTICS DENIED_CONNECTIONS 18 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
112+def information_schema THREAD_STATISTICS EMPTY_QUERIES 21 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
113+def information_schema THREAD_STATISTICS LOST_CONNECTIONS 19 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
114+def information_schema THREAD_STATISTICS OTHER_COMMANDS 15 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
115+def information_schema THREAD_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
116+def information_schema THREAD_STATISTICS ROWS_FETCHED 10 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
117+def information_schema THREAD_STATISTICS ROWS_UPDATED 11 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
118+def information_schema THREAD_STATISTICS SELECT_COMMANDS 13 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
119+def information_schema THREAD_STATISTICS TABLE_ROWS_READ 12 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
120+def information_schema THREAD_STATISTICS THREAD_ID 1 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
121+def information_schema THREAD_STATISTICS TOTAL_CONNECTIONS 2 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
122+def information_schema THREAD_STATISTICS TOTAL_SSL_CONNECTIONS 22 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
123+def information_schema THREAD_STATISTICS UPDATE_COMMANDS 14 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
124 def information_schema TRIGGERS ACTION_CONDITION 9 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8 utf8_general_ci longtext select
125 def information_schema TRIGGERS ACTION_ORDER 8 0 NO bigint NULL NULL 19 0 NULL NULL NULL bigint(4) select
126 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 def information_schema USER_PRIVILEGES IS_GRANTABLE 4 NO varchar 3 9 NULL NULL NULL utf8 utf8_general_ci varchar(3) select
129 def information_schema USER_PRIVILEGES PRIVILEGE_TYPE 3 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select
130 def information_schema USER_PRIVILEGES TABLE_CATALOG 2 NO varchar 512 1536 NULL NULL NULL utf8 utf8_general_ci varchar(512) select
131-def information_schema USER_STATISTICS ACCESS_DENIED 20 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
132-def information_schema USER_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
133-def information_schema USER_STATISTICS BUSY_TIME 5 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
134-def information_schema USER_STATISTICS BYTES_RECEIVED 7 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
135-def information_schema USER_STATISTICS BYTES_SENT 8 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
136-def information_schema USER_STATISTICS COMMIT_TRANSACTIONS 16 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
137-def information_schema USER_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
138-def information_schema USER_STATISTICS CONNECTED_TIME 4 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
139-def information_schema USER_STATISTICS CPU_TIME 6 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
140-def information_schema USER_STATISTICS DENIED_CONNECTIONS 18 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
141-def information_schema USER_STATISTICS EMPTY_QUERIES 21 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
142-def information_schema USER_STATISTICS LOST_CONNECTIONS 19 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
143-def information_schema USER_STATISTICS OTHER_COMMANDS 15 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
144-def information_schema USER_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
145-def information_schema USER_STATISTICS ROWS_FETCHED 10 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
146-def information_schema USER_STATISTICS ROWS_UPDATED 11 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
147-def information_schema USER_STATISTICS SELECT_COMMANDS 13 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
148-def information_schema USER_STATISTICS TABLE_ROWS_READ 12 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
149-def information_schema USER_STATISTICS TOTAL_CONNECTIONS 2 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
150-def information_schema USER_STATISTICS TOTAL_SSL_CONNECTIONS 22 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
151-def information_schema USER_STATISTICS UPDATE_COMMANDS 14 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select
152+def information_schema USER_STATISTICS ACCESS_DENIED 20 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
153+def information_schema USER_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
154+def information_schema USER_STATISTICS BUSY_TIME 5 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
155+def information_schema USER_STATISTICS BYTES_RECEIVED 7 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
156+def information_schema USER_STATISTICS BYTES_SENT 8 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
157+def information_schema USER_STATISTICS COMMIT_TRANSACTIONS 16 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
158+def information_schema USER_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
159+def information_schema USER_STATISTICS CONNECTED_TIME 4 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
160+def information_schema USER_STATISTICS CPU_TIME 6 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
161+def information_schema USER_STATISTICS DENIED_CONNECTIONS 18 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
162+def information_schema USER_STATISTICS EMPTY_QUERIES 21 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
163+def information_schema USER_STATISTICS LOST_CONNECTIONS 19 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
164+def information_schema USER_STATISTICS OTHER_COMMANDS 15 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
165+def information_schema USER_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
166+def information_schema USER_STATISTICS ROWS_FETCHED 10 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
167+def information_schema USER_STATISTICS ROWS_UPDATED 11 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
168+def information_schema USER_STATISTICS SELECT_COMMANDS 13 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
169+def information_schema USER_STATISTICS TABLE_ROWS_READ 12 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
170+def information_schema USER_STATISTICS TOTAL_CONNECTIONS 2 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
171+def information_schema USER_STATISTICS TOTAL_SSL_CONNECTIONS 22 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
172+def information_schema USER_STATISTICS UPDATE_COMMANDS 14 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
173 def information_schema USER_STATISTICS USER 1 NO varchar 48 144 NULL NULL NULL utf8 utf8_general_ci varchar(48) select
174 def information_schema VIEWS CHARACTER_SET_CLIENT 9 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select
175 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 3.0000 information_schema CHARACTER_SETS DESCRIPTION varchar 60 180 utf8 utf8_general_ci varchar(60)
178 NULL information_schema CHARACTER_SETS MAXLEN bigint NULL NULL NULL NULL bigint(3)
179 3.0000 information_schema CLIENT_STATISTICS CLIENT varchar 64 192 utf8 utf8_general_ci varchar(64)
180-NULL information_schema CLIENT_STATISTICS TOTAL_CONNECTIONS int NULL NULL NULL NULL int(21)
181-NULL information_schema CLIENT_STATISTICS CONCURRENT_CONNECTIONS int NULL NULL NULL NULL int(21)
182-NULL information_schema CLIENT_STATISTICS CONNECTED_TIME int NULL NULL NULL NULL int(21)
183-NULL information_schema CLIENT_STATISTICS BUSY_TIME int NULL NULL NULL NULL int(21)
184-NULL information_schema CLIENT_STATISTICS CPU_TIME int NULL NULL NULL NULL int(21)
185-NULL information_schema CLIENT_STATISTICS BYTES_RECEIVED int NULL NULL NULL NULL int(21)
186-NULL information_schema CLIENT_STATISTICS BYTES_SENT int NULL NULL NULL NULL int(21)
187-NULL information_schema CLIENT_STATISTICS BINLOG_BYTES_WRITTEN int NULL NULL NULL NULL int(21)
188-NULL information_schema CLIENT_STATISTICS ROWS_FETCHED int NULL NULL NULL NULL int(21)
189-NULL information_schema CLIENT_STATISTICS ROWS_UPDATED int NULL NULL NULL NULL int(21)
190-NULL information_schema CLIENT_STATISTICS TABLE_ROWS_READ int NULL NULL NULL NULL int(21)
191-NULL information_schema CLIENT_STATISTICS SELECT_COMMANDS int NULL NULL NULL NULL int(21)
192-NULL information_schema CLIENT_STATISTICS UPDATE_COMMANDS int NULL NULL NULL NULL int(21)
193-NULL information_schema CLIENT_STATISTICS OTHER_COMMANDS int NULL NULL NULL NULL int(21)
194-NULL information_schema CLIENT_STATISTICS COMMIT_TRANSACTIONS int NULL NULL NULL NULL int(21)
195-NULL information_schema CLIENT_STATISTICS ROLLBACK_TRANSACTIONS int NULL NULL NULL NULL int(21)
196-NULL information_schema CLIENT_STATISTICS DENIED_CONNECTIONS int NULL NULL NULL NULL int(21)
197-NULL information_schema CLIENT_STATISTICS LOST_CONNECTIONS int NULL NULL NULL NULL int(21)
198-NULL information_schema CLIENT_STATISTICS ACCESS_DENIED int NULL NULL NULL NULL int(21)
199-NULL information_schema CLIENT_STATISTICS EMPTY_QUERIES int NULL NULL NULL NULL int(21)
200-NULL information_schema CLIENT_STATISTICS TOTAL_SSL_CONNECTIONS int NULL NULL NULL NULL int(21)
201+NULL information_schema CLIENT_STATISTICS TOTAL_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
202+NULL information_schema CLIENT_STATISTICS CONCURRENT_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
203+NULL information_schema CLIENT_STATISTICS CONNECTED_TIME bigint NULL NULL NULL NULL bigint(21) unsigned
204+NULL information_schema CLIENT_STATISTICS BUSY_TIME bigint NULL NULL NULL NULL bigint(21) unsigned
205+NULL information_schema CLIENT_STATISTICS CPU_TIME bigint NULL NULL NULL NULL bigint(21) unsigned
206+NULL information_schema CLIENT_STATISTICS BYTES_RECEIVED bigint NULL NULL NULL NULL bigint(21) unsigned
207+NULL information_schema CLIENT_STATISTICS BYTES_SENT bigint NULL NULL NULL NULL bigint(21) unsigned
208+NULL information_schema CLIENT_STATISTICS BINLOG_BYTES_WRITTEN bigint NULL NULL NULL NULL bigint(21) unsigned
209+NULL information_schema CLIENT_STATISTICS ROWS_FETCHED bigint NULL NULL NULL NULL bigint(21) unsigned
210+NULL information_schema CLIENT_STATISTICS ROWS_UPDATED bigint NULL NULL NULL NULL bigint(21) unsigned
211+NULL information_schema CLIENT_STATISTICS TABLE_ROWS_READ bigint NULL NULL NULL NULL bigint(21) unsigned
212+NULL information_schema CLIENT_STATISTICS SELECT_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned
213+NULL information_schema CLIENT_STATISTICS UPDATE_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned
214+NULL information_schema CLIENT_STATISTICS OTHER_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned
215+NULL information_schema CLIENT_STATISTICS COMMIT_TRANSACTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
216+NULL information_schema CLIENT_STATISTICS ROLLBACK_TRANSACTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
217+NULL information_schema CLIENT_STATISTICS DENIED_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
218+NULL information_schema CLIENT_STATISTICS LOST_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
219+NULL information_schema CLIENT_STATISTICS ACCESS_DENIED bigint NULL NULL NULL NULL bigint(21) unsigned
220+NULL information_schema CLIENT_STATISTICS EMPTY_QUERIES bigint NULL NULL NULL NULL bigint(21) unsigned
221+NULL information_schema CLIENT_STATISTICS TOTAL_SSL_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
222 3.0000 information_schema COLLATIONS COLLATION_NAME varchar 32 96 utf8 utf8_general_ci varchar(32)
223 3.0000 information_schema COLLATIONS CHARACTER_SET_NAME varchar 32 96 utf8 utf8_general_ci varchar(32)
224 NULL information_schema COLLATIONS ID bigint NULL NULL NULL NULL bigint(11)
225@@ -660,7 +660,7 @@
226 3.0000 information_schema INDEX_STATISTICS TABLE_SCHEMA varchar 192 576 utf8 utf8_general_ci varchar(192)
227 3.0000 information_schema INDEX_STATISTICS TABLE_NAME varchar 192 576 utf8 utf8_general_ci varchar(192)
228 3.0000 information_schema INDEX_STATISTICS INDEX_NAME varchar 192 576 utf8 utf8_general_ci varchar(192)
229-NULL information_schema INDEX_STATISTICS ROWS_READ int NULL NULL NULL NULL int(21)
230+NULL information_schema INDEX_STATISTICS ROWS_READ bigint NULL NULL NULL NULL bigint(21) unsigned
231 3.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512)
232 3.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64)
233 3.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)
234@@ -856,9 +856,9 @@
235 3.0000 information_schema TABLE_PRIVILEGES IS_GRANTABLE varchar 3 9 utf8 utf8_general_ci varchar(3)
236 3.0000 information_schema TABLE_STATISTICS TABLE_SCHEMA varchar 192 576 utf8 utf8_general_ci varchar(192)
237 3.0000 information_schema TABLE_STATISTICS TABLE_NAME varchar 192 576 utf8 utf8_general_ci varchar(192)
238-NULL information_schema TABLE_STATISTICS ROWS_READ int NULL NULL NULL NULL int(21)
239-NULL information_schema TABLE_STATISTICS ROWS_CHANGED int NULL NULL NULL NULL int(21)
240-NULL information_schema TABLE_STATISTICS ROWS_CHANGED_X_INDEXES int NULL NULL NULL NULL int(21)
241+NULL information_schema TABLE_STATISTICS ROWS_READ bigint NULL NULL NULL NULL bigint(21) unsigned
242+NULL information_schema TABLE_STATISTICS ROWS_CHANGED bigint NULL NULL NULL NULL bigint(21) unsigned
243+NULL information_schema TABLE_STATISTICS ROWS_CHANGED_X_INDEXES bigint NULL NULL NULL NULL bigint(21) unsigned
244 NULL information_schema TEMPORARY_TABLES SESSION_ID bigint NULL NULL NULL NULL bigint(4)
245 3.0000 information_schema TEMPORARY_TABLES TABLE_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64)
246 3.0000 information_schema TEMPORARY_TABLES TABLE_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)
247@@ -870,28 +870,28 @@
248 NULL information_schema TEMPORARY_TABLES INDEX_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
249 NULL information_schema TEMPORARY_TABLES CREATE_TIME datetime NULL NULL NULL NULL datetime
250 NULL information_schema TEMPORARY_TABLES UPDATE_TIME datetime NULL NULL NULL NULL datetime
251-NULL information_schema THREAD_STATISTICS THREAD_ID int NULL NULL NULL NULL int(21)
252-NULL information_schema THREAD_STATISTICS TOTAL_CONNECTIONS int NULL NULL NULL NULL int(21)
253-NULL information_schema THREAD_STATISTICS CONCURRENT_CONNECTIONS int NULL NULL NULL NULL int(21)
254-NULL information_schema THREAD_STATISTICS CONNECTED_TIME int NULL NULL NULL NULL int(21)
255-NULL information_schema THREAD_STATISTICS BUSY_TIME int NULL NULL NULL NULL int(21)
256-NULL information_schema THREAD_STATISTICS CPU_TIME int NULL NULL NULL NULL int(21)
257-NULL information_schema THREAD_STATISTICS BYTES_RECEIVED int NULL NULL NULL NULL int(21)
258-NULL information_schema THREAD_STATISTICS BYTES_SENT int NULL NULL NULL NULL int(21)
259-NULL information_schema THREAD_STATISTICS BINLOG_BYTES_WRITTEN int NULL NULL NULL NULL int(21)
260-NULL information_schema THREAD_STATISTICS ROWS_FETCHED int NULL NULL NULL NULL int(21)
261-NULL information_schema THREAD_STATISTICS ROWS_UPDATED int NULL NULL NULL NULL int(21)
262-NULL information_schema THREAD_STATISTICS TABLE_ROWS_READ int NULL NULL NULL NULL int(21)
263-NULL information_schema THREAD_STATISTICS SELECT_COMMANDS int NULL NULL NULL NULL int(21)
264-NULL information_schema THREAD_STATISTICS UPDATE_COMMANDS int NULL NULL NULL NULL int(21)
265-NULL information_schema THREAD_STATISTICS OTHER_COMMANDS int NULL NULL NULL NULL int(21)
266-NULL information_schema THREAD_STATISTICS COMMIT_TRANSACTIONS int NULL NULL NULL NULL int(21)
267-NULL information_schema THREAD_STATISTICS ROLLBACK_TRANSACTIONS int NULL NULL NULL NULL int(21)
268-NULL information_schema THREAD_STATISTICS DENIED_CONNECTIONS int NULL NULL NULL NULL int(21)
269-NULL information_schema THREAD_STATISTICS LOST_CONNECTIONS int NULL NULL NULL NULL int(21)
270-NULL information_schema THREAD_STATISTICS ACCESS_DENIED int NULL NULL NULL NULL int(21)
271-NULL information_schema THREAD_STATISTICS EMPTY_QUERIES int NULL NULL NULL NULL int(21)
272-NULL information_schema THREAD_STATISTICS TOTAL_SSL_CONNECTIONS int NULL NULL NULL NULL int(21)
273+NULL information_schema THREAD_STATISTICS THREAD_ID bigint NULL NULL NULL NULL bigint(21) unsigned
274+NULL information_schema THREAD_STATISTICS TOTAL_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
275+NULL information_schema THREAD_STATISTICS CONCURRENT_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
276+NULL information_schema THREAD_STATISTICS CONNECTED_TIME bigint NULL NULL NULL NULL bigint(21) unsigned
277+NULL information_schema THREAD_STATISTICS BUSY_TIME bigint NULL NULL NULL NULL bigint(21) unsigned
278+NULL information_schema THREAD_STATISTICS CPU_TIME bigint NULL NULL NULL NULL bigint(21) unsigned
279+NULL information_schema THREAD_STATISTICS BYTES_RECEIVED bigint NULL NULL NULL NULL bigint(21) unsigned
280+NULL information_schema THREAD_STATISTICS BYTES_SENT bigint NULL NULL NULL NULL bigint(21) unsigned
281+NULL information_schema THREAD_STATISTICS BINLOG_BYTES_WRITTEN bigint NULL NULL NULL NULL bigint(21) unsigned
282+NULL information_schema THREAD_STATISTICS ROWS_FETCHED bigint NULL NULL NULL NULL bigint(21) unsigned
283+NULL information_schema THREAD_STATISTICS ROWS_UPDATED bigint NULL NULL NULL NULL bigint(21) unsigned
284+NULL information_schema THREAD_STATISTICS TABLE_ROWS_READ bigint NULL NULL NULL NULL bigint(21) unsigned
285+NULL information_schema THREAD_STATISTICS SELECT_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned
286+NULL information_schema THREAD_STATISTICS UPDATE_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned
287+NULL information_schema THREAD_STATISTICS OTHER_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned
288+NULL information_schema THREAD_STATISTICS COMMIT_TRANSACTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
289+NULL information_schema THREAD_STATISTICS ROLLBACK_TRANSACTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
290+NULL information_schema THREAD_STATISTICS DENIED_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
291+NULL information_schema THREAD_STATISTICS LOST_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
292+NULL information_schema THREAD_STATISTICS ACCESS_DENIED bigint NULL NULL NULL NULL bigint(21) unsigned
293+NULL information_schema THREAD_STATISTICS EMPTY_QUERIES bigint NULL NULL NULL NULL bigint(21) unsigned
294+NULL information_schema THREAD_STATISTICS TOTAL_SSL_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
295 3.0000 information_schema TRIGGERS TRIGGER_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512)
296 3.0000 information_schema TRIGGERS TRIGGER_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64)
297 3.0000 information_schema TRIGGERS TRIGGER_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)
298@@ -919,27 +919,27 @@
299 3.0000 information_schema USER_PRIVILEGES PRIVILEGE_TYPE varchar 64 192 utf8 utf8_general_ci varchar(64)
300 3.0000 information_schema USER_PRIVILEGES IS_GRANTABLE varchar 3 9 utf8 utf8_general_ci varchar(3)
301 3.0000 information_schema USER_STATISTICS USER varchar 48 144 utf8 utf8_general_ci varchar(48)
302-NULL information_schema USER_STATISTICS TOTAL_CONNECTIONS int NULL NULL NULL NULL int(21)
303-NULL information_schema USER_STATISTICS CONCURRENT_CONNECTIONS int NULL NULL NULL NULL int(21)
304-NULL information_schema USER_STATISTICS CONNECTED_TIME int NULL NULL NULL NULL int(21)
305-NULL information_schema USER_STATISTICS BUSY_TIME int NULL NULL NULL NULL int(21)
306-NULL information_schema USER_STATISTICS CPU_TIME int NULL NULL NULL NULL int(21)
307-NULL information_schema USER_STATISTICS BYTES_RECEIVED int NULL NULL NULL NULL int(21)
308-NULL information_schema USER_STATISTICS BYTES_SENT int NULL NULL NULL NULL int(21)
309-NULL information_schema USER_STATISTICS BINLOG_BYTES_WRITTEN int NULL NULL NULL NULL int(21)
310-NULL information_schema USER_STATISTICS ROWS_FETCHED int NULL NULL NULL NULL int(21)
311-NULL information_schema USER_STATISTICS ROWS_UPDATED int NULL NULL NULL NULL int(21)
312-NULL information_schema USER_STATISTICS TABLE_ROWS_READ int NULL NULL NULL NULL int(21)
313-NULL information_schema USER_STATISTICS SELECT_COMMANDS int NULL NULL NULL NULL int(21)
314-NULL information_schema USER_STATISTICS UPDATE_COMMANDS int NULL NULL NULL NULL int(21)
315-NULL information_schema USER_STATISTICS OTHER_COMMANDS int NULL NULL NULL NULL int(21)
316-NULL information_schema USER_STATISTICS COMMIT_TRANSACTIONS int NULL NULL NULL NULL int(21)
317-NULL information_schema USER_STATISTICS ROLLBACK_TRANSACTIONS int NULL NULL NULL NULL int(21)
318-NULL information_schema USER_STATISTICS DENIED_CONNECTIONS int NULL NULL NULL NULL int(21)
319-NULL information_schema USER_STATISTICS LOST_CONNECTIONS int NULL NULL NULL NULL int(21)
320-NULL information_schema USER_STATISTICS ACCESS_DENIED int NULL NULL NULL NULL int(21)
321-NULL information_schema USER_STATISTICS EMPTY_QUERIES int NULL NULL NULL NULL int(21)
322-NULL information_schema USER_STATISTICS TOTAL_SSL_CONNECTIONS int NULL NULL NULL NULL int(21)
323+NULL information_schema USER_STATISTICS TOTAL_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
324+NULL information_schema USER_STATISTICS CONCURRENT_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
325+NULL information_schema USER_STATISTICS CONNECTED_TIME bigint NULL NULL NULL NULL bigint(21) unsigned
326+NULL information_schema USER_STATISTICS BUSY_TIME bigint NULL NULL NULL NULL bigint(21) unsigned
327+NULL information_schema USER_STATISTICS CPU_TIME bigint NULL NULL NULL NULL bigint(21) unsigned
328+NULL information_schema USER_STATISTICS BYTES_RECEIVED bigint NULL NULL NULL NULL bigint(21) unsigned
329+NULL information_schema USER_STATISTICS BYTES_SENT bigint NULL NULL NULL NULL bigint(21) unsigned
330+NULL information_schema USER_STATISTICS BINLOG_BYTES_WRITTEN bigint NULL NULL NULL NULL bigint(21) unsigned
331+NULL information_schema USER_STATISTICS ROWS_FETCHED bigint NULL NULL NULL NULL bigint(21) unsigned
332+NULL information_schema USER_STATISTICS ROWS_UPDATED bigint NULL NULL NULL NULL bigint(21) unsigned
333+NULL information_schema USER_STATISTICS TABLE_ROWS_READ bigint NULL NULL NULL NULL bigint(21) unsigned
334+NULL information_schema USER_STATISTICS SELECT_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned
335+NULL information_schema USER_STATISTICS UPDATE_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned
336+NULL information_schema USER_STATISTICS OTHER_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned
337+NULL information_schema USER_STATISTICS COMMIT_TRANSACTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
338+NULL information_schema USER_STATISTICS ROLLBACK_TRANSACTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
339+NULL information_schema USER_STATISTICS DENIED_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
340+NULL information_schema USER_STATISTICS LOST_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
341+NULL information_schema USER_STATISTICS ACCESS_DENIED bigint NULL NULL NULL NULL bigint(21) unsigned
342+NULL information_schema USER_STATISTICS EMPTY_QUERIES bigint NULL NULL NULL NULL bigint(21) unsigned
343+NULL information_schema USER_STATISTICS TOTAL_SSL_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
344 3.0000 information_schema VIEWS TABLE_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512)
345 3.0000 information_schema VIEWS TABLE_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64)
346 3.0000 information_schema VIEWS TABLE_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)
347
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 for (uint i = 0; i < all_user_stats->records; ++i)
353 {
354 restore_record(table, s->default_values);
355- USER_STATS *user_stats = (USER_STATS *) my_hash_element(all_user_stats, i);
356- table->field[0]->store(user_stats->user, strlen(user_stats->user), system_charset_info);
357- table->field[1]->store((longlong)user_stats->total_connections);
358- table->field[2]->store((longlong)user_stats->concurrent_connections);
359- table->field[3]->store((longlong)user_stats->connected_time);
360- table->field[4]->store((longlong)user_stats->busy_time);
361- table->field[5]->store((longlong)user_stats->cpu_time);
362- table->field[6]->store((longlong)user_stats->bytes_received);
363- table->field[7]->store((longlong)user_stats->bytes_sent);
364- table->field[8]->store((longlong)user_stats->binlog_bytes_written);
365- table->field[9]->store((longlong)user_stats->rows_fetched);
366- table->field[10]->store((longlong)user_stats->rows_updated);
367- table->field[11]->store((longlong)user_stats->rows_read);
368- table->field[12]->store((longlong)user_stats->select_commands);
369- table->field[13]->store((longlong)user_stats->update_commands);
370- table->field[14]->store((longlong)user_stats->other_commands);
371- table->field[15]->store((longlong)user_stats->commit_trans);
372- table->field[16]->store((longlong)user_stats->rollback_trans);
373- table->field[17]->store((longlong)user_stats->denied_connections);
374- table->field[18]->store((longlong)user_stats->lost_connections);
375- table->field[19]->store((longlong)user_stats->access_denied_errors);
376- table->field[20]->store((longlong)user_stats->empty_queries);
377- table->field[21]->store((longlong)user_stats->total_ssl_connections);
378- if (schema_table_store_record(thd, table))
379- {
380- DBUG_PRINT("error", ("store record error"));
381- DBUG_RETURN(1);
382- }
383+ USER_STATS *user_stats = (USER_STATS*) my_hash_element(all_user_stats, i);
384+ table->field[0]->store(user_stats->user, strlen(user_stats->user),
385+ system_charset_info);
386+ table->field[1]->store(user_stats->total_connections, true);
387+ table->field[2]->store(user_stats->concurrent_connections, true);
388+ table->field[3]->store(user_stats->connected_time, true);
389+ table->field[4]->store((ulonglong)user_stats->busy_time, true);
390+ table->field[5]->store((ulonglong)user_stats->cpu_time, true);
391+ table->field[6]->store(user_stats->bytes_received, true);
392+ table->field[7]->store(user_stats->bytes_sent, true);
393+ table->field[8]->store(user_stats->binlog_bytes_written, true);
394+ table->field[9]->store(user_stats->rows_fetched, true);
395+ table->field[10]->store(user_stats->rows_updated, true);
396+ table->field[11]->store(user_stats->rows_read, true);
397+ table->field[12]->store(user_stats->select_commands, true);
398+ table->field[13]->store(user_stats->update_commands, true);
399+ table->field[14]->store(user_stats->other_commands, true);
400+ table->field[15]->store(user_stats->commit_trans, true);
401+ table->field[16]->store(user_stats->rollback_trans, true);
402+ table->field[17]->store(user_stats->denied_connections, true);
403+ table->field[18]->store(user_stats->lost_connections, true);
404+ table->field[19]->store(user_stats->access_denied_errors, true);
405+ table->field[20]->store(user_stats->empty_queries, true);
406+ table->field[21]->store(user_stats->total_ssl_connections, true);
407+ if (schema_table_store_record(thd, table))
408+ {
409+ DBUG_PRINT("error", ("store record error"));
410+ DBUG_RETURN(1);
411+ }
412 }
413 DBUG_RETURN(0);
414 }
415@@ -2672,34 +2673,35 @@
416 for (uint i = 0; i < all_thread_stats->records; ++i)
417 {
418 restore_record(table, s->default_values);
419- THREAD_STATS *user_stats = (THREAD_STATS *) my_hash_element(all_thread_stats, i);
420- table->field[0]->store((longlong)user_stats->id);
421- table->field[1]->store((longlong)user_stats->total_connections);
422- table->field[2]->store((longlong)user_stats->concurrent_connections);
423- table->field[3]->store((longlong)user_stats->connected_time);
424- table->field[4]->store((longlong)user_stats->busy_time);
425- table->field[5]->store((longlong)user_stats->cpu_time);
426- table->field[6]->store((longlong)user_stats->bytes_received);
427- table->field[7]->store((longlong)user_stats->bytes_sent);
428- table->field[8]->store((longlong)user_stats->binlog_bytes_written);
429- table->field[9]->store((longlong)user_stats->rows_fetched);
430- table->field[10]->store((longlong)user_stats->rows_updated);
431- table->field[11]->store((longlong)user_stats->rows_read);
432- table->field[12]->store((longlong)user_stats->select_commands);
433- table->field[13]->store((longlong)user_stats->update_commands);
434- table->field[14]->store((longlong)user_stats->other_commands);
435- table->field[15]->store((longlong)user_stats->commit_trans);
436- table->field[16]->store((longlong)user_stats->rollback_trans);
437- table->field[17]->store((longlong)user_stats->denied_connections);
438- table->field[18]->store((longlong)user_stats->lost_connections);
439- table->field[19]->store((longlong)user_stats->access_denied_errors);
440- table->field[20]->store((longlong)user_stats->empty_queries);
441- table->field[21]->store((longlong)user_stats->total_ssl_connections);
442- if (schema_table_store_record(thd, table))
443- {
444- DBUG_PRINT("error", ("store record error"));
445- DBUG_RETURN(1);
446- }
447+ THREAD_STATS *user_stats
448+ = (THREAD_STATS*)my_hash_element(all_thread_stats, i);
449+ table->field[0]->store(user_stats->id, true);
450+ table->field[1]->store(user_stats->total_connections, true);
451+ table->field[2]->store(user_stats->concurrent_connections, true);
452+ table->field[3]->store(user_stats->connected_time, true);
453+ table->field[4]->store((ulonglong)user_stats->busy_time, true);
454+ table->field[5]->store((ulonglong)user_stats->cpu_time, true);
455+ table->field[6]->store(user_stats->bytes_received, true);
456+ table->field[7]->store(user_stats->bytes_sent, true);
457+ table->field[8]->store(user_stats->binlog_bytes_written, true);
458+ table->field[9]->store(user_stats->rows_fetched, true);
459+ table->field[10]->store(user_stats->rows_updated, true);
460+ table->field[11]->store(user_stats->rows_read, true);
461+ table->field[12]->store(user_stats->select_commands, true);
462+ table->field[13]->store(user_stats->update_commands, true);
463+ table->field[14]->store(user_stats->other_commands, true);
464+ table->field[15]->store(user_stats->commit_trans, true);
465+ table->field[16]->store(user_stats->rollback_trans, true);
466+ table->field[17]->store(user_stats->denied_connections, true);
467+ table->field[18]->store(user_stats->lost_connections, true);
468+ table->field[19]->store(user_stats->access_denied_errors, true);
469+ table->field[20]->store(user_stats->empty_queries, true);
470+ table->field[21]->store(user_stats->total_ssl_connections, true);
471+ if (schema_table_store_record(thd, table))
472+ {
473+ DBUG_PRINT("error", ("store record error"));
474+ DBUG_RETURN(1);
475+ }
476 }
477 DBUG_RETURN(0);
478 }
479@@ -2838,9 +2840,9 @@
480
481 table->field[0]->store(table_schema, strlen(table_schema), system_charset_info);
482 table->field[1]->store(table_full_name, strlen(table_full_name), system_charset_info);
483- table->field[2]->store((longlong)table_stats->rows_read, TRUE);
484- table->field[3]->store((longlong)table_stats->rows_changed, TRUE);
485- table->field[4]->store((longlong)table_stats->rows_changed_x_indexes, TRUE);
486+ table->field[2]->store(table_stats->rows_read, true);
487+ table->field[3]->store(table_stats->rows_changed, true);
488+ table->field[4]->store(table_stats->rows_changed_x_indexes, true);
489
490 if (schema_table_store_record(thd, table))
491 {
492@@ -2884,7 +2886,7 @@
493 table->field[0]->store(table_schema, strlen(table_schema), system_charset_info);
494 table->field[1]->store(table_name, strlen(table_name), system_charset_info);
495 table->field[2]->store(index_full_name, strlen(index_full_name), system_charset_info);
496- table->field[3]->store((longlong)index_stats->rows_read, TRUE);
497+ table->field[3]->store(index_stats->rows_read, true);
498
499 if (schema_table_store_record(thd, table))
500 {
501@@ -8317,100 +8319,174 @@
502 ST_FIELD_INFO user_stats_fields_info[]=
503 {
504 {"USER", USERNAME_LENGTH, MYSQL_TYPE_STRING, 0, 0, "User", SKIP_OPEN_TABLE},
505- {"TOTAL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Total_connections", SKIP_OPEN_TABLE},
506- {"CONCURRENT_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Concurrent_connections", SKIP_OPEN_TABLE},
507- {"CONNECTED_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Connected_time", SKIP_OPEN_TABLE},
508- {"BUSY_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Busy_time", SKIP_OPEN_TABLE},
509- {"CPU_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Cpu_time", SKIP_OPEN_TABLE},
510- {"BYTES_RECEIVED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Bytes_received", SKIP_OPEN_TABLE},
511- {"BYTES_SENT", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Bytes_sent", SKIP_OPEN_TABLE},
512- {"BINLOG_BYTES_WRITTEN", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Binlog_bytes_written", SKIP_OPEN_TABLE},
513- {"ROWS_FETCHED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_fetched", SKIP_OPEN_TABLE},
514- {"ROWS_UPDATED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_updated", SKIP_OPEN_TABLE},
515- {"TABLE_ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Table_rows_read", SKIP_OPEN_TABLE},
516- {"SELECT_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Select_commands", SKIP_OPEN_TABLE},
517- {"UPDATE_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Update_commands", SKIP_OPEN_TABLE},
518- {"OTHER_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Other_commands", SKIP_OPEN_TABLE},
519- {"COMMIT_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Commit_transactions", SKIP_OPEN_TABLE},
520- {"ROLLBACK_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rollback_transactions", SKIP_OPEN_TABLE},
521- {"DENIED_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Denied_connections", SKIP_OPEN_TABLE},
522- {"LOST_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Lost_connections", SKIP_OPEN_TABLE},
523- {"ACCESS_DENIED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Access_denied", SKIP_OPEN_TABLE},
524- {"EMPTY_QUERIES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Empty_queries", SKIP_OPEN_TABLE},
525- {"TOTAL_SSL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Total_ssl_connections", SKIP_OPEN_TABLE},
526+ {"TOTAL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
527+ MY_I_S_UNSIGNED, "Total_connections", SKIP_OPEN_TABLE},
528+ {"CONCURRENT_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
529+ 0, MY_I_S_UNSIGNED, "Concurrent_connections", SKIP_OPEN_TABLE},
530+ {"CONNECTED_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
531+ MY_I_S_UNSIGNED, "Connected_time", SKIP_OPEN_TABLE},
532+ {"BUSY_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
533+ MY_I_S_UNSIGNED, "Busy_time", SKIP_OPEN_TABLE},
534+ {"CPU_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
535+ MY_I_S_UNSIGNED, "Cpu_time", SKIP_OPEN_TABLE},
536+ {"BYTES_RECEIVED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
537+ MY_I_S_UNSIGNED, "Bytes_received", SKIP_OPEN_TABLE},
538+ {"BYTES_SENT", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
539+ MY_I_S_UNSIGNED, "Bytes_sent", SKIP_OPEN_TABLE},
540+ {"BINLOG_BYTES_WRITTEN", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
541+ 0, MY_I_S_UNSIGNED, "Binlog_bytes_written", SKIP_OPEN_TABLE},
542+ {"ROWS_FETCHED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
543+ MY_I_S_UNSIGNED, "Rows_fetched", SKIP_OPEN_TABLE},
544+ {"ROWS_UPDATED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
545+ MY_I_S_UNSIGNED, "Rows_updated", SKIP_OPEN_TABLE},
546+ {"TABLE_ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
547+ MY_I_S_UNSIGNED, "Table_rows_read", SKIP_OPEN_TABLE},
548+ {"SELECT_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
549+ MY_I_S_UNSIGNED, "Select_commands", SKIP_OPEN_TABLE},
550+ {"UPDATE_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
551+ MY_I_S_UNSIGNED, "Update_commands", SKIP_OPEN_TABLE},
552+ {"OTHER_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
553+ MY_I_S_UNSIGNED, "Other_commands", SKIP_OPEN_TABLE},
554+ {"COMMIT_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
555+ MY_I_S_UNSIGNED, "Commit_transactions", SKIP_OPEN_TABLE},
556+ {"ROLLBACK_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
557+ 0, MY_I_S_UNSIGNED, "Rollback_transactions", SKIP_OPEN_TABLE},
558+ {"DENIED_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
559+ MY_I_S_UNSIGNED, "Denied_connections", SKIP_OPEN_TABLE},
560+ {"LOST_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
561+ MY_I_S_UNSIGNED, "Lost_connections", SKIP_OPEN_TABLE},
562+ {"ACCESS_DENIED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
563+ MY_I_S_UNSIGNED, "Access_denied", SKIP_OPEN_TABLE},
564+ {"EMPTY_QUERIES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
565+ MY_I_S_UNSIGNED, "Empty_queries", SKIP_OPEN_TABLE},
566+ {"TOTAL_SSL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
567+ 0, MY_I_S_UNSIGNED, "Total_ssl_connections", SKIP_OPEN_TABLE},
568 {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0}
569 };
570
571 ST_FIELD_INFO client_stats_fields_info[]=
572 {
573- {"CLIENT", LIST_PROCESS_HOST_LEN, MYSQL_TYPE_STRING, 0, 0, "Client", SKIP_OPEN_TABLE},
574- {"TOTAL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Total_connections", SKIP_OPEN_TABLE},
575- {"CONCURRENT_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Concurrent_connections", SKIP_OPEN_TABLE},
576- {"CONNECTED_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Connected_time", SKIP_OPEN_TABLE},
577- {"BUSY_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Busy_time", SKIP_OPEN_TABLE},
578- {"CPU_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Cpu_time", SKIP_OPEN_TABLE},
579- {"BYTES_RECEIVED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Bytes_received", SKIP_OPEN_TABLE},
580- {"BYTES_SENT", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Bytes_sent", SKIP_OPEN_TABLE},
581- {"BINLOG_BYTES_WRITTEN", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Binlog_bytes_written", SKIP_OPEN_TABLE},
582- {"ROWS_FETCHED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_fetched", SKIP_OPEN_TABLE},
583- {"ROWS_UPDATED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_updated", SKIP_OPEN_TABLE},
584- {"TABLE_ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Table_rows_read", SKIP_OPEN_TABLE},
585- {"SELECT_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Select_commands", SKIP_OPEN_TABLE},
586- {"UPDATE_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Update_commands", SKIP_OPEN_TABLE},
587- {"OTHER_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Other_commands", SKIP_OPEN_TABLE},
588- {"COMMIT_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Commit_transactions", SKIP_OPEN_TABLE},
589- {"ROLLBACK_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rollback_transactions", SKIP_OPEN_TABLE},
590- {"DENIED_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Denied_connections", SKIP_OPEN_TABLE},
591- {"LOST_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Lost_connections", SKIP_OPEN_TABLE},
592- {"ACCESS_DENIED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Access_denied", SKIP_OPEN_TABLE},
593- {"EMPTY_QUERIES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Empty_queries", SKIP_OPEN_TABLE},
594- {"TOTAL_SSL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Total_ssl_connections", SKIP_OPEN_TABLE},
595+ {"CLIENT", LIST_PROCESS_HOST_LEN, MYSQL_TYPE_STRING, 0, 0, "Client",
596+ SKIP_OPEN_TABLE},
597+ {"TOTAL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
598+ MY_I_S_UNSIGNED, "Total_connections", SKIP_OPEN_TABLE},
599+ {"CONCURRENT_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
600+ 0, MY_I_S_UNSIGNED, "Concurrent_connections", SKIP_OPEN_TABLE},
601+ {"CONNECTED_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
602+ MY_I_S_UNSIGNED, "Connected_time", SKIP_OPEN_TABLE},
603+ {"BUSY_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
604+ MY_I_S_UNSIGNED, "Busy_time", SKIP_OPEN_TABLE},
605+ {"CPU_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
606+ MY_I_S_UNSIGNED, "Cpu_time", SKIP_OPEN_TABLE},
607+ {"BYTES_RECEIVED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
608+ MY_I_S_UNSIGNED, "Bytes_received", SKIP_OPEN_TABLE},
609+ {"BYTES_SENT", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
610+ MY_I_S_UNSIGNED, "Bytes_sent", SKIP_OPEN_TABLE},
611+ {"BINLOG_BYTES_WRITTEN", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
612+ 0, MY_I_S_UNSIGNED, "Binlog_bytes_written", SKIP_OPEN_TABLE},
613+ {"ROWS_FETCHED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
614+ MY_I_S_UNSIGNED, "Rows_fetched", SKIP_OPEN_TABLE},
615+ {"ROWS_UPDATED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
616+ MY_I_S_UNSIGNED, "Rows_updated", SKIP_OPEN_TABLE},
617+ {"TABLE_ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
618+ MY_I_S_UNSIGNED, "Table_rows_read", SKIP_OPEN_TABLE},
619+ {"SELECT_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
620+ MY_I_S_UNSIGNED, "Select_commands", SKIP_OPEN_TABLE},
621+ {"UPDATE_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
622+ MY_I_S_UNSIGNED, "Update_commands", SKIP_OPEN_TABLE},
623+ {"OTHER_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
624+ MY_I_S_UNSIGNED, "Other_commands", SKIP_OPEN_TABLE},
625+ {"COMMIT_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
626+ MY_I_S_UNSIGNED, "Commit_transactions", SKIP_OPEN_TABLE},
627+ {"ROLLBACK_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
628+ 0, MY_I_S_UNSIGNED, "Rollback_transactions", SKIP_OPEN_TABLE},
629+ {"DENIED_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
630+ MY_I_S_UNSIGNED, "Denied_connections", SKIP_OPEN_TABLE},
631+ {"LOST_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
632+ MY_I_S_UNSIGNED, "Lost_connections", SKIP_OPEN_TABLE},
633+ {"ACCESS_DENIED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
634+ MY_I_S_UNSIGNED, "Access_denied", SKIP_OPEN_TABLE},
635+ {"EMPTY_QUERIES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
636+ MY_I_S_UNSIGNED, "Empty_queries", SKIP_OPEN_TABLE},
637+ {"TOTAL_SSL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
638+ 0, MY_I_S_UNSIGNED, "Total_ssl_connections", SKIP_OPEN_TABLE},
639 {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0}
640 };
641
642 ST_FIELD_INFO thread_stats_fields_info[]=
643 {
644- {"THREAD_ID", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Thread_id", SKIP_OPEN_TABLE},
645- {"TOTAL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Total_connections", SKIP_OPEN_TABLE},
646- {"CONCURRENT_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Concurrent_connections", SKIP_OPEN_TABLE},
647- {"CONNECTED_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Connected_time", SKIP_OPEN_TABLE},
648- {"BUSY_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Busy_time", SKIP_OPEN_TABLE},
649- {"CPU_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Cpu_time", SKIP_OPEN_TABLE},
650- {"BYTES_RECEIVED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Bytes_received", SKIP_OPEN_TABLE},
651- {"BYTES_SENT", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Bytes_sent", SKIP_OPEN_TABLE},
652- {"BINLOG_BYTES_WRITTEN", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Binlog_bytes_written", SKIP_OPEN_TABLE},
653- {"ROWS_FETCHED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_fetched", SKIP_OPEN_TABLE},
654- {"ROWS_UPDATED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_updated", SKIP_OPEN_TABLE},
655- {"TABLE_ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Table_rows_read", SKIP_OPEN_TABLE},
656- {"SELECT_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Select_commands", SKIP_OPEN_TABLE},
657- {"UPDATE_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Update_commands", SKIP_OPEN_TABLE},
658- {"OTHER_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Other_commands", SKIP_OPEN_TABLE},
659- {"COMMIT_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Commit_transactions", SKIP_OPEN_TABLE},
660- {"ROLLBACK_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rollback_transactions", SKIP_OPEN_TABLE},
661- {"DENIED_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Denied_connections", SKIP_OPEN_TABLE},
662- {"LOST_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Lost_connections", SKIP_OPEN_TABLE},
663- {"ACCESS_DENIED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Access_denied", SKIP_OPEN_TABLE},
664- {"EMPTY_QUERIES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Empty_queries", SKIP_OPEN_TABLE},
665- {"TOTAL_SSL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Total_ssl_connections", SKIP_OPEN_TABLE},
666+ {"THREAD_ID", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
667+ MY_I_S_UNSIGNED, "Thread_id", SKIP_OPEN_TABLE},
668+ {"TOTAL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
669+ MY_I_S_UNSIGNED, "Total_connections", SKIP_OPEN_TABLE},
670+ {"CONCURRENT_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
671+ 0, MY_I_S_UNSIGNED, "Concurrent_connections", SKIP_OPEN_TABLE},
672+ {"CONNECTED_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
673+ MY_I_S_UNSIGNED, "Connected_time", SKIP_OPEN_TABLE},
674+ {"BUSY_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
675+ MY_I_S_UNSIGNED, "Busy_time", SKIP_OPEN_TABLE},
676+ {"CPU_TIME", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
677+ MY_I_S_UNSIGNED, "Cpu_time", SKIP_OPEN_TABLE},
678+ {"BYTES_RECEIVED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
679+ MY_I_S_UNSIGNED, "Bytes_received", SKIP_OPEN_TABLE},
680+ {"BYTES_SENT", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
681+ MY_I_S_UNSIGNED, "Bytes_sent", SKIP_OPEN_TABLE},
682+ {"BINLOG_BYTES_WRITTEN", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
683+ MY_I_S_UNSIGNED, "Binlog_bytes_written", SKIP_OPEN_TABLE},
684+ {"ROWS_FETCHED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
685+ MY_I_S_UNSIGNED, "Rows_fetched", SKIP_OPEN_TABLE},
686+ {"ROWS_UPDATED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
687+ MY_I_S_UNSIGNED, "Rows_updated", SKIP_OPEN_TABLE},
688+ {"TABLE_ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
689+ MY_I_S_UNSIGNED, "Table_rows_read", SKIP_OPEN_TABLE},
690+ {"SELECT_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
691+ MY_I_S_UNSIGNED, "Select_commands", SKIP_OPEN_TABLE},
692+ {"UPDATE_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
693+ MY_I_S_UNSIGNED, "Update_commands", SKIP_OPEN_TABLE},
694+ {"OTHER_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
695+ MY_I_S_UNSIGNED, "Other_commands", SKIP_OPEN_TABLE},
696+ {"COMMIT_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
697+ MY_I_S_UNSIGNED, "Commit_transactions", SKIP_OPEN_TABLE},
698+ {"ROLLBACK_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
699+ 0, MY_I_S_UNSIGNED, "Rollback_transactions", SKIP_OPEN_TABLE},
700+ {"DENIED_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
701+ MY_I_S_UNSIGNED, "Denied_connections", SKIP_OPEN_TABLE},
702+ {"LOST_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
703+ MY_I_S_UNSIGNED, "Lost_connections", SKIP_OPEN_TABLE},
704+ {"ACCESS_DENIED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
705+ MY_I_S_UNSIGNED, "Access_denied", SKIP_OPEN_TABLE},
706+ {"EMPTY_QUERIES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
707+ MY_I_S_UNSIGNED, "Empty_queries", SKIP_OPEN_TABLE},
708+ {"TOTAL_SSL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
709+ 0, MY_I_S_UNSIGNED, "Total_ssl_connections", SKIP_OPEN_TABLE},
710 {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0}
711 };
712
713 ST_FIELD_INFO table_stats_fields_info[]=
714 {
715- {"TABLE_SCHEMA", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Table_schema", SKIP_OPEN_TABLE},
716- {"TABLE_NAME", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Table_name", SKIP_OPEN_TABLE},
717- {"ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_read", SKIP_OPEN_TABLE},
718- {"ROWS_CHANGED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_changed", SKIP_OPEN_TABLE},
719- {"ROWS_CHANGED_X_INDEXES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_changed_x_#indexes", SKIP_OPEN_TABLE},
720+ {"TABLE_SCHEMA", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Table_schema",
721+ SKIP_OPEN_TABLE},
722+ {"TABLE_NAME", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Table_name",
723+ SKIP_OPEN_TABLE},
724+ {"ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
725+ MY_I_S_UNSIGNED, "Rows_read", SKIP_OPEN_TABLE},
726+ {"ROWS_CHANGED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
727+ MY_I_S_UNSIGNED, "Rows_changed", SKIP_OPEN_TABLE},
728+ {"ROWS_CHANGED_X_INDEXES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
729+ 0, MY_I_S_UNSIGNED, "Rows_changed_x_#indexes", SKIP_OPEN_TABLE},
730 {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0}
731 };
732
733 ST_FIELD_INFO index_stats_fields_info[]=
734 {
735- {"TABLE_SCHEMA", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Table_schema", SKIP_OPEN_TABLE},
736- {"TABLE_NAME", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Table_name", SKIP_OPEN_TABLE},
737- {"INDEX_NAME", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Index_name", SKIP_OPEN_TABLE},
738- {"ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_read", SKIP_OPEN_TABLE},
739+ {"TABLE_SCHEMA", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Table_schema",
740+ SKIP_OPEN_TABLE},
741+ {"TABLE_NAME", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Table_name",
742+ SKIP_OPEN_TABLE},
743+ {"INDEX_NAME", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Index_name",
744+ SKIP_OPEN_TABLE},
745+ {"ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
746+ MY_I_S_UNSIGNED, "Rows_read", SKIP_OPEN_TABLE},
747 {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0}
748 };
749

Subscribers

People subscribed via source and target branches