Percona Server moved to https://jira.percona.com/projects/PS

Merge lp:~laurynas-biveinis/percona-server/bug714925-5.6 into lp:percona-server/5.6

  1. bug714925-5.6
  2. 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
Reviewer Review Type Date Requested Status
Vlad Lesin (community) Approve
Review via email: mp+166643@code.launchpad.net

Description of the change

Merge bug 714925 fix.
ST 32205.
http://jenkins.percona.com/job/percona-server-5.6-param/128/

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 :

http://jenkins.percona.com/job/percona-server-5.6-param/129/

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
=== modified file 'Percona-Server/mysql-test/suite/funcs_1/r/is_columns_is.result'
--- Percona-Server/mysql-test/suite/funcs_1/r/is_columns_is.result 2013-05-10 09:39:17 +0000
+++ Percona-Server/mysql-test/suite/funcs_1/r/is_columns_is.result 2013-05-31 04:35:35 +0000
@@ -7,28 +7,28 @@
7def information_schema CHARACTER_SETS DEFAULT_COLLATE_NAME 2 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select 7def information_schema CHARACTER_SETS DEFAULT_COLLATE_NAME 2 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select
8def information_schema CHARACTER_SETS DESCRIPTION 3 NO varchar 60 180 NULL NULL NULL utf8 utf8_general_ci varchar(60) select 8def information_schema CHARACTER_SETS DESCRIPTION 3 NO varchar 60 180 NULL NULL NULL utf8 utf8_general_ci varchar(60) select
9def information_schema CHARACTER_SETS MAXLEN 4 0 NO bigint NULL NULL 19 0 NULL NULL NULL bigint(3) select 9def information_schema CHARACTER_SETS MAXLEN 4 0 NO bigint NULL NULL 19 0 NULL NULL NULL bigint(3) select
10def information_schema CLIENT_STATISTICS ACCESS_DENIED 20 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 10def information_schema CLIENT_STATISTICS ACCESS_DENIED 20 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
11def information_schema CLIENT_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 11def information_schema CLIENT_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
12def information_schema CLIENT_STATISTICS BUSY_TIME 5 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 12def information_schema CLIENT_STATISTICS BUSY_TIME 5 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
13def information_schema CLIENT_STATISTICS BYTES_RECEIVED 7 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 13def information_schema CLIENT_STATISTICS BYTES_RECEIVED 7 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
14def information_schema CLIENT_STATISTICS BYTES_SENT 8 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 14def information_schema CLIENT_STATISTICS BYTES_SENT 8 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
15def information_schema CLIENT_STATISTICS CLIENT 1 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select 15def information_schema CLIENT_STATISTICS CLIENT 1 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select
16def information_schema CLIENT_STATISTICS COMMIT_TRANSACTIONS 16 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 16def information_schema CLIENT_STATISTICS COMMIT_TRANSACTIONS 16 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
17def information_schema CLIENT_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 17def information_schema CLIENT_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
18def information_schema CLIENT_STATISTICS CONNECTED_TIME 4 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 18def information_schema CLIENT_STATISTICS CONNECTED_TIME 4 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
19def information_schema CLIENT_STATISTICS CPU_TIME 6 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 19def information_schema CLIENT_STATISTICS CPU_TIME 6 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
20def information_schema CLIENT_STATISTICS DENIED_CONNECTIONS 18 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 20def information_schema CLIENT_STATISTICS DENIED_CONNECTIONS 18 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
21def information_schema CLIENT_STATISTICS EMPTY_QUERIES 21 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 21def information_schema CLIENT_STATISTICS EMPTY_QUERIES 21 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
22def information_schema CLIENT_STATISTICS LOST_CONNECTIONS 19 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 22def information_schema CLIENT_STATISTICS LOST_CONNECTIONS 19 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
23def information_schema CLIENT_STATISTICS OTHER_COMMANDS 15 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 23def information_schema CLIENT_STATISTICS OTHER_COMMANDS 15 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
24def information_schema CLIENT_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 24def information_schema CLIENT_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
25def information_schema CLIENT_STATISTICS ROWS_FETCHED 10 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 25def information_schema CLIENT_STATISTICS ROWS_FETCHED 10 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
26def information_schema CLIENT_STATISTICS ROWS_UPDATED 11 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 26def information_schema CLIENT_STATISTICS ROWS_UPDATED 11 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
27def information_schema CLIENT_STATISTICS SELECT_COMMANDS 13 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 27def information_schema CLIENT_STATISTICS SELECT_COMMANDS 13 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
28def information_schema CLIENT_STATISTICS TABLE_ROWS_READ 12 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 28def information_schema CLIENT_STATISTICS TABLE_ROWS_READ 12 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
29def information_schema CLIENT_STATISTICS TOTAL_CONNECTIONS 2 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 29def information_schema CLIENT_STATISTICS TOTAL_CONNECTIONS 2 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
30def information_schema CLIENT_STATISTICS TOTAL_SSL_CONNECTIONS 22 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 30def information_schema CLIENT_STATISTICS TOTAL_SSL_CONNECTIONS 22 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
31def information_schema CLIENT_STATISTICS UPDATE_COMMANDS 14 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 31def information_schema CLIENT_STATISTICS UPDATE_COMMANDS 14 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
32def information_schema COLLATIONS CHARACTER_SET_NAME 2 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select 32def information_schema COLLATIONS CHARACTER_SET_NAME 2 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select
33def information_schema COLLATIONS COLLATION_NAME 1 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select 33def information_schema COLLATIONS COLLATION_NAME 1 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select
34def information_schema COLLATIONS ID 3 0 NO bigint NULL NULL 19 0 NULL NULL NULL bigint(11) select 34def information_schema COLLATIONS ID 3 0 NO bigint NULL NULL 19 0 NULL NULL NULL bigint(11) select
@@ -148,7 +148,7 @@
148def information_schema GLOBAL_VARIABLES VARIABLE_NAME 1 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select 148def information_schema GLOBAL_VARIABLES VARIABLE_NAME 1 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select
149def information_schema GLOBAL_VARIABLES VARIABLE_VALUE 2 NULL YES varchar 1024 3072 NULL NULL NULL utf8 utf8_general_ci varchar(1024) select 149def information_schema GLOBAL_VARIABLES VARIABLE_VALUE 2 NULL YES varchar 1024 3072 NULL NULL NULL utf8 utf8_general_ci varchar(1024) select
150def information_schema INDEX_STATISTICS INDEX_NAME 3 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select 150def information_schema INDEX_STATISTICS INDEX_NAME 3 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select
151def information_schema INDEX_STATISTICS ROWS_READ 4 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 151def information_schema INDEX_STATISTICS ROWS_READ 4 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
152def information_schema INDEX_STATISTICS TABLE_NAME 2 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select 152def information_schema INDEX_STATISTICS TABLE_NAME 2 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select
153def information_schema INDEX_STATISTICS TABLE_SCHEMA 1 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select 153def information_schema INDEX_STATISTICS TABLE_SCHEMA 1 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select
154def information_schema KEY_COLUMN_USAGE COLUMN_NAME 7 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select 154def information_schema KEY_COLUMN_USAGE COLUMN_NAME 7 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select
@@ -344,9 +344,9 @@
344def information_schema TABLE_PRIVILEGES TABLE_CATALOG 2 NO varchar 512 1536 NULL NULL NULL utf8 utf8_general_ci varchar(512) select 344def information_schema TABLE_PRIVILEGES TABLE_CATALOG 2 NO varchar 512 1536 NULL NULL NULL utf8 utf8_general_ci varchar(512) select
345def information_schema TABLE_PRIVILEGES TABLE_NAME 4 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select 345def information_schema TABLE_PRIVILEGES TABLE_NAME 4 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select
346def information_schema TABLE_PRIVILEGES TABLE_SCHEMA 3 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select 346def information_schema TABLE_PRIVILEGES TABLE_SCHEMA 3 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select
347def information_schema TABLE_STATISTICS ROWS_CHANGED 4 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 347def information_schema TABLE_STATISTICS ROWS_CHANGED 4 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
348def information_schema TABLE_STATISTICS ROWS_CHANGED_X_INDEXES 5 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 348def information_schema TABLE_STATISTICS ROWS_CHANGED_X_INDEXES 5 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
349def information_schema TABLE_STATISTICS ROWS_READ 3 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 349def information_schema TABLE_STATISTICS ROWS_READ 3 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
350def information_schema TABLE_STATISTICS TABLE_NAME 2 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select 350def information_schema TABLE_STATISTICS TABLE_NAME 2 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select
351def information_schema TABLE_STATISTICS TABLE_SCHEMA 1 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select 351def information_schema TABLE_STATISTICS TABLE_SCHEMA 1 NO varchar 192 576 NULL NULL NULL utf8 utf8_general_ci varchar(192) select
352def information_schema TEMPORARY_TABLES AVG_ROW_LENGTH 7 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select 352def information_schema TEMPORARY_TABLES AVG_ROW_LENGTH 7 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
@@ -360,28 +360,28 @@
360def information_schema TEMPORARY_TABLES TABLE_ROWS 6 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select 360def information_schema TEMPORARY_TABLES TABLE_ROWS 6 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
361def information_schema TEMPORARY_TABLES TABLE_SCHEMA 2 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select 361def information_schema TEMPORARY_TABLES TABLE_SCHEMA 2 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select
362def information_schema TEMPORARY_TABLES UPDATE_TIME 11 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select 362def information_schema TEMPORARY_TABLES UPDATE_TIME 11 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select
363def information_schema THREAD_STATISTICS ACCESS_DENIED 20 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 363def information_schema THREAD_STATISTICS ACCESS_DENIED 20 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
364def information_schema THREAD_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 364def information_schema THREAD_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
365def information_schema THREAD_STATISTICS BUSY_TIME 5 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 365def information_schema THREAD_STATISTICS BUSY_TIME 5 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
366def information_schema THREAD_STATISTICS BYTES_RECEIVED 7 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 366def information_schema THREAD_STATISTICS BYTES_RECEIVED 7 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
367def information_schema THREAD_STATISTICS BYTES_SENT 8 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 367def information_schema THREAD_STATISTICS BYTES_SENT 8 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
368def information_schema THREAD_STATISTICS COMMIT_TRANSACTIONS 16 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 368def information_schema THREAD_STATISTICS COMMIT_TRANSACTIONS 16 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
369def information_schema THREAD_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 369def information_schema THREAD_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
370def information_schema THREAD_STATISTICS CONNECTED_TIME 4 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 370def information_schema THREAD_STATISTICS CONNECTED_TIME 4 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
371def information_schema THREAD_STATISTICS CPU_TIME 6 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 371def information_schema THREAD_STATISTICS CPU_TIME 6 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
372def information_schema THREAD_STATISTICS DENIED_CONNECTIONS 18 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 372def information_schema THREAD_STATISTICS DENIED_CONNECTIONS 18 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
373def information_schema THREAD_STATISTICS EMPTY_QUERIES 21 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 373def information_schema THREAD_STATISTICS EMPTY_QUERIES 21 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
374def information_schema THREAD_STATISTICS LOST_CONNECTIONS 19 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 374def information_schema THREAD_STATISTICS LOST_CONNECTIONS 19 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
375def information_schema THREAD_STATISTICS OTHER_COMMANDS 15 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 375def information_schema THREAD_STATISTICS OTHER_COMMANDS 15 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
376def information_schema THREAD_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 376def information_schema THREAD_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
377def information_schema THREAD_STATISTICS ROWS_FETCHED 10 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 377def information_schema THREAD_STATISTICS ROWS_FETCHED 10 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
378def information_schema THREAD_STATISTICS ROWS_UPDATED 11 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 378def information_schema THREAD_STATISTICS ROWS_UPDATED 11 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
379def information_schema THREAD_STATISTICS SELECT_COMMANDS 13 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 379def information_schema THREAD_STATISTICS SELECT_COMMANDS 13 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
380def information_schema THREAD_STATISTICS TABLE_ROWS_READ 12 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 380def information_schema THREAD_STATISTICS TABLE_ROWS_READ 12 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
381def information_schema THREAD_STATISTICS THREAD_ID 1 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 381def information_schema THREAD_STATISTICS THREAD_ID 1 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
382def information_schema THREAD_STATISTICS TOTAL_CONNECTIONS 2 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 382def information_schema THREAD_STATISTICS TOTAL_CONNECTIONS 2 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
383def information_schema THREAD_STATISTICS TOTAL_SSL_CONNECTIONS 22 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 383def information_schema THREAD_STATISTICS TOTAL_SSL_CONNECTIONS 22 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
384def information_schema THREAD_STATISTICS UPDATE_COMMANDS 14 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 384def information_schema THREAD_STATISTICS UPDATE_COMMANDS 14 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
385def information_schema TRIGGERS ACTION_CONDITION 9 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8 utf8_general_ci longtext select 385def information_schema TRIGGERS ACTION_CONDITION 9 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8 utf8_general_ci longtext select
386def information_schema TRIGGERS ACTION_ORDER 8 0 NO bigint NULL NULL 19 0 NULL NULL NULL bigint(4) select 386def information_schema TRIGGERS ACTION_ORDER 8 0 NO bigint NULL NULL 19 0 NULL NULL NULL bigint(4) select
387def information_schema TRIGGERS ACTION_ORIENTATION 11 NO varchar 9 27 NULL NULL NULL utf8 utf8_general_ci varchar(9) select 387def information_schema TRIGGERS ACTION_ORIENTATION 11 NO varchar 9 27 NULL NULL NULL utf8 utf8_general_ci varchar(9) select
@@ -408,27 +408,27 @@
408def information_schema USER_PRIVILEGES IS_GRANTABLE 4 NO varchar 3 9 NULL NULL NULL utf8 utf8_general_ci varchar(3) select 408def information_schema USER_PRIVILEGES IS_GRANTABLE 4 NO varchar 3 9 NULL NULL NULL utf8 utf8_general_ci varchar(3) select
409def information_schema USER_PRIVILEGES PRIVILEGE_TYPE 3 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select 409def information_schema USER_PRIVILEGES PRIVILEGE_TYPE 3 NO varchar 64 192 NULL NULL NULL utf8 utf8_general_ci varchar(64) select
410def information_schema USER_PRIVILEGES TABLE_CATALOG 2 NO varchar 512 1536 NULL NULL NULL utf8 utf8_general_ci varchar(512) select 410def information_schema USER_PRIVILEGES TABLE_CATALOG 2 NO varchar 512 1536 NULL NULL NULL utf8 utf8_general_ci varchar(512) select
411def information_schema USER_STATISTICS ACCESS_DENIED 20 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 411def information_schema USER_STATISTICS ACCESS_DENIED 20 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
412def information_schema USER_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 412def information_schema USER_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
413def information_schema USER_STATISTICS BUSY_TIME 5 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 413def information_schema USER_STATISTICS BUSY_TIME 5 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
414def information_schema USER_STATISTICS BYTES_RECEIVED 7 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 414def information_schema USER_STATISTICS BYTES_RECEIVED 7 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
415def information_schema USER_STATISTICS BYTES_SENT 8 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 415def information_schema USER_STATISTICS BYTES_SENT 8 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
416def information_schema USER_STATISTICS COMMIT_TRANSACTIONS 16 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 416def information_schema USER_STATISTICS COMMIT_TRANSACTIONS 16 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
417def information_schema USER_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 417def information_schema USER_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
418def information_schema USER_STATISTICS CONNECTED_TIME 4 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 418def information_schema USER_STATISTICS CONNECTED_TIME 4 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
419def information_schema USER_STATISTICS CPU_TIME 6 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 419def information_schema USER_STATISTICS CPU_TIME 6 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
420def information_schema USER_STATISTICS DENIED_CONNECTIONS 18 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 420def information_schema USER_STATISTICS DENIED_CONNECTIONS 18 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
421def information_schema USER_STATISTICS EMPTY_QUERIES 21 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 421def information_schema USER_STATISTICS EMPTY_QUERIES 21 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
422def information_schema USER_STATISTICS LOST_CONNECTIONS 19 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 422def information_schema USER_STATISTICS LOST_CONNECTIONS 19 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
423def information_schema USER_STATISTICS OTHER_COMMANDS 15 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 423def information_schema USER_STATISTICS OTHER_COMMANDS 15 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
424def information_schema USER_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 424def information_schema USER_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
425def information_schema USER_STATISTICS ROWS_FETCHED 10 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 425def information_schema USER_STATISTICS ROWS_FETCHED 10 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
426def information_schema USER_STATISTICS ROWS_UPDATED 11 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 426def information_schema USER_STATISTICS ROWS_UPDATED 11 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
427def information_schema USER_STATISTICS SELECT_COMMANDS 13 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 427def information_schema USER_STATISTICS SELECT_COMMANDS 13 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
428def information_schema USER_STATISTICS TABLE_ROWS_READ 12 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 428def information_schema USER_STATISTICS TABLE_ROWS_READ 12 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
429def information_schema USER_STATISTICS TOTAL_CONNECTIONS 2 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 429def information_schema USER_STATISTICS TOTAL_CONNECTIONS 2 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
430def information_schema USER_STATISTICS TOTAL_SSL_CONNECTIONS 22 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 430def information_schema USER_STATISTICS TOTAL_SSL_CONNECTIONS 22 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
431def information_schema USER_STATISTICS UPDATE_COMMANDS 14 0 NO int NULL NULL 10 0 NULL NULL NULL int(21) select 431def information_schema USER_STATISTICS UPDATE_COMMANDS 14 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint(21) unsigned select
432def information_schema USER_STATISTICS USER 1 NO varchar 48 144 NULL NULL NULL utf8 utf8_general_ci varchar(48) select 432def information_schema USER_STATISTICS USER 1 NO varchar 48 144 NULL NULL NULL utf8 utf8_general_ci varchar(48) select
433def information_schema VIEWS CHARACTER_SET_CLIENT 9 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select 433def information_schema VIEWS CHARACTER_SET_CLIENT 9 NO varchar 32 96 NULL NULL NULL utf8 utf8_general_ci varchar(32) select
434def information_schema VIEWS CHECK_OPTION 5 NO varchar 8 24 NULL NULL NULL utf8 utf8_general_ci varchar(8) select 434def information_schema VIEWS CHECK_OPTION 5 NO varchar 8 24 NULL NULL NULL utf8 utf8_general_ci varchar(8) select
@@ -518,27 +518,27 @@
5183.0000 information_schema CHARACTER_SETS DESCRIPTION varchar 60 180 utf8 utf8_general_ci varchar(60)5183.0000 information_schema CHARACTER_SETS DESCRIPTION varchar 60 180 utf8 utf8_general_ci varchar(60)
519NULL information_schema CHARACTER_SETS MAXLEN bigint NULL NULL NULL NULL bigint(3)519NULL information_schema CHARACTER_SETS MAXLEN bigint NULL NULL NULL NULL bigint(3)
5203.0000 information_schema CLIENT_STATISTICS CLIENT varchar 64 192 utf8 utf8_general_ci varchar(64)5203.0000 information_schema CLIENT_STATISTICS CLIENT varchar 64 192 utf8 utf8_general_ci varchar(64)
521NULL information_schema CLIENT_STATISTICS TOTAL_CONNECTIONS int NULL NULL NULL NULL int(21)521NULL information_schema CLIENT_STATISTICS TOTAL_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
522NULL information_schema CLIENT_STATISTICS CONCURRENT_CONNECTIONS int NULL NULL NULL NULL int(21)522NULL information_schema CLIENT_STATISTICS CONCURRENT_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
523NULL information_schema CLIENT_STATISTICS CONNECTED_TIME int NULL NULL NULL NULL int(21)523NULL information_schema CLIENT_STATISTICS CONNECTED_TIME bigint NULL NULL NULL NULL bigint(21) unsigned
524NULL information_schema CLIENT_STATISTICS BUSY_TIME int NULL NULL NULL NULL int(21)524NULL information_schema CLIENT_STATISTICS BUSY_TIME bigint NULL NULL NULL NULL bigint(21) unsigned
525NULL information_schema CLIENT_STATISTICS CPU_TIME int NULL NULL NULL NULL int(21)525NULL information_schema CLIENT_STATISTICS CPU_TIME bigint NULL NULL NULL NULL bigint(21) unsigned
526NULL information_schema CLIENT_STATISTICS BYTES_RECEIVED int NULL NULL NULL NULL int(21)526NULL information_schema CLIENT_STATISTICS BYTES_RECEIVED bigint NULL NULL NULL NULL bigint(21) unsigned
527NULL information_schema CLIENT_STATISTICS BYTES_SENT int NULL NULL NULL NULL int(21)527NULL information_schema CLIENT_STATISTICS BYTES_SENT bigint NULL NULL NULL NULL bigint(21) unsigned
528NULL information_schema CLIENT_STATISTICS BINLOG_BYTES_WRITTEN int NULL NULL NULL NULL int(21)528NULL information_schema CLIENT_STATISTICS BINLOG_BYTES_WRITTEN bigint NULL NULL NULL NULL bigint(21) unsigned
529NULL information_schema CLIENT_STATISTICS ROWS_FETCHED int NULL NULL NULL NULL int(21)529NULL information_schema CLIENT_STATISTICS ROWS_FETCHED bigint NULL NULL NULL NULL bigint(21) unsigned
530NULL information_schema CLIENT_STATISTICS ROWS_UPDATED int NULL NULL NULL NULL int(21)530NULL information_schema CLIENT_STATISTICS ROWS_UPDATED bigint NULL NULL NULL NULL bigint(21) unsigned
531NULL information_schema CLIENT_STATISTICS TABLE_ROWS_READ int NULL NULL NULL NULL int(21)531NULL information_schema CLIENT_STATISTICS TABLE_ROWS_READ bigint NULL NULL NULL NULL bigint(21) unsigned
532NULL information_schema CLIENT_STATISTICS SELECT_COMMANDS int NULL NULL NULL NULL int(21)532NULL information_schema CLIENT_STATISTICS SELECT_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned
533NULL information_schema CLIENT_STATISTICS UPDATE_COMMANDS int NULL NULL NULL NULL int(21)533NULL information_schema CLIENT_STATISTICS UPDATE_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned
534NULL information_schema CLIENT_STATISTICS OTHER_COMMANDS int NULL NULL NULL NULL int(21)534NULL information_schema CLIENT_STATISTICS OTHER_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned
535NULL information_schema CLIENT_STATISTICS COMMIT_TRANSACTIONS int NULL NULL NULL NULL int(21)535NULL information_schema CLIENT_STATISTICS COMMIT_TRANSACTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
536NULL information_schema CLIENT_STATISTICS ROLLBACK_TRANSACTIONS int NULL NULL NULL NULL int(21)536NULL information_schema CLIENT_STATISTICS ROLLBACK_TRANSACTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
537NULL information_schema CLIENT_STATISTICS DENIED_CONNECTIONS int NULL NULL NULL NULL int(21)537NULL information_schema CLIENT_STATISTICS DENIED_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
538NULL information_schema CLIENT_STATISTICS LOST_CONNECTIONS int NULL NULL NULL NULL int(21)538NULL information_schema CLIENT_STATISTICS LOST_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
539NULL information_schema CLIENT_STATISTICS ACCESS_DENIED int NULL NULL NULL NULL int(21)539NULL information_schema CLIENT_STATISTICS ACCESS_DENIED bigint NULL NULL NULL NULL bigint(21) unsigned
540NULL information_schema CLIENT_STATISTICS EMPTY_QUERIES int NULL NULL NULL NULL int(21)540NULL information_schema CLIENT_STATISTICS EMPTY_QUERIES bigint NULL NULL NULL NULL bigint(21) unsigned
541NULL information_schema CLIENT_STATISTICS TOTAL_SSL_CONNECTIONS int NULL NULL NULL NULL int(21)541NULL information_schema CLIENT_STATISTICS TOTAL_SSL_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
5423.0000 information_schema COLLATIONS COLLATION_NAME varchar 32 96 utf8 utf8_general_ci varchar(32)5423.0000 information_schema COLLATIONS COLLATION_NAME varchar 32 96 utf8 utf8_general_ci varchar(32)
5433.0000 information_schema COLLATIONS CHARACTER_SET_NAME varchar 32 96 utf8 utf8_general_ci varchar(32)5433.0000 information_schema COLLATIONS CHARACTER_SET_NAME varchar 32 96 utf8 utf8_general_ci varchar(32)
544NULL information_schema COLLATIONS ID bigint NULL NULL NULL NULL bigint(11)544NULL information_schema COLLATIONS ID bigint NULL NULL NULL NULL bigint(11)
@@ -660,7 +660,7 @@
6603.0000 information_schema INDEX_STATISTICS TABLE_SCHEMA varchar 192 576 utf8 utf8_general_ci varchar(192)6603.0000 information_schema INDEX_STATISTICS TABLE_SCHEMA varchar 192 576 utf8 utf8_general_ci varchar(192)
6613.0000 information_schema INDEX_STATISTICS TABLE_NAME varchar 192 576 utf8 utf8_general_ci varchar(192)6613.0000 information_schema INDEX_STATISTICS TABLE_NAME varchar 192 576 utf8 utf8_general_ci varchar(192)
6623.0000 information_schema INDEX_STATISTICS INDEX_NAME varchar 192 576 utf8 utf8_general_ci varchar(192)6623.0000 information_schema INDEX_STATISTICS INDEX_NAME varchar 192 576 utf8 utf8_general_ci varchar(192)
663NULL information_schema INDEX_STATISTICS ROWS_READ int NULL NULL NULL NULL int(21)663NULL information_schema INDEX_STATISTICS ROWS_READ bigint NULL NULL NULL NULL bigint(21) unsigned
6643.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512)6643.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512)
6653.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64)6653.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64)
6663.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)6663.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)
@@ -856,9 +856,9 @@
8563.0000 information_schema TABLE_PRIVILEGES IS_GRANTABLE varchar 3 9 utf8 utf8_general_ci varchar(3)8563.0000 information_schema TABLE_PRIVILEGES IS_GRANTABLE varchar 3 9 utf8 utf8_general_ci varchar(3)
8573.0000 information_schema TABLE_STATISTICS TABLE_SCHEMA varchar 192 576 utf8 utf8_general_ci varchar(192)8573.0000 information_schema TABLE_STATISTICS TABLE_SCHEMA varchar 192 576 utf8 utf8_general_ci varchar(192)
8583.0000 information_schema TABLE_STATISTICS TABLE_NAME varchar 192 576 utf8 utf8_general_ci varchar(192)8583.0000 information_schema TABLE_STATISTICS TABLE_NAME varchar 192 576 utf8 utf8_general_ci varchar(192)
859NULL information_schema TABLE_STATISTICS ROWS_READ int NULL NULL NULL NULL int(21)859NULL information_schema TABLE_STATISTICS ROWS_READ bigint NULL NULL NULL NULL bigint(21) unsigned
860NULL information_schema TABLE_STATISTICS ROWS_CHANGED int NULL NULL NULL NULL int(21)860NULL information_schema TABLE_STATISTICS ROWS_CHANGED bigint NULL NULL NULL NULL bigint(21) unsigned
861NULL information_schema TABLE_STATISTICS ROWS_CHANGED_X_INDEXES int NULL NULL NULL NULL int(21)861NULL information_schema TABLE_STATISTICS ROWS_CHANGED_X_INDEXES bigint NULL NULL NULL NULL bigint(21) unsigned
862NULL information_schema TEMPORARY_TABLES SESSION_ID bigint NULL NULL NULL NULL bigint(4)862NULL information_schema TEMPORARY_TABLES SESSION_ID bigint NULL NULL NULL NULL bigint(4)
8633.0000 information_schema TEMPORARY_TABLES TABLE_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64)8633.0000 information_schema TEMPORARY_TABLES TABLE_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64)
8643.0000 information_schema TEMPORARY_TABLES TABLE_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)8643.0000 information_schema TEMPORARY_TABLES TABLE_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)
@@ -870,28 +870,28 @@
870NULL information_schema TEMPORARY_TABLES INDEX_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned870NULL information_schema TEMPORARY_TABLES INDEX_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
871NULL information_schema TEMPORARY_TABLES CREATE_TIME datetime NULL NULL NULL NULL datetime871NULL information_schema TEMPORARY_TABLES CREATE_TIME datetime NULL NULL NULL NULL datetime
872NULL information_schema TEMPORARY_TABLES UPDATE_TIME datetime NULL NULL NULL NULL datetime872NULL information_schema TEMPORARY_TABLES UPDATE_TIME datetime NULL NULL NULL NULL datetime
873NULL information_schema THREAD_STATISTICS THREAD_ID int NULL NULL NULL NULL int(21)873NULL information_schema THREAD_STATISTICS THREAD_ID bigint NULL NULL NULL NULL bigint(21) unsigned
874NULL information_schema THREAD_STATISTICS TOTAL_CONNECTIONS int NULL NULL NULL NULL int(21)874NULL information_schema THREAD_STATISTICS TOTAL_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
875NULL information_schema THREAD_STATISTICS CONCURRENT_CONNECTIONS int NULL NULL NULL NULL int(21)875NULL information_schema THREAD_STATISTICS CONCURRENT_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
876NULL information_schema THREAD_STATISTICS CONNECTED_TIME int NULL NULL NULL NULL int(21)876NULL information_schema THREAD_STATISTICS CONNECTED_TIME bigint NULL NULL NULL NULL bigint(21) unsigned
877NULL information_schema THREAD_STATISTICS BUSY_TIME int NULL NULL NULL NULL int(21)877NULL information_schema THREAD_STATISTICS BUSY_TIME bigint NULL NULL NULL NULL bigint(21) unsigned
878NULL information_schema THREAD_STATISTICS CPU_TIME int NULL NULL NULL NULL int(21)878NULL information_schema THREAD_STATISTICS CPU_TIME bigint NULL NULL NULL NULL bigint(21) unsigned
879NULL information_schema THREAD_STATISTICS BYTES_RECEIVED int NULL NULL NULL NULL int(21)879NULL information_schema THREAD_STATISTICS BYTES_RECEIVED bigint NULL NULL NULL NULL bigint(21) unsigned
880NULL information_schema THREAD_STATISTICS BYTES_SENT int NULL NULL NULL NULL int(21)880NULL information_schema THREAD_STATISTICS BYTES_SENT bigint NULL NULL NULL NULL bigint(21) unsigned
881NULL information_schema THREAD_STATISTICS BINLOG_BYTES_WRITTEN int NULL NULL NULL NULL int(21)881NULL information_schema THREAD_STATISTICS BINLOG_BYTES_WRITTEN bigint NULL NULL NULL NULL bigint(21) unsigned
882NULL information_schema THREAD_STATISTICS ROWS_FETCHED int NULL NULL NULL NULL int(21)882NULL information_schema THREAD_STATISTICS ROWS_FETCHED bigint NULL NULL NULL NULL bigint(21) unsigned
883NULL information_schema THREAD_STATISTICS ROWS_UPDATED int NULL NULL NULL NULL int(21)883NULL information_schema THREAD_STATISTICS ROWS_UPDATED bigint NULL NULL NULL NULL bigint(21) unsigned
884NULL information_schema THREAD_STATISTICS TABLE_ROWS_READ int NULL NULL NULL NULL int(21)884NULL information_schema THREAD_STATISTICS TABLE_ROWS_READ bigint NULL NULL NULL NULL bigint(21) unsigned
885NULL information_schema THREAD_STATISTICS SELECT_COMMANDS int NULL NULL NULL NULL int(21)885NULL information_schema THREAD_STATISTICS SELECT_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned
886NULL information_schema THREAD_STATISTICS UPDATE_COMMANDS int NULL NULL NULL NULL int(21)886NULL information_schema THREAD_STATISTICS UPDATE_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned
887NULL information_schema THREAD_STATISTICS OTHER_COMMANDS int NULL NULL NULL NULL int(21)887NULL information_schema THREAD_STATISTICS OTHER_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned
888NULL information_schema THREAD_STATISTICS COMMIT_TRANSACTIONS int NULL NULL NULL NULL int(21)888NULL information_schema THREAD_STATISTICS COMMIT_TRANSACTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
889NULL information_schema THREAD_STATISTICS ROLLBACK_TRANSACTIONS int NULL NULL NULL NULL int(21)889NULL information_schema THREAD_STATISTICS ROLLBACK_TRANSACTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
890NULL information_schema THREAD_STATISTICS DENIED_CONNECTIONS int NULL NULL NULL NULL int(21)890NULL information_schema THREAD_STATISTICS DENIED_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
891NULL information_schema THREAD_STATISTICS LOST_CONNECTIONS int NULL NULL NULL NULL int(21)891NULL information_schema THREAD_STATISTICS LOST_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
892NULL information_schema THREAD_STATISTICS ACCESS_DENIED int NULL NULL NULL NULL int(21)892NULL information_schema THREAD_STATISTICS ACCESS_DENIED bigint NULL NULL NULL NULL bigint(21) unsigned
893NULL information_schema THREAD_STATISTICS EMPTY_QUERIES int NULL NULL NULL NULL int(21)893NULL information_schema THREAD_STATISTICS EMPTY_QUERIES bigint NULL NULL NULL NULL bigint(21) unsigned
894NULL information_schema THREAD_STATISTICS TOTAL_SSL_CONNECTIONS int NULL NULL NULL NULL int(21)894NULL information_schema THREAD_STATISTICS TOTAL_SSL_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
8953.0000 information_schema TRIGGERS TRIGGER_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512)8953.0000 information_schema TRIGGERS TRIGGER_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512)
8963.0000 information_schema TRIGGERS TRIGGER_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64)8963.0000 information_schema TRIGGERS TRIGGER_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64)
8973.0000 information_schema TRIGGERS TRIGGER_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)8973.0000 information_schema TRIGGERS TRIGGER_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)
@@ -919,27 +919,27 @@
9193.0000 information_schema USER_PRIVILEGES PRIVILEGE_TYPE varchar 64 192 utf8 utf8_general_ci varchar(64)9193.0000 information_schema USER_PRIVILEGES PRIVILEGE_TYPE varchar 64 192 utf8 utf8_general_ci varchar(64)
9203.0000 information_schema USER_PRIVILEGES IS_GRANTABLE varchar 3 9 utf8 utf8_general_ci varchar(3)9203.0000 information_schema USER_PRIVILEGES IS_GRANTABLE varchar 3 9 utf8 utf8_general_ci varchar(3)
9213.0000 information_schema USER_STATISTICS USER varchar 48 144 utf8 utf8_general_ci varchar(48)9213.0000 information_schema USER_STATISTICS USER varchar 48 144 utf8 utf8_general_ci varchar(48)
922NULL information_schema USER_STATISTICS TOTAL_CONNECTIONS int NULL NULL NULL NULL int(21)922NULL information_schema USER_STATISTICS TOTAL_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
923NULL information_schema USER_STATISTICS CONCURRENT_CONNECTIONS int NULL NULL NULL NULL int(21)923NULL information_schema USER_STATISTICS CONCURRENT_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
924NULL information_schema USER_STATISTICS CONNECTED_TIME int NULL NULL NULL NULL int(21)924NULL information_schema USER_STATISTICS CONNECTED_TIME bigint NULL NULL NULL NULL bigint(21) unsigned
925NULL information_schema USER_STATISTICS BUSY_TIME int NULL NULL NULL NULL int(21)925NULL information_schema USER_STATISTICS BUSY_TIME bigint NULL NULL NULL NULL bigint(21) unsigned
926NULL information_schema USER_STATISTICS CPU_TIME int NULL NULL NULL NULL int(21)926NULL information_schema USER_STATISTICS CPU_TIME bigint NULL NULL NULL NULL bigint(21) unsigned
927NULL information_schema USER_STATISTICS BYTES_RECEIVED int NULL NULL NULL NULL int(21)927NULL information_schema USER_STATISTICS BYTES_RECEIVED bigint NULL NULL NULL NULL bigint(21) unsigned
928NULL information_schema USER_STATISTICS BYTES_SENT int NULL NULL NULL NULL int(21)928NULL information_schema USER_STATISTICS BYTES_SENT bigint NULL NULL NULL NULL bigint(21) unsigned
929NULL information_schema USER_STATISTICS BINLOG_BYTES_WRITTEN int NULL NULL NULL NULL int(21)929NULL information_schema USER_STATISTICS BINLOG_BYTES_WRITTEN bigint NULL NULL NULL NULL bigint(21) unsigned
930NULL information_schema USER_STATISTICS ROWS_FETCHED int NULL NULL NULL NULL int(21)930NULL information_schema USER_STATISTICS ROWS_FETCHED bigint NULL NULL NULL NULL bigint(21) unsigned
931NULL information_schema USER_STATISTICS ROWS_UPDATED int NULL NULL NULL NULL int(21)931NULL information_schema USER_STATISTICS ROWS_UPDATED bigint NULL NULL NULL NULL bigint(21) unsigned
932NULL information_schema USER_STATISTICS TABLE_ROWS_READ int NULL NULL NULL NULL int(21)932NULL information_schema USER_STATISTICS TABLE_ROWS_READ bigint NULL NULL NULL NULL bigint(21) unsigned
933NULL information_schema USER_STATISTICS SELECT_COMMANDS int NULL NULL NULL NULL int(21)933NULL information_schema USER_STATISTICS SELECT_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned
934NULL information_schema USER_STATISTICS UPDATE_COMMANDS int NULL NULL NULL NULL int(21)934NULL information_schema USER_STATISTICS UPDATE_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned
935NULL information_schema USER_STATISTICS OTHER_COMMANDS int NULL NULL NULL NULL int(21)935NULL information_schema USER_STATISTICS OTHER_COMMANDS bigint NULL NULL NULL NULL bigint(21) unsigned
936NULL information_schema USER_STATISTICS COMMIT_TRANSACTIONS int NULL NULL NULL NULL int(21)936NULL information_schema USER_STATISTICS COMMIT_TRANSACTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
937NULL information_schema USER_STATISTICS ROLLBACK_TRANSACTIONS int NULL NULL NULL NULL int(21)937NULL information_schema USER_STATISTICS ROLLBACK_TRANSACTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
938NULL information_schema USER_STATISTICS DENIED_CONNECTIONS int NULL NULL NULL NULL int(21)938NULL information_schema USER_STATISTICS DENIED_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
939NULL information_schema USER_STATISTICS LOST_CONNECTIONS int NULL NULL NULL NULL int(21)939NULL information_schema USER_STATISTICS LOST_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
940NULL information_schema USER_STATISTICS ACCESS_DENIED int NULL NULL NULL NULL int(21)940NULL information_schema USER_STATISTICS ACCESS_DENIED bigint NULL NULL NULL NULL bigint(21) unsigned
941NULL information_schema USER_STATISTICS EMPTY_QUERIES int NULL NULL NULL NULL int(21)941NULL information_schema USER_STATISTICS EMPTY_QUERIES bigint NULL NULL NULL NULL bigint(21) unsigned
942NULL information_schema USER_STATISTICS TOTAL_SSL_CONNECTIONS int NULL NULL NULL NULL int(21)942NULL information_schema USER_STATISTICS TOTAL_SSL_CONNECTIONS bigint NULL NULL NULL NULL bigint(21) unsigned
9433.0000 information_schema VIEWS TABLE_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512)9433.0000 information_schema VIEWS TABLE_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512)
9443.0000 information_schema VIEWS TABLE_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64)9443.0000 information_schema VIEWS TABLE_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64)
9453.0000 information_schema VIEWS TABLE_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)9453.0000 information_schema VIEWS TABLE_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)
946946
=== modified file 'Percona-Server/sql/sql_show.cc'
--- Percona-Server/sql/sql_show.cc 2013-05-26 10:55:00 +0000
+++ Percona-Server/sql/sql_show.cc 2013-05-31 04:35:35 +0000
@@ -2634,34 +2634,35 @@
2634 for (uint i = 0; i < all_user_stats->records; ++i)2634 for (uint i = 0; i < all_user_stats->records; ++i)
2635 {2635 {
2636 restore_record(table, s->default_values);2636 restore_record(table, s->default_values);
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);
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),
2639 table->field[1]->store((longlong)user_stats->total_connections);2639 system_charset_info);
2640 table->field[2]->store((longlong)user_stats->concurrent_connections);2640 table->field[1]->store(user_stats->total_connections, true);
2641 table->field[3]->store((longlong)user_stats->connected_time);2641 table->field[2]->store(user_stats->concurrent_connections, true);
2642 table->field[4]->store((longlong)user_stats->busy_time);2642 table->field[3]->store(user_stats->connected_time, true);
2643 table->field[5]->store((longlong)user_stats->cpu_time);2643 table->field[4]->store((ulonglong)user_stats->busy_time, true);
2644 table->field[6]->store((longlong)user_stats->bytes_received);2644 table->field[5]->store((ulonglong)user_stats->cpu_time, true);
2645 table->field[7]->store((longlong)user_stats->bytes_sent);2645 table->field[6]->store(user_stats->bytes_received, true);
2646 table->field[8]->store((longlong)user_stats->binlog_bytes_written);2646 table->field[7]->store(user_stats->bytes_sent, true);
2647 table->field[9]->store((longlong)user_stats->rows_fetched);2647 table->field[8]->store(user_stats->binlog_bytes_written, true);
2648 table->field[10]->store((longlong)user_stats->rows_updated);2648 table->field[9]->store(user_stats->rows_fetched, true);
2649 table->field[11]->store((longlong)user_stats->rows_read);2649 table->field[10]->store(user_stats->rows_updated, true);
2650 table->field[12]->store((longlong)user_stats->select_commands);2650 table->field[11]->store(user_stats->rows_read, true);
2651 table->field[13]->store((longlong)user_stats->update_commands);2651 table->field[12]->store(user_stats->select_commands, true);
2652 table->field[14]->store((longlong)user_stats->other_commands);2652 table->field[13]->store(user_stats->update_commands, true);
2653 table->field[15]->store((longlong)user_stats->commit_trans);2653 table->field[14]->store(user_stats->other_commands, true);
2654 table->field[16]->store((longlong)user_stats->rollback_trans);2654 table->field[15]->store(user_stats->commit_trans, true);
2655 table->field[17]->store((longlong)user_stats->denied_connections);2655 table->field[16]->store(user_stats->rollback_trans, true);
2656 table->field[18]->store((longlong)user_stats->lost_connections);2656 table->field[17]->store(user_stats->denied_connections, true);
2657 table->field[19]->store((longlong)user_stats->access_denied_errors);2657 table->field[18]->store(user_stats->lost_connections, true);
2658 table->field[20]->store((longlong)user_stats->empty_queries);2658 table->field[19]->store(user_stats->access_denied_errors, true);
2659 table->field[21]->store((longlong)user_stats->total_ssl_connections);2659 table->field[20]->store(user_stats->empty_queries, true);
2660 if (schema_table_store_record(thd, table))2660 table->field[21]->store(user_stats->total_ssl_connections, true);
2661 {2661 if (schema_table_store_record(thd, table))
2662 DBUG_PRINT("error", ("store record error"));2662 {
2663 DBUG_RETURN(1);2663 DBUG_PRINT("error", ("store record error"));
2664 }2664 DBUG_RETURN(1);
2665 }
2665 }2666 }
2666 DBUG_RETURN(0);2667 DBUG_RETURN(0);
2667}2668}
@@ -2672,34 +2673,35 @@
2672 for (uint i = 0; i < all_thread_stats->records; ++i)2673 for (uint i = 0; i < all_thread_stats->records; ++i)
2673 {2674 {
2674 restore_record(table, s->default_values);2675 restore_record(table, s->default_values);
2675 THREAD_STATS *user_stats = (THREAD_STATS *) my_hash_element(all_thread_stats, i);2676 THREAD_STATS *user_stats
2676 table->field[0]->store((longlong)user_stats->id);2677 = (THREAD_STATS*)my_hash_element(all_thread_stats, i);
2677 table->field[1]->store((longlong)user_stats->total_connections);2678 table->field[0]->store(user_stats->id, true);
2678 table->field[2]->store((longlong)user_stats->concurrent_connections);2679 table->field[1]->store(user_stats->total_connections, true);
2679 table->field[3]->store((longlong)user_stats->connected_time);2680 table->field[2]->store(user_stats->concurrent_connections, true);
2680 table->field[4]->store((longlong)user_stats->busy_time);2681 table->field[3]->store(user_stats->connected_time, true);
2681 table->field[5]->store((longlong)user_stats->cpu_time);2682 table->field[4]->store((ulonglong)user_stats->busy_time, true);
2682 table->field[6]->store((longlong)user_stats->bytes_received);2683 table->field[5]->store((ulonglong)user_stats->cpu_time, true);
2683 table->field[7]->store((longlong)user_stats->bytes_sent);2684 table->field[6]->store(user_stats->bytes_received, true);
2684 table->field[8]->store((longlong)user_stats->binlog_bytes_written);2685 table->field[7]->store(user_stats->bytes_sent, true);
2685 table->field[9]->store((longlong)user_stats->rows_fetched);2686 table->field[8]->store(user_stats->binlog_bytes_written, true);
2686 table->field[10]->store((longlong)user_stats->rows_updated);2687 table->field[9]->store(user_stats->rows_fetched, true);
2687 table->field[11]->store((longlong)user_stats->rows_read);2688 table->field[10]->store(user_stats->rows_updated, true);
2688 table->field[12]->store((longlong)user_stats->select_commands);2689 table->field[11]->store(user_stats->rows_read, true);
2689 table->field[13]->store((longlong)user_stats->update_commands);2690 table->field[12]->store(user_stats->select_commands, true);
2690 table->field[14]->store((longlong)user_stats->other_commands);2691 table->field[13]->store(user_stats->update_commands, true);
2691 table->field[15]->store((longlong)user_stats->commit_trans);2692 table->field[14]->store(user_stats->other_commands, true);
2692 table->field[16]->store((longlong)user_stats->rollback_trans);2693 table->field[15]->store(user_stats->commit_trans, true);
2693 table->field[17]->store((longlong)user_stats->denied_connections);2694 table->field[16]->store(user_stats->rollback_trans, true);
2694 table->field[18]->store((longlong)user_stats->lost_connections);2695 table->field[17]->store(user_stats->denied_connections, true);
2695 table->field[19]->store((longlong)user_stats->access_denied_errors);2696 table->field[18]->store(user_stats->lost_connections, true);
2696 table->field[20]->store((longlong)user_stats->empty_queries);2697 table->field[19]->store(user_stats->access_denied_errors, true);
2697 table->field[21]->store((longlong)user_stats->total_ssl_connections);2698 table->field[20]->store(user_stats->empty_queries, true);
2698 if (schema_table_store_record(thd, table))2699 table->field[21]->store(user_stats->total_ssl_connections, true);
2699 {2700 if (schema_table_store_record(thd, table))
2700 DBUG_PRINT("error", ("store record error"));2701 {
2701 DBUG_RETURN(1);2702 DBUG_PRINT("error", ("store record error"));
2702 }2703 DBUG_RETURN(1);
2704 }
2703 }2705 }
2704 DBUG_RETURN(0);2706 DBUG_RETURN(0);
2705}2707}
@@ -2838,9 +2840,9 @@
28382840
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);
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);
2841 table->field[2]->store((longlong)table_stats->rows_read, TRUE);2843 table->field[2]->store(table_stats->rows_read, true);
2842 table->field[3]->store((longlong)table_stats->rows_changed, TRUE);2844 table->field[3]->store(table_stats->rows_changed, true);
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);
28442846
2845 if (schema_table_store_record(thd, table))2847 if (schema_table_store_record(thd, table))
2846 {2848 {
@@ -2884,7 +2886,7 @@
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);
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);
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);
2887 table->field[3]->store((longlong)index_stats->rows_read, TRUE);2889 table->field[3]->store(index_stats->rows_read, true);
28882890
2889 if (schema_table_store_record(thd, table))2891 if (schema_table_store_record(thd, table))
2890 {2892 {
@@ -8317,100 +8319,174 @@
8317ST_FIELD_INFO user_stats_fields_info[]=8319ST_FIELD_INFO user_stats_fields_info[]=
8318{8320{
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},
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
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,
8343 MY_I_S_UNSIGNED, "Table_rows_read", SKIP_OPEN_TABLE},
8344 {"SELECT_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8345 MY_I_S_UNSIGNED, "Select_commands", SKIP_OPEN_TABLE},
8346 {"UPDATE_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8347 MY_I_S_UNSIGNED, "Update_commands", SKIP_OPEN_TABLE},
8348 {"OTHER_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8349 MY_I_S_UNSIGNED, "Other_commands", SKIP_OPEN_TABLE},
8350 {"COMMIT_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8351 MY_I_S_UNSIGNED, "Commit_transactions", SKIP_OPEN_TABLE},
8352 {"ROLLBACK_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
8353 0, MY_I_S_UNSIGNED, "Rollback_transactions", SKIP_OPEN_TABLE},
8354 {"DENIED_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8355 MY_I_S_UNSIGNED, "Denied_connections", SKIP_OPEN_TABLE},
8356 {"LOST_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8357 MY_I_S_UNSIGNED, "Lost_connections", SKIP_OPEN_TABLE},
8358 {"ACCESS_DENIED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8359 MY_I_S_UNSIGNED, "Access_denied", SKIP_OPEN_TABLE},
8360 {"EMPTY_QUERIES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8361 MY_I_S_UNSIGNED, "Empty_queries", SKIP_OPEN_TABLE},
8362 {"TOTAL_SSL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
8363 0, MY_I_S_UNSIGNED, "Total_ssl_connections", SKIP_OPEN_TABLE},
8341 {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0}8364 {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0}
8342};8365};
83438366
8344ST_FIELD_INFO client_stats_fields_info[]=8367ST_FIELD_INFO client_stats_fields_info[]=
8345{8368{
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",
8347 {"TOTAL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Total_connections", SKIP_OPEN_TABLE},8370 SKIP_OPEN_TABLE},
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
8391 {"TABLE_ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8392 MY_I_S_UNSIGNED, "Table_rows_read", SKIP_OPEN_TABLE},
8393 {"SELECT_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8394 MY_I_S_UNSIGNED, "Select_commands", SKIP_OPEN_TABLE},
8395 {"UPDATE_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8396 MY_I_S_UNSIGNED, "Update_commands", SKIP_OPEN_TABLE},
8397 {"OTHER_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8398 MY_I_S_UNSIGNED, "Other_commands", SKIP_OPEN_TABLE},
8399 {"COMMIT_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8400 MY_I_S_UNSIGNED, "Commit_transactions", SKIP_OPEN_TABLE},
8401 {"ROLLBACK_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
8402 0, MY_I_S_UNSIGNED, "Rollback_transactions", SKIP_OPEN_TABLE},
8403 {"DENIED_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8404 MY_I_S_UNSIGNED, "Denied_connections", SKIP_OPEN_TABLE},
8405 {"LOST_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8406 MY_I_S_UNSIGNED, "Lost_connections", SKIP_OPEN_TABLE},
8407 {"ACCESS_DENIED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8408 MY_I_S_UNSIGNED, "Access_denied", SKIP_OPEN_TABLE},
8409 {"EMPTY_QUERIES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8410 MY_I_S_UNSIGNED, "Empty_queries", SKIP_OPEN_TABLE},
8411 {"TOTAL_SSL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
8412 0, MY_I_S_UNSIGNED, "Total_ssl_connections", SKIP_OPEN_TABLE},
8368 {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0}8413 {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0}
8369};8414};
83708415
8371ST_FIELD_INFO thread_stats_fields_info[]=8416ST_FIELD_INFO thread_stats_fields_info[]=
8372{8417{
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
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,
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},
8440 {"TABLE_ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8441 MY_I_S_UNSIGNED, "Table_rows_read", SKIP_OPEN_TABLE},
8442 {"SELECT_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8443 MY_I_S_UNSIGNED, "Select_commands", SKIP_OPEN_TABLE},
8444 {"UPDATE_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8445 MY_I_S_UNSIGNED, "Update_commands", SKIP_OPEN_TABLE},
8446 {"OTHER_COMMANDS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8447 MY_I_S_UNSIGNED, "Other_commands", SKIP_OPEN_TABLE},
8448 {"COMMIT_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8449 MY_I_S_UNSIGNED, "Commit_transactions", SKIP_OPEN_TABLE},
8450 {"ROLLBACK_TRANSACTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
8451 0, MY_I_S_UNSIGNED, "Rollback_transactions", SKIP_OPEN_TABLE},
8452 {"DENIED_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8453 MY_I_S_UNSIGNED, "Denied_connections", SKIP_OPEN_TABLE},
8454 {"LOST_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8455 MY_I_S_UNSIGNED, "Lost_connections", SKIP_OPEN_TABLE},
8456 {"ACCESS_DENIED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8457 MY_I_S_UNSIGNED, "Access_denied", SKIP_OPEN_TABLE},
8458 {"EMPTY_QUERIES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8459 MY_I_S_UNSIGNED, "Empty_queries", SKIP_OPEN_TABLE},
8460 {"TOTAL_SSL_CONNECTIONS", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
8461 0, MY_I_S_UNSIGNED, "Total_ssl_connections", SKIP_OPEN_TABLE},
8395 {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0}8462 {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0}
8396};8463};
83978464
8398ST_FIELD_INFO table_stats_fields_info[]=8465ST_FIELD_INFO table_stats_fields_info[]=
8399{8466{
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",
8401 {"TABLE_NAME", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Table_name", SKIP_OPEN_TABLE},8468 SKIP_OPEN_TABLE},
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",
8403 {"ROWS_CHANGED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_changed", SKIP_OPEN_TABLE},8470 SKIP_OPEN_TABLE},
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,
8472 MY_I_S_UNSIGNED, "Rows_read", SKIP_OPEN_TABLE},
8473 {"ROWS_CHANGED", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8474 MY_I_S_UNSIGNED, "Rows_changed", SKIP_OPEN_TABLE},
8475 {"ROWS_CHANGED_X_INDEXES", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG,
8476 0, MY_I_S_UNSIGNED, "Rows_changed_x_#indexes", SKIP_OPEN_TABLE},
8405 {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0}8477 {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0}
8406};8478};
84078479
8408ST_FIELD_INFO index_stats_fields_info[]=8480ST_FIELD_INFO index_stats_fields_info[]=
8409{8481{
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",
8411 {"TABLE_NAME", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Table_name", SKIP_OPEN_TABLE},8483 SKIP_OPEN_TABLE},
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",
8413 {"ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, "Rows_read", SKIP_OPEN_TABLE},8485 SKIP_OPEN_TABLE},
8486 {"INDEX_NAME", NAME_LEN, MYSQL_TYPE_STRING, 0, 0, "Index_name",
8487 SKIP_OPEN_TABLE},
8488 {"ROWS_READ", MY_INT64_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, 0,
8489 MY_I_S_UNSIGNED, "Rows_read", SKIP_OPEN_TABLE},
8414 {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0}8490 {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, 0}
8415};8491};
84168492

Subscribers

People subscribed via source and target branches