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

Merge lp:~percona-dev/percona-server/5.1.54-mysql-tests into lp:percona-server/release-5.1.54-12

  1. 5.1.54-mysql-tests
  2. Merge into 5.1.54
Proposed by Aleksandr Kuzminsky
Status: Merged
Approved by: Vadim Tkachenko
Approved revision: no longer in the source branch.
Merged at revision: 187
Proposed branch: lp:~percona-dev/percona-server/5.1.54-mysql-tests
Merge into: lp:percona-server/release-5.1.54-12
Diff against target: 3010 lines (+2955/-2)
6 files modified
mysql-test.diff (+2949/-0)
mysql-test/percona_innodb_buffer_pool_shm-master.opt (+1/-0)
mysql-test/percona_innodb_buffer_pool_shm.result (+2/-0)
mysql-test/percona_innodb_buffer_pool_shm.test (+1/-0)
mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.result (+1/-1)
mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.test (+1/-1)
To merge this branch: bzr merge lp:~percona-dev/percona-server/5.1.54-mysql-tests
Reviewer Review Type Date Requested Status
Vadim Tkachenko Approve
Review via email: mp+45120@code.launchpad.net

Description of the change

Ported tests from 5.1.53

To post a comment you must log in.
Revision history for this message
Vadim Tkachenko (vadim-tk) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'mysql-test.diff'
2--- mysql-test.diff 2010-12-02 17:27:13 +0000
3+++ mysql-test.diff 2011-01-04 13:41:02 +0000
4@@ -1044,3 +1044,2952 @@
5 -
6 ---echo End of 5.1 tests
7 -
8+diff -Nur a/mysql-test/suite/innodb/t/disabled.def b/mysql-test/suite/innodb/t/disabled.def
9+--- a/mysql-test/suite/innodb/t/disabled.def 2010-12-03 07:45:59.000000000 -0800
10++++ b/mysql-test/suite/innodb/t/disabled.def 2010-12-10 07:38:20.000000000 -0800
11+@@ -9,3 +9,4 @@
12+ # Do not use any TAB characters for whitespace.
13+ #
14+ ##############################################################################
15++innodb.innodb_bug56143 : Bug #684250 2010-12-03 akuzminsky https://bugs.launchpad.net/percona-server/+bug/684250
16+diff -Nur a/mysql-test/suite/funcs_1/r/is_columns_is.result b/mysql-test/suite/funcs_1/r/is_columns_is.result
17+--- a/mysql-test/suite/funcs_1/r/is_columns_is.result 2010-12-23 10:11:44.000000000 -0500
18++++ b/mysql-test/suite/funcs_1/r/is_columns_is.result 2010-12-23 10:13:04.000000000 -0500
19+@@ -7,6 +7,27 @@
20+ NULL information_schema CHARACTER_SETS DEFAULT_COLLATE_NAME 2 NO varchar 32 96 NULL NULL utf8 utf8_general_ci varchar(32) select
21+ NULL information_schema CHARACTER_SETS DESCRIPTION 3 NO varchar 60 180 NULL NULL utf8 utf8_general_ci varchar(60) select
22+ NULL information_schema CHARACTER_SETS MAXLEN 4 0 NO bigint NULL NULL 19 0 NULL NULL bigint(3) select
23++NULL information_schema CLIENT_STATISTICS ACCESS_DENIED 20 0 NO int NULL NULL 10 0 NULL NULL int(21) select
24++NULL information_schema CLIENT_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO int NULL NULL 10 0 NULL NULL int(21) select
25++NULL information_schema CLIENT_STATISTICS BUSY_TIME 5 0 NO int NULL NULL 10 0 NULL NULL int(21) select
26++NULL information_schema CLIENT_STATISTICS BYTES_RECEIVED 7 0 NO int NULL NULL 10 0 NULL NULL int(21) select
27++NULL information_schema CLIENT_STATISTICS BYTES_SENT 8 0 NO int NULL NULL 10 0 NULL NULL int(21) select
28++NULL information_schema CLIENT_STATISTICS CLIENT 1 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
29++NULL information_schema CLIENT_STATISTICS COMMIT_TRANSACTIONS 16 0 NO int NULL NULL 10 0 NULL NULL int(21) select
30++NULL information_schema CLIENT_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO int NULL NULL 10 0 NULL NULL int(21) select
31++NULL information_schema CLIENT_STATISTICS CONNECTED_TIME 4 0 NO int NULL NULL 10 0 NULL NULL int(21) select
32++NULL information_schema CLIENT_STATISTICS CPU_TIME 6 0 NO int NULL NULL 10 0 NULL NULL int(21) select
33++NULL information_schema CLIENT_STATISTICS DENIED_CONNECTIONS 18 0 NO int NULL NULL 10 0 NULL NULL int(21) select
34++NULL information_schema CLIENT_STATISTICS EMPTY_QUERIES 21 0 NO int NULL NULL 10 0 NULL NULL int(21) select
35++NULL information_schema CLIENT_STATISTICS LOST_CONNECTIONS 19 0 NO int NULL NULL 10 0 NULL NULL int(21) select
36++NULL information_schema CLIENT_STATISTICS OTHER_COMMANDS 15 0 NO int NULL NULL 10 0 NULL NULL int(21) select
37++NULL information_schema CLIENT_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO int NULL NULL 10 0 NULL NULL int(21) select
38++NULL information_schema CLIENT_STATISTICS ROWS_FETCHED 10 0 NO int NULL NULL 10 0 NULL NULL int(21) select
39++NULL information_schema CLIENT_STATISTICS ROWS_UPDATED 11 0 NO int NULL NULL 10 0 NULL NULL int(21) select
40++NULL information_schema CLIENT_STATISTICS SELECT_COMMANDS 13 0 NO int NULL NULL 10 0 NULL NULL int(21) select
41++NULL information_schema CLIENT_STATISTICS TABLE_ROWS_READ 12 0 NO int NULL NULL 10 0 NULL NULL int(21) select
42++NULL information_schema CLIENT_STATISTICS TOTAL_CONNECTIONS 2 0 NO int NULL NULL 10 0 NULL NULL int(21) select
43++NULL information_schema CLIENT_STATISTICS UPDATE_COMMANDS 14 0 NO int NULL NULL 10 0 NULL NULL int(21) select
44+ NULL information_schema COLLATIONS CHARACTER_SET_NAME 2 NO varchar 32 96 NULL NULL utf8 utf8_general_ci varchar(32) select
45+ NULL information_schema COLLATIONS COLLATION_NAME 1 NO varchar 32 96 NULL NULL utf8 utf8_general_ci varchar(32) select
46+ NULL information_schema COLLATIONS ID 3 0 NO bigint NULL NULL 19 0 NULL NULL bigint(11) select
47+@@ -111,8 +132,132 @@
48+ NULL information_schema FILES VERSION 25 NULL YES bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
49+ NULL information_schema GLOBAL_STATUS VARIABLE_NAME 1 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
50+ NULL information_schema GLOBAL_STATUS VARIABLE_VALUE 2 NULL YES varchar 1024 3072 NULL NULL utf8 utf8_general_ci varchar(1024) select
51++NULL information_schema GLOBAL_TEMPORARY_TABLES AVG_ROW_LENGTH 7 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
52++NULL information_schema GLOBAL_TEMPORARY_TABLES CREATE_TIME 10 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select
53++NULL information_schema GLOBAL_TEMPORARY_TABLES DATA_LENGTH 8 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
54++NULL information_schema GLOBAL_TEMPORARY_TABLES ENGINE 4 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
55++NULL information_schema GLOBAL_TEMPORARY_TABLES INDEX_LENGTH 9 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
56++NULL information_schema GLOBAL_TEMPORARY_TABLES NAME 5 NO varchar 512 1536 NULL NULL utf8 utf8_general_ci varchar(512) select
57++NULL information_schema GLOBAL_TEMPORARY_TABLES SESSION_ID 1 0 NO bigint NULL NULL 19 0 NULL NULL bigint(4) select
58++NULL information_schema GLOBAL_TEMPORARY_TABLES TABLE_NAME 3 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
59++NULL information_schema GLOBAL_TEMPORARY_TABLES TABLE_ROWS 6 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
60++NULL information_schema GLOBAL_TEMPORARY_TABLES TABLE_SCHEMA 2 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
61++NULL information_schema GLOBAL_TEMPORARY_TABLES UPDATE_TIME 11 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select
62+ NULL information_schema GLOBAL_VARIABLES VARIABLE_NAME 1 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
63+ NULL information_schema GLOBAL_VARIABLES VARIABLE_VALUE 2 NULL YES varchar 1024 3072 NULL NULL utf8 utf8_general_ci varchar(1024) select
64++NULL information_schema INDEX_STATISTICS INDEX_NAME 3 NO varchar 192 576 NULL NULL utf8 utf8_general_ci varchar(192) select
65++NULL information_schema INDEX_STATISTICS ROWS_READ 4 0 NO int NULL NULL 10 0 NULL NULL int(21) select
66++NULL information_schema INDEX_STATISTICS TABLE_NAME 2 NO varchar 192 576 NULL NULL utf8 utf8_general_ci varchar(192) select
67++NULL information_schema INDEX_STATISTICS TABLE_SCHEMA 1 NO varchar 192 576 NULL NULL utf8 utf8_general_ci varchar(192) select
68++NULL information_schema INNODB_BUFFER_POOL_PAGES fix_count 5 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
69++NULL information_schema INNODB_BUFFER_POOL_PAGES flush_type 6 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
70++NULL information_schema INNODB_BUFFER_POOL_PAGES lru_position 4 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
71++NULL information_schema INNODB_BUFFER_POOL_PAGES page_no 3 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
72++NULL information_schema INNODB_BUFFER_POOL_PAGES page_type 1 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
73++NULL information_schema INNODB_BUFFER_POOL_PAGES space_id 2 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
74++NULL information_schema INNODB_BUFFER_POOL_PAGES_BLOB compressed 3 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
75++NULL information_schema INNODB_BUFFER_POOL_PAGES_BLOB fix_count 7 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
76++NULL information_schema INNODB_BUFFER_POOL_PAGES_BLOB flush_type 8 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
77++NULL information_schema INNODB_BUFFER_POOL_PAGES_BLOB lru_position 6 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
78++NULL information_schema INNODB_BUFFER_POOL_PAGES_BLOB next_page_no 5 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
79++NULL information_schema INNODB_BUFFER_POOL_PAGES_BLOB page_no 2 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
80++NULL information_schema INNODB_BUFFER_POOL_PAGES_BLOB part_len 4 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
81++NULL information_schema INNODB_BUFFER_POOL_PAGES_BLOB space_id 1 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
82++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX access_time 7 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
83++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX data_size 5 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
84++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX dirty 9 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
85++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX fix_count 12 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
86++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX flush_type 13 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
87++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX hashed 6 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
88++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX index_id 1 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
89++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX lru_position 11 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
90++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX modified 8 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
91++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX n_recs 4 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
92++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX old 10 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
93++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX page_no 3 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
94++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX space_id 2 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
95++NULL information_schema INNODB_CMP compress_ops 2 0 NO int NULL NULL 10 0 NULL NULL int(11) select
96++NULL information_schema INNODB_CMP compress_ops_ok 3 0 NO int NULL NULL 10 0 NULL NULL int(11) select
97++NULL information_schema INNODB_CMP compress_time 4 0 NO int NULL NULL 10 0 NULL NULL int(11) select
98++NULL information_schema INNODB_CMP page_size 1 0 NO int NULL NULL 10 0 NULL NULL int(5) select
99++NULL information_schema INNODB_CMP uncompress_ops 5 0 NO int NULL NULL 10 0 NULL NULL int(11) select
100++NULL information_schema INNODB_CMP uncompress_time 6 0 NO int NULL NULL 10 0 NULL NULL int(11) select
101++NULL information_schema INNODB_CMPMEM pages_free 3 0 NO int NULL NULL 10 0 NULL NULL int(11) select
102++NULL information_schema INNODB_CMPMEM pages_used 2 0 NO int NULL NULL 10 0 NULL NULL int(11) select
103++NULL information_schema INNODB_CMPMEM page_size 1 0 NO int NULL NULL 10 0 NULL NULL int(5) select
104++NULL information_schema INNODB_CMPMEM relocation_ops 4 0 NO bigint NULL NULL 19 0 NULL NULL bigint(21) select
105++NULL information_schema INNODB_CMPMEM relocation_time 5 0 NO int NULL NULL 10 0 NULL NULL int(11) select
106++NULL information_schema INNODB_CMPMEM_RESET pages_free 3 0 NO int NULL NULL 10 0 NULL NULL int(11) select
107++NULL information_schema INNODB_CMPMEM_RESET pages_used 2 0 NO int NULL NULL 10 0 NULL NULL int(11) select
108++NULL information_schema INNODB_CMPMEM_RESET page_size 1 0 NO int NULL NULL 10 0 NULL NULL int(5) select
109++NULL information_schema INNODB_CMPMEM_RESET relocation_ops 4 0 NO bigint NULL NULL 19 0 NULL NULL bigint(21) select
110++NULL information_schema INNODB_CMPMEM_RESET relocation_time 5 0 NO int NULL NULL 10 0 NULL NULL int(11) select
111++NULL information_schema INNODB_CMP_RESET compress_ops 2 0 NO int NULL NULL 10 0 NULL NULL int(11) select
112++NULL information_schema INNODB_CMP_RESET compress_ops_ok 3 0 NO int NULL NULL 10 0 NULL NULL int(11) select
113++NULL information_schema INNODB_CMP_RESET compress_time 4 0 NO int NULL NULL 10 0 NULL NULL int(11) select
114++NULL information_schema INNODB_CMP_RESET page_size 1 0 NO int NULL NULL 10 0 NULL NULL int(5) select
115++NULL information_schema INNODB_CMP_RESET uncompress_ops 5 0 NO int NULL NULL 10 0 NULL NULL int(11) select
116++NULL information_schema INNODB_CMP_RESET uncompress_time 6 0 NO int NULL NULL 10 0 NULL NULL int(11) select
117++NULL information_schema INNODB_INDEX_STATS fields 4 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
118++NULL information_schema INNODB_INDEX_STATS index_name 3 NO varchar 192 576 NULL NULL utf8 utf8_general_ci varchar(192) select
119++NULL information_schema INNODB_INDEX_STATS index_size 6 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
120++NULL information_schema INNODB_INDEX_STATS leaf_pages 7 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
121++NULL information_schema INNODB_INDEX_STATS row_per_keys 5 NO varchar 256 768 NULL NULL utf8 utf8_general_ci varchar(256) select
122++NULL information_schema INNODB_INDEX_STATS table_name 2 NO varchar 192 576 NULL NULL utf8 utf8_general_ci varchar(192) select
123++NULL information_schema INNODB_INDEX_STATS table_schema 1 NO varchar 192 576 NULL NULL utf8 utf8_general_ci varchar(192) select
124++NULL information_schema INNODB_LOCKS lock_data 10 NULL YES varchar 8192 24576 NULL NULL utf8 utf8_general_ci varchar(8192) select
125++NULL information_schema INNODB_LOCKS lock_id 1 NO varchar 81 243 NULL NULL utf8 utf8_general_ci varchar(81) select
126++NULL information_schema INNODB_LOCKS lock_index 6 NULL YES varchar 1024 3072 NULL NULL utf8 utf8_general_ci varchar(1024) select
127++NULL information_schema INNODB_LOCKS lock_mode 3 NO varchar 32 96 NULL NULL utf8 utf8_general_ci varchar(32) select
128++NULL information_schema INNODB_LOCKS lock_page 8 NULL YES bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
129++NULL information_schema INNODB_LOCKS lock_rec 9 NULL YES bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
130++NULL information_schema INNODB_LOCKS lock_space 7 NULL YES bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
131++NULL information_schema INNODB_LOCKS lock_table 5 NO varchar 1024 3072 NULL NULL utf8 utf8_general_ci varchar(1024) select
132++NULL information_schema INNODB_LOCKS lock_trx_id 2 NO varchar 18 54 NULL NULL utf8 utf8_general_ci varchar(18) select
133++NULL information_schema INNODB_LOCKS lock_type 4 NO varchar 32 96 NULL NULL utf8 utf8_general_ci varchar(32) select
134++NULL information_schema INNODB_LOCK_WAITS blocking_lock_id 4 NO varchar 81 243 NULL NULL utf8 utf8_general_ci varchar(81) select
135++NULL information_schema INNODB_LOCK_WAITS blocking_trx_id 3 NO varchar 18 54 NULL NULL utf8 utf8_general_ci varchar(18) select
136++NULL information_schema INNODB_LOCK_WAITS requested_lock_id 2 NO varchar 81 243 NULL NULL utf8 utf8_general_ci varchar(81) select
137++NULL information_schema INNODB_LOCK_WAITS requesting_trx_id 1 NO varchar 18 54 NULL NULL utf8 utf8_general_ci varchar(18) select
138++NULL information_schema INNODB_RSEG curr_size 6 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
139++NULL information_schema INNODB_RSEG max_size 5 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
140++NULL information_schema INNODB_RSEG page_no 4 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
141++NULL information_schema INNODB_RSEG rseg_id 1 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
142++NULL information_schema INNODB_RSEG space_id 2 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
143++NULL information_schema INNODB_RSEG zip_size 3 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
144++NULL information_schema INNODB_SYS_INDEXES ID 2 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
145++NULL information_schema INNODB_SYS_INDEXES NAME 3 NO varchar 192 576 NULL NULL utf8 utf8_general_ci varchar(192) select
146++NULL information_schema INNODB_SYS_INDEXES N_FIELDS 4 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
147++NULL information_schema INNODB_SYS_INDEXES PAGE_NO 7 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
148++NULL information_schema INNODB_SYS_INDEXES SPACE 6 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
149++NULL information_schema INNODB_SYS_INDEXES TABLE_ID 1 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
150++NULL information_schema INNODB_SYS_INDEXES TYPE 5 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
151++NULL information_schema INNODB_SYS_STATS DIFF_VALS 3 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
152++NULL information_schema INNODB_SYS_STATS INDEX_ID 1 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
153++NULL information_schema INNODB_SYS_STATS KEY_COLS 2 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
154++NULL information_schema INNODB_SYS_TABLES CLUSTER_NAME 8 NO varchar 192 576 NULL NULL utf8 utf8_general_ci varchar(192) select
155++NULL information_schema INNODB_SYS_TABLES ID 3 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
156++NULL information_schema INNODB_SYS_TABLES MIX_ID 6 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
157++NULL information_schema INNODB_SYS_TABLES MIX_LEN 7 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
158++NULL information_schema INNODB_SYS_TABLES NAME 2 NO varchar 192 576 NULL NULL utf8 utf8_general_ci varchar(192) select
159++NULL information_schema INNODB_SYS_TABLES N_COLS 4 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
160++NULL information_schema INNODB_SYS_TABLES SCHEMA 1 NO varchar 192 576 NULL NULL utf8 utf8_general_ci varchar(192) select
161++NULL information_schema INNODB_SYS_TABLES SPACE 9 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
162++NULL information_schema INNODB_SYS_TABLES TYPE 5 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
163++NULL information_schema INNODB_TABLE_STATS clust_size 4 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
164++NULL information_schema INNODB_TABLE_STATS modified 6 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
165++NULL information_schema INNODB_TABLE_STATS other_size 5 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
166++NULL information_schema INNODB_TABLE_STATS rows 3 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
167++NULL information_schema INNODB_TABLE_STATS table_name 2 NO varchar 192 576 NULL NULL utf8 utf8_general_ci varchar(192) select
168++NULL information_schema INNODB_TABLE_STATS table_schema 1 NO varchar 192 576 NULL NULL utf8 utf8_general_ci varchar(192) select
169++NULL information_schema INNODB_TRX trx_id 1 NO varchar 18 54 NULL NULL utf8 utf8_general_ci varchar(18) select
170++NULL information_schema INNODB_TRX trx_mysql_thread_id 7 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
171++NULL information_schema INNODB_TRX trx_query 8 NULL YES varchar 1024 3072 NULL NULL utf8 utf8_general_ci varchar(1024) select
172++NULL information_schema INNODB_TRX trx_requested_lock_id 4 NULL YES varchar 81 243 NULL NULL utf8 utf8_general_ci varchar(81) select
173++NULL information_schema INNODB_TRX trx_started 3 0000-00-00 00:00:00 NO datetime NULL NULL NULL NULL NULL NULL datetime select
174++NULL information_schema INNODB_TRX trx_state 2 NO varchar 13 39 NULL NULL utf8 utf8_general_ci varchar(13) select
175++NULL information_schema INNODB_TRX trx_wait_started 5 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select
176++NULL information_schema INNODB_TRX trx_weight 6 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
177+ NULL information_schema KEY_COLUMN_USAGE COLUMN_NAME 7 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
178+ NULL information_schema KEY_COLUMN_USAGE CONSTRAINT_CATALOG 1 NULL YES varchar 512 1536 NULL NULL utf8 utf8_general_ci varchar(512) select
179+ NULL information_schema KEY_COLUMN_USAGE CONSTRAINT_NAME 3 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
180+@@ -167,7 +312,11 @@
181+ NULL information_schema PROCESSLIST INFO 8 NULL YES longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select
182+ NULL information_schema PROCESSLIST STATE 7 NULL YES varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
183+ NULL information_schema PROCESSLIST TIME 6 0 NO int NULL NULL 10 0 NULL NULL int(7) select
184++NULL information_schema PROCESSLIST TIME_MS 9 0 NO bigint NULL NULL 19 0 NULL NULL bigint(21) select
185+ NULL information_schema PROCESSLIST USER 2 NO varchar 16 48 NULL NULL utf8 utf8_general_ci varchar(16) select
186++NULL information_schema QUERY_RESPONSE_TIME count 2 0 NO int NULL NULL 10 0 NULL NULL int(11) unsigned select
187++NULL information_schema QUERY_RESPONSE_TIME time 1 NO varchar 14 42 NULL NULL utf8 utf8_general_ci varchar(14) select
188++NULL information_schema QUERY_RESPONSE_TIME total 3 NO varchar 14 42 NULL NULL utf8 utf8_general_ci varchar(14) select
189+ NULL information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_CATALOG 1 NULL YES varchar 512 1536 NULL NULL utf8 utf8_general_ci varchar(512) select
190+ NULL information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME 3 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
191+ NULL information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA 2 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
192+@@ -264,6 +413,43 @@
193+ NULL information_schema TABLE_PRIVILEGES TABLE_CATALOG 2 NULL YES varchar 512 1536 NULL NULL utf8 utf8_general_ci varchar(512) select
194+ NULL information_schema TABLE_PRIVILEGES TABLE_NAME 4 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
195+ NULL information_schema TABLE_PRIVILEGES TABLE_SCHEMA 3 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
196++NULL information_schema TABLE_STATISTICS ROWS_CHANGED 4 0 NO int NULL NULL 10 0 NULL NULL int(21) select
197++NULL information_schema TABLE_STATISTICS ROWS_CHANGED_X_INDEXES 5 0 NO int NULL NULL 10 0 NULL NULL int(21) select
198++NULL information_schema TABLE_STATISTICS ROWS_READ 3 0 NO int NULL NULL 10 0 NULL NULL int(21) select
199++NULL information_schema TABLE_STATISTICS TABLE_NAME 2 NO varchar 192 576 NULL NULL utf8 utf8_general_ci varchar(192) select
200++NULL information_schema TABLE_STATISTICS TABLE_SCHEMA 1 NO varchar 192 576 NULL NULL utf8 utf8_general_ci varchar(192) select
201++NULL information_schema TEMPORARY_TABLES AVG_ROW_LENGTH 7 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
202++NULL information_schema TEMPORARY_TABLES CREATE_TIME 10 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select
203++NULL information_schema TEMPORARY_TABLES DATA_LENGTH 8 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
204++NULL information_schema TEMPORARY_TABLES ENGINE 4 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
205++NULL information_schema TEMPORARY_TABLES INDEX_LENGTH 9 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
206++NULL information_schema TEMPORARY_TABLES NAME 5 NO varchar 512 1536 NULL NULL utf8 utf8_general_ci varchar(512) select
207++NULL information_schema TEMPORARY_TABLES SESSION_ID 1 0 NO bigint NULL NULL 19 0 NULL NULL bigint(4) select
208++NULL information_schema TEMPORARY_TABLES TABLE_NAME 3 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
209++NULL information_schema TEMPORARY_TABLES TABLE_ROWS 6 0 NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned select
210++NULL information_schema TEMPORARY_TABLES TABLE_SCHEMA 2 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
211++NULL information_schema TEMPORARY_TABLES UPDATE_TIME 11 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select
212++NULL information_schema THREAD_STATISTICS ACCESS_DENIED 20 0 NO int NULL NULL 10 0 NULL NULL int(21) select
213++NULL information_schema THREAD_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO int NULL NULL 10 0 NULL NULL int(21) select
214++NULL information_schema THREAD_STATISTICS BUSY_TIME 5 0 NO int NULL NULL 10 0 NULL NULL int(21) select
215++NULL information_schema THREAD_STATISTICS BYTES_RECEIVED 7 0 NO int NULL NULL 10 0 NULL NULL int(21) select
216++NULL information_schema THREAD_STATISTICS BYTES_SENT 8 0 NO int NULL NULL 10 0 NULL NULL int(21) select
217++NULL information_schema THREAD_STATISTICS COMMIT_TRANSACTIONS 16 0 NO int NULL NULL 10 0 NULL NULL int(21) select
218++NULL information_schema THREAD_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO int NULL NULL 10 0 NULL NULL int(21) select
219++NULL information_schema THREAD_STATISTICS CONNECTED_TIME 4 0 NO int NULL NULL 10 0 NULL NULL int(21) select
220++NULL information_schema THREAD_STATISTICS CPU_TIME 6 0 NO int NULL NULL 10 0 NULL NULL int(21) select
221++NULL information_schema THREAD_STATISTICS DENIED_CONNECTIONS 18 0 NO int NULL NULL 10 0 NULL NULL int(21) select
222++NULL information_schema THREAD_STATISTICS EMPTY_QUERIES 21 0 NO int NULL NULL 10 0 NULL NULL int(21) select
223++NULL information_schema THREAD_STATISTICS LOST_CONNECTIONS 19 0 NO int NULL NULL 10 0 NULL NULL int(21) select
224++NULL information_schema THREAD_STATISTICS OTHER_COMMANDS 15 0 NO int NULL NULL 10 0 NULL NULL int(21) select
225++NULL information_schema THREAD_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO int NULL NULL 10 0 NULL NULL int(21) select
226++NULL information_schema THREAD_STATISTICS ROWS_FETCHED 10 0 NO int NULL NULL 10 0 NULL NULL int(21) select
227++NULL information_schema THREAD_STATISTICS ROWS_UPDATED 11 0 NO int NULL NULL 10 0 NULL NULL int(21) select
228++NULL information_schema THREAD_STATISTICS SELECT_COMMANDS 13 0 NO int NULL NULL 10 0 NULL NULL int(21) select
229++NULL information_schema THREAD_STATISTICS TABLE_ROWS_READ 12 0 NO int NULL NULL 10 0 NULL NULL int(21) select
230++NULL information_schema THREAD_STATISTICS THREAD_ID 1 0 NO int NULL NULL 10 0 NULL NULL int(21) select
231++NULL information_schema THREAD_STATISTICS TOTAL_CONNECTIONS 2 0 NO int NULL NULL 10 0 NULL NULL int(21) select
232++NULL information_schema THREAD_STATISTICS UPDATE_COMMANDS 14 0 NO int NULL NULL 10 0 NULL NULL int(21) select
233+ NULL information_schema TRIGGERS ACTION_CONDITION 9 NULL YES longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select
234+ NULL information_schema TRIGGERS ACTION_ORDER 8 0 NO bigint NULL NULL 19 0 NULL NULL bigint(4) select
235+ NULL information_schema TRIGGERS ACTION_ORIENTATION 11 NO varchar 9 27 NULL NULL utf8 utf8_general_ci varchar(9) select
236+@@ -290,6 +476,27 @@
237+ NULL information_schema USER_PRIVILEGES IS_GRANTABLE 4 NO varchar 3 9 NULL NULL utf8 utf8_general_ci varchar(3) select
238+ NULL information_schema USER_PRIVILEGES PRIVILEGE_TYPE 3 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
239+ NULL information_schema USER_PRIVILEGES TABLE_CATALOG 2 NULL YES varchar 512 1536 NULL NULL utf8 utf8_general_ci varchar(512) select
240++NULL information_schema USER_STATISTICS ACCESS_DENIED 20 0 NO int NULL NULL 10 0 NULL NULL int(21) select
241++NULL information_schema USER_STATISTICS BINLOG_BYTES_WRITTEN 9 0 NO int NULL NULL 10 0 NULL NULL int(21) select
242++NULL information_schema USER_STATISTICS BUSY_TIME 5 0 NO int NULL NULL 10 0 NULL NULL int(21) select
243++NULL information_schema USER_STATISTICS BYTES_RECEIVED 7 0 NO int NULL NULL 10 0 NULL NULL int(21) select
244++NULL information_schema USER_STATISTICS BYTES_SENT 8 0 NO int NULL NULL 10 0 NULL NULL int(21) select
245++NULL information_schema USER_STATISTICS COMMIT_TRANSACTIONS 16 0 NO int NULL NULL 10 0 NULL NULL int(21) select
246++NULL information_schema USER_STATISTICS CONCURRENT_CONNECTIONS 3 0 NO int NULL NULL 10 0 NULL NULL int(21) select
247++NULL information_schema USER_STATISTICS CONNECTED_TIME 4 0 NO int NULL NULL 10 0 NULL NULL int(21) select
248++NULL information_schema USER_STATISTICS CPU_TIME 6 0 NO int NULL NULL 10 0 NULL NULL int(21) select
249++NULL information_schema USER_STATISTICS DENIED_CONNECTIONS 18 0 NO int NULL NULL 10 0 NULL NULL int(21) select
250++NULL information_schema USER_STATISTICS EMPTY_QUERIES 21 0 NO int NULL NULL 10 0 NULL NULL int(21) select
251++NULL information_schema USER_STATISTICS LOST_CONNECTIONS 19 0 NO int NULL NULL 10 0 NULL NULL int(21) select
252++NULL information_schema USER_STATISTICS OTHER_COMMANDS 15 0 NO int NULL NULL 10 0 NULL NULL int(21) select
253++NULL information_schema USER_STATISTICS ROLLBACK_TRANSACTIONS 17 0 NO int NULL NULL 10 0 NULL NULL int(21) select
254++NULL information_schema USER_STATISTICS ROWS_FETCHED 10 0 NO int NULL NULL 10 0 NULL NULL int(21) select
255++NULL information_schema USER_STATISTICS ROWS_UPDATED 11 0 NO int NULL NULL 10 0 NULL NULL int(21) select
256++NULL information_schema USER_STATISTICS SELECT_COMMANDS 13 0 NO int NULL NULL 10 0 NULL NULL int(21) select
257++NULL information_schema USER_STATISTICS TABLE_ROWS_READ 12 0 NO int NULL NULL 10 0 NULL NULL int(21) select
258++NULL information_schema USER_STATISTICS TOTAL_CONNECTIONS 2 0 NO int NULL NULL 10 0 NULL NULL int(21) select
259++NULL information_schema USER_STATISTICS UPDATE_COMMANDS 14 0 NO int NULL NULL 10 0 NULL NULL int(21) select
260++NULL information_schema USER_STATISTICS USER 1 NO varchar 48 144 NULL NULL utf8 utf8_general_ci varchar(48) select
261+ NULL information_schema VIEWS CHARACTER_SET_CLIENT 9 NO varchar 32 96 NULL NULL utf8 utf8_general_ci varchar(32) select
262+ NULL information_schema VIEWS CHECK_OPTION 5 NO varchar 8 24 NULL NULL utf8 utf8_general_ci varchar(8) select
263+ NULL information_schema VIEWS COLLATION_CONNECTION 10 NO varchar 32 96 NULL NULL utf8 utf8_general_ci varchar(32) select
264+@@ -300,6 +507,11 @@
265+ NULL information_schema VIEWS TABLE_NAME 3 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
266+ NULL information_schema VIEWS TABLE_SCHEMA 2 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) select
267+ NULL information_schema VIEWS VIEW_DEFINITION 4 NULL NO longtext 4294967295 4294967295 NULL NULL utf8 utf8_general_ci longtext select
268++NULL information_schema XTRADB_ADMIN_COMMAND result_message 1 NO varchar 1024 3072 NULL NULL utf8 utf8_general_ci varchar(1024) select
269++NULL information_schema XTRADB_ENHANCEMENTS comment 3 NO varchar 100 300 NULL NULL utf8 utf8_general_ci varchar(100) select
270++NULL information_schema XTRADB_ENHANCEMENTS description 2 NO varchar 255 765 NULL NULL utf8 utf8_general_ci varchar(255) select
271++NULL information_schema XTRADB_ENHANCEMENTS link 4 NO varchar 255 765 NULL NULL utf8 utf8_general_ci varchar(255) select
272++NULL information_schema XTRADB_ENHANCEMENTS name 1 NO varchar 255 765 NULL NULL utf8 utf8_general_ci varchar(255) select
273+ ##########################################################################
274+ # Show the quotient of CHARACTER_OCTET_LENGTH and CHARACTER_MAXIMUM_LENGTH
275+ ##########################################################################
276+@@ -362,6 +574,27 @@
277+ 3.0000 information_schema CHARACTER_SETS DEFAULT_COLLATE_NAME varchar 32 96 utf8 utf8_general_ci varchar(32)
278+ 3.0000 information_schema CHARACTER_SETS DESCRIPTION varchar 60 180 utf8 utf8_general_ci varchar(60)
279+ NULL information_schema CHARACTER_SETS MAXLEN bigint NULL NULL NULL NULL bigint(3)
280++3.0000 information_schema CLIENT_STATISTICS CLIENT varchar 64 192 utf8 utf8_general_ci varchar(64)
281++NULL information_schema CLIENT_STATISTICS TOTAL_CONNECTIONS int NULL NULL NULL NULL int(21)
282++NULL information_schema CLIENT_STATISTICS CONCURRENT_CONNECTIONS int NULL NULL NULL NULL int(21)
283++NULL information_schema CLIENT_STATISTICS CONNECTED_TIME int NULL NULL NULL NULL int(21)
284++NULL information_schema CLIENT_STATISTICS BUSY_TIME int NULL NULL NULL NULL int(21)
285++NULL information_schema CLIENT_STATISTICS CPU_TIME int NULL NULL NULL NULL int(21)
286++NULL information_schema CLIENT_STATISTICS BYTES_RECEIVED int NULL NULL NULL NULL int(21)
287++NULL information_schema CLIENT_STATISTICS BYTES_SENT int NULL NULL NULL NULL int(21)
288++NULL information_schema CLIENT_STATISTICS BINLOG_BYTES_WRITTEN int NULL NULL NULL NULL int(21)
289++NULL information_schema CLIENT_STATISTICS ROWS_FETCHED int NULL NULL NULL NULL int(21)
290++NULL information_schema CLIENT_STATISTICS ROWS_UPDATED int NULL NULL NULL NULL int(21)
291++NULL information_schema CLIENT_STATISTICS TABLE_ROWS_READ int NULL NULL NULL NULL int(21)
292++NULL information_schema CLIENT_STATISTICS SELECT_COMMANDS int NULL NULL NULL NULL int(21)
293++NULL information_schema CLIENT_STATISTICS UPDATE_COMMANDS int NULL NULL NULL NULL int(21)
294++NULL information_schema CLIENT_STATISTICS OTHER_COMMANDS int NULL NULL NULL NULL int(21)
295++NULL information_schema CLIENT_STATISTICS COMMIT_TRANSACTIONS int NULL NULL NULL NULL int(21)
296++NULL information_schema CLIENT_STATISTICS ROLLBACK_TRANSACTIONS int NULL NULL NULL NULL int(21)
297++NULL information_schema CLIENT_STATISTICS DENIED_CONNECTIONS int NULL NULL NULL NULL int(21)
298++NULL information_schema CLIENT_STATISTICS LOST_CONNECTIONS int NULL NULL NULL NULL int(21)
299++NULL information_schema CLIENT_STATISTICS ACCESS_DENIED int NULL NULL NULL NULL int(21)
300++NULL information_schema CLIENT_STATISTICS EMPTY_QUERIES int NULL NULL NULL NULL int(21)
301+ 3.0000 information_schema COLLATIONS COLLATION_NAME varchar 32 96 utf8 utf8_general_ci varchar(32)
302+ 3.0000 information_schema COLLATIONS CHARACTER_SET_NAME varchar 32 96 utf8 utf8_general_ci varchar(32)
303+ NULL information_schema COLLATIONS ID bigint NULL NULL NULL NULL bigint(11)
304+@@ -466,8 +699,132 @@
305+ 3.0000 information_schema FILES EXTRA varchar 255 765 utf8 utf8_general_ci varchar(255)
306+ 3.0000 information_schema GLOBAL_STATUS VARIABLE_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)
307+ 3.0000 information_schema GLOBAL_STATUS VARIABLE_VALUE varchar 1024 3072 utf8 utf8_general_ci varchar(1024)
308++NULL information_schema GLOBAL_TEMPORARY_TABLES SESSION_ID bigint NULL NULL NULL NULL bigint(4)
309++3.0000 information_schema GLOBAL_TEMPORARY_TABLES TABLE_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64)
310++3.0000 information_schema GLOBAL_TEMPORARY_TABLES TABLE_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)
311++3.0000 information_schema GLOBAL_TEMPORARY_TABLES ENGINE varchar 64 192 utf8 utf8_general_ci varchar(64)
312++3.0000 information_schema GLOBAL_TEMPORARY_TABLES NAME varchar 512 1536 utf8 utf8_general_ci varchar(512)
313++NULL information_schema GLOBAL_TEMPORARY_TABLES TABLE_ROWS bigint NULL NULL NULL NULL bigint(21) unsigned
314++NULL information_schema GLOBAL_TEMPORARY_TABLES AVG_ROW_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
315++NULL information_schema GLOBAL_TEMPORARY_TABLES DATA_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
316++NULL information_schema GLOBAL_TEMPORARY_TABLES INDEX_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
317++NULL information_schema GLOBAL_TEMPORARY_TABLES CREATE_TIME datetime NULL NULL NULL NULL datetime
318++NULL information_schema GLOBAL_TEMPORARY_TABLES UPDATE_TIME datetime NULL NULL NULL NULL datetime
319+ 3.0000 information_schema GLOBAL_VARIABLES VARIABLE_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)
320+ 3.0000 information_schema GLOBAL_VARIABLES VARIABLE_VALUE varchar 1024 3072 utf8 utf8_general_ci varchar(1024)
321++3.0000 information_schema INDEX_STATISTICS TABLE_SCHEMA varchar 192 576 utf8 utf8_general_ci varchar(192)
322++3.0000 information_schema INDEX_STATISTICS TABLE_NAME varchar 192 576 utf8 utf8_general_ci varchar(192)
323++3.0000 information_schema INDEX_STATISTICS INDEX_NAME varchar 192 576 utf8 utf8_general_ci varchar(192)
324++NULL information_schema INDEX_STATISTICS ROWS_READ int NULL NULL NULL NULL int(21)
325++3.0000 information_schema INNODB_BUFFER_POOL_PAGES page_type varchar 64 192 utf8 utf8_general_ci varchar(64)
326++NULL information_schema INNODB_BUFFER_POOL_PAGES space_id bigint NULL NULL NULL NULL bigint(21) unsigned
327++NULL information_schema INNODB_BUFFER_POOL_PAGES page_no bigint NULL NULL NULL NULL bigint(21) unsigned
328++NULL information_schema INNODB_BUFFER_POOL_PAGES lru_position bigint NULL NULL NULL NULL bigint(21) unsigned
329++NULL information_schema INNODB_BUFFER_POOL_PAGES fix_count bigint NULL NULL NULL NULL bigint(21) unsigned
330++NULL information_schema INNODB_BUFFER_POOL_PAGES flush_type bigint NULL NULL NULL NULL bigint(21) unsigned
331++NULL information_schema INNODB_BUFFER_POOL_PAGES_BLOB space_id bigint NULL NULL NULL NULL bigint(21) unsigned
332++NULL information_schema INNODB_BUFFER_POOL_PAGES_BLOB page_no bigint NULL NULL NULL NULL bigint(21) unsigned
333++NULL information_schema INNODB_BUFFER_POOL_PAGES_BLOB compressed bigint NULL NULL NULL NULL bigint(21) unsigned
334++NULL information_schema INNODB_BUFFER_POOL_PAGES_BLOB part_len bigint NULL NULL NULL NULL bigint(21) unsigned
335++NULL information_schema INNODB_BUFFER_POOL_PAGES_BLOB next_page_no bigint NULL NULL NULL NULL bigint(21) unsigned
336++NULL information_schema INNODB_BUFFER_POOL_PAGES_BLOB lru_position bigint NULL NULL NULL NULL bigint(21) unsigned
337++NULL information_schema INNODB_BUFFER_POOL_PAGES_BLOB fix_count bigint NULL NULL NULL NULL bigint(21) unsigned
338++NULL information_schema INNODB_BUFFER_POOL_PAGES_BLOB flush_type bigint NULL NULL NULL NULL bigint(21) unsigned
339++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX index_id bigint NULL NULL NULL NULL bigint(21) unsigned
340++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX space_id bigint NULL NULL NULL NULL bigint(21) unsigned
341++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX page_no bigint NULL NULL NULL NULL bigint(21) unsigned
342++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX n_recs bigint NULL NULL NULL NULL bigint(21) unsigned
343++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX data_size bigint NULL NULL NULL NULL bigint(21) unsigned
344++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX hashed bigint NULL NULL NULL NULL bigint(21) unsigned
345++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX access_time bigint NULL NULL NULL NULL bigint(21) unsigned
346++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX modified bigint NULL NULL NULL NULL bigint(21) unsigned
347++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX dirty bigint NULL NULL NULL NULL bigint(21) unsigned
348++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX old bigint NULL NULL NULL NULL bigint(21) unsigned
349++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX lru_position bigint NULL NULL NULL NULL bigint(21) unsigned
350++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX fix_count bigint NULL NULL NULL NULL bigint(21) unsigned
351++NULL information_schema INNODB_BUFFER_POOL_PAGES_INDEX flush_type bigint NULL NULL NULL NULL bigint(21) unsigned
352++NULL information_schema INNODB_CMP page_size int NULL NULL NULL NULL int(5)
353++NULL information_schema INNODB_CMP compress_ops int NULL NULL NULL NULL int(11)
354++NULL information_schema INNODB_CMP compress_ops_ok int NULL NULL NULL NULL int(11)
355++NULL information_schema INNODB_CMP compress_time int NULL NULL NULL NULL int(11)
356++NULL information_schema INNODB_CMP uncompress_ops int NULL NULL NULL NULL int(11)
357++NULL information_schema INNODB_CMP uncompress_time int NULL NULL NULL NULL int(11)
358++NULL information_schema INNODB_CMPMEM page_size int NULL NULL NULL NULL int(5)
359++NULL information_schema INNODB_CMPMEM pages_used int NULL NULL NULL NULL int(11)
360++NULL information_schema INNODB_CMPMEM pages_free int NULL NULL NULL NULL int(11)
361++NULL information_schema INNODB_CMPMEM relocation_ops bigint NULL NULL NULL NULL bigint(21)
362++NULL information_schema INNODB_CMPMEM relocation_time int NULL NULL NULL NULL int(11)
363++NULL information_schema INNODB_CMPMEM_RESET page_size int NULL NULL NULL NULL int(5)
364++NULL information_schema INNODB_CMPMEM_RESET pages_used int NULL NULL NULL NULL int(11)
365++NULL information_schema INNODB_CMPMEM_RESET pages_free int NULL NULL NULL NULL int(11)
366++NULL information_schema INNODB_CMPMEM_RESET relocation_ops bigint NULL NULL NULL NULL bigint(21)
367++NULL information_schema INNODB_CMPMEM_RESET relocation_time int NULL NULL NULL NULL int(11)
368++NULL information_schema INNODB_CMP_RESET page_size int NULL NULL NULL NULL int(5)
369++NULL information_schema INNODB_CMP_RESET compress_ops int NULL NULL NULL NULL int(11)
370++NULL information_schema INNODB_CMP_RESET compress_ops_ok int NULL NULL NULL NULL int(11)
371++NULL information_schema INNODB_CMP_RESET compress_time int NULL NULL NULL NULL int(11)
372++NULL information_schema INNODB_CMP_RESET uncompress_ops int NULL NULL NULL NULL int(11)
373++NULL information_schema INNODB_CMP_RESET uncompress_time int NULL NULL NULL NULL int(11)
374++3.0000 information_schema INNODB_INDEX_STATS table_schema varchar 192 576 utf8 utf8_general_ci varchar(192)
375++3.0000 information_schema INNODB_INDEX_STATS table_name varchar 192 576 utf8 utf8_general_ci varchar(192)
376++3.0000 information_schema INNODB_INDEX_STATS index_name varchar 192 576 utf8 utf8_general_ci varchar(192)
377++NULL information_schema INNODB_INDEX_STATS fields bigint NULL NULL NULL NULL bigint(21) unsigned
378++3.0000 information_schema INNODB_INDEX_STATS row_per_keys varchar 256 768 utf8 utf8_general_ci varchar(256)
379++NULL information_schema INNODB_INDEX_STATS index_size bigint NULL NULL NULL NULL bigint(21) unsigned
380++NULL information_schema INNODB_INDEX_STATS leaf_pages bigint NULL NULL NULL NULL bigint(21) unsigned
381++3.0000 information_schema INNODB_LOCKS lock_id varchar 81 243 utf8 utf8_general_ci varchar(81)
382++3.0000 information_schema INNODB_LOCKS lock_trx_id varchar 18 54 utf8 utf8_general_ci varchar(18)
383++3.0000 information_schema INNODB_LOCKS lock_mode varchar 32 96 utf8 utf8_general_ci varchar(32)
384++3.0000 information_schema INNODB_LOCKS lock_type varchar 32 96 utf8 utf8_general_ci varchar(32)
385++3.0000 information_schema INNODB_LOCKS lock_table varchar 1024 3072 utf8 utf8_general_ci varchar(1024)
386++3.0000 information_schema INNODB_LOCKS lock_index varchar 1024 3072 utf8 utf8_general_ci varchar(1024)
387++NULL information_schema INNODB_LOCKS lock_space bigint NULL NULL NULL NULL bigint(21) unsigned
388++NULL information_schema INNODB_LOCKS lock_page bigint NULL NULL NULL NULL bigint(21) unsigned
389++NULL information_schema INNODB_LOCKS lock_rec bigint NULL NULL NULL NULL bigint(21) unsigned
390++3.0000 information_schema INNODB_LOCKS lock_data varchar 8192 24576 utf8 utf8_general_ci varchar(8192)
391++3.0000 information_schema INNODB_LOCK_WAITS requesting_trx_id varchar 18 54 utf8 utf8_general_ci varchar(18)
392++3.0000 information_schema INNODB_LOCK_WAITS requested_lock_id varchar 81 243 utf8 utf8_general_ci varchar(81)
393++3.0000 information_schema INNODB_LOCK_WAITS blocking_trx_id varchar 18 54 utf8 utf8_general_ci varchar(18)
394++3.0000 information_schema INNODB_LOCK_WAITS blocking_lock_id varchar 81 243 utf8 utf8_general_ci varchar(81)
395++NULL information_schema INNODB_RSEG rseg_id bigint NULL NULL NULL NULL bigint(21) unsigned
396++NULL information_schema INNODB_RSEG space_id bigint NULL NULL NULL NULL bigint(21) unsigned
397++NULL information_schema INNODB_RSEG zip_size bigint NULL NULL NULL NULL bigint(21) unsigned
398++NULL information_schema INNODB_RSEG page_no bigint NULL NULL NULL NULL bigint(21) unsigned
399++NULL information_schema INNODB_RSEG max_size bigint NULL NULL NULL NULL bigint(21) unsigned
400++NULL information_schema INNODB_RSEG curr_size bigint NULL NULL NULL NULL bigint(21) unsigned
401++NULL information_schema INNODB_SYS_INDEXES TABLE_ID bigint NULL NULL NULL NULL bigint(21) unsigned
402++NULL information_schema INNODB_SYS_INDEXES ID bigint NULL NULL NULL NULL bigint(21) unsigned
403++3.0000 information_schema INNODB_SYS_INDEXES NAME varchar 192 576 utf8 utf8_general_ci varchar(192)
404++NULL information_schema INNODB_SYS_INDEXES N_FIELDS bigint NULL NULL NULL NULL bigint(21) unsigned
405++NULL information_schema INNODB_SYS_INDEXES TYPE bigint NULL NULL NULL NULL bigint(21) unsigned
406++NULL information_schema INNODB_SYS_INDEXES SPACE bigint NULL NULL NULL NULL bigint(21) unsigned
407++NULL information_schema INNODB_SYS_INDEXES PAGE_NO bigint NULL NULL NULL NULL bigint(21) unsigned
408++NULL information_schema INNODB_SYS_STATS INDEX_ID bigint NULL NULL NULL NULL bigint(21) unsigned
409++NULL information_schema INNODB_SYS_STATS KEY_COLS bigint NULL NULL NULL NULL bigint(21) unsigned
410++NULL information_schema INNODB_SYS_STATS DIFF_VALS bigint NULL NULL NULL NULL bigint(21) unsigned
411++3.0000 information_schema INNODB_SYS_TABLES SCHEMA varchar 192 576 utf8 utf8_general_ci varchar(192)
412++3.0000 information_schema INNODB_SYS_TABLES NAME varchar 192 576 utf8 utf8_general_ci varchar(192)
413++NULL information_schema INNODB_SYS_TABLES ID bigint NULL NULL NULL NULL bigint(21) unsigned
414++NULL information_schema INNODB_SYS_TABLES N_COLS bigint NULL NULL NULL NULL bigint(21) unsigned
415++NULL information_schema INNODB_SYS_TABLES TYPE bigint NULL NULL NULL NULL bigint(21) unsigned
416++NULL information_schema INNODB_SYS_TABLES MIX_ID bigint NULL NULL NULL NULL bigint(21) unsigned
417++NULL information_schema INNODB_SYS_TABLES MIX_LEN bigint NULL NULL NULL NULL bigint(21) unsigned
418++3.0000 information_schema INNODB_SYS_TABLES CLUSTER_NAME varchar 192 576 utf8 utf8_general_ci varchar(192)
419++NULL information_schema INNODB_SYS_TABLES SPACE bigint NULL NULL NULL NULL bigint(21) unsigned
420++3.0000 information_schema INNODB_TABLE_STATS table_schema varchar 192 576 utf8 utf8_general_ci varchar(192)
421++3.0000 information_schema INNODB_TABLE_STATS table_name varchar 192 576 utf8 utf8_general_ci varchar(192)
422++NULL information_schema INNODB_TABLE_STATS rows bigint NULL NULL NULL NULL bigint(21) unsigned
423++NULL information_schema INNODB_TABLE_STATS clust_size bigint NULL NULL NULL NULL bigint(21) unsigned
424++NULL information_schema INNODB_TABLE_STATS other_size bigint NULL NULL NULL NULL bigint(21) unsigned
425++NULL information_schema INNODB_TABLE_STATS modified bigint NULL NULL NULL NULL bigint(21) unsigned
426++3.0000 information_schema INNODB_TRX trx_id varchar 18 54 utf8 utf8_general_ci varchar(18)
427++3.0000 information_schema INNODB_TRX trx_state varchar 13 39 utf8 utf8_general_ci varchar(13)
428++NULL information_schema INNODB_TRX trx_started datetime NULL NULL NULL NULL datetime
429++3.0000 information_schema INNODB_TRX trx_requested_lock_id varchar 81 243 utf8 utf8_general_ci varchar(81)
430++NULL information_schema INNODB_TRX trx_wait_started datetime NULL NULL NULL NULL datetime
431++NULL information_schema INNODB_TRX trx_weight bigint NULL NULL NULL NULL bigint(21) unsigned
432++NULL information_schema INNODB_TRX trx_mysql_thread_id bigint NULL NULL NULL NULL bigint(21) unsigned
433++3.0000 information_schema INNODB_TRX trx_query varchar 1024 3072 utf8 utf8_general_ci varchar(1024)
434+ 3.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512)
435+ 3.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64)
436+ 3.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)
437+@@ -523,6 +880,10 @@
438+ NULL information_schema PROCESSLIST TIME int NULL NULL NULL NULL int(7)
439+ 3.0000 information_schema PROCESSLIST STATE varchar 64 192 utf8 utf8_general_ci varchar(64)
440+ 1.0000 information_schema PROCESSLIST INFO longtext 4294967295 4294967295 utf8 utf8_general_ci longtext
441++NULL information_schema PROCESSLIST TIME_MS bigint NULL NULL NULL NULL bigint(21)
442++3.0000 information_schema QUERY_RESPONSE_TIME time varchar 14 42 utf8 utf8_general_ci varchar(14)
443++NULL information_schema QUERY_RESPONSE_TIME count int NULL NULL NULL NULL int(11) unsigned
444++3.0000 information_schema QUERY_RESPONSE_TIME total varchar 14 42 utf8 utf8_general_ci varchar(14)
445+ 3.0000 information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512)
446+ 3.0000 information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64)
447+ 3.0000 information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)
448+@@ -619,6 +980,43 @@
449+ 3.0000 information_schema TABLE_PRIVILEGES TABLE_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)
450+ 3.0000 information_schema TABLE_PRIVILEGES PRIVILEGE_TYPE varchar 64 192 utf8 utf8_general_ci varchar(64)
451+ 3.0000 information_schema TABLE_PRIVILEGES IS_GRANTABLE varchar 3 9 utf8 utf8_general_ci varchar(3)
452++3.0000 information_schema TABLE_STATISTICS TABLE_SCHEMA varchar 192 576 utf8 utf8_general_ci varchar(192)
453++3.0000 information_schema TABLE_STATISTICS TABLE_NAME varchar 192 576 utf8 utf8_general_ci varchar(192)
454++NULL information_schema TABLE_STATISTICS ROWS_READ int NULL NULL NULL NULL int(21)
455++NULL information_schema TABLE_STATISTICS ROWS_CHANGED int NULL NULL NULL NULL int(21)
456++NULL information_schema TABLE_STATISTICS ROWS_CHANGED_X_INDEXES int NULL NULL NULL NULL int(21)
457++NULL information_schema TEMPORARY_TABLES SESSION_ID bigint NULL NULL NULL NULL bigint(4)
458++3.0000 information_schema TEMPORARY_TABLES TABLE_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64)
459++3.0000 information_schema TEMPORARY_TABLES TABLE_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)
460++3.0000 information_schema TEMPORARY_TABLES ENGINE varchar 64 192 utf8 utf8_general_ci varchar(64)
461++3.0000 information_schema TEMPORARY_TABLES NAME varchar 512 1536 utf8 utf8_general_ci varchar(512)
462++NULL information_schema TEMPORARY_TABLES TABLE_ROWS bigint NULL NULL NULL NULL bigint(21) unsigned
463++NULL information_schema TEMPORARY_TABLES AVG_ROW_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
464++NULL information_schema TEMPORARY_TABLES DATA_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
465++NULL information_schema TEMPORARY_TABLES INDEX_LENGTH bigint NULL NULL NULL NULL bigint(21) unsigned
466++NULL information_schema TEMPORARY_TABLES CREATE_TIME datetime NULL NULL NULL NULL datetime
467++NULL information_schema TEMPORARY_TABLES UPDATE_TIME datetime NULL NULL NULL NULL datetime
468++NULL information_schema THREAD_STATISTICS THREAD_ID int NULL NULL NULL NULL int(21)
469++NULL information_schema THREAD_STATISTICS TOTAL_CONNECTIONS int NULL NULL NULL NULL int(21)
470++NULL information_schema THREAD_STATISTICS CONCURRENT_CONNECTIONS int NULL NULL NULL NULL int(21)
471++NULL information_schema THREAD_STATISTICS CONNECTED_TIME int NULL NULL NULL NULL int(21)
472++NULL information_schema THREAD_STATISTICS BUSY_TIME int NULL NULL NULL NULL int(21)
473++NULL information_schema THREAD_STATISTICS CPU_TIME int NULL NULL NULL NULL int(21)
474++NULL information_schema THREAD_STATISTICS BYTES_RECEIVED int NULL NULL NULL NULL int(21)
475++NULL information_schema THREAD_STATISTICS BYTES_SENT int NULL NULL NULL NULL int(21)
476++NULL information_schema THREAD_STATISTICS BINLOG_BYTES_WRITTEN int NULL NULL NULL NULL int(21)
477++NULL information_schema THREAD_STATISTICS ROWS_FETCHED int NULL NULL NULL NULL int(21)
478++NULL information_schema THREAD_STATISTICS ROWS_UPDATED int NULL NULL NULL NULL int(21)
479++NULL information_schema THREAD_STATISTICS TABLE_ROWS_READ int NULL NULL NULL NULL int(21)
480++NULL information_schema THREAD_STATISTICS SELECT_COMMANDS int NULL NULL NULL NULL int(21)
481++NULL information_schema THREAD_STATISTICS UPDATE_COMMANDS int NULL NULL NULL NULL int(21)
482++NULL information_schema THREAD_STATISTICS OTHER_COMMANDS int NULL NULL NULL NULL int(21)
483++NULL information_schema THREAD_STATISTICS COMMIT_TRANSACTIONS int NULL NULL NULL NULL int(21)
484++NULL information_schema THREAD_STATISTICS ROLLBACK_TRANSACTIONS int NULL NULL NULL NULL int(21)
485++NULL information_schema THREAD_STATISTICS DENIED_CONNECTIONS int NULL NULL NULL NULL int(21)
486++NULL information_schema THREAD_STATISTICS LOST_CONNECTIONS int NULL NULL NULL NULL int(21)
487++NULL information_schema THREAD_STATISTICS ACCESS_DENIED int NULL NULL NULL NULL int(21)
488++NULL information_schema THREAD_STATISTICS EMPTY_QUERIES int NULL NULL NULL NULL int(21)
489+ 3.0000 information_schema TRIGGERS TRIGGER_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512)
490+ 3.0000 information_schema TRIGGERS TRIGGER_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64)
491+ 3.0000 information_schema TRIGGERS TRIGGER_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)
492+@@ -645,6 +1043,27 @@
493+ 3.0000 information_schema USER_PRIVILEGES TABLE_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512)
494+ 3.0000 information_schema USER_PRIVILEGES PRIVILEGE_TYPE varchar 64 192 utf8 utf8_general_ci varchar(64)
495+ 3.0000 information_schema USER_PRIVILEGES IS_GRANTABLE varchar 3 9 utf8 utf8_general_ci varchar(3)
496++3.0000 information_schema USER_STATISTICS USER varchar 48 144 utf8 utf8_general_ci varchar(48)
497++NULL information_schema USER_STATISTICS TOTAL_CONNECTIONS int NULL NULL NULL NULL int(21)
498++NULL information_schema USER_STATISTICS CONCURRENT_CONNECTIONS int NULL NULL NULL NULL int(21)
499++NULL information_schema USER_STATISTICS CONNECTED_TIME int NULL NULL NULL NULL int(21)
500++NULL information_schema USER_STATISTICS BUSY_TIME int NULL NULL NULL NULL int(21)
501++NULL information_schema USER_STATISTICS CPU_TIME int NULL NULL NULL NULL int(21)
502++NULL information_schema USER_STATISTICS BYTES_RECEIVED int NULL NULL NULL NULL int(21)
503++NULL information_schema USER_STATISTICS BYTES_SENT int NULL NULL NULL NULL int(21)
504++NULL information_schema USER_STATISTICS BINLOG_BYTES_WRITTEN int NULL NULL NULL NULL int(21)
505++NULL information_schema USER_STATISTICS ROWS_FETCHED int NULL NULL NULL NULL int(21)
506++NULL information_schema USER_STATISTICS ROWS_UPDATED int NULL NULL NULL NULL int(21)
507++NULL information_schema USER_STATISTICS TABLE_ROWS_READ int NULL NULL NULL NULL int(21)
508++NULL information_schema USER_STATISTICS SELECT_COMMANDS int NULL NULL NULL NULL int(21)
509++NULL information_schema USER_STATISTICS UPDATE_COMMANDS int NULL NULL NULL NULL int(21)
510++NULL information_schema USER_STATISTICS OTHER_COMMANDS int NULL NULL NULL NULL int(21)
511++NULL information_schema USER_STATISTICS COMMIT_TRANSACTIONS int NULL NULL NULL NULL int(21)
512++NULL information_schema USER_STATISTICS ROLLBACK_TRANSACTIONS int NULL NULL NULL NULL int(21)
513++NULL information_schema USER_STATISTICS DENIED_CONNECTIONS int NULL NULL NULL NULL int(21)
514++NULL information_schema USER_STATISTICS LOST_CONNECTIONS int NULL NULL NULL NULL int(21)
515++NULL information_schema USER_STATISTICS ACCESS_DENIED int NULL NULL NULL NULL int(21)
516++NULL information_schema USER_STATISTICS EMPTY_QUERIES int NULL NULL NULL NULL int(21)
517+ 3.0000 information_schema VIEWS TABLE_CATALOG varchar 512 1536 utf8 utf8_general_ci varchar(512)
518+ 3.0000 information_schema VIEWS TABLE_SCHEMA varchar 64 192 utf8 utf8_general_ci varchar(64)
519+ 3.0000 information_schema VIEWS TABLE_NAME varchar 64 192 utf8 utf8_general_ci varchar(64)
520+@@ -655,3 +1074,8 @@
521+ 3.0000 information_schema VIEWS SECURITY_TYPE varchar 7 21 utf8 utf8_general_ci varchar(7)
522+ 3.0000 information_schema VIEWS CHARACTER_SET_CLIENT varchar 32 96 utf8 utf8_general_ci varchar(32)
523+ 3.0000 information_schema VIEWS COLLATION_CONNECTION varchar 32 96 utf8 utf8_general_ci varchar(32)
524++3.0000 information_schema XTRADB_ADMIN_COMMAND result_message varchar 1024 3072 utf8 utf8_general_ci varchar(1024)
525++3.0000 information_schema XTRADB_ENHANCEMENTS name varchar 255 765 utf8 utf8_general_ci varchar(255)
526++3.0000 information_schema XTRADB_ENHANCEMENTS description varchar 255 765 utf8 utf8_general_ci varchar(255)
527++3.0000 information_schema XTRADB_ENHANCEMENTS comment varchar 100 300 utf8 utf8_general_ci varchar(100)
528++3.0000 information_schema XTRADB_ENHANCEMENTS link varchar 255 765 utf8 utf8_general_ci varchar(255)
529+diff -Nur a/mysql-test/suite/funcs_1/r/is_engines_innodb.result b/mysql-test/suite/funcs_1/r/is_engines_innodb.result
530+--- a/mysql-test/suite/funcs_1/r/is_engines_innodb.result 2010-12-23 10:16:32.000000000 -0500
531++++ b/mysql-test/suite/funcs_1/r/is_engines_innodb.result 2010-12-23 15:29:55.000000000 -0500
532+@@ -2,7 +2,7 @@
533+ WHERE ENGINE = 'InnoDB';
534+ ENGINE InnoDB
535+ SUPPORT YES
536+-COMMENT Supports transactions, row-level locking, and foreign keys
537++COMMENT Percona-XtraDB, Supports transactions, row-level locking, and foreign keys
538+ TRANSACTIONS YES
539+ XA YES
540+ SAVEPOINTS YES
541+diff -Nur a/mysql-test/suite/funcs_1/r/is_tables_is.result b/mysql-test/suite/funcs_1/r/is_tables_is.result
542+--- a/mysql-test/suite/funcs_1/r/is_tables_is.result 2010-12-23 10:16:32.000000000 -0500
543++++ b/mysql-test/suite/funcs_1/r/is_tables_is.result 2010-12-23 10:17:32.000000000 -0500
544+@@ -38,6 +38,29 @@
545+ Separator -----------------------------------------------------
546+ TABLE_CATALOG NULL
547+ TABLE_SCHEMA information_schema
548++TABLE_NAME CLIENT_STATISTICS
549++TABLE_TYPE SYSTEM VIEW
550++ENGINE MEMORY
551++VERSION 10
552++ROW_FORMAT Fixed
553++TABLE_ROWS #TBLR#
554++AVG_ROW_LENGTH #ARL#
555++DATA_LENGTH #DL#
556++MAX_DATA_LENGTH #MDL#
557++INDEX_LENGTH #IL#
558++DATA_FREE #DF#
559++AUTO_INCREMENT NULL
560++CREATE_TIME #CRT#
561++UPDATE_TIME #UT#
562++CHECK_TIME #CT#
563++TABLE_COLLATION utf8_general_ci
564++CHECKSUM NULL
565++CREATE_OPTIONS #CO#
566++TABLE_COMMENT #TC#
567++user_comment
568++Separator -----------------------------------------------------
569++TABLE_CATALOG NULL
570++TABLE_SCHEMA information_schema
571+ TABLE_NAME COLLATIONS
572+ TABLE_TYPE SYSTEM VIEW
573+ ENGINE MEMORY
574+@@ -222,7 +245,7 @@
575+ Separator -----------------------------------------------------
576+ TABLE_CATALOG NULL
577+ TABLE_SCHEMA information_schema
578+-TABLE_NAME GLOBAL_VARIABLES
579++TABLE_NAME GLOBAL_TEMPORARY_TABLES
580+ TABLE_TYPE SYSTEM VIEW
581+ ENGINE MEMORY
582+ VERSION 10
583+@@ -245,7 +268,7 @@
584+ Separator -----------------------------------------------------
585+ TABLE_CATALOG NULL
586+ TABLE_SCHEMA information_schema
587+-TABLE_NAME KEY_COLUMN_USAGE
588++TABLE_NAME GLOBAL_VARIABLES
589+ TABLE_TYPE SYSTEM VIEW
590+ ENGINE MEMORY
591+ VERSION 10
592+@@ -268,11 +291,11 @@
593+ Separator -----------------------------------------------------
594+ TABLE_CATALOG NULL
595+ TABLE_SCHEMA information_schema
596+-TABLE_NAME PARTITIONS
597++TABLE_NAME INDEX_STATISTICS
598+ TABLE_TYPE SYSTEM VIEW
599+-ENGINE MyISAM
600++ENGINE MEMORY
601+ VERSION 10
602+-ROW_FORMAT Dynamic
603++ROW_FORMAT Fixed
604+ TABLE_ROWS #TBLR#
605+ AVG_ROW_LENGTH #ARL#
606+ DATA_LENGTH #DL#
607+@@ -291,11 +314,11 @@
608+ Separator -----------------------------------------------------
609+ TABLE_CATALOG NULL
610+ TABLE_SCHEMA information_schema
611+-TABLE_NAME PLUGINS
612++TABLE_NAME INNODB_BUFFER_POOL_PAGES
613+ TABLE_TYPE SYSTEM VIEW
614+-ENGINE MyISAM
615++ENGINE MEMORY
616+ VERSION 10
617+-ROW_FORMAT Dynamic
618++ROW_FORMAT Fixed
619+ TABLE_ROWS #TBLR#
620+ AVG_ROW_LENGTH #ARL#
621+ DATA_LENGTH #DL#
622+@@ -314,11 +337,11 @@
623+ Separator -----------------------------------------------------
624+ TABLE_CATALOG NULL
625+ TABLE_SCHEMA information_schema
626+-TABLE_NAME PROCESSLIST
627++TABLE_NAME INNODB_BUFFER_POOL_PAGES_BLOB
628+ TABLE_TYPE SYSTEM VIEW
629+-ENGINE MyISAM
630++ENGINE MEMORY
631+ VERSION 10
632+-ROW_FORMAT Dynamic
633++ROW_FORMAT Fixed
634+ TABLE_ROWS #TBLR#
635+ AVG_ROW_LENGTH #ARL#
636+ DATA_LENGTH #DL#
637+@@ -337,7 +360,7 @@
638+ Separator -----------------------------------------------------
639+ TABLE_CATALOG NULL
640+ TABLE_SCHEMA information_schema
641+-TABLE_NAME REFERENTIAL_CONSTRAINTS
642++TABLE_NAME INNODB_BUFFER_POOL_PAGES_INDEX
643+ TABLE_TYPE SYSTEM VIEW
644+ ENGINE MEMORY
645+ VERSION 10
646+@@ -360,11 +383,11 @@
647+ Separator -----------------------------------------------------
648+ TABLE_CATALOG NULL
649+ TABLE_SCHEMA information_schema
650+-TABLE_NAME ROUTINES
651++TABLE_NAME INNODB_CMP
652+ TABLE_TYPE SYSTEM VIEW
653+-ENGINE MyISAM
654++ENGINE MEMORY
655+ VERSION 10
656+-ROW_FORMAT Dynamic
657++ROW_FORMAT Fixed
658+ TABLE_ROWS #TBLR#
659+ AVG_ROW_LENGTH #ARL#
660+ DATA_LENGTH #DL#
661+@@ -383,7 +406,7 @@
662+ Separator -----------------------------------------------------
663+ TABLE_CATALOG NULL
664+ TABLE_SCHEMA information_schema
665+-TABLE_NAME SCHEMATA
666++TABLE_NAME INNODB_CMPMEM
667+ TABLE_TYPE SYSTEM VIEW
668+ ENGINE MEMORY
669+ VERSION 10
670+@@ -406,7 +429,7 @@
671+ Separator -----------------------------------------------------
672+ TABLE_CATALOG NULL
673+ TABLE_SCHEMA information_schema
674+-TABLE_NAME SCHEMA_PRIVILEGES
675++TABLE_NAME INNODB_CMPMEM_RESET
676+ TABLE_TYPE SYSTEM VIEW
677+ ENGINE MEMORY
678+ VERSION 10
679+@@ -429,7 +452,7 @@
680+ Separator -----------------------------------------------------
681+ TABLE_CATALOG NULL
682+ TABLE_SCHEMA information_schema
683+-TABLE_NAME SESSION_STATUS
684++TABLE_NAME INNODB_CMP_RESET
685+ TABLE_TYPE SYSTEM VIEW
686+ ENGINE MEMORY
687+ VERSION 10
688+@@ -452,7 +475,7 @@
689+ Separator -----------------------------------------------------
690+ TABLE_CATALOG NULL
691+ TABLE_SCHEMA information_schema
692+-TABLE_NAME SESSION_VARIABLES
693++TABLE_NAME INNODB_INDEX_STATS
694+ TABLE_TYPE SYSTEM VIEW
695+ ENGINE MEMORY
696+ VERSION 10
697+@@ -475,7 +498,7 @@
698+ Separator -----------------------------------------------------
699+ TABLE_CATALOG NULL
700+ TABLE_SCHEMA information_schema
701+-TABLE_NAME STATISTICS
702++TABLE_NAME INNODB_LOCKS
703+ TABLE_TYPE SYSTEM VIEW
704+ ENGINE MEMORY
705+ VERSION 10
706+@@ -498,7 +521,7 @@
707+ Separator -----------------------------------------------------
708+ TABLE_CATALOG NULL
709+ TABLE_SCHEMA information_schema
710+-TABLE_NAME TABLES
711++TABLE_NAME INNODB_LOCK_WAITS
712+ TABLE_TYPE SYSTEM VIEW
713+ ENGINE MEMORY
714+ VERSION 10
715+@@ -521,7 +544,7 @@
716+ Separator -----------------------------------------------------
717+ TABLE_CATALOG NULL
718+ TABLE_SCHEMA information_schema
719+-TABLE_NAME TABLE_CONSTRAINTS
720++TABLE_NAME INNODB_RSEG
721+ TABLE_TYPE SYSTEM VIEW
722+ ENGINE MEMORY
723+ VERSION 10
724+@@ -544,7 +567,7 @@
725+ Separator -----------------------------------------------------
726+ TABLE_CATALOG NULL
727+ TABLE_SCHEMA information_schema
728+-TABLE_NAME TABLE_PRIVILEGES
729++TABLE_NAME INNODB_SYS_INDEXES
730+ TABLE_TYPE SYSTEM VIEW
731+ ENGINE MEMORY
732+ VERSION 10
733+@@ -567,11 +590,11 @@
734+ Separator -----------------------------------------------------
735+ TABLE_CATALOG NULL
736+ TABLE_SCHEMA information_schema
737+-TABLE_NAME TRIGGERS
738++TABLE_NAME INNODB_SYS_STATS
739+ TABLE_TYPE SYSTEM VIEW
740+-ENGINE MyISAM
741++ENGINE MEMORY
742+ VERSION 10
743+-ROW_FORMAT Dynamic
744++ROW_FORMAT Fixed
745+ TABLE_ROWS #TBLR#
746+ AVG_ROW_LENGTH #ARL#
747+ DATA_LENGTH #DL#
748+@@ -590,7 +613,7 @@
749+ Separator -----------------------------------------------------
750+ TABLE_CATALOG NULL
751+ TABLE_SCHEMA information_schema
752+-TABLE_NAME USER_PRIVILEGES
753++TABLE_NAME INNODB_SYS_TABLES
754+ TABLE_TYPE SYSTEM VIEW
755+ ENGINE MEMORY
756+ VERSION 10
757+@@ -613,11 +636,11 @@
758+ Separator -----------------------------------------------------
759+ TABLE_CATALOG NULL
760+ TABLE_SCHEMA information_schema
761+-TABLE_NAME VIEWS
762++TABLE_NAME INNODB_TABLE_STATS
763+ TABLE_TYPE SYSTEM VIEW
764+-ENGINE MyISAM
765++ENGINE MEMORY
766+ VERSION 10
767+-ROW_FORMAT Dynamic
768++ROW_FORMAT Fixed
769+ TABLE_ROWS #TBLR#
770+ AVG_ROW_LENGTH #ARL#
771+ DATA_LENGTH #DL#
772+@@ -634,26 +657,9 @@
773+ TABLE_COMMENT #TC#
774+ user_comment
775+ Separator -----------------------------------------------------
776+-DROP USER testuser1@localhost;
777+-CREATE USER testuser1@localhost;
778+-GRANT SELECT ON test1.* TO testuser1@localhost;
779+-# Establish connection testuser1 (user=testuser1)
780+-SELECT *,
781+-LEFT( table_comment,
782+-IF(INSTR(table_comment,'InnoDB free') = 0
783+-AND INSTR(table_comment,'number_of_replicas') = 0,
784+-LENGTH(table_comment),
785+-INSTR(table_comment,'InnoDB free')
786+-+ INSTR(table_comment,'number_of_replicas') - 1))
787+-AS "user_comment",
788+-'-----------------------------------------------------' AS "Separator"
789+-FROM information_schema.tables
790+-WHERE table_schema = 'information_schema'
791+-AND table_name <> 'profiling'
792+-ORDER BY table_schema,table_name;
793+ TABLE_CATALOG NULL
794+ TABLE_SCHEMA information_schema
795+-TABLE_NAME CHARACTER_SETS
796++TABLE_NAME INNODB_TRX
797+ TABLE_TYPE SYSTEM VIEW
798+ ENGINE MEMORY
799+ VERSION 10
800+@@ -676,7 +682,7 @@
801+ Separator -----------------------------------------------------
802+ TABLE_CATALOG NULL
803+ TABLE_SCHEMA information_schema
804+-TABLE_NAME COLLATIONS
805++TABLE_NAME KEY_COLUMN_USAGE
806+ TABLE_TYPE SYSTEM VIEW
807+ ENGINE MEMORY
808+ VERSION 10
809+@@ -699,11 +705,11 @@
810+ Separator -----------------------------------------------------
811+ TABLE_CATALOG NULL
812+ TABLE_SCHEMA information_schema
813+-TABLE_NAME COLLATION_CHARACTER_SET_APPLICABILITY
814++TABLE_NAME PARTITIONS
815+ TABLE_TYPE SYSTEM VIEW
816+-ENGINE MEMORY
817++ENGINE MyISAM
818+ VERSION 10
819+-ROW_FORMAT Fixed
820++ROW_FORMAT Dynamic
821+ TABLE_ROWS #TBLR#
822+ AVG_ROW_LENGTH #ARL#
823+ DATA_LENGTH #DL#
824+@@ -722,7 +728,7 @@
825+ Separator -----------------------------------------------------
826+ TABLE_CATALOG NULL
827+ TABLE_SCHEMA information_schema
828+-TABLE_NAME COLUMNS
829++TABLE_NAME PLUGINS
830+ TABLE_TYPE SYSTEM VIEW
831+ ENGINE MyISAM
832+ VERSION 10
833+@@ -745,7 +751,30 @@
834+ Separator -----------------------------------------------------
835+ TABLE_CATALOG NULL
836+ TABLE_SCHEMA information_schema
837+-TABLE_NAME COLUMN_PRIVILEGES
838++TABLE_NAME PROCESSLIST
839++TABLE_TYPE SYSTEM VIEW
840++ENGINE MyISAM
841++VERSION 10
842++ROW_FORMAT Dynamic
843++TABLE_ROWS #TBLR#
844++AVG_ROW_LENGTH #ARL#
845++DATA_LENGTH #DL#
846++MAX_DATA_LENGTH #MDL#
847++INDEX_LENGTH #IL#
848++DATA_FREE #DF#
849++AUTO_INCREMENT NULL
850++CREATE_TIME #CRT#
851++UPDATE_TIME #UT#
852++CHECK_TIME #CT#
853++TABLE_COLLATION utf8_general_ci
854++CHECKSUM NULL
855++CREATE_OPTIONS #CO#
856++TABLE_COMMENT #TC#
857++user_comment
858++Separator -----------------------------------------------------
859++TABLE_CATALOG NULL
860++TABLE_SCHEMA information_schema
861++TABLE_NAME QUERY_RESPONSE_TIME
862+ TABLE_TYPE SYSTEM VIEW
863+ ENGINE MEMORY
864+ VERSION 10
865+@@ -768,7 +797,7 @@
866+ Separator -----------------------------------------------------
867+ TABLE_CATALOG NULL
868+ TABLE_SCHEMA information_schema
869+-TABLE_NAME ENGINES
870++TABLE_NAME REFERENTIAL_CONSTRAINTS
871+ TABLE_TYPE SYSTEM VIEW
872+ ENGINE MEMORY
873+ VERSION 10
874+@@ -791,7 +820,7 @@
875+ Separator -----------------------------------------------------
876+ TABLE_CATALOG NULL
877+ TABLE_SCHEMA information_schema
878+-TABLE_NAME EVENTS
879++TABLE_NAME ROUTINES
880+ TABLE_TYPE SYSTEM VIEW
881+ ENGINE MyISAM
882+ VERSION 10
883+@@ -814,7 +843,7 @@
884+ Separator -----------------------------------------------------
885+ TABLE_CATALOG NULL
886+ TABLE_SCHEMA information_schema
887+-TABLE_NAME FILES
888++TABLE_NAME SCHEMATA
889+ TABLE_TYPE SYSTEM VIEW
890+ ENGINE MEMORY
891+ VERSION 10
892+@@ -837,7 +866,7 @@
893+ Separator -----------------------------------------------------
894+ TABLE_CATALOG NULL
895+ TABLE_SCHEMA information_schema
896+-TABLE_NAME GLOBAL_STATUS
897++TABLE_NAME SCHEMA_PRIVILEGES
898+ TABLE_TYPE SYSTEM VIEW
899+ ENGINE MEMORY
900+ VERSION 10
901+@@ -860,7 +889,7 @@
902+ Separator -----------------------------------------------------
903+ TABLE_CATALOG NULL
904+ TABLE_SCHEMA information_schema
905+-TABLE_NAME GLOBAL_VARIABLES
906++TABLE_NAME SESSION_STATUS
907+ TABLE_TYPE SYSTEM VIEW
908+ ENGINE MEMORY
909+ VERSION 10
910+@@ -883,7 +912,7 @@
911+ Separator -----------------------------------------------------
912+ TABLE_CATALOG NULL
913+ TABLE_SCHEMA information_schema
914+-TABLE_NAME KEY_COLUMN_USAGE
915++TABLE_NAME SESSION_VARIABLES
916+ TABLE_TYPE SYSTEM VIEW
917+ ENGINE MEMORY
918+ VERSION 10
919+@@ -906,11 +935,11 @@
920+ Separator -----------------------------------------------------
921+ TABLE_CATALOG NULL
922+ TABLE_SCHEMA information_schema
923+-TABLE_NAME PARTITIONS
924++TABLE_NAME STATISTICS
925+ TABLE_TYPE SYSTEM VIEW
926+-ENGINE MyISAM
927++ENGINE MEMORY
928+ VERSION 10
929+-ROW_FORMAT Dynamic
930++ROW_FORMAT Fixed
931+ TABLE_ROWS #TBLR#
932+ AVG_ROW_LENGTH #ARL#
933+ DATA_LENGTH #DL#
934+@@ -929,11 +958,11 @@
935+ Separator -----------------------------------------------------
936+ TABLE_CATALOG NULL
937+ TABLE_SCHEMA information_schema
938+-TABLE_NAME PLUGINS
939++TABLE_NAME TABLES
940+ TABLE_TYPE SYSTEM VIEW
941+-ENGINE MyISAM
942++ENGINE MEMORY
943+ VERSION 10
944+-ROW_FORMAT Dynamic
945++ROW_FORMAT Fixed
946+ TABLE_ROWS #TBLR#
947+ AVG_ROW_LENGTH #ARL#
948+ DATA_LENGTH #DL#
949+@@ -952,11 +981,11 @@
950+ Separator -----------------------------------------------------
951+ TABLE_CATALOG NULL
952+ TABLE_SCHEMA information_schema
953+-TABLE_NAME PROCESSLIST
954++TABLE_NAME TABLE_CONSTRAINTS
955+ TABLE_TYPE SYSTEM VIEW
956+-ENGINE MyISAM
957++ENGINE MEMORY
958+ VERSION 10
959+-ROW_FORMAT Dynamic
960++ROW_FORMAT Fixed
961+ TABLE_ROWS #TBLR#
962+ AVG_ROW_LENGTH #ARL#
963+ DATA_LENGTH #DL#
964+@@ -975,7 +1004,7 @@
965+ Separator -----------------------------------------------------
966+ TABLE_CATALOG NULL
967+ TABLE_SCHEMA information_schema
968+-TABLE_NAME REFERENTIAL_CONSTRAINTS
969++TABLE_NAME TABLE_PRIVILEGES
970+ TABLE_TYPE SYSTEM VIEW
971+ ENGINE MEMORY
972+ VERSION 10
973+@@ -998,11 +1027,11 @@
974+ Separator -----------------------------------------------------
975+ TABLE_CATALOG NULL
976+ TABLE_SCHEMA information_schema
977+-TABLE_NAME ROUTINES
978++TABLE_NAME TABLE_STATISTICS
979+ TABLE_TYPE SYSTEM VIEW
980+-ENGINE MyISAM
981++ENGINE MEMORY
982+ VERSION 10
983+-ROW_FORMAT Dynamic
984++ROW_FORMAT Fixed
985+ TABLE_ROWS #TBLR#
986+ AVG_ROW_LENGTH #ARL#
987+ DATA_LENGTH #DL#
988+@@ -1021,7 +1050,7 @@
989+ Separator -----------------------------------------------------
990+ TABLE_CATALOG NULL
991+ TABLE_SCHEMA information_schema
992+-TABLE_NAME SCHEMATA
993++TABLE_NAME TEMPORARY_TABLES
994+ TABLE_TYPE SYSTEM VIEW
995+ ENGINE MEMORY
996+ VERSION 10
997+@@ -1044,7 +1073,7 @@
998+ Separator -----------------------------------------------------
999+ TABLE_CATALOG NULL
1000+ TABLE_SCHEMA information_schema
1001+-TABLE_NAME SCHEMA_PRIVILEGES
1002++TABLE_NAME THREAD_STATISTICS
1003+ TABLE_TYPE SYSTEM VIEW
1004+ ENGINE MEMORY
1005+ VERSION 10
1006+@@ -1067,7 +1096,30 @@
1007+ Separator -----------------------------------------------------
1008+ TABLE_CATALOG NULL
1009+ TABLE_SCHEMA information_schema
1010+-TABLE_NAME SESSION_STATUS
1011++TABLE_NAME TRIGGERS
1012++TABLE_TYPE SYSTEM VIEW
1013++ENGINE MyISAM
1014++VERSION 10
1015++ROW_FORMAT Dynamic
1016++TABLE_ROWS #TBLR#
1017++AVG_ROW_LENGTH #ARL#
1018++DATA_LENGTH #DL#
1019++MAX_DATA_LENGTH #MDL#
1020++INDEX_LENGTH #IL#
1021++DATA_FREE #DF#
1022++AUTO_INCREMENT NULL
1023++CREATE_TIME #CRT#
1024++UPDATE_TIME #UT#
1025++CHECK_TIME #CT#
1026++TABLE_COLLATION utf8_general_ci
1027++CHECKSUM NULL
1028++CREATE_OPTIONS #CO#
1029++TABLE_COMMENT #TC#
1030++user_comment
1031++Separator -----------------------------------------------------
1032++TABLE_CATALOG NULL
1033++TABLE_SCHEMA information_schema
1034++TABLE_NAME USER_PRIVILEGES
1035+ TABLE_TYPE SYSTEM VIEW
1036+ ENGINE MEMORY
1037+ VERSION 10
1038+@@ -1090,7 +1142,7 @@
1039+ Separator -----------------------------------------------------
1040+ TABLE_CATALOG NULL
1041+ TABLE_SCHEMA information_schema
1042+-TABLE_NAME SESSION_VARIABLES
1043++TABLE_NAME USER_STATISTICS
1044+ TABLE_TYPE SYSTEM VIEW
1045+ ENGINE MEMORY
1046+ VERSION 10
1047+@@ -1113,7 +1165,30 @@
1048+ Separator -----------------------------------------------------
1049+ TABLE_CATALOG NULL
1050+ TABLE_SCHEMA information_schema
1051+-TABLE_NAME STATISTICS
1052++TABLE_NAME VIEWS
1053++TABLE_TYPE SYSTEM VIEW
1054++ENGINE MyISAM
1055++VERSION 10
1056++ROW_FORMAT Dynamic
1057++TABLE_ROWS #TBLR#
1058++AVG_ROW_LENGTH #ARL#
1059++DATA_LENGTH #DL#
1060++MAX_DATA_LENGTH #MDL#
1061++INDEX_LENGTH #IL#
1062++DATA_FREE #DF#
1063++AUTO_INCREMENT NULL
1064++CREATE_TIME #CRT#
1065++UPDATE_TIME #UT#
1066++CHECK_TIME #CT#
1067++TABLE_COLLATION utf8_general_ci
1068++CHECKSUM NULL
1069++CREATE_OPTIONS #CO#
1070++TABLE_COMMENT #TC#
1071++user_comment
1072++Separator -----------------------------------------------------
1073++TABLE_CATALOG NULL
1074++TABLE_SCHEMA information_schema
1075++TABLE_NAME XTRADB_ADMIN_COMMAND
1076+ TABLE_TYPE SYSTEM VIEW
1077+ ENGINE MEMORY
1078+ VERSION 10
1079+@@ -1136,7 +1211,7 @@
1080+ Separator -----------------------------------------------------
1081+ TABLE_CATALOG NULL
1082+ TABLE_SCHEMA information_schema
1083+-TABLE_NAME TABLES
1084++TABLE_NAME XTRADB_ENHANCEMENTS
1085+ TABLE_TYPE SYSTEM VIEW
1086+ ENGINE MEMORY
1087+ VERSION 10
1088+@@ -1157,9 +1232,26 @@
1089+ TABLE_COMMENT #TC#
1090+ user_comment
1091+ Separator -----------------------------------------------------
1092++DROP USER testuser1@localhost;
1093++CREATE USER testuser1@localhost;
1094++GRANT SELECT ON test1.* TO testuser1@localhost;
1095++# Establish connection testuser1 (user=testuser1)
1096++SELECT *,
1097++LEFT( table_comment,
1098++IF(INSTR(table_comment,'InnoDB free') = 0
1099++AND INSTR(table_comment,'number_of_replicas') = 0,
1100++LENGTH(table_comment),
1101++INSTR(table_comment,'InnoDB free')
1102+++ INSTR(table_comment,'number_of_replicas') - 1))
1103++AS "user_comment",
1104++'-----------------------------------------------------' AS "Separator"
1105++FROM information_schema.tables
1106++WHERE table_schema = 'information_schema'
1107++AND table_name <> 'profiling'
1108++ORDER BY table_schema,table_name;
1109+ TABLE_CATALOG NULL
1110+ TABLE_SCHEMA information_schema
1111+-TABLE_NAME TABLE_CONSTRAINTS
1112++TABLE_NAME CHARACTER_SETS
1113+ TABLE_TYPE SYSTEM VIEW
1114+ ENGINE MEMORY
1115+ VERSION 10
1116+@@ -1182,7 +1274,7 @@
1117+ Separator -----------------------------------------------------
1118+ TABLE_CATALOG NULL
1119+ TABLE_SCHEMA information_schema
1120+-TABLE_NAME TABLE_PRIVILEGES
1121++TABLE_NAME CLIENT_STATISTICS
1122+ TABLE_TYPE SYSTEM VIEW
1123+ ENGINE MEMORY
1124+ VERSION 10
1125+@@ -1205,11 +1297,11 @@
1126+ Separator -----------------------------------------------------
1127+ TABLE_CATALOG NULL
1128+ TABLE_SCHEMA information_schema
1129+-TABLE_NAME TRIGGERS
1130++TABLE_NAME COLLATIONS
1131+ TABLE_TYPE SYSTEM VIEW
1132+-ENGINE MyISAM
1133++ENGINE MEMORY
1134+ VERSION 10
1135+-ROW_FORMAT Dynamic
1136++ROW_FORMAT Fixed
1137+ TABLE_ROWS #TBLR#
1138+ AVG_ROW_LENGTH #ARL#
1139+ DATA_LENGTH #DL#
1140+@@ -1228,7 +1320,7 @@
1141+ Separator -----------------------------------------------------
1142+ TABLE_CATALOG NULL
1143+ TABLE_SCHEMA information_schema
1144+-TABLE_NAME USER_PRIVILEGES
1145++TABLE_NAME COLLATION_CHARACTER_SET_APPLICABILITY
1146+ TABLE_TYPE SYSTEM VIEW
1147+ ENGINE MEMORY
1148+ VERSION 10
1149+@@ -1251,7 +1343,7 @@
1150+ Separator -----------------------------------------------------
1151+ TABLE_CATALOG NULL
1152+ TABLE_SCHEMA information_schema
1153+-TABLE_NAME VIEWS
1154++TABLE_NAME COLUMNS
1155+ TABLE_TYPE SYSTEM VIEW
1156+ ENGINE MyISAM
1157+ VERSION 10
1158+@@ -1272,6 +1364,1110 @@
1159+ TABLE_COMMENT #TC#
1160+ user_comment
1161+ Separator -----------------------------------------------------
1162++TABLE_CATALOG NULL
1163++TABLE_SCHEMA information_schema
1164++TABLE_NAME COLUMN_PRIVILEGES
1165++TABLE_TYPE SYSTEM VIEW
1166++ENGINE MEMORY
1167++VERSION 10
1168++ROW_FORMAT Fixed
1169++TABLE_ROWS #TBLR#
1170++AVG_ROW_LENGTH #ARL#
1171++DATA_LENGTH #DL#
1172++MAX_DATA_LENGTH #MDL#
1173++INDEX_LENGTH #IL#
1174++DATA_FREE #DF#
1175++AUTO_INCREMENT NULL
1176++CREATE_TIME #CRT#
1177++UPDATE_TIME #UT#
1178++CHECK_TIME #CT#
1179++TABLE_COLLATION utf8_general_ci
1180++CHECKSUM NULL
1181++CREATE_OPTIONS #CO#
1182++TABLE_COMMENT #TC#
1183++user_comment
1184++Separator -----------------------------------------------------
1185++TABLE_CATALOG NULL
1186++TABLE_SCHEMA information_schema
1187++TABLE_NAME ENGINES
1188++TABLE_TYPE SYSTEM VIEW
1189++ENGINE MEMORY
1190++VERSION 10
1191++ROW_FORMAT Fixed
1192++TABLE_ROWS #TBLR#
1193++AVG_ROW_LENGTH #ARL#
1194++DATA_LENGTH #DL#
1195++MAX_DATA_LENGTH #MDL#
1196++INDEX_LENGTH #IL#
1197++DATA_FREE #DF#
1198++AUTO_INCREMENT NULL
1199++CREATE_TIME #CRT#
1200++UPDATE_TIME #UT#
1201++CHECK_TIME #CT#
1202++TABLE_COLLATION utf8_general_ci
1203++CHECKSUM NULL
1204++CREATE_OPTIONS #CO#
1205++TABLE_COMMENT #TC#
1206++user_comment
1207++Separator -----------------------------------------------------
1208++TABLE_CATALOG NULL
1209++TABLE_SCHEMA information_schema
1210++TABLE_NAME EVENTS
1211++TABLE_TYPE SYSTEM VIEW
1212++ENGINE MyISAM
1213++VERSION 10
1214++ROW_FORMAT Dynamic
1215++TABLE_ROWS #TBLR#
1216++AVG_ROW_LENGTH #ARL#
1217++DATA_LENGTH #DL#
1218++MAX_DATA_LENGTH #MDL#
1219++INDEX_LENGTH #IL#
1220++DATA_FREE #DF#
1221++AUTO_INCREMENT NULL
1222++CREATE_TIME #CRT#
1223++UPDATE_TIME #UT#
1224++CHECK_TIME #CT#
1225++TABLE_COLLATION utf8_general_ci
1226++CHECKSUM NULL
1227++CREATE_OPTIONS #CO#
1228++TABLE_COMMENT #TC#
1229++user_comment
1230++Separator -----------------------------------------------------
1231++TABLE_CATALOG NULL
1232++TABLE_SCHEMA information_schema
1233++TABLE_NAME FILES
1234++TABLE_TYPE SYSTEM VIEW
1235++ENGINE MEMORY
1236++VERSION 10
1237++ROW_FORMAT Fixed
1238++TABLE_ROWS #TBLR#
1239++AVG_ROW_LENGTH #ARL#
1240++DATA_LENGTH #DL#
1241++MAX_DATA_LENGTH #MDL#
1242++INDEX_LENGTH #IL#
1243++DATA_FREE #DF#
1244++AUTO_INCREMENT NULL
1245++CREATE_TIME #CRT#
1246++UPDATE_TIME #UT#
1247++CHECK_TIME #CT#
1248++TABLE_COLLATION utf8_general_ci
1249++CHECKSUM NULL
1250++CREATE_OPTIONS #CO#
1251++TABLE_COMMENT #TC#
1252++user_comment
1253++Separator -----------------------------------------------------
1254++TABLE_CATALOG NULL
1255++TABLE_SCHEMA information_schema
1256++TABLE_NAME GLOBAL_STATUS
1257++TABLE_TYPE SYSTEM VIEW
1258++ENGINE MEMORY
1259++VERSION 10
1260++ROW_FORMAT Fixed
1261++TABLE_ROWS #TBLR#
1262++AVG_ROW_LENGTH #ARL#
1263++DATA_LENGTH #DL#
1264++MAX_DATA_LENGTH #MDL#
1265++INDEX_LENGTH #IL#
1266++DATA_FREE #DF#
1267++AUTO_INCREMENT NULL
1268++CREATE_TIME #CRT#
1269++UPDATE_TIME #UT#
1270++CHECK_TIME #CT#
1271++TABLE_COLLATION utf8_general_ci
1272++CHECKSUM NULL
1273++CREATE_OPTIONS #CO#
1274++TABLE_COMMENT #TC#
1275++user_comment
1276++Separator -----------------------------------------------------
1277++TABLE_CATALOG NULL
1278++TABLE_SCHEMA information_schema
1279++TABLE_NAME GLOBAL_TEMPORARY_TABLES
1280++TABLE_TYPE SYSTEM VIEW
1281++ENGINE MEMORY
1282++VERSION 10
1283++ROW_FORMAT Fixed
1284++TABLE_ROWS #TBLR#
1285++AVG_ROW_LENGTH #ARL#
1286++DATA_LENGTH #DL#
1287++MAX_DATA_LENGTH #MDL#
1288++INDEX_LENGTH #IL#
1289++DATA_FREE #DF#
1290++AUTO_INCREMENT NULL
1291++CREATE_TIME #CRT#
1292++UPDATE_TIME #UT#
1293++CHECK_TIME #CT#
1294++TABLE_COLLATION utf8_general_ci
1295++CHECKSUM NULL
1296++CREATE_OPTIONS #CO#
1297++TABLE_COMMENT #TC#
1298++user_comment
1299++Separator -----------------------------------------------------
1300++TABLE_CATALOG NULL
1301++TABLE_SCHEMA information_schema
1302++TABLE_NAME GLOBAL_VARIABLES
1303++TABLE_TYPE SYSTEM VIEW
1304++ENGINE MEMORY
1305++VERSION 10
1306++ROW_FORMAT Fixed
1307++TABLE_ROWS #TBLR#
1308++AVG_ROW_LENGTH #ARL#
1309++DATA_LENGTH #DL#
1310++MAX_DATA_LENGTH #MDL#
1311++INDEX_LENGTH #IL#
1312++DATA_FREE #DF#
1313++AUTO_INCREMENT NULL
1314++CREATE_TIME #CRT#
1315++UPDATE_TIME #UT#
1316++CHECK_TIME #CT#
1317++TABLE_COLLATION utf8_general_ci
1318++CHECKSUM NULL
1319++CREATE_OPTIONS #CO#
1320++TABLE_COMMENT #TC#
1321++user_comment
1322++Separator -----------------------------------------------------
1323++TABLE_CATALOG NULL
1324++TABLE_SCHEMA information_schema
1325++TABLE_NAME INDEX_STATISTICS
1326++TABLE_TYPE SYSTEM VIEW
1327++ENGINE MEMORY
1328++VERSION 10
1329++ROW_FORMAT Fixed
1330++TABLE_ROWS #TBLR#
1331++AVG_ROW_LENGTH #ARL#
1332++DATA_LENGTH #DL#
1333++MAX_DATA_LENGTH #MDL#
1334++INDEX_LENGTH #IL#
1335++DATA_FREE #DF#
1336++AUTO_INCREMENT NULL
1337++CREATE_TIME #CRT#
1338++UPDATE_TIME #UT#
1339++CHECK_TIME #CT#
1340++TABLE_COLLATION utf8_general_ci
1341++CHECKSUM NULL
1342++CREATE_OPTIONS #CO#
1343++TABLE_COMMENT #TC#
1344++user_comment
1345++Separator -----------------------------------------------------
1346++TABLE_CATALOG NULL
1347++TABLE_SCHEMA information_schema
1348++TABLE_NAME INNODB_BUFFER_POOL_PAGES
1349++TABLE_TYPE SYSTEM VIEW
1350++ENGINE MEMORY
1351++VERSION 10
1352++ROW_FORMAT Fixed
1353++TABLE_ROWS #TBLR#
1354++AVG_ROW_LENGTH #ARL#
1355++DATA_LENGTH #DL#
1356++MAX_DATA_LENGTH #MDL#
1357++INDEX_LENGTH #IL#
1358++DATA_FREE #DF#
1359++AUTO_INCREMENT NULL
1360++CREATE_TIME #CRT#
1361++UPDATE_TIME #UT#
1362++CHECK_TIME #CT#
1363++TABLE_COLLATION utf8_general_ci
1364++CHECKSUM NULL
1365++CREATE_OPTIONS #CO#
1366++TABLE_COMMENT #TC#
1367++user_comment
1368++Separator -----------------------------------------------------
1369++TABLE_CATALOG NULL
1370++TABLE_SCHEMA information_schema
1371++TABLE_NAME INNODB_BUFFER_POOL_PAGES_BLOB
1372++TABLE_TYPE SYSTEM VIEW
1373++ENGINE MEMORY
1374++VERSION 10
1375++ROW_FORMAT Fixed
1376++TABLE_ROWS #TBLR#
1377++AVG_ROW_LENGTH #ARL#
1378++DATA_LENGTH #DL#
1379++MAX_DATA_LENGTH #MDL#
1380++INDEX_LENGTH #IL#
1381++DATA_FREE #DF#
1382++AUTO_INCREMENT NULL
1383++CREATE_TIME #CRT#
1384++UPDATE_TIME #UT#
1385++CHECK_TIME #CT#
1386++TABLE_COLLATION utf8_general_ci
1387++CHECKSUM NULL
1388++CREATE_OPTIONS #CO#
1389++TABLE_COMMENT #TC#
1390++user_comment
1391++Separator -----------------------------------------------------
1392++TABLE_CATALOG NULL
1393++TABLE_SCHEMA information_schema
1394++TABLE_NAME INNODB_BUFFER_POOL_PAGES_INDEX
1395++TABLE_TYPE SYSTEM VIEW
1396++ENGINE MEMORY
1397++VERSION 10
1398++ROW_FORMAT Fixed
1399++TABLE_ROWS #TBLR#
1400++AVG_ROW_LENGTH #ARL#
1401++DATA_LENGTH #DL#
1402++MAX_DATA_LENGTH #MDL#
1403++INDEX_LENGTH #IL#
1404++DATA_FREE #DF#
1405++AUTO_INCREMENT NULL
1406++CREATE_TIME #CRT#
1407++UPDATE_TIME #UT#
1408++CHECK_TIME #CT#
1409++TABLE_COLLATION utf8_general_ci
1410++CHECKSUM NULL
1411++CREATE_OPTIONS #CO#
1412++TABLE_COMMENT #TC#
1413++user_comment
1414++Separator -----------------------------------------------------
1415++TABLE_CATALOG NULL
1416++TABLE_SCHEMA information_schema
1417++TABLE_NAME INNODB_CMP
1418++TABLE_TYPE SYSTEM VIEW
1419++ENGINE MEMORY
1420++VERSION 10
1421++ROW_FORMAT Fixed
1422++TABLE_ROWS #TBLR#
1423++AVG_ROW_LENGTH #ARL#
1424++DATA_LENGTH #DL#
1425++MAX_DATA_LENGTH #MDL#
1426++INDEX_LENGTH #IL#
1427++DATA_FREE #DF#
1428++AUTO_INCREMENT NULL
1429++CREATE_TIME #CRT#
1430++UPDATE_TIME #UT#
1431++CHECK_TIME #CT#
1432++TABLE_COLLATION utf8_general_ci
1433++CHECKSUM NULL
1434++CREATE_OPTIONS #CO#
1435++TABLE_COMMENT #TC#
1436++user_comment
1437++Separator -----------------------------------------------------
1438++TABLE_CATALOG NULL
1439++TABLE_SCHEMA information_schema
1440++TABLE_NAME INNODB_CMPMEM
1441++TABLE_TYPE SYSTEM VIEW
1442++ENGINE MEMORY
1443++VERSION 10
1444++ROW_FORMAT Fixed
1445++TABLE_ROWS #TBLR#
1446++AVG_ROW_LENGTH #ARL#
1447++DATA_LENGTH #DL#
1448++MAX_DATA_LENGTH #MDL#
1449++INDEX_LENGTH #IL#
1450++DATA_FREE #DF#
1451++AUTO_INCREMENT NULL
1452++CREATE_TIME #CRT#
1453++UPDATE_TIME #UT#
1454++CHECK_TIME #CT#
1455++TABLE_COLLATION utf8_general_ci
1456++CHECKSUM NULL
1457++CREATE_OPTIONS #CO#
1458++TABLE_COMMENT #TC#
1459++user_comment
1460++Separator -----------------------------------------------------
1461++TABLE_CATALOG NULL
1462++TABLE_SCHEMA information_schema
1463++TABLE_NAME INNODB_CMPMEM_RESET
1464++TABLE_TYPE SYSTEM VIEW
1465++ENGINE MEMORY
1466++VERSION 10
1467++ROW_FORMAT Fixed
1468++TABLE_ROWS #TBLR#
1469++AVG_ROW_LENGTH #ARL#
1470++DATA_LENGTH #DL#
1471++MAX_DATA_LENGTH #MDL#
1472++INDEX_LENGTH #IL#
1473++DATA_FREE #DF#
1474++AUTO_INCREMENT NULL
1475++CREATE_TIME #CRT#
1476++UPDATE_TIME #UT#
1477++CHECK_TIME #CT#
1478++TABLE_COLLATION utf8_general_ci
1479++CHECKSUM NULL
1480++CREATE_OPTIONS #CO#
1481++TABLE_COMMENT #TC#
1482++user_comment
1483++Separator -----------------------------------------------------
1484++TABLE_CATALOG NULL
1485++TABLE_SCHEMA information_schema
1486++TABLE_NAME INNODB_CMP_RESET
1487++TABLE_TYPE SYSTEM VIEW
1488++ENGINE MEMORY
1489++VERSION 10
1490++ROW_FORMAT Fixed
1491++TABLE_ROWS #TBLR#
1492++AVG_ROW_LENGTH #ARL#
1493++DATA_LENGTH #DL#
1494++MAX_DATA_LENGTH #MDL#
1495++INDEX_LENGTH #IL#
1496++DATA_FREE #DF#
1497++AUTO_INCREMENT NULL
1498++CREATE_TIME #CRT#
1499++UPDATE_TIME #UT#
1500++CHECK_TIME #CT#
1501++TABLE_COLLATION utf8_general_ci
1502++CHECKSUM NULL
1503++CREATE_OPTIONS #CO#
1504++TABLE_COMMENT #TC#
1505++user_comment
1506++Separator -----------------------------------------------------
1507++TABLE_CATALOG NULL
1508++TABLE_SCHEMA information_schema
1509++TABLE_NAME INNODB_INDEX_STATS
1510++TABLE_TYPE SYSTEM VIEW
1511++ENGINE MEMORY
1512++VERSION 10
1513++ROW_FORMAT Fixed
1514++TABLE_ROWS #TBLR#
1515++AVG_ROW_LENGTH #ARL#
1516++DATA_LENGTH #DL#
1517++MAX_DATA_LENGTH #MDL#
1518++INDEX_LENGTH #IL#
1519++DATA_FREE #DF#
1520++AUTO_INCREMENT NULL
1521++CREATE_TIME #CRT#
1522++UPDATE_TIME #UT#
1523++CHECK_TIME #CT#
1524++TABLE_COLLATION utf8_general_ci
1525++CHECKSUM NULL
1526++CREATE_OPTIONS #CO#
1527++TABLE_COMMENT #TC#
1528++user_comment
1529++Separator -----------------------------------------------------
1530++TABLE_CATALOG NULL
1531++TABLE_SCHEMA information_schema
1532++TABLE_NAME INNODB_LOCKS
1533++TABLE_TYPE SYSTEM VIEW
1534++ENGINE MEMORY
1535++VERSION 10
1536++ROW_FORMAT Fixed
1537++TABLE_ROWS #TBLR#
1538++AVG_ROW_LENGTH #ARL#
1539++DATA_LENGTH #DL#
1540++MAX_DATA_LENGTH #MDL#
1541++INDEX_LENGTH #IL#
1542++DATA_FREE #DF#
1543++AUTO_INCREMENT NULL
1544++CREATE_TIME #CRT#
1545++UPDATE_TIME #UT#
1546++CHECK_TIME #CT#
1547++TABLE_COLLATION utf8_general_ci
1548++CHECKSUM NULL
1549++CREATE_OPTIONS #CO#
1550++TABLE_COMMENT #TC#
1551++user_comment
1552++Separator -----------------------------------------------------
1553++TABLE_CATALOG NULL
1554++TABLE_SCHEMA information_schema
1555++TABLE_NAME INNODB_LOCK_WAITS
1556++TABLE_TYPE SYSTEM VIEW
1557++ENGINE MEMORY
1558++VERSION 10
1559++ROW_FORMAT Fixed
1560++TABLE_ROWS #TBLR#
1561++AVG_ROW_LENGTH #ARL#
1562++DATA_LENGTH #DL#
1563++MAX_DATA_LENGTH #MDL#
1564++INDEX_LENGTH #IL#
1565++DATA_FREE #DF#
1566++AUTO_INCREMENT NULL
1567++CREATE_TIME #CRT#
1568++UPDATE_TIME #UT#
1569++CHECK_TIME #CT#
1570++TABLE_COLLATION utf8_general_ci
1571++CHECKSUM NULL
1572++CREATE_OPTIONS #CO#
1573++TABLE_COMMENT #TC#
1574++user_comment
1575++Separator -----------------------------------------------------
1576++TABLE_CATALOG NULL
1577++TABLE_SCHEMA information_schema
1578++TABLE_NAME INNODB_RSEG
1579++TABLE_TYPE SYSTEM VIEW
1580++ENGINE MEMORY
1581++VERSION 10
1582++ROW_FORMAT Fixed
1583++TABLE_ROWS #TBLR#
1584++AVG_ROW_LENGTH #ARL#
1585++DATA_LENGTH #DL#
1586++MAX_DATA_LENGTH #MDL#
1587++INDEX_LENGTH #IL#
1588++DATA_FREE #DF#
1589++AUTO_INCREMENT NULL
1590++CREATE_TIME #CRT#
1591++UPDATE_TIME #UT#
1592++CHECK_TIME #CT#
1593++TABLE_COLLATION utf8_general_ci
1594++CHECKSUM NULL
1595++CREATE_OPTIONS #CO#
1596++TABLE_COMMENT #TC#
1597++user_comment
1598++Separator -----------------------------------------------------
1599++TABLE_CATALOG NULL
1600++TABLE_SCHEMA information_schema
1601++TABLE_NAME INNODB_SYS_INDEXES
1602++TABLE_TYPE SYSTEM VIEW
1603++ENGINE MEMORY
1604++VERSION 10
1605++ROW_FORMAT Fixed
1606++TABLE_ROWS #TBLR#
1607++AVG_ROW_LENGTH #ARL#
1608++DATA_LENGTH #DL#
1609++MAX_DATA_LENGTH #MDL#
1610++INDEX_LENGTH #IL#
1611++DATA_FREE #DF#
1612++AUTO_INCREMENT NULL
1613++CREATE_TIME #CRT#
1614++UPDATE_TIME #UT#
1615++CHECK_TIME #CT#
1616++TABLE_COLLATION utf8_general_ci
1617++CHECKSUM NULL
1618++CREATE_OPTIONS #CO#
1619++TABLE_COMMENT #TC#
1620++user_comment
1621++Separator -----------------------------------------------------
1622++TABLE_CATALOG NULL
1623++TABLE_SCHEMA information_schema
1624++TABLE_NAME INNODB_SYS_STATS
1625++TABLE_TYPE SYSTEM VIEW
1626++ENGINE MEMORY
1627++VERSION 10
1628++ROW_FORMAT Fixed
1629++TABLE_ROWS #TBLR#
1630++AVG_ROW_LENGTH #ARL#
1631++DATA_LENGTH #DL#
1632++MAX_DATA_LENGTH #MDL#
1633++INDEX_LENGTH #IL#
1634++DATA_FREE #DF#
1635++AUTO_INCREMENT NULL
1636++CREATE_TIME #CRT#
1637++UPDATE_TIME #UT#
1638++CHECK_TIME #CT#
1639++TABLE_COLLATION utf8_general_ci
1640++CHECKSUM NULL
1641++CREATE_OPTIONS #CO#
1642++TABLE_COMMENT #TC#
1643++user_comment
1644++Separator -----------------------------------------------------
1645++TABLE_CATALOG NULL
1646++TABLE_SCHEMA information_schema
1647++TABLE_NAME INNODB_SYS_TABLES
1648++TABLE_TYPE SYSTEM VIEW
1649++ENGINE MEMORY
1650++VERSION 10
1651++ROW_FORMAT Fixed
1652++TABLE_ROWS #TBLR#
1653++AVG_ROW_LENGTH #ARL#
1654++DATA_LENGTH #DL#
1655++MAX_DATA_LENGTH #MDL#
1656++INDEX_LENGTH #IL#
1657++DATA_FREE #DF#
1658++AUTO_INCREMENT NULL
1659++CREATE_TIME #CRT#
1660++UPDATE_TIME #UT#
1661++CHECK_TIME #CT#
1662++TABLE_COLLATION utf8_general_ci
1663++CHECKSUM NULL
1664++CREATE_OPTIONS #CO#
1665++TABLE_COMMENT #TC#
1666++user_comment
1667++Separator -----------------------------------------------------
1668++TABLE_CATALOG NULL
1669++TABLE_SCHEMA information_schema
1670++TABLE_NAME INNODB_TABLE_STATS
1671++TABLE_TYPE SYSTEM VIEW
1672++ENGINE MEMORY
1673++VERSION 10
1674++ROW_FORMAT Fixed
1675++TABLE_ROWS #TBLR#
1676++AVG_ROW_LENGTH #ARL#
1677++DATA_LENGTH #DL#
1678++MAX_DATA_LENGTH #MDL#
1679++INDEX_LENGTH #IL#
1680++DATA_FREE #DF#
1681++AUTO_INCREMENT NULL
1682++CREATE_TIME #CRT#
1683++UPDATE_TIME #UT#
1684++CHECK_TIME #CT#
1685++TABLE_COLLATION utf8_general_ci
1686++CHECKSUM NULL
1687++CREATE_OPTIONS #CO#
1688++TABLE_COMMENT #TC#
1689++user_comment
1690++Separator -----------------------------------------------------
1691++TABLE_CATALOG NULL
1692++TABLE_SCHEMA information_schema
1693++TABLE_NAME INNODB_TRX
1694++TABLE_TYPE SYSTEM VIEW
1695++ENGINE MEMORY
1696++VERSION 10
1697++ROW_FORMAT Fixed
1698++TABLE_ROWS #TBLR#
1699++AVG_ROW_LENGTH #ARL#
1700++DATA_LENGTH #DL#
1701++MAX_DATA_LENGTH #MDL#
1702++INDEX_LENGTH #IL#
1703++DATA_FREE #DF#
1704++AUTO_INCREMENT NULL
1705++CREATE_TIME #CRT#
1706++UPDATE_TIME #UT#
1707++CHECK_TIME #CT#
1708++TABLE_COLLATION utf8_general_ci
1709++CHECKSUM NULL
1710++CREATE_OPTIONS #CO#
1711++TABLE_COMMENT #TC#
1712++user_comment
1713++Separator -----------------------------------------------------
1714++TABLE_CATALOG NULL
1715++TABLE_SCHEMA information_schema
1716++TABLE_NAME KEY_COLUMN_USAGE
1717++TABLE_TYPE SYSTEM VIEW
1718++ENGINE MEMORY
1719++VERSION 10
1720++ROW_FORMAT Fixed
1721++TABLE_ROWS #TBLR#
1722++AVG_ROW_LENGTH #ARL#
1723++DATA_LENGTH #DL#
1724++MAX_DATA_LENGTH #MDL#
1725++INDEX_LENGTH #IL#
1726++DATA_FREE #DF#
1727++AUTO_INCREMENT NULL
1728++CREATE_TIME #CRT#
1729++UPDATE_TIME #UT#
1730++CHECK_TIME #CT#
1731++TABLE_COLLATION utf8_general_ci
1732++CHECKSUM NULL
1733++CREATE_OPTIONS #CO#
1734++TABLE_COMMENT #TC#
1735++user_comment
1736++Separator -----------------------------------------------------
1737++TABLE_CATALOG NULL
1738++TABLE_SCHEMA information_schema
1739++TABLE_NAME PARTITIONS
1740++TABLE_TYPE SYSTEM VIEW
1741++ENGINE MyISAM
1742++VERSION 10
1743++ROW_FORMAT Dynamic
1744++TABLE_ROWS #TBLR#
1745++AVG_ROW_LENGTH #ARL#
1746++DATA_LENGTH #DL#
1747++MAX_DATA_LENGTH #MDL#
1748++INDEX_LENGTH #IL#
1749++DATA_FREE #DF#
1750++AUTO_INCREMENT NULL
1751++CREATE_TIME #CRT#
1752++UPDATE_TIME #UT#
1753++CHECK_TIME #CT#
1754++TABLE_COLLATION utf8_general_ci
1755++CHECKSUM NULL
1756++CREATE_OPTIONS #CO#
1757++TABLE_COMMENT #TC#
1758++user_comment
1759++Separator -----------------------------------------------------
1760++TABLE_CATALOG NULL
1761++TABLE_SCHEMA information_schema
1762++TABLE_NAME PLUGINS
1763++TABLE_TYPE SYSTEM VIEW
1764++ENGINE MyISAM
1765++VERSION 10
1766++ROW_FORMAT Dynamic
1767++TABLE_ROWS #TBLR#
1768++AVG_ROW_LENGTH #ARL#
1769++DATA_LENGTH #DL#
1770++MAX_DATA_LENGTH #MDL#
1771++INDEX_LENGTH #IL#
1772++DATA_FREE #DF#
1773++AUTO_INCREMENT NULL
1774++CREATE_TIME #CRT#
1775++UPDATE_TIME #UT#
1776++CHECK_TIME #CT#
1777++TABLE_COLLATION utf8_general_ci
1778++CHECKSUM NULL
1779++CREATE_OPTIONS #CO#
1780++TABLE_COMMENT #TC#
1781++user_comment
1782++Separator -----------------------------------------------------
1783++TABLE_CATALOG NULL
1784++TABLE_SCHEMA information_schema
1785++TABLE_NAME PROCESSLIST
1786++TABLE_TYPE SYSTEM VIEW
1787++ENGINE MyISAM
1788++VERSION 10
1789++ROW_FORMAT Dynamic
1790++TABLE_ROWS #TBLR#
1791++AVG_ROW_LENGTH #ARL#
1792++DATA_LENGTH #DL#
1793++MAX_DATA_LENGTH #MDL#
1794++INDEX_LENGTH #IL#
1795++DATA_FREE #DF#
1796++AUTO_INCREMENT NULL
1797++CREATE_TIME #CRT#
1798++UPDATE_TIME #UT#
1799++CHECK_TIME #CT#
1800++TABLE_COLLATION utf8_general_ci
1801++CHECKSUM NULL
1802++CREATE_OPTIONS #CO#
1803++TABLE_COMMENT #TC#
1804++user_comment
1805++Separator -----------------------------------------------------
1806++TABLE_CATALOG NULL
1807++TABLE_SCHEMA information_schema
1808++TABLE_NAME QUERY_RESPONSE_TIME
1809++TABLE_TYPE SYSTEM VIEW
1810++ENGINE MEMORY
1811++VERSION 10
1812++ROW_FORMAT Fixed
1813++TABLE_ROWS #TBLR#
1814++AVG_ROW_LENGTH #ARL#
1815++DATA_LENGTH #DL#
1816++MAX_DATA_LENGTH #MDL#
1817++INDEX_LENGTH #IL#
1818++DATA_FREE #DF#
1819++AUTO_INCREMENT NULL
1820++CREATE_TIME #CRT#
1821++UPDATE_TIME #UT#
1822++CHECK_TIME #CT#
1823++TABLE_COLLATION utf8_general_ci
1824++CHECKSUM NULL
1825++CREATE_OPTIONS #CO#
1826++TABLE_COMMENT #TC#
1827++user_comment
1828++Separator -----------------------------------------------------
1829++TABLE_CATALOG NULL
1830++TABLE_SCHEMA information_schema
1831++TABLE_NAME REFERENTIAL_CONSTRAINTS
1832++TABLE_TYPE SYSTEM VIEW
1833++ENGINE MEMORY
1834++VERSION 10
1835++ROW_FORMAT Fixed
1836++TABLE_ROWS #TBLR#
1837++AVG_ROW_LENGTH #ARL#
1838++DATA_LENGTH #DL#
1839++MAX_DATA_LENGTH #MDL#
1840++INDEX_LENGTH #IL#
1841++DATA_FREE #DF#
1842++AUTO_INCREMENT NULL
1843++CREATE_TIME #CRT#
1844++UPDATE_TIME #UT#
1845++CHECK_TIME #CT#
1846++TABLE_COLLATION utf8_general_ci
1847++CHECKSUM NULL
1848++CREATE_OPTIONS #CO#
1849++TABLE_COMMENT #TC#
1850++user_comment
1851++Separator -----------------------------------------------------
1852++TABLE_CATALOG NULL
1853++TABLE_SCHEMA information_schema
1854++TABLE_NAME ROUTINES
1855++TABLE_TYPE SYSTEM VIEW
1856++ENGINE MyISAM
1857++VERSION 10
1858++ROW_FORMAT Dynamic
1859++TABLE_ROWS #TBLR#
1860++AVG_ROW_LENGTH #ARL#
1861++DATA_LENGTH #DL#
1862++MAX_DATA_LENGTH #MDL#
1863++INDEX_LENGTH #IL#
1864++DATA_FREE #DF#
1865++AUTO_INCREMENT NULL
1866++CREATE_TIME #CRT#
1867++UPDATE_TIME #UT#
1868++CHECK_TIME #CT#
1869++TABLE_COLLATION utf8_general_ci
1870++CHECKSUM NULL
1871++CREATE_OPTIONS #CO#
1872++TABLE_COMMENT #TC#
1873++user_comment
1874++Separator -----------------------------------------------------
1875++TABLE_CATALOG NULL
1876++TABLE_SCHEMA information_schema
1877++TABLE_NAME SCHEMATA
1878++TABLE_TYPE SYSTEM VIEW
1879++ENGINE MEMORY
1880++VERSION 10
1881++ROW_FORMAT Fixed
1882++TABLE_ROWS #TBLR#
1883++AVG_ROW_LENGTH #ARL#
1884++DATA_LENGTH #DL#
1885++MAX_DATA_LENGTH #MDL#
1886++INDEX_LENGTH #IL#
1887++DATA_FREE #DF#
1888++AUTO_INCREMENT NULL
1889++CREATE_TIME #CRT#
1890++UPDATE_TIME #UT#
1891++CHECK_TIME #CT#
1892++TABLE_COLLATION utf8_general_ci
1893++CHECKSUM NULL
1894++CREATE_OPTIONS #CO#
1895++TABLE_COMMENT #TC#
1896++user_comment
1897++Separator -----------------------------------------------------
1898++TABLE_CATALOG NULL
1899++TABLE_SCHEMA information_schema
1900++TABLE_NAME SCHEMA_PRIVILEGES
1901++TABLE_TYPE SYSTEM VIEW
1902++ENGINE MEMORY
1903++VERSION 10
1904++ROW_FORMAT Fixed
1905++TABLE_ROWS #TBLR#
1906++AVG_ROW_LENGTH #ARL#
1907++DATA_LENGTH #DL#
1908++MAX_DATA_LENGTH #MDL#
1909++INDEX_LENGTH #IL#
1910++DATA_FREE #DF#
1911++AUTO_INCREMENT NULL
1912++CREATE_TIME #CRT#
1913++UPDATE_TIME #UT#
1914++CHECK_TIME #CT#
1915++TABLE_COLLATION utf8_general_ci
1916++CHECKSUM NULL
1917++CREATE_OPTIONS #CO#
1918++TABLE_COMMENT #TC#
1919++user_comment
1920++Separator -----------------------------------------------------
1921++TABLE_CATALOG NULL
1922++TABLE_SCHEMA information_schema
1923++TABLE_NAME SESSION_STATUS
1924++TABLE_TYPE SYSTEM VIEW
1925++ENGINE MEMORY
1926++VERSION 10
1927++ROW_FORMAT Fixed
1928++TABLE_ROWS #TBLR#
1929++AVG_ROW_LENGTH #ARL#
1930++DATA_LENGTH #DL#
1931++MAX_DATA_LENGTH #MDL#
1932++INDEX_LENGTH #IL#
1933++DATA_FREE #DF#
1934++AUTO_INCREMENT NULL
1935++CREATE_TIME #CRT#
1936++UPDATE_TIME #UT#
1937++CHECK_TIME #CT#
1938++TABLE_COLLATION utf8_general_ci
1939++CHECKSUM NULL
1940++CREATE_OPTIONS #CO#
1941++TABLE_COMMENT #TC#
1942++user_comment
1943++Separator -----------------------------------------------------
1944++TABLE_CATALOG NULL
1945++TABLE_SCHEMA information_schema
1946++TABLE_NAME SESSION_VARIABLES
1947++TABLE_TYPE SYSTEM VIEW
1948++ENGINE MEMORY
1949++VERSION 10
1950++ROW_FORMAT Fixed
1951++TABLE_ROWS #TBLR#
1952++AVG_ROW_LENGTH #ARL#
1953++DATA_LENGTH #DL#
1954++MAX_DATA_LENGTH #MDL#
1955++INDEX_LENGTH #IL#
1956++DATA_FREE #DF#
1957++AUTO_INCREMENT NULL
1958++CREATE_TIME #CRT#
1959++UPDATE_TIME #UT#
1960++CHECK_TIME #CT#
1961++TABLE_COLLATION utf8_general_ci
1962++CHECKSUM NULL
1963++CREATE_OPTIONS #CO#
1964++TABLE_COMMENT #TC#
1965++user_comment
1966++Separator -----------------------------------------------------
1967++TABLE_CATALOG NULL
1968++TABLE_SCHEMA information_schema
1969++TABLE_NAME STATISTICS
1970++TABLE_TYPE SYSTEM VIEW
1971++ENGINE MEMORY
1972++VERSION 10
1973++ROW_FORMAT Fixed
1974++TABLE_ROWS #TBLR#
1975++AVG_ROW_LENGTH #ARL#
1976++DATA_LENGTH #DL#
1977++MAX_DATA_LENGTH #MDL#
1978++INDEX_LENGTH #IL#
1979++DATA_FREE #DF#
1980++AUTO_INCREMENT NULL
1981++CREATE_TIME #CRT#
1982++UPDATE_TIME #UT#
1983++CHECK_TIME #CT#
1984++TABLE_COLLATION utf8_general_ci
1985++CHECKSUM NULL
1986++CREATE_OPTIONS #CO#
1987++TABLE_COMMENT #TC#
1988++user_comment
1989++Separator -----------------------------------------------------
1990++TABLE_CATALOG NULL
1991++TABLE_SCHEMA information_schema
1992++TABLE_NAME TABLES
1993++TABLE_TYPE SYSTEM VIEW
1994++ENGINE MEMORY
1995++VERSION 10
1996++ROW_FORMAT Fixed
1997++TABLE_ROWS #TBLR#
1998++AVG_ROW_LENGTH #ARL#
1999++DATA_LENGTH #DL#
2000++MAX_DATA_LENGTH #MDL#
2001++INDEX_LENGTH #IL#
2002++DATA_FREE #DF#
2003++AUTO_INCREMENT NULL
2004++CREATE_TIME #CRT#
2005++UPDATE_TIME #UT#
2006++CHECK_TIME #CT#
2007++TABLE_COLLATION utf8_general_ci
2008++CHECKSUM NULL
2009++CREATE_OPTIONS #CO#
2010++TABLE_COMMENT #TC#
2011++user_comment
2012++Separator -----------------------------------------------------
2013++TABLE_CATALOG NULL
2014++TABLE_SCHEMA information_schema
2015++TABLE_NAME TABLE_CONSTRAINTS
2016++TABLE_TYPE SYSTEM VIEW
2017++ENGINE MEMORY
2018++VERSION 10
2019++ROW_FORMAT Fixed
2020++TABLE_ROWS #TBLR#
2021++AVG_ROW_LENGTH #ARL#
2022++DATA_LENGTH #DL#
2023++MAX_DATA_LENGTH #MDL#
2024++INDEX_LENGTH #IL#
2025++DATA_FREE #DF#
2026++AUTO_INCREMENT NULL
2027++CREATE_TIME #CRT#
2028++UPDATE_TIME #UT#
2029++CHECK_TIME #CT#
2030++TABLE_COLLATION utf8_general_ci
2031++CHECKSUM NULL
2032++CREATE_OPTIONS #CO#
2033++TABLE_COMMENT #TC#
2034++user_comment
2035++Separator -----------------------------------------------------
2036++TABLE_CATALOG NULL
2037++TABLE_SCHEMA information_schema
2038++TABLE_NAME TABLE_PRIVILEGES
2039++TABLE_TYPE SYSTEM VIEW
2040++ENGINE MEMORY
2041++VERSION 10
2042++ROW_FORMAT Fixed
2043++TABLE_ROWS #TBLR#
2044++AVG_ROW_LENGTH #ARL#
2045++DATA_LENGTH #DL#
2046++MAX_DATA_LENGTH #MDL#
2047++INDEX_LENGTH #IL#
2048++DATA_FREE #DF#
2049++AUTO_INCREMENT NULL
2050++CREATE_TIME #CRT#
2051++UPDATE_TIME #UT#
2052++CHECK_TIME #CT#
2053++TABLE_COLLATION utf8_general_ci
2054++CHECKSUM NULL
2055++CREATE_OPTIONS #CO#
2056++TABLE_COMMENT #TC#
2057++user_comment
2058++Separator -----------------------------------------------------
2059++TABLE_CATALOG NULL
2060++TABLE_SCHEMA information_schema
2061++TABLE_NAME TABLE_STATISTICS
2062++TABLE_TYPE SYSTEM VIEW
2063++ENGINE MEMORY
2064++VERSION 10
2065++ROW_FORMAT Fixed
2066++TABLE_ROWS #TBLR#
2067++AVG_ROW_LENGTH #ARL#
2068++DATA_LENGTH #DL#
2069++MAX_DATA_LENGTH #MDL#
2070++INDEX_LENGTH #IL#
2071++DATA_FREE #DF#
2072++AUTO_INCREMENT NULL
2073++CREATE_TIME #CRT#
2074++UPDATE_TIME #UT#
2075++CHECK_TIME #CT#
2076++TABLE_COLLATION utf8_general_ci
2077++CHECKSUM NULL
2078++CREATE_OPTIONS #CO#
2079++TABLE_COMMENT #TC#
2080++user_comment
2081++Separator -----------------------------------------------------
2082++TABLE_CATALOG NULL
2083++TABLE_SCHEMA information_schema
2084++TABLE_NAME TEMPORARY_TABLES
2085++TABLE_TYPE SYSTEM VIEW
2086++ENGINE MEMORY
2087++VERSION 10
2088++ROW_FORMAT Fixed
2089++TABLE_ROWS #TBLR#
2090++AVG_ROW_LENGTH #ARL#
2091++DATA_LENGTH #DL#
2092++MAX_DATA_LENGTH #MDL#
2093++INDEX_LENGTH #IL#
2094++DATA_FREE #DF#
2095++AUTO_INCREMENT NULL
2096++CREATE_TIME #CRT#
2097++UPDATE_TIME #UT#
2098++CHECK_TIME #CT#
2099++TABLE_COLLATION utf8_general_ci
2100++CHECKSUM NULL
2101++CREATE_OPTIONS #CO#
2102++TABLE_COMMENT #TC#
2103++user_comment
2104++Separator -----------------------------------------------------
2105++TABLE_CATALOG NULL
2106++TABLE_SCHEMA information_schema
2107++TABLE_NAME THREAD_STATISTICS
2108++TABLE_TYPE SYSTEM VIEW
2109++ENGINE MEMORY
2110++VERSION 10
2111++ROW_FORMAT Fixed
2112++TABLE_ROWS #TBLR#
2113++AVG_ROW_LENGTH #ARL#
2114++DATA_LENGTH #DL#
2115++MAX_DATA_LENGTH #MDL#
2116++INDEX_LENGTH #IL#
2117++DATA_FREE #DF#
2118++AUTO_INCREMENT NULL
2119++CREATE_TIME #CRT#
2120++UPDATE_TIME #UT#
2121++CHECK_TIME #CT#
2122++TABLE_COLLATION utf8_general_ci
2123++CHECKSUM NULL
2124++CREATE_OPTIONS #CO#
2125++TABLE_COMMENT #TC#
2126++user_comment
2127++Separator -----------------------------------------------------
2128++TABLE_CATALOG NULL
2129++TABLE_SCHEMA information_schema
2130++TABLE_NAME TRIGGERS
2131++TABLE_TYPE SYSTEM VIEW
2132++ENGINE MyISAM
2133++VERSION 10
2134++ROW_FORMAT Dynamic
2135++TABLE_ROWS #TBLR#
2136++AVG_ROW_LENGTH #ARL#
2137++DATA_LENGTH #DL#
2138++MAX_DATA_LENGTH #MDL#
2139++INDEX_LENGTH #IL#
2140++DATA_FREE #DF#
2141++AUTO_INCREMENT NULL
2142++CREATE_TIME #CRT#
2143++UPDATE_TIME #UT#
2144++CHECK_TIME #CT#
2145++TABLE_COLLATION utf8_general_ci
2146++CHECKSUM NULL
2147++CREATE_OPTIONS #CO#
2148++TABLE_COMMENT #TC#
2149++user_comment
2150++Separator -----------------------------------------------------
2151++TABLE_CATALOG NULL
2152++TABLE_SCHEMA information_schema
2153++TABLE_NAME USER_PRIVILEGES
2154++TABLE_TYPE SYSTEM VIEW
2155++ENGINE MEMORY
2156++VERSION 10
2157++ROW_FORMAT Fixed
2158++TABLE_ROWS #TBLR#
2159++AVG_ROW_LENGTH #ARL#
2160++DATA_LENGTH #DL#
2161++MAX_DATA_LENGTH #MDL#
2162++INDEX_LENGTH #IL#
2163++DATA_FREE #DF#
2164++AUTO_INCREMENT NULL
2165++CREATE_TIME #CRT#
2166++UPDATE_TIME #UT#
2167++CHECK_TIME #CT#
2168++TABLE_COLLATION utf8_general_ci
2169++CHECKSUM NULL
2170++CREATE_OPTIONS #CO#
2171++TABLE_COMMENT #TC#
2172++user_comment
2173++Separator -----------------------------------------------------
2174++TABLE_CATALOG NULL
2175++TABLE_SCHEMA information_schema
2176++TABLE_NAME USER_STATISTICS
2177++TABLE_TYPE SYSTEM VIEW
2178++ENGINE MEMORY
2179++VERSION 10
2180++ROW_FORMAT Fixed
2181++TABLE_ROWS #TBLR#
2182++AVG_ROW_LENGTH #ARL#
2183++DATA_LENGTH #DL#
2184++MAX_DATA_LENGTH #MDL#
2185++INDEX_LENGTH #IL#
2186++DATA_FREE #DF#
2187++AUTO_INCREMENT NULL
2188++CREATE_TIME #CRT#
2189++UPDATE_TIME #UT#
2190++CHECK_TIME #CT#
2191++TABLE_COLLATION utf8_general_ci
2192++CHECKSUM NULL
2193++CREATE_OPTIONS #CO#
2194++TABLE_COMMENT #TC#
2195++user_comment
2196++Separator -----------------------------------------------------
2197++TABLE_CATALOG NULL
2198++TABLE_SCHEMA information_schema
2199++TABLE_NAME VIEWS
2200++TABLE_TYPE SYSTEM VIEW
2201++ENGINE MyISAM
2202++VERSION 10
2203++ROW_FORMAT Dynamic
2204++TABLE_ROWS #TBLR#
2205++AVG_ROW_LENGTH #ARL#
2206++DATA_LENGTH #DL#
2207++MAX_DATA_LENGTH #MDL#
2208++INDEX_LENGTH #IL#
2209++DATA_FREE #DF#
2210++AUTO_INCREMENT NULL
2211++CREATE_TIME #CRT#
2212++UPDATE_TIME #UT#
2213++CHECK_TIME #CT#
2214++TABLE_COLLATION utf8_general_ci
2215++CHECKSUM NULL
2216++CREATE_OPTIONS #CO#
2217++TABLE_COMMENT #TC#
2218++user_comment
2219++Separator -----------------------------------------------------
2220++TABLE_CATALOG NULL
2221++TABLE_SCHEMA information_schema
2222++TABLE_NAME XTRADB_ADMIN_COMMAND
2223++TABLE_TYPE SYSTEM VIEW
2224++ENGINE MEMORY
2225++VERSION 10
2226++ROW_FORMAT Fixed
2227++TABLE_ROWS #TBLR#
2228++AVG_ROW_LENGTH #ARL#
2229++DATA_LENGTH #DL#
2230++MAX_DATA_LENGTH #MDL#
2231++INDEX_LENGTH #IL#
2232++DATA_FREE #DF#
2233++AUTO_INCREMENT NULL
2234++CREATE_TIME #CRT#
2235++UPDATE_TIME #UT#
2236++CHECK_TIME #CT#
2237++TABLE_COLLATION utf8_general_ci
2238++CHECKSUM NULL
2239++CREATE_OPTIONS #CO#
2240++TABLE_COMMENT #TC#
2241++user_comment
2242++Separator -----------------------------------------------------
2243++TABLE_CATALOG NULL
2244++TABLE_SCHEMA information_schema
2245++TABLE_NAME XTRADB_ENHANCEMENTS
2246++TABLE_TYPE SYSTEM VIEW
2247++ENGINE MEMORY
2248++VERSION 10
2249++ROW_FORMAT Fixed
2250++TABLE_ROWS #TBLR#
2251++AVG_ROW_LENGTH #ARL#
2252++DATA_LENGTH #DL#
2253++MAX_DATA_LENGTH #MDL#
2254++INDEX_LENGTH #IL#
2255++DATA_FREE #DF#
2256++AUTO_INCREMENT NULL
2257++CREATE_TIME #CRT#
2258++UPDATE_TIME #UT#
2259++CHECK_TIME #CT#
2260++TABLE_COLLATION utf8_general_ci
2261++CHECKSUM NULL
2262++CREATE_OPTIONS #CO#
2263++TABLE_COMMENT #TC#
2264++user_comment
2265++Separator -----------------------------------------------------
2266+ # Switch to connection default and close connection testuser1
2267+ DROP USER testuser1@localhost;
2268+ DROP DATABASE test1;
2269+diff -Nur a/mysql-test/suite/funcs_1/datadict/processlist_priv.inc b/mysql-test/suite/funcs_1/datadict/processlist_priv.inc
2270+--- a/mysql-test/suite/funcs_1/datadict/processlist_priv.inc 2010-12-23 10:16:32.000000000 -0500
2271++++ b/mysql-test/suite/funcs_1/datadict/processlist_priv.inc 2010-12-23 13:26:13.000000000 -0500
2272+@@ -66,7 +66,7 @@
2273+ let $table= processlist;
2274+ #
2275+ # columns of the information_schema table e.g. to use in a select.
2276+-let $columns= ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO;
2277++let $columns= ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS;
2278+ #
2279+ # Where clause for an update.
2280+ let $update_where= WHERE id=1 ;
2281+@@ -136,11 +136,11 @@
2282+ WHERE DB = 'information_schema' AND COMMAND = 'Sleep' AND USER = 'ddicttestuser1';
2283+ --source include/wait_condition.inc
2284+ eval SHOW CREATE TABLE $table;
2285+---replace_column 1 ID 3 HOST_NAME 6 TIME
2286++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2287+ eval SHOW $table;
2288+---replace_column 1 ID 3 HOST_NAME 6 TIME
2289++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2290+ eval SELECT * FROM $table $select_where ORDER BY id;
2291+---replace_column 1 ID 3 HOST_NAME 6 TIME
2292++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2293+ eval SELECT $columns FROM $table $select_where ORDER BY id;
2294+ --source suite/funcs_1/datadict/datadict_priv.inc
2295+
2296+@@ -154,11 +154,11 @@
2297+ # The current state of the default session might depend on load of testing box
2298+ # but "ddicttestuser1" must not see anything of the root session.
2299+ eval SHOW CREATE TABLE $table;
2300+---replace_column 1 ID 3 HOST_NAME 6 TIME
2301++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2302+ eval SHOW $table;
2303+---replace_column 1 ID 3 HOST_NAME 6 TIME
2304++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2305+ eval SELECT * FROM $table $select_where ORDER BY id;
2306+---replace_column 1 ID 3 HOST_NAME 6 TIME
2307++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2308+ eval SELECT $columns FROM $table $select_where ORDER BY id;
2309+ --source suite/funcs_1/datadict/datadict_priv.inc
2310+ --real_sleep 0.3
2311+@@ -180,9 +180,9 @@
2312+ --echo ####################################################################################
2313+ connection con100;
2314+ SHOW GRANTS;
2315+---replace_column 1 ID 3 HOST_NAME 6 TIME
2316++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2317+ SHOW processlist;
2318+---replace_column 1 ID 3 HOST_NAME 6 TIME
2319++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2320+ SELECT * FROM information_schema.processlist;
2321+ --real_sleep 0.3
2322+
2323+@@ -192,9 +192,9 @@
2324+ --echo ####################################################################################
2325+ connect (con101,localhost,ddicttestuser1,ddictpass,information_schema);
2326+ SHOW GRANTS;
2327+---replace_column 1 ID 3 HOST_NAME 6 TIME
2328++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2329+ SHOW processlist;
2330+---replace_column 1 ID 3 HOST_NAME 6 TIME
2331++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2332+ SELECT * FROM information_schema.processlist;
2333+ --real_sleep 0.3
2334+
2335+@@ -214,9 +214,9 @@
2336+ --echo ####################################################################################
2337+ connect (anonymous1,localhost,"''",,information_schema);
2338+ SHOW GRANTS;
2339+---replace_column 1 ID 3 HOST_NAME 6 TIME
2340++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2341+ SHOW processlist;
2342+---replace_column 1 ID 3 HOST_NAME 6 TIME
2343++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2344+ SELECT * FROM information_schema.processlist;
2345+ --real_sleep 0.3
2346+
2347+@@ -236,9 +236,9 @@
2348+ --echo ddicttestuser1 are visible.
2349+ --echo ####################################################################################
2350+ SHOW GRANTS;
2351+---replace_column 1 ID 3 HOST_NAME 6 TIME
2352++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2353+ SHOW processlist;
2354+---replace_column 1 ID 3 HOST_NAME 6 TIME
2355++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2356+ SELECT * FROM information_schema.processlist;
2357+ --real_sleep 0.3
2358+
2359+@@ -261,10 +261,10 @@
2360+ if ($fixed_bug_30395)
2361+ {
2362+ # Bug#30395 strange results after REVOKE PROCESS ON *.* FROM ...
2363+---replace_column 1 ID 3 HOST_NAME 6 TIME
2364++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2365+ SHOW processlist;
2366+ }
2367+---replace_column 1 ID 3 HOST_NAME 6 TIME
2368++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2369+ SELECT * FROM information_schema.processlist;
2370+ --real_sleep 0.3
2371+
2372+@@ -283,9 +283,9 @@
2373+ --echo Only the processes of ddicttestuser1 user are visible.
2374+ --echo ####################################################################################
2375+ SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
2376+---replace_column 1 ID 3 HOST_NAME 6 TIME
2377++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2378+ SHOW processlist;
2379+---replace_column 1 ID 3 HOST_NAME 6 TIME
2380++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2381+ SELECT * FROM information_schema.processlist;
2382+ --real_sleep 0.3
2383+
2384+@@ -305,9 +305,9 @@
2385+ --echo Only the processes of ddicttestuser1 are visible.
2386+ --echo ####################################################################################
2387+ SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
2388+---replace_column 1 ID 3 HOST_NAME 6 TIME
2389++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2390+ SHOW processlist;
2391+---replace_column 1 ID 3 HOST_NAME 6 TIME
2392++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2393+ SELECT * FROM information_schema.processlist;
2394+ --real_sleep 0.3
2395+
2396+@@ -352,9 +352,9 @@
2397+ --echo ddicttestuser2 has now the PROCESS privilege and sees all connections
2398+ --echo ####################################################################################
2399+ SHOW GRANTS FOR 'ddicttestuser2'@'localhost';
2400+---replace_column 1 ID 3 HOST_NAME 6 TIME
2401++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2402+ SHOW processlist;
2403+---replace_column 1 ID 3 HOST_NAME 6 TIME
2404++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2405+ SELECT * FROM information_schema.processlist;
2406+ --real_sleep 0.3
2407+
2408+@@ -373,9 +373,9 @@
2409+ --echo ddicttestuser2 has no more the PROCESS privilege and can only see own connects
2410+ --echo ####################################################################################
2411+ SHOW GRANTS;
2412+---replace_column 1 ID 3 HOST_NAME 6 TIME
2413++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2414+ SHOW processlist;
2415+---replace_column 1 ID 3 HOST_NAME 6 TIME
2416++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2417+ SELECT * FROM information_schema.processlist;
2418+ --real_sleep 0.3
2419+
2420+@@ -396,9 +396,9 @@
2421+ SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
2422+ --error ER_ACCESS_DENIED_ERROR
2423+ GRANT PROCESS ON *.* TO 'ddicttestuser2'@'localhost';
2424+---replace_column 1 ID 3 HOST_NAME 6 TIME
2425++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2426+ SHOW processlist;
2427+---replace_column 1 ID 3 HOST_NAME 6 TIME
2428++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2429+ SELECT * FROM information_schema.processlist;
2430+ --real_sleep 0.3
2431+
2432+@@ -420,9 +420,9 @@
2433+ --echo Therefore the missing SELECT privilege does not affect SELECTs on PROCESSLIST.
2434+ --echo ####################################################################################
2435+ SHOW GRANTS FOR 'ddicttestuser1'@'localhost';
2436+---replace_column 1 ID 3 HOST_NAME 6 TIME
2437++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2438+ SHOW processlist;
2439+---replace_column 1 ID 3 HOST_NAME 6 TIME
2440++--replace_column 1 ID 3 HOST_NAME 6 TIME 9 TIME_MS
2441+ SELECT * FROM information_schema.processlist;
2442+ --real_sleep 0.3
2443+
2444+diff -Nur a/mysql-test/suite/funcs_1/r/processlist_priv_ps.result b/mysql-test/suite/funcs_1/r/processlist_priv_ps.result
2445+--- a/mysql-test/suite/funcs_1/r/processlist_priv_ps.result 2010-12-23 10:16:32.000000000 -0500
2446++++ b/mysql-test/suite/funcs_1/r/processlist_priv_ps.result 2010-12-23 13:28:13.000000000 -0500
2447+@@ -29,28 +29,29 @@
2448+ `COMMAND` varchar(16) NOT NULL DEFAULT '',
2449+ `TIME` int(7) NOT NULL DEFAULT '0',
2450+ `STATE` varchar(64) DEFAULT NULL,
2451+- `INFO` longtext
2452++ `INFO` longtext,
2453++ `TIME_MS` bigint(21) NOT NULL DEFAULT '0'
2454+ ) ENGINE=MyISAM DEFAULT CHARSET=utf8
2455+ SHOW processlist;
2456+ Id User Host db Command Time State Info
2457+ ID root HOST_NAME information_schema Query TIME NULL SHOW processlist
2458+ ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2459+ SELECT * FROM processlist ORDER BY id;
2460+-ID USER HOST DB COMMAND TIME STATE INFO
2461+-ID root HOST_NAME information_schema Execute TIME executing SELECT * FROM processlist ORDER BY id
2462+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2463+-SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO FROM processlist ORDER BY id;
2464+-ID USER HOST DB COMMAND TIME STATE INFO
2465+-ID root HOST_NAME information_schema Execute TIME executing SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO FROM processlist ORDER BY id
2466+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2467++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2468++ID root HOST_NAME information_schema Execute TIME executing SELECT * FROM processlist ORDER BY id TIME_MS
2469++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2470++SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS FROM processlist ORDER BY id;
2471++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2472++ID root HOST_NAME information_schema Execute TIME executing SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS FROM processlist ORDER BY id TIME_MS
2473++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2474+ CREATE TEMPORARY TABLE test.t_processlist AS SELECT * FROM processlist;
2475+ UPDATE test.t_processlist SET user='horst' WHERE id=1 ;
2476+ INSERT INTO processlist SELECT * FROM test.t_processlist;
2477+ ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
2478+ DROP TABLE test.t_processlist;
2479+-CREATE VIEW test.v_processlist (ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO) AS SELECT * FROM processlist WITH CHECK OPTION;
2480++CREATE VIEW test.v_processlist (ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS) AS SELECT * FROM processlist WITH CHECK OPTION;
2481+ ERROR HY000: CHECK OPTION on non-updatable view 'test.v_processlist'
2482+-CREATE VIEW test.v_processlist (ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO) AS SELECT * FROM processlist;
2483++CREATE VIEW test.v_processlist (ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS) AS SELECT * FROM processlist;
2484+ UPDATE test.v_processlist SET TIME=NOW() WHERE id = 1;
2485+ ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
2486+ DROP VIEW test.v_processlist;
2487+@@ -99,25 +100,26 @@
2488+ `COMMAND` varchar(16) NOT NULL DEFAULT '',
2489+ `TIME` int(7) NOT NULL DEFAULT '0',
2490+ `STATE` varchar(64) DEFAULT NULL,
2491+- `INFO` longtext
2492++ `INFO` longtext,
2493++ `TIME_MS` bigint(21) NOT NULL DEFAULT '0'
2494+ ) ENGINE=MyISAM DEFAULT CHARSET=utf8
2495+ SHOW processlist;
2496+ Id User Host db Command Time State Info
2497+ ID ddicttestuser1 HOST_NAME information_schema Query TIME NULL SHOW processlist
2498+ SELECT * FROM processlist ORDER BY id;
2499+-ID USER HOST DB COMMAND TIME STATE INFO
2500+-ID ddicttestuser1 HOST_NAME information_schema Execute TIME executing SELECT * FROM processlist ORDER BY id
2501+-SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO FROM processlist ORDER BY id;
2502+-ID USER HOST DB COMMAND TIME STATE INFO
2503+-ID ddicttestuser1 HOST_NAME information_schema Execute TIME executing SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO FROM processlist ORDER BY id
2504++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2505++ID ddicttestuser1 HOST_NAME information_schema Execute TIME executing SELECT * FROM processlist ORDER BY id TIME_MS
2506++SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS FROM processlist ORDER BY id;
2507++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2508++ID ddicttestuser1 HOST_NAME information_schema Execute TIME executing SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS FROM processlist ORDER BY id TIME_MS
2509+ CREATE TEMPORARY TABLE test.t_processlist AS SELECT * FROM processlist;
2510+ UPDATE test.t_processlist SET user='horst' WHERE id=1 ;
2511+ INSERT INTO processlist SELECT * FROM test.t_processlist;
2512+ ERROR 42000: Access denied for user 'ddicttestuser1'@'localhost' to database 'information_schema'
2513+ DROP TABLE test.t_processlist;
2514+-CREATE VIEW test.v_processlist (ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO) AS SELECT * FROM processlist WITH CHECK OPTION;
2515++CREATE VIEW test.v_processlist (ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS) AS SELECT * FROM processlist WITH CHECK OPTION;
2516+ ERROR HY000: CHECK OPTION on non-updatable view 'test.v_processlist'
2517+-CREATE VIEW test.v_processlist (ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO) AS SELECT * FROM processlist;
2518++CREATE VIEW test.v_processlist (ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO, TIME_MS) AS SELECT * FROM processlist;
2519+ UPDATE test.v_processlist SET TIME=NOW() WHERE id = 1;
2520+ ERROR 42000: Access denied for user 'ddicttestuser1'@'localhost' to database 'information_schema'
2521+ DROP VIEW test.v_processlist;
2522+@@ -170,8 +172,8 @@
2523+ Id User Host db Command Time State Info
2524+ ID ddicttestuser1 HOST_NAME information_schema Query TIME NULL SHOW processlist
2525+ SELECT * FROM information_schema.processlist;
2526+-ID USER HOST DB COMMAND TIME STATE INFO
2527+-ID ddicttestuser1 HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist
2528++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2529++ID ddicttestuser1 HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist TIME_MS
2530+ ####################################################################################
2531+ 4.2 New connection con101 (ddicttestuser1 with PROCESS privilege)
2532+ SHOW/SELECT shows all processes/threads.
2533+@@ -185,10 +187,10 @@
2534+ ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2535+ ID ddicttestuser1 HOST_NAME information_schema Query TIME NULL SHOW processlist
2536+ SELECT * FROM information_schema.processlist;
2537+-ID USER HOST DB COMMAND TIME STATE INFO
2538+-ID ddicttestuser1 HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist
2539+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2540+-ID root HOST_NAME information_schema Sleep TIME NULL
2541++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2542++ID ddicttestuser1 HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist TIME_MS
2543++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2544++ID root HOST_NAME information_schema Sleep TIME NULL TIME_MS
2545+ ####################################################################################
2546+ 5 Grant PROCESS privilege to anonymous user.
2547+ connection default (user=root)
2548+@@ -209,11 +211,11 @@
2549+ ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2550+ ID HOST_NAME information_schema Query TIME NULL SHOW processlist
2551+ SELECT * FROM information_schema.processlist;
2552+-ID USER HOST DB COMMAND TIME STATE INFO
2553+-ID HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist
2554+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2555+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2556+-ID root HOST_NAME information_schema Sleep TIME NULL
2557++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2558++ID HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist TIME_MS
2559++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2560++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2561++ID root HOST_NAME information_schema Sleep TIME NULL TIME_MS
2562+ ####################################################################################
2563+ 6 Revoke PROCESS privilege from ddicttestuser1
2564+ connection default (user=root)
2565+@@ -233,10 +235,10 @@
2566+ ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2567+ ID ddicttestuser1 HOST_NAME information_schema Query TIME NULL SHOW processlist
2568+ SELECT * FROM information_schema.processlist;
2569+-ID USER HOST DB COMMAND TIME STATE INFO
2570+-ID ddicttestuser1 HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist
2571+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2572+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2573++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2574++ID ddicttestuser1 HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist TIME_MS
2575++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2576++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2577+ ####################################################################################
2578+ 7 Revoke PROCESS privilege from anonymous user
2579+ connection default (user=root)
2580+@@ -251,9 +253,9 @@
2581+ Grants for @localhost
2582+ GRANT USAGE ON *.* TO ''@'localhost'
2583+ SELECT * FROM information_schema.processlist;
2584+-ID USER HOST DB COMMAND TIME STATE INFO
2585+-ID HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist
2586+-ID HOST_NAME information_schema Sleep TIME NULL
2587++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2588++ID HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist TIME_MS
2589++ID HOST_NAME information_schema Sleep TIME NULL TIME_MS
2590+ ####################################################################################
2591+ 8 Grant SUPER (does not imply PROCESS) privilege to ddicttestuser1
2592+ connection default (user=root)
2593+@@ -273,11 +275,11 @@
2594+ ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2595+ ID ddicttestuser1 HOST_NAME information_schema Query TIME NULL SHOW processlist
2596+ SELECT * FROM information_schema.processlist;
2597+-ID USER HOST DB COMMAND TIME STATE INFO
2598+-ID ddicttestuser1 HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist
2599+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2600+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2601+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2602++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2603++ID ddicttestuser1 HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist TIME_MS
2604++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2605++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2606++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2607+ ####################################################################################
2608+ 9 Revoke SUPER privilege from user ddicttestuser1
2609+ connection default (user=root)
2610+@@ -299,12 +301,12 @@
2611+ ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2612+ ID ddicttestuser1 HOST_NAME information_schema Query TIME NULL SHOW processlist
2613+ SELECT * FROM information_schema.processlist;
2614+-ID USER HOST DB COMMAND TIME STATE INFO
2615+-ID ddicttestuser1 HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist
2616+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2617+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2618+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2619+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2620++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2621++ID ddicttestuser1 HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist TIME_MS
2622++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2623++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2624++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2625++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2626+ ####################################################################################
2627+ 10 Grant SUPER privilege with grant option to user ddicttestuser1.
2628+ connection default (user=root)
2629+@@ -353,18 +355,18 @@
2630+ ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2631+ ID ddicttestuser2 HOST_NAME information_schema Query TIME NULL SHOW processlist
2632+ SELECT * FROM information_schema.processlist;
2633+-ID USER HOST DB COMMAND TIME STATE INFO
2634+-ID ddicttestuser2 HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist
2635+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2636+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2637+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2638+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2639+-ID HOST_NAME information_schema Sleep TIME NULL
2640+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2641+-ID HOST_NAME information_schema Sleep TIME NULL
2642+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2643+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2644+-ID root HOST_NAME information_schema Sleep TIME NULL
2645++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2646++ID ddicttestuser2 HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist TIME_MS
2647++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2648++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2649++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2650++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2651++ID HOST_NAME information_schema Sleep TIME NULL TIME_MS
2652++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2653++ID HOST_NAME information_schema Sleep TIME NULL TIME_MS
2654++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2655++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2656++ID root HOST_NAME information_schema Sleep TIME NULL TIME_MS
2657+ ####################################################################################
2658+ 11 User ddicttestuser1 revokes PROCESS privilege from user ddicttestuser2
2659+ connection ddicttestuser1;
2660+@@ -382,9 +384,9 @@
2661+ ID ddicttestuser2 HOST_NAME information_schema Sleep TIME NULL
2662+ ID ddicttestuser2 HOST_NAME information_schema Query TIME NULL SHOW processlist
2663+ SELECT * FROM information_schema.processlist;
2664+-ID USER HOST DB COMMAND TIME STATE INFO
2665+-ID ddicttestuser2 HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist
2666+-ID ddicttestuser2 HOST_NAME information_schema Sleep TIME NULL
2667++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2668++ID ddicttestuser2 HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist TIME_MS
2669++ID ddicttestuser2 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2670+ ####################################################################################
2671+ 11.2 Revoke SUPER,PROCESS,GRANT OPTION privilege from user ddicttestuser1
2672+ connection default (user=root)
2673+@@ -411,15 +413,15 @@
2674+ ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2675+ ID ddicttestuser1 HOST_NAME information_schema Query TIME NULL SHOW processlist
2676+ SELECT * FROM information_schema.processlist;
2677+-ID USER HOST DB COMMAND TIME STATE INFO
2678+-ID ddicttestuser1 HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist
2679+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2680+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2681+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2682+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2683+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2684+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2685+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2686++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2687++ID ddicttestuser1 HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist TIME_MS
2688++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2689++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2690++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2691++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2692++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2693++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2694++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2695+ ####################################################################################
2696+ 12 Revoke the SELECT privilege from user ddicttestuser1
2697+ connection default (user=root)
2698+@@ -447,16 +449,16 @@
2699+ ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2700+ ID ddicttestuser1 HOST_NAME information_schema Query TIME NULL SHOW processlist
2701+ SELECT * FROM information_schema.processlist;
2702+-ID USER HOST DB COMMAND TIME STATE INFO
2703+-ID ddicttestuser1 HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist
2704+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2705+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2706+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2707+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2708+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2709+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2710+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2711+-ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL
2712++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2713++ID ddicttestuser1 HOST_NAME information_schema Execute TIME executing SELECT * FROM information_schema.processlist TIME_MS
2714++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2715++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2716++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2717++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2718++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2719++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2720++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2721++ID ddicttestuser1 HOST_NAME information_schema Sleep TIME NULL TIME_MS
2722+ ####################################################################################
2723+ 12.2 Revoke only the SELECT privilege on the information_schema from ddicttestuser1.
2724+ connection default (user=root)
2725+diff -Nur a/mysql-test/suite/funcs_1/datadict/processlist_val.inc b/mysql-test/suite/funcs_1/datadict/processlist_val.inc
2726+--- a/mysql-test/suite/funcs_1/datadict/processlist_val.inc 2010-12-23 10:16:32.000000000 -0500
2727++++ b/mysql-test/suite/funcs_1/datadict/processlist_val.inc 2010-12-23 14:02:00.000000000 -0500
2728+@@ -32,7 +32,7 @@
2729+ # TIME: In many cases within this test 0 seconds but if the testing box is #
2730+ # overloaded we might get up to 2 seconds. #
2731+ # Solution: #
2732+-# --replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME> #
2733++# --replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME> 9 <TIME_MS> #
2734+ # 5. How to debug the script? #
2735+ # <graphical diff tool> \ #
2736+ # suite/funcs_1/datadict/processlist_val.inc \ #
2737+@@ -92,9 +92,9 @@
2738+ # - INFO must contain the corresponding SHOW/SELECT PROCESSLIST
2739+ #
2740+ # 1. Just dump what we get
2741+---replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
2742++--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME> 9 <TIME_MS>
2743+ SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
2744+---replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
2745++--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME> 9 <TIME_MS>
2746+ SHOW FULL PROCESSLIST;
2747+ #
2748+ # Determine the connection id of the current connection (default)
2749+@@ -165,9 +165,9 @@
2750+ WHERE COMMAND = 'Sleep' AND USER = 'test_user';
2751+ --source include/wait_condition.inc
2752+ # 1. Just dump what we get
2753+---replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
2754++--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME> 9 <TIME_MS>
2755+ SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
2756+---replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
2757++--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME> 9 <TIME_MS>
2758+ SHOW FULL PROCESSLIST;
2759+ #
2760+ # Pull ID and TIME of the second connection
2761+@@ -210,9 +210,9 @@
2762+ # ----- switch to connection con1 (user = test_user) -----
2763+ ;
2764+ connection con1;
2765+---replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
2766++--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME> 9 <TIME_MS>
2767+ SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
2768+---replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
2769++--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME> 9 <TIME_MS>
2770+ SHOW FULL PROCESSLIST;
2771+
2772+
2773+@@ -244,9 +244,9 @@
2774+ ;
2775+ connection con2;
2776+ # Just dump what we get
2777+---replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
2778++--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME> 9 <TIME_MS>
2779+ SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
2780+---replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
2781++--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME> 9 <TIME_MS>
2782+ SHOW FULL PROCESSLIST;
2783+ #
2784+ echo
2785+@@ -304,9 +304,9 @@
2786+ AND State = 'User sleep' AND INFO IS NOT NULL ;
2787+ --source include/wait_condition.inc
2788+ # 1. Just dump what we get
2789+---replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
2790++--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME> 9 <TIME_MS>
2791+ SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
2792+---replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
2793++--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME> 9 <TIME_MS>
2794+ SHOW FULL PROCESSLIST;
2795+ #
2796+ # Pull some information about the connection con2
2797+@@ -375,7 +375,7 @@
2798+ #
2799+ # Expect to see the state 'Locked' for the third connection because the SELECT
2800+ # collides with the WRITE TABLE LOCK.
2801+---replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
2802++--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME> 9 <TIME_MS>
2803+ SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
2804+ UNLOCK TABLES;
2805+ #
2806+diff -Nur a/mysql-test/suite/funcs_1/r/processlist_val_ps.result b/mysql-test/suite/funcs_1/r/processlist_val_ps.result
2807+--- a/mysql-test/suite/funcs_1/r/processlist_val_ps.result 2010-12-23 10:16:32.000000000 -0500
2808++++ b/mysql-test/suite/funcs_1/r/processlist_val_ps.result 2010-12-23 14:03:30.000000000 -0500
2809+@@ -19,14 +19,15 @@
2810+ `COMMAND` varchar(16) NOT NULL DEFAULT '',
2811+ `TIME` int(7) NOT NULL DEFAULT '0',
2812+ `STATE` varchar(64) DEFAULT NULL,
2813+- `INFO` longtext
2814++ `INFO` longtext,
2815++ `TIME_MS` bigint(21) NOT NULL DEFAULT '0'
2816+ ) ENGINE=MyISAM DEFAULT CHARSET=utf8
2817+ # Ensure that the information about the own connection is correct.
2818+ #--------------------------------------------------------------------------
2819+
2820+ SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
2821+-ID USER HOST DB COMMAND TIME STATE INFO
2822+-<ID> root <HOST_NAME> test Execute <TIME> executing SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
2823++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2824++<ID> root <HOST_NAME> test Execute <TIME> executing SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST <TIME_MS>
2825+ SHOW FULL PROCESSLIST;
2826+ Id User Host db Command Time State Info
2827+ <ID> root <HOST_NAME> test Query <TIME> NULL SHOW FULL PROCESSLIST
2828+@@ -72,9 +73,9 @@
2829+ # Poll till the connection con1 is in state COMMAND = 'Sleep'.
2830+
2831+ SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
2832+-ID USER HOST DB COMMAND TIME STATE INFO
2833+-<ID> test_user <HOST_NAME> information_schema Sleep <TIME> NULL
2834+-<ID> root <HOST_NAME> information_schema Execute <TIME> executing SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
2835++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2836++<ID> test_user <HOST_NAME> information_schema Sleep <TIME> NULL <TIME_MS>
2837++<ID> root <HOST_NAME> information_schema Execute <TIME> executing SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST <TIME_MS>
2838+ SHOW FULL PROCESSLIST;
2839+ Id User Host db Command Time State Info
2840+ <ID> root <HOST_NAME> information_schema Query <TIME> NULL SHOW FULL PROCESSLIST
2841+@@ -106,8 +107,8 @@
2842+ # ----- switch to connection con1 (user = test_user) -----
2843+
2844+ SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
2845+-ID USER HOST DB COMMAND TIME STATE INFO
2846+-<ID> test_user <HOST_NAME> information_schema Execute <TIME> executing SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
2847++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2848++<ID> test_user <HOST_NAME> information_schema Execute <TIME> executing SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST <TIME_MS>
2849+ SHOW FULL PROCESSLIST;
2850+ Id User Host db Command Time State Info
2851+ <ID> test_user <HOST_NAME> information_schema Query <TIME> NULL SHOW FULL PROCESSLIST
2852+@@ -123,9 +124,9 @@
2853+ # ----- switch to connection con2 (user = test_user) -----
2854+
2855+ SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
2856+-ID USER HOST DB COMMAND TIME STATE INFO
2857+-<ID> test_user <HOST_NAME> information_schema Execute <TIME> executing SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
2858+-<ID> test_user <HOST_NAME> information_schema Sleep <TIME> NULL
2859++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2860++<ID> test_user <HOST_NAME> information_schema Execute <TIME> executing SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST <TIME_MS>
2861++<ID> test_user <HOST_NAME> information_schema Sleep <TIME> NULL <TIME_MS>
2862+ SHOW FULL PROCESSLIST;
2863+ Id User Host db Command Time State Info
2864+ <ID> test_user <HOST_NAME> information_schema Sleep <TIME> NULL
2865+@@ -149,10 +150,10 @@
2866+ # Poll till connection con2 is in state 'User sleep'.
2867+
2868+ SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
2869+-ID USER HOST DB COMMAND TIME STATE INFO
2870+-<ID> test_user <HOST_NAME> information_schema Query <TIME> User sleep SELECT sleep(10), 17
2871+-<ID> test_user <HOST_NAME> information_schema Sleep <TIME> NULL
2872+-<ID> root <HOST_NAME> information_schema Execute <TIME> executing SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
2873++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2874++<ID> test_user <HOST_NAME> information_schema Query <TIME> User sleep SELECT sleep(10), 17 <TIME_MS>
2875++<ID> test_user <HOST_NAME> information_schema Sleep <TIME> NULL <TIME_MS>
2876++<ID> root <HOST_NAME> information_schema Execute <TIME> executing SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST <TIME_MS>
2877+ SHOW FULL PROCESSLIST;
2878+ Id User Host db Command Time State Info
2879+ <ID> root <HOST_NAME> information_schema Query <TIME> NULL SHOW FULL PROCESSLIST
2880+@@ -196,10 +197,10 @@
2881+ # Poll till INFO is no more NULL and State = 'Locked'.
2882+
2883+ SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
2884+-ID USER HOST DB COMMAND TIME STATE INFO
2885+-<ID> test_user <HOST_NAME> information_schema Query <TIME> Locked SELECT COUNT(*) FROM test.t1
2886+-<ID> test_user <HOST_NAME> information_schema Sleep <TIME> NULL
2887+-<ID> root <HOST_NAME> information_schema Execute <TIME> executing SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
2888++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2889++<ID> test_user <HOST_NAME> information_schema Query <TIME> Locked SELECT COUNT(*) FROM test.t1 <TIME_MS>
2890++<ID> test_user <HOST_NAME> information_schema Sleep <TIME> NULL <TIME_MS>
2891++<ID> root <HOST_NAME> information_schema Execute <TIME> executing SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST <TIME_MS>
2892+ UNLOCK TABLES;
2893+ # ----- switch to connection con2 (user = test_user) -----
2894+
2895+@@ -230,10 +231,10 @@
2896+ # SHOW PROCESSLIST statement truncated after 100 char
2897+
2898+ SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
2899+-ID USER HOST DB COMMAND TIME STATE INFO
2900+-<ID> test_user <HOST_NAME> information_schema <COMMAND> <TIME> <STATE> SELECT count(*),'BEGIN-This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.-END' AS "Long string" FROM test.t1
2901+-<ID> test_user <HOST_NAME> information_schema <COMMAND> <TIME> <STATE> NULL
2902+-<ID> root <HOST_NAME> information_schema <COMMAND> <TIME> <STATE> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
2903++ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2904++<ID> test_user <HOST_NAME> information_schema <COMMAND> <TIME> <STATE> SELECT count(*),'BEGIN-This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.-END' AS "Long string" FROM test.t1 101
2905++<ID> test_user <HOST_NAME> information_schema <COMMAND> <TIME> <STATE> NULL 10109
2906++<ID> root <HOST_NAME> information_schema <COMMAND> <TIME> <STATE> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST 0
2907+ SHOW FULL PROCESSLIST;
2908+ Id User Host db Command Time State Info
2909+ <ID> root <HOST_NAME> information_schema <COMMAND> <TIME> <STATE> SHOW FULL PROCESSLIST
2910+diff -Nur a/mysql-test/include/mtr_warnings.sql b/mysql-test/include/mtr_warnings.sql
2911+--- a/mysql-test/include/mtr_warnings.sql 2010-12-23 10:16:32.000000000 -0500
2912++++ b/mysql-test/include/mtr_warnings.sql 2010-12-23 11:07:57.000000000 -0500
2913+@@ -198,6 +198,9 @@
2914+ ("Slave I/O: Get master clock failed with error:.*"),
2915+ ("Slave I/O: Get master COLLATION_SERVER failed with error:.*"),
2916+ ("Slave I/O: Get master TIME_ZONE failed with error:.*"),
2917++
2918++ /* Suppress innodb_buffer_pool_shm_key warning */
2919++ ("InnoDB: Warning: The innodb_buffer_pool_shm_key option has been specified."),
2920+
2921+ ("THE_LAST_SUPPRESSION")||
2922+
2923+diff -Nur a/mysql-test/suite/funcs_1/datadict/processlist_val.inc b/mysql-test/suite/funcs_1/datadict/processlist_val.inc
2924+--- a/mysql-test/suite/funcs_1/datadict/processlist_val.inc 2010-12-27 13:21:19.206787175 +0000
2925++++ b/mysql-test/suite/funcs_1/datadict/processlist_val.inc 2010-12-27 13:42:44.225499888 +0000
2926+@@ -434,11 +434,11 @@
2927+ # SHOW FULL PROCESSLIST Complete statement
2928+ # SHOW PROCESSLIST statement truncated after 100 char
2929+ ;
2930+---replace_column 1 <ID> 3 <HOST_NAME> 5 <COMMAND> 6 <TIME> 7 <STATE>
2931++--replace_column 1 <ID> 3 <HOST_NAME> 5 <COMMAND> 6 <TIME> 7 <STATE> 9 <TIME_MS>
2932+ SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
2933+---replace_column 1 <ID> 3 <HOST_NAME> 5 <COMMAND> 6 <TIME> 7 <STATE>
2934++--replace_column 1 <ID> 3 <HOST_NAME> 5 <COMMAND> 6 <TIME> 7 <STATE> 9 <TIME_MS>
2935+ SHOW FULL PROCESSLIST;
2936+---replace_column 1 <ID> 3 <HOST_NAME> 5 <COMMAND> 6 <TIME> 7 <STATE>
2937++--replace_column 1 <ID> 3 <HOST_NAME> 5 <COMMAND> 6 <TIME> 7 <STATE> 9 <TIME_MS>
2938+ SHOW PROCESSLIST;
2939+ UNLOCK TABLES;
2940+ echo
2941+diff -Nur a/mysql-test/suite/funcs_1/r/processlist_val_ps.result b/mysql-test/suite/funcs_1/r/processlist_val_ps.result
2942+--- a/mysql-test/suite/funcs_1/r/processlist_val_ps.result 2010-12-27 13:21:15.327831609 +0000
2943++++ b/mysql-test/suite/funcs_1/r/processlist_val_ps.result 2010-12-27 13:43:06.142793567 +0000
2944+@@ -232,9 +232,9 @@
2945+
2946+ SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
2947+ ID USER HOST DB COMMAND TIME STATE INFO TIME_MS
2948+-<ID> test_user <HOST_NAME> information_schema <COMMAND> <TIME> <STATE> SELECT count(*),'BEGIN-This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.-END' AS "Long string" FROM test.t1 101
2949+-<ID> test_user <HOST_NAME> information_schema <COMMAND> <TIME> <STATE> NULL 10109
2950+-<ID> root <HOST_NAME> information_schema <COMMAND> <TIME> <STATE> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST 0
2951++<ID> test_user <HOST_NAME> information_schema <COMMAND> <TIME> <STATE> SELECT count(*),'BEGIN-This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.This is the representative of a very long statement.-END' AS "Long string" FROM test.t1 <TIME_MS>
2952++<ID> test_user <HOST_NAME> information_schema <COMMAND> <TIME> <STATE> NULL <TIME_MS>
2953++<ID> root <HOST_NAME> information_schema <COMMAND> <TIME> <STATE> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST <TIME_MS>
2954+ SHOW FULL PROCESSLIST;
2955+ Id User Host db Command Time State Info
2956+ <ID> root <HOST_NAME> information_schema <COMMAND> <TIME> <STATE> SHOW FULL PROCESSLIST
2957
2958=== modified file 'mysql-test/percona_innodb_buffer_pool_shm-master.opt'
2959--- mysql-test/percona_innodb_buffer_pool_shm-master.opt 2010-07-14 10:37:02 +0000
2960+++ mysql-test/percona_innodb_buffer_pool_shm-master.opt 2011-01-04 13:41:02 +0000
2961@@ -1,1 +1,2 @@
2962 --innodb_buffer_pool_shm_key=123456
2963+--innodb=FORCE
2964
2965=== modified file 'mysql-test/percona_innodb_buffer_pool_shm.result'
2966--- mysql-test/percona_innodb_buffer_pool_shm.result 2010-07-14 10:37:02 +0000
2967+++ mysql-test/percona_innodb_buffer_pool_shm.result 2011-01-04 13:41:02 +0000
2968@@ -1,6 +1,8 @@
2969 show variables like 'innodb_buffer_pool_shm%';
2970 Variable_name Value
2971+innodb_buffer_pool_shm_checksum ON
2972 innodb_buffer_pool_shm_key 123456
2973 show variables like 'innodb_buffer_pool_shm%';
2974 Variable_name Value
2975+innodb_buffer_pool_shm_checksum ON
2976 innodb_buffer_pool_shm_key 123456
2977
2978=== modified file 'mysql-test/percona_innodb_buffer_pool_shm.test'
2979--- mysql-test/percona_innodb_buffer_pool_shm.test 2010-07-14 10:37:02 +0000
2980+++ mysql-test/percona_innodb_buffer_pool_shm.test 2011-01-04 13:41:02 +0000
2981@@ -1,3 +1,4 @@
2982+--source include/big_test.inc
2983 --source include/have_innodb.inc
2984 show variables like 'innodb_buffer_pool_shm%';
2985
2986
2987=== modified file 'mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.result'
2988--- mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.result 2010-11-16 13:48:48 +0000
2989+++ mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.result 2011-01-04 13:41:02 +0000
2990@@ -13,7 +13,7 @@
2991 0
2992 SHOW SLAVE STATUS NOLOCK;
2993 Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master Master_SSL_Verify_Server_Cert Last_IO_Errno Last_IO_Error Last_SQL_Errno Last_SQL_Error
2994- host user port 1 master-bin.000001 276 slave-relay-bin.000003 422 master-bin.000001 No No 0 0 276 577 None 0 No NULL No 0 0
2995+<STATE> <HOST> <USER> <PORT> 1 master-bin.000001 276 slave-relay-bin.000003 422 master-bin.000001 Yes Yes 0 0 276 577 None 0 No 0 No 0 0
2996 select count(*) from t;
2997 count(*)
2998 0
2999
3000=== modified file 'mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.test'
3001--- mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.test 2010-12-14 19:45:37 +0000
3002+++ mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.test 2011-01-04 13:41:02 +0000
3003@@ -14,7 +14,7 @@
3004 send STOP SLAVE;
3005 connection slave1;
3006 select count(*) from t;
3007-replace_column 2 host 3 user 4 port;
3008+replace_column 1 <STATE> 2 <HOST> 3 <USER> 4 <PORT>;
3009 SHOW SLAVE STATUS NOLOCK;
3010 select count(*) from t;
3011

Subscribers

People subscribed via source and target branches

to all changes: