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

Merge lp:~tsarev/percona-server/5.1_fix_840218 into lp:percona-server/5.1

  1. 5.1_fix_840218
  2. Merge into 5.1
Proposed by Oleg Tsarev
Status: Merged
Approved by: Oleg Tsarev
Approved revision: no longer in the source branch.
Merged at revision: 281
Proposed branch: lp:~tsarev/percona-server/5.1_fix_840218
Merge into: lp:percona-server/5.1
Prerequisite: lp:~tsarev/percona-server/5.1_bug_838725_fix
Diff against target: 8110 lines (+3873/-3856)
65 files modified
Makefile (+1/-3)
install_tests (+0/-37)
mysql-test/have_nodebug.inc (+0/-4)
mysql-test/have_nodebug.require (+0/-2)
mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.result (+0/-28)
mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.test (+0/-61)
mysql-test/innodb_fix_misc_bug51325.result (+0/-13)
mysql-test/innodb_fix_misc_bug51325.test (+0/-13)
mysql-test/percona_innodb_buffer_pool_shm-master.opt (+0/-2)
mysql-test/percona_innodb_buffer_pool_shm.result (+0/-4)
mysql-test/percona_innodb_buffer_pool_shm.test (+0/-3)
mysql-test/percona_innodb_doublewrite_file-master.opt (+0/-1)
mysql-test/percona_innodb_doublewrite_file.result (+0/-4)
mysql-test/percona_innodb_doublewrite_file.test (+0/-2)
mysql-test/percona_innodb_use_sys_stats_table-master.opt (+0/-1)
mysql-test/percona_innodb_use_sys_stats_table.result (+0/-3)
mysql-test/percona_innodb_use_sys_stats_table.test (+0/-2)
mysql-test/percona_server_variables.inc (+0/-3)
mysql-test/percona_server_variables_debug.result (+0/-347)
mysql-test/percona_server_variables_debug.test (+0/-2)
mysql-test/percona_server_variables_release.result (+0/-344)
mysql-test/percona_server_variables_release.test (+0/-2)
mysql-test/percona_show_temp_tables.result (+0/-58)
mysql-test/percona_show_temp_tables.test (+0/-65)
mysql-test/percona_xtradb_admin_command.result (+0/-6)
mysql-test/percona_xtradb_admin_command.test (+0/-3)
mysql-test/percona_xtradb_bug317074.result (+0/-4)
mysql-test/percona_xtradb_bug317074.test (+0/-47)
mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc (+0/-95)
mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc.backup (+0/-88)
mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.result (+0/-866)
mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.test (+0/-5)
mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_begin.inc (+0/-12)
mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_clear.inc (+0/-5)
mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_crash.result (+0/-21)
mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_crash.test (+0/-22)
mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_disable.result (+0/-865)
mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_disable.test (+0/-3)
mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_end.inc (+0/-3)
mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_eval.inc (+0/-7)
mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_prepared_statements.result (+0/-396)
mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_prepared_statements.test (+0/-208)
mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_show.inc (+0/-8)
mysql-test/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.result (+0/-27)
mysql-test/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.test (+0/-37)
mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.result (+0/-21)
mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.test (+0/-50)
mysql-test/sql_no_fcache.patch/percona_sql_no_fcache.result (+0/-12)
mysql-test/sql_no_fcache.patch/percona_sql_no_fcache.test (+0/-11)
mysql-test/userstat_bug602047.result (+0/-16)
mysql-test/userstat_bug602047.test (+0/-13)
patches/innodb_admin_command_base.patch (+15/-0)
patches/innodb_buffer_pool_shm.patch (+18/-0)
patches/innodb_deadlock_count.patch (+95/-0)
patches/innodb_fix_misc.patch (+32/-0)
patches/innodb_separate_doublewrite.patch (+16/-0)
patches/innodb_show_sys_tables.patch (+15/-0)
patches/mysql-test.diff (+725/-1)
patches/query_cache_enhance.patch (+2628/-0)
patches/series (+1/-0)
patches/show_slave_status_nolock.patch (+77/-0)
patches/show_temp_51.patch (+129/-0)
patches/sql_no_fcache.patch (+29/-0)
patches/userstat.patch (+35/-0)
patches/xtradb_bug317074.patch (+57/-0)
To merge this branch: bzr merge lp:~tsarev/percona-server/5.1_fix_840218
Reviewer Review Type Date Requested Status
Laurynas Biveinis Pending
Review via email: mp+74177@code.launchpad.net

This proposal supersedes a proposal from 2011-09-03.

Description of the change

1) move tests from mysql-test/ to patches
2) remove install_tests script and call of script from Makefile

I checked by
export REV=280
rm -rf ${REV} && bzr update -r ${REV} && make all && mv Percona-Server-*-* ${REV}
export REV=281
rm -rf ${REV} && bzr update -r ${REV} && make all && mv Percona-Server-*-* ${REV}
diff -ruN 280 281 > 280_281.diff
wc -l 280_281.diff # should be zero

To post a comment you must log in.
Revision history for this message
Oleg Tsarev (tsarev) wrote : Posted in a previous version of this proposal

I checked by
bzr update -r 283 && make all && mv Percona-Server-*-* 283
bzr update -r 284 && make all && mv Percona-Server-*-* 284
diff -ruN 283 284

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote : Posted in a previous version of this proposal

LGTM, provided Jenkins testing is OK.

review: Approve
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote : Posted in a previous version of this proposal

On the second thought, "diff -ruN" testing is more than enough here.

Revision history for this message
Oleg Tsarev (tsarev) wrote :

http://jenkins.percona.com/view/Percona%20Server%205.1/job/percona-server-5.1-param/132/

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'Makefile'
2--- Makefile 2011-08-12 19:09:19 +0000
3+++ Makefile 2011-09-06 08:39:24 +0000
4@@ -6,7 +6,7 @@
5 PERCONA_SERVER_SHORT_1 ?=Percona-Server-$(MYSQL_VERSION)
6 PERCONA_SERVER_SHORT_2 ?=Percona-Server
7
8-all: main install-lic tests misc handlersocket maatkit-udf autorun
9+all: main install-lic misc handlersocket maatkit-udf autorun
10 @echo ""
11 @echo "Percona Server source code is ready"
12 @echo "Now change directory to $(PERCONA_SERVER) define variables as show below"
13@@ -56,8 +56,6 @@
14 @echo "Downloading MySQL sources from $(MASTER_SITE)"
15 $(FETCH_CMD) $(MASTER_SITE)/mysql-$(MYSQL_VERSION).tar.gz
16
17-tests:
18- PERCONA_SERVER=${PERCONA_SERVER} sh install_tests
19
20 misc:
21 @echo "Installing other files"
22
23=== removed file 'install_tests'
24--- install_tests 2011-07-27 10:28:37 +0000
25+++ install_tests 1970-01-01 00:00:00 +0000
26@@ -1,37 +0,0 @@
27-#!/bin/sh
28-
29-set -u
30-
31-MYSQL_VERSION="$(grep ^MYSQL_VERSION= "Makefile" \
32- | cut -d = -f 2)"
33-PERCONA_SERVER_VERSION="$(grep ^PERCONA_SERVER_VERSION= "Makefile" \
34- | cut -d = -f 2)"
35-PERCONA_SERVER="Percona-Server-${MYSQL_VERSION}-${PERCONA_SERVER_VERSION}"
36-
37-install_file_type()
38-{
39- for file in `ls $1/*.$2 2>/dev/null`; do
40- test -f $file && install -m 644 $file ${PERCONA_SERVER}/mysql-test/$3
41- done;
42-}
43-do_install_path()
44-{
45- install_file_type $1 test t
46- install_file_type $1 opt t
47- install_file_type $1 result r
48- install_file_type $1 require r
49- install_file_type $1 inc include
50-}
51-install_path()
52-{
53- echo "[$3/$4] Installing mysql-test files: $2"
54- test -d $1 && do_install_path $1 $2
55-}
56-current=0;
57-count=`wc -l patches/series`;
58-install_path mysql-test "global" $current $count
59-for test_name in `cat patches/series`; do
60- current=$((current+1));
61- install_path mysql-test/$test_name $test_name $current $count
62-done
63-echo "Done"
64
65=== removed directory 'mysql-test'
66=== removed file 'mysql-test/have_nodebug.inc'
67--- mysql-test/have_nodebug.inc 2011-06-23 02:21:00 +0000
68+++ mysql-test/have_nodebug.inc 1970-01-01 00:00:00 +0000
69@@ -1,4 +0,0 @@
70--- require r/have_nodebug.require
71-disable_query_log;
72-select (version() like '%debug%') as debug;
73-enable_query_log;
74
75=== removed file 'mysql-test/have_nodebug.require'
76--- mysql-test/have_nodebug.require 2011-06-23 02:21:00 +0000
77+++ mysql-test/have_nodebug.require 1970-01-01 00:00:00 +0000
78@@ -1,2 +0,0 @@
79-debug
80-0
81
82=== removed directory 'mysql-test/innodb_deadlock_count.patch'
83=== removed file 'mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.result'
84--- mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.result 2011-06-22 10:21:58 +0000
85+++ mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.result 1970-01-01 00:00:00 +0000
86@@ -1,28 +0,0 @@
87-# Establish connection con1 (user=root)
88-# Establish connection con2 (user=root)
89-# Establish connection con3 (user=root)
90-# Drop test table
91-drop table if exists t;
92-# Create test table
93-create table t(a INT PRIMARY KEY, b INT) engine=InnoDB;
94-# Insert two rows to test table
95-insert into t values(2,1);
96-insert into t values(1,2);
97-# Switch to connection con1
98-BEGIN;
99-SELECT b FROM t WHERE a=1 FOR UPDATE;
100-# Switch to connection con2
101-BEGIN;
102-SELECT b FROM t WHERE a=2 FOR UPDATE;
103-# Switch to connection con1
104-SELECT b FROM t WHERE a=2 FOR UPDATE;
105-# Switch to connection con2
106-SELECT b FROM t WHERE a=1 FOR UPDATE;
107-# Switch to connection con1
108-ROLLBACK;
109-# Switch to connection con2
110-ROLLBACK;
111-# Switch to connection con3
112-Deadlocks: 1
113-# Drop test table
114-drop table t;
115
116=== removed file 'mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.test'
117--- mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.test 2011-06-22 10:21:58 +0000
118+++ mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.test 1970-01-01 00:00:00 +0000
119@@ -1,61 +0,0 @@
120---source include/have_innodb.inc
121---echo # Establish connection con1 (user=root)
122-connect (con1,localhost,root,,);
123---echo # Establish connection con2 (user=root)
124-connect (con2,localhost,root,,);
125---echo # Establish connection con3 (user=root)
126-connect (con3,localhost,root,,);
127---echo # Drop test table
128---disable_warnings
129-drop table if exists t;
130---enable_warnings
131-
132---echo # Create test table
133-create table t(a INT PRIMARY KEY, b INT) engine=InnoDB;
134---echo # Insert two rows to test table
135-insert into t values(2,1);
136-insert into t values(1,2);
137-
138-#--echo # Save current deadlock count
139-let $current = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Innodb_deadlocks'`;
140-
141---disable_result_log
142-
143---echo # Switch to connection con1
144-connection con1;
145-BEGIN; SELECT b FROM t WHERE a=1 FOR UPDATE;
146-
147---echo # Switch to connection con2
148-connection con2;
149-BEGIN; SELECT b FROM t WHERE a=2 FOR UPDATE;
150-
151---echo # Switch to connection con1
152-connection con1;
153-SEND SELECT b FROM t WHERE a=2 FOR UPDATE;
154-
155---echo # Switch to connection con2
156-connection con2;
157-SEND SELECT b FROM t WHERE a=1 FOR UPDATE;
158-
159---echo # Switch to connection con1
160-connection con1;
161---error 0, ER_LOCK_DEADLOCK
162-reap;
163-ROLLBACK;
164-
165---echo # Switch to connection con2
166-connection con2;
167---error 0, ER_LOCK_DEADLOCK
168-reap;
169-ROLLBACK;
170-
171---echo # Switch to connection con3
172-connection con3;
173-let $result = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Innodb_deadlocks'`;
174-
175---enable_result_log
176-
177-let $diff = `SELECT $result - $current`;
178-echo Deadlocks: $diff;
179---echo # Drop test table
180-drop table t;
181
182=== removed file 'mysql-test/innodb_fix_misc_bug51325.result'
183--- mysql-test/innodb_fix_misc_bug51325.result 2011-05-25 15:11:57 +0000
184+++ mysql-test/innodb_fix_misc_bug51325.result 1970-01-01 00:00:00 +0000
185@@ -1,13 +0,0 @@
186-DROP TABLE IF EXISTS t1;
187-SET GLOBAL innodb_file_per_table=ON;
188-SHOW VARIABLES LIKE 'innodb_lazy_drop_table';
189-Variable_name Value
190-innodb_lazy_drop_table 0
191-SET GLOBAL innodb_lazy_drop_table=1;
192-SHOW VARIABLES LIKE 'innodb_lazy_drop_table';
193-Variable_name Value
194-innodb_lazy_drop_table 1
195-CREATE TABLE t1 (a INT) ENGINE=InnoDB;
196-DROP TABLE t1;
197-SET GLOBAL innodb_lazy_drop_table=default;
198-SET GLOBAL innodb_file_per_table=default;
199
200=== removed file 'mysql-test/innodb_fix_misc_bug51325.test'
201--- mysql-test/innodb_fix_misc_bug51325.test 2011-03-09 21:00:46 +0000
202+++ mysql-test/innodb_fix_misc_bug51325.test 1970-01-01 00:00:00 +0000
203@@ -1,13 +0,0 @@
204-# Test for 'innodb_lazy_drop_table' variable
205---source include/have_innodb.inc
206---disable_warnings
207-DROP TABLE IF EXISTS t1;
208---enable_warnings
209-SET GLOBAL innodb_file_per_table=ON;
210-SHOW VARIABLES LIKE 'innodb_lazy_drop_table';
211-SET GLOBAL innodb_lazy_drop_table=1;
212-SHOW VARIABLES LIKE 'innodb_lazy_drop_table';
213-CREATE TABLE t1 (a INT) ENGINE=InnoDB;
214-DROP TABLE t1;
215-SET GLOBAL innodb_lazy_drop_table=default;
216-SET GLOBAL innodb_file_per_table=default;
217
218=== removed file 'mysql-test/percona_innodb_buffer_pool_shm-master.opt'
219--- mysql-test/percona_innodb_buffer_pool_shm-master.opt 2010-12-28 17:35:28 +0000
220+++ mysql-test/percona_innodb_buffer_pool_shm-master.opt 1970-01-01 00:00:00 +0000
221@@ -1,2 +0,0 @@
222---innodb_buffer_pool_shm_key=123456
223---innodb=FORCE
224
225=== removed file 'mysql-test/percona_innodb_buffer_pool_shm.result'
226--- mysql-test/percona_innodb_buffer_pool_shm.result 2011-06-22 02:53:48 +0000
227+++ mysql-test/percona_innodb_buffer_pool_shm.result 1970-01-01 00:00:00 +0000
228@@ -1,4 +0,0 @@
229-show variables like 'innodb_buffer_pool_shm%';
230-Variable_name Value
231-innodb_buffer_pool_shm_checksum ON
232-innodb_buffer_pool_shm_key 123456
233
234=== removed file 'mysql-test/percona_innodb_buffer_pool_shm.test'
235--- mysql-test/percona_innodb_buffer_pool_shm.test 2011-06-22 02:53:48 +0000
236+++ mysql-test/percona_innodb_buffer_pool_shm.test 1970-01-01 00:00:00 +0000
237@@ -1,3 +0,0 @@
238---source include/have_innodb.inc
239-show variables like 'innodb_buffer_pool_shm%';
240-
241
242=== removed file 'mysql-test/percona_innodb_doublewrite_file-master.opt'
243--- mysql-test/percona_innodb_doublewrite_file-master.opt 2010-05-26 10:15:29 +0000
244+++ mysql-test/percona_innodb_doublewrite_file-master.opt 1970-01-01 00:00:00 +0000
245@@ -1,1 +0,0 @@
246---innodb_doublewrite_file=ib_doublewrite
247
248=== removed file 'mysql-test/percona_innodb_doublewrite_file.result'
249--- mysql-test/percona_innodb_doublewrite_file.result 2010-05-26 10:15:29 +0000
250+++ mysql-test/percona_innodb_doublewrite_file.result 1970-01-01 00:00:00 +0000
251@@ -1,4 +0,0 @@
252-show variables like 'innodb_doublewrite%';
253-Variable_name Value
254-innodb_doublewrite ON
255-innodb_doublewrite_file ib_doublewrite
256
257=== removed file 'mysql-test/percona_innodb_doublewrite_file.test'
258--- mysql-test/percona_innodb_doublewrite_file.test 2010-05-26 10:15:29 +0000
259+++ mysql-test/percona_innodb_doublewrite_file.test 1970-01-01 00:00:00 +0000
260@@ -1,2 +0,0 @@
261---source include/have_innodb.inc
262-show variables like 'innodb_doublewrite%';
263
264=== removed file 'mysql-test/percona_innodb_use_sys_stats_table-master.opt'
265--- mysql-test/percona_innodb_use_sys_stats_table-master.opt 2010-07-06 08:20:44 +0000
266+++ mysql-test/percona_innodb_use_sys_stats_table-master.opt 1970-01-01 00:00:00 +0000
267@@ -1,1 +0,0 @@
268---innodb_use_sys_stats_table
269
270=== removed file 'mysql-test/percona_innodb_use_sys_stats_table.result'
271--- mysql-test/percona_innodb_use_sys_stats_table.result 2010-07-06 08:20:44 +0000
272+++ mysql-test/percona_innodb_use_sys_stats_table.result 1970-01-01 00:00:00 +0000
273@@ -1,3 +0,0 @@
274-show variables like 'innodb_use_sys_stats%';
275-Variable_name Value
276-innodb_use_sys_stats_table ON
277
278=== removed file 'mysql-test/percona_innodb_use_sys_stats_table.test'
279--- mysql-test/percona_innodb_use_sys_stats_table.test 2010-07-06 08:20:44 +0000
280+++ mysql-test/percona_innodb_use_sys_stats_table.test 1970-01-01 00:00:00 +0000
281@@ -1,2 +0,0 @@
282---source include/have_innodb.inc
283-show variables like 'innodb_use_sys_stats%';
284
285=== removed file 'mysql-test/percona_server_variables.inc'
286--- mysql-test/percona_server_variables.inc 2011-06-23 02:21:00 +0000
287+++ mysql-test/percona_server_variables.inc 1970-01-01 00:00:00 +0000
288@@ -1,3 +0,0 @@
289---source include/have_response_time_distribution.inc
290---source include/have_innodb.inc
291-SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
292
293=== removed file 'mysql-test/percona_server_variables_debug.result'
294--- mysql-test/percona_server_variables_debug.result 2011-07-30 22:04:31 +0000
295+++ mysql-test/percona_server_variables_debug.result 1970-01-01 00:00:00 +0000
296@@ -1,347 +0,0 @@
297-SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
298-Variable_name
299-AUTOCOMMIT
300-AUTOMATIC_SP_PRIVILEGES
301-AUTO_INCREMENT_INCREMENT
302-AUTO_INCREMENT_OFFSET
303-BACK_LOG
304-BASEDIR
305-BIG_TABLES
306-BINLOG_CACHE_SIZE
307-BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES
308-BINLOG_FORMAT
309-BULK_INSERT_BUFFER_SIZE
310-CHARACTER_SETS_DIR
311-CHARACTER_SET_CLIENT
312-CHARACTER_SET_CONNECTION
313-CHARACTER_SET_DATABASE
314-CHARACTER_SET_FILESYSTEM
315-CHARACTER_SET_RESULTS
316-CHARACTER_SET_SERVER
317-CHARACTER_SET_SYSTEM
318-COLLATION_CONNECTION
319-COLLATION_DATABASE
320-COLLATION_SERVER
321-COMPLETION_TYPE
322-CONCURRENT_INSERT
323-CONNECT_TIMEOUT
324-DATADIR
325-DATETIME_FORMAT
326-DATE_FORMAT
327-DEBUG
328-DEBUG_SYNC
329-DEFAULT_WEEK_FORMAT
330-DELAYED_INSERT_LIMIT
331-DELAYED_INSERT_TIMEOUT
332-DELAYED_QUEUE_SIZE
333-DELAY_KEY_WRITE
334-DIV_PRECISION_INCREMENT
335-ENABLE_QUERY_RESPONSE_TIME_STATS
336-ENGINE_CONDITION_PUSHDOWN
337-ERROR_COUNT
338-EVENT_SCHEDULER
339-EXPIRE_LOGS_DAYS
340-FAST_INDEX_CREATION
341-FLUSH
342-FLUSH_TIME
343-FOREIGN_KEY_CHECKS
344-FT_BOOLEAN_SYNTAX
345-FT_MAX_WORD_LEN
346-FT_MIN_WORD_LEN
347-FT_QUERY_EXPANSION_LIMIT
348-FT_STOPWORD_FILE
349-GENERAL_LOG
350-GENERAL_LOG_FILE
351-GROUP_CONCAT_MAX_LEN
352-HAVE_COMMUNITY_FEATURES
353-HAVE_COMPRESS
354-HAVE_CRYPT
355-HAVE_CSV
356-HAVE_DYNAMIC_LOADING
357-HAVE_GEOMETRY
358-HAVE_INNODB
359-HAVE_NDBCLUSTER
360-HAVE_OPENSSL
361-HAVE_PARTITIONING
362-HAVE_QUERY_CACHE
363-HAVE_RESPONSE_TIME_DISTRIBUTION
364-HAVE_RTREE_KEYS
365-HAVE_SSL
366-HAVE_SYMLINK
367-HOSTNAME
368-IDENTITY
369-IGNORE_BUILTIN_INNODB
370-INIT_CONNECT
371-INIT_FILE
372-INIT_SLAVE
373-INNODB_ADAPTIVE_CHECKPOINT
374-INNODB_ADAPTIVE_FLUSHING
375-INNODB_ADAPTIVE_HASH_INDEX
376-INNODB_ADDITIONAL_MEM_POOL_SIZE
377-INNODB_AUTOEXTEND_INCREMENT
378-INNODB_AUTOINC_LOCK_MODE
379-INNODB_AUTO_LRU_DUMP
380-INNODB_BUFFER_POOL_SHM_CHECKSUM
381-INNODB_BUFFER_POOL_SHM_KEY
382-INNODB_BUFFER_POOL_SIZE
383-INNODB_CHANGE_BUFFERING
384-INNODB_CHECKPOINT_AGE_TARGET
385-INNODB_CHECKSUMS
386-INNODB_COMMIT_CONCURRENCY
387-INNODB_CONCURRENCY_TICKETS
388-INNODB_DATA_FILE_PATH
389-INNODB_DATA_HOME_DIR
390-INNODB_DICT_SIZE_LIMIT
391-INNODB_DOUBLEWRITE
392-INNODB_DOUBLEWRITE_FILE
393-INNODB_ENABLE_UNSAFE_GROUP_COMMIT
394-INNODB_EXPAND_IMPORT
395-INNODB_EXTRA_RSEGMENTS
396-INNODB_EXTRA_UNDOSLOTS
397-INNODB_FAST_CHECKSUM
398-INNODB_FAST_RECOVERY
399-INNODB_FAST_SHUTDOWN
400-INNODB_FILE_FORMAT
401-INNODB_FILE_FORMAT_CHECK
402-INNODB_FILE_PER_TABLE
403-INNODB_FLUSH_LOG_AT_TRX_COMMIT
404-INNODB_FLUSH_LOG_AT_TRX_COMMIT_SESSION
405-INNODB_FLUSH_METHOD
406-INNODB_FLUSH_NEIGHBOR_PAGES
407-INNODB_FORCE_RECOVERY
408-INNODB_IBUF_ACCEL_RATE
409-INNODB_IBUF_ACTIVE_CONTRACT
410-INNODB_IBUF_MAX_SIZE
411-INNODB_IO_CAPACITY
412-INNODB_LAZY_DROP_TABLE
413-INNODB_LOCKS_UNSAFE_FOR_BINLOG
414-INNODB_LOCK_WAIT_TIMEOUT
415-INNODB_LOG_BLOCK_SIZE
416-INNODB_LOG_BUFFER_SIZE
417-INNODB_LOG_FILES_IN_GROUP
418-INNODB_LOG_FILE_SIZE
419-INNODB_LOG_GROUP_HOME_DIR
420-INNODB_MAX_DIRTY_PAGES_PCT
421-INNODB_MAX_PURGE_LAG
422-INNODB_MIRRORED_LOG_GROUPS
423-INNODB_OLD_BLOCKS_PCT
424-INNODB_OLD_BLOCKS_TIME
425-INNODB_OPEN_FILES
426-INNODB_OVERWRITE_RELAY_LOG_INFO
427-INNODB_PAGE_SIZE
428-INNODB_PASS_CORRUPT_TABLE
429-INNODB_READ_AHEAD
430-INNODB_READ_AHEAD_THRESHOLD
431-INNODB_READ_IO_THREADS
432-INNODB_RECOVERY_STATS
433-INNODB_REPLICATION_DELAY
434-INNODB_ROLLBACK_ON_TIMEOUT
435-INNODB_SHOW_LOCKS_HELD
436-INNODB_SHOW_VERBOSE_LOCKS
437-INNODB_SPIN_WAIT_DELAY
438-INNODB_STATS_AUTO_UPDATE
439-INNODB_STATS_METHOD
440-INNODB_STATS_ON_METADATA
441-INNODB_STATS_SAMPLE_PAGES
442-INNODB_STATS_UPDATE_NEED_LOCK
443-INNODB_STRICT_MODE
444-INNODB_SUPPORT_XA
445-INNODB_SYNC_SPIN_LOOPS
446-INNODB_TABLE_LOCKS
447-INNODB_THREAD_CONCURRENCY
448-INNODB_THREAD_CONCURRENCY_TIMER_BASED
449-INNODB_THREAD_SLEEP_DELAY
450-INNODB_USE_PURGE_THREAD
451-INNODB_USE_SYS_MALLOC
452-INNODB_USE_SYS_STATS_TABLE
453-INNODB_VERSION
454-INNODB_WRITE_IO_THREADS
455-INSERT_ID
456-INTERACTIVE_TIMEOUT
457-JOIN_BUFFER_SIZE
458-KEEP_FILES_ON_CREATE
459-KEY_BUFFER_SIZE
460-KEY_CACHE_AGE_THRESHOLD
461-KEY_CACHE_BLOCK_SIZE
462-KEY_CACHE_DIVISION_LIMIT
463-LANGUAGE
464-LARGE_FILES_SUPPORT
465-LARGE_PAGES
466-LARGE_PAGE_SIZE
467-LAST_INSERT_ID
468-LC_TIME_NAMES
469-LICENSE
470-LOCAL_INFILE
471-LOCKED_IN_MEMORY
472-LOG
473-LOG_BIN
474-LOG_BIN_TRUST_FUNCTION_CREATORS
475-LOG_BIN_TRUST_ROUTINE_CREATORS
476-LOG_ERROR
477-LOG_OUTPUT
478-LOG_QUERIES_NOT_USING_INDEXES
479-LOG_SLAVE_UPDATES
480-LOG_SLOW_FILTER
481-LOG_SLOW_QUERIES
482-LOG_SLOW_RATE_LIMIT
483-LOG_SLOW_SLAVE_STATEMENTS
484-LOG_SLOW_SP_STATEMENTS
485-LOG_SLOW_TIMESTAMP_EVERY
486-LOG_SLOW_VERBOSITY
487-LOG_WARNINGS
488-LONG_QUERY_TIME
489-LOWER_CASE_FILE_SYSTEM
490-LOWER_CASE_TABLE_NAMES
491-LOW_PRIORITY_UPDATES
492-MAX_ALLOWED_PACKET
493-MAX_BINLOG_CACHE_SIZE
494-MAX_BINLOG_SIZE
495-MAX_CONNECTIONS
496-MAX_CONNECT_ERRORS
497-MAX_DELAYED_THREADS
498-MAX_ERROR_COUNT
499-MAX_HEAP_TABLE_SIZE
500-MAX_INSERT_DELAYED_THREADS
501-MAX_JOIN_SIZE
502-MAX_LENGTH_FOR_SORT_DATA
503-MAX_LONG_DATA_SIZE
504-MAX_PREPARED_STMT_COUNT
505-MAX_RELAY_LOG_SIZE
506-MAX_SEEKS_FOR_KEY
507-MAX_SORT_LENGTH
508-MAX_SP_RECURSION_DEPTH
509-MAX_TMP_TABLES
510-MAX_USER_CONNECTIONS
511-MAX_WRITE_LOCK_COUNT
512-MIN_EXAMINED_ROW_LIMIT
513-MULTI_RANGE_COUNT
514-MYISAM_DATA_POINTER_SIZE
515-MYISAM_MAX_SORT_FILE_SIZE
516-MYISAM_MMAP_SIZE
517-MYISAM_RECOVER_OPTIONS
518-MYISAM_REPAIR_THREADS
519-MYISAM_SORT_BUFFER_SIZE
520-MYISAM_STATS_METHOD
521-MYISAM_USE_MMAP
522-NET_BUFFER_LENGTH
523-NET_READ_TIMEOUT
524-NET_RETRY_COUNT
525-NET_WRITE_TIMEOUT
526-NEW
527-OLD
528-OLD_ALTER_TABLE
529-OLD_PASSWORDS
530-OPEN_FILES_LIMIT
531-OPTIMIZER_FIX
532-OPTIMIZER_PRUNE_LEVEL
533-OPTIMIZER_SEARCH_DEPTH
534-OPTIMIZER_SWITCH
535-PID_FILE
536-PLUGIN_DIR
537-PORT
538-PRELOAD_BUFFER_SIZE
539-PROFILING
540-PROFILING_HISTORY_SIZE
541-PROFILING_SERVER
542-PROFILING_USE_GETRUSAGE
543-PROTOCOL_VERSION
544-PSEUDO_THREAD_ID
545-QUERY_ALLOC_BLOCK_SIZE
546-QUERY_CACHE_LIMIT
547-QUERY_CACHE_MIN_RES_UNIT
548-QUERY_CACHE_SIZE
549-QUERY_CACHE_STRIP_COMMENTS
550-QUERY_CACHE_TYPE
551-QUERY_CACHE_WLOCK_INVALIDATE
552-QUERY_EXEC_TIME
553-QUERY_PREALLOC_SIZE
554-QUERY_RESPONSE_TIME_RANGE_BASE
555-RAND_SEED1
556-RAND_SEED2
557-RANGE_ALLOC_BLOCK_SIZE
558-READ_BUFFER_SIZE
559-READ_ONLY
560-READ_RND_BUFFER_SIZE
561-RELAY_LOG
562-RELAY_LOG_INDEX
563-RELAY_LOG_INFO_FILE
564-RELAY_LOG_PURGE
565-RELAY_LOG_SPACE_LIMIT
566-REPORT_HOST
567-REPORT_PASSWORD
568-REPORT_PORT
569-REPORT_USER
570-RPL_RECOVERY_RANK
571-SECURE_AUTH
572-SECURE_FILE_PRIV
573-SERVER_ID
574-SKIP_EXTERNAL_LOCKING
575-SKIP_NAME_RESOLVE
576-SKIP_NETWORKING
577-SKIP_SHOW_DATABASE
578-SLAVE_COMPRESSED_PROTOCOL
579-SLAVE_EXEC_MODE
580-SLAVE_LOAD_TMPDIR
581-SLAVE_NET_TIMEOUT
582-SLAVE_SKIP_ERRORS
583-SLAVE_TRANSACTION_RETRIES
584-SLOW_LAUNCH_TIME
585-SLOW_QUERY_LOG
586-SLOW_QUERY_LOG_FILE
587-SLOW_QUERY_LOG_MICROSECONDS_TIMESTAMP
588-SOCKET
589-SORT_BUFFER_SIZE
590-SQL_AUTO_IS_NULL
591-SQL_BIG_SELECTS
592-SQL_BIG_TABLES
593-SQL_BUFFER_RESULT
594-SQL_LOG_BIN
595-SQL_LOG_OFF
596-SQL_LOG_UPDATE
597-SQL_LOW_PRIORITY_UPDATES
598-SQL_MAX_JOIN_SIZE
599-SQL_MODE
600-SQL_NOTES
601-SQL_QUOTE_SHOW_CREATE
602-SQL_SAFE_UPDATES
603-SQL_SELECT_LIMIT
604-SQL_SLAVE_SKIP_COUNTER
605-SQL_WARNINGS
606-SSL_CA
607-SSL_CAPATH
608-SSL_CERT
609-SSL_CIPHER
610-SSL_KEY
611-STORAGE_ENGINE
612-SUPPRESS_LOG_WARNING_1592
613-SYNC_BINLOG
614-SYNC_FRM
615-SYSTEM_TIME_ZONE
616-TABLE_DEFINITION_CACHE
617-TABLE_LOCK_WAIT_TIMEOUT
618-TABLE_OPEN_CACHE
619-TABLE_TYPE
620-THREAD_CACHE_SIZE
621-THREAD_HANDLING
622-THREAD_STACK
623-THREAD_STATISTICS
624-TIMED_MUTEXES
625-TIMESTAMP
626-TIME_FORMAT
627-TIME_ZONE
628-TMPDIR
629-TMP_TABLE_SIZE
630-TRANSACTION_ALLOC_BLOCK_SIZE
631-TRANSACTION_PREALLOC_SIZE
632-TX_ISOLATION
633-UNIQUE_CHECKS
634-UPDATABLE_VIEWS_WITH_LIMIT
635-USERSTAT_RUNNING
636-USE_GLOBAL_LOG_SLOW_CONTROL
637-USE_GLOBAL_LONG_QUERY_TIME
638-VERSION
639-VERSION_COMMENT
640-VERSION_COMPILE_MACHINE
641-VERSION_COMPILE_OS
642-WAIT_TIMEOUT
643-WARNING_COUNT
644
645=== removed file 'mysql-test/percona_server_variables_debug.test'
646--- mysql-test/percona_server_variables_debug.test 2011-06-23 02:21:00 +0000
647+++ mysql-test/percona_server_variables_debug.test 1970-01-01 00:00:00 +0000
648@@ -1,2 +0,0 @@
649---source include/have_debug.inc
650---source include/percona_server_variables.inc
651
652=== removed file 'mysql-test/percona_server_variables_release.result'
653--- mysql-test/percona_server_variables_release.result 2011-07-28 18:07:09 +0000
654+++ mysql-test/percona_server_variables_release.result 1970-01-01 00:00:00 +0000
655@@ -1,344 +0,0 @@
656-SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
657-Variable_name
658-AUTOCOMMIT
659-AUTOMATIC_SP_PRIVILEGES
660-AUTO_INCREMENT_INCREMENT
661-AUTO_INCREMENT_OFFSET
662-BACK_LOG
663-BASEDIR
664-BIG_TABLES
665-BINLOG_CACHE_SIZE
666-BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES
667-BINLOG_FORMAT
668-BULK_INSERT_BUFFER_SIZE
669-CHARACTER_SETS_DIR
670-CHARACTER_SET_CLIENT
671-CHARACTER_SET_CONNECTION
672-CHARACTER_SET_DATABASE
673-CHARACTER_SET_FILESYSTEM
674-CHARACTER_SET_RESULTS
675-CHARACTER_SET_SERVER
676-CHARACTER_SET_SYSTEM
677-COLLATION_CONNECTION
678-COLLATION_DATABASE
679-COLLATION_SERVER
680-COMPLETION_TYPE
681-CONCURRENT_INSERT
682-CONNECT_TIMEOUT
683-DATADIR
684-DATETIME_FORMAT
685-DATE_FORMAT
686-DEFAULT_WEEK_FORMAT
687-DELAYED_INSERT_LIMIT
688-DELAYED_INSERT_TIMEOUT
689-DELAYED_QUEUE_SIZE
690-DELAY_KEY_WRITE
691-DIV_PRECISION_INCREMENT
692-ENABLE_QUERY_RESPONSE_TIME_STATS
693-ENGINE_CONDITION_PUSHDOWN
694-ERROR_COUNT
695-EVENT_SCHEDULER
696-EXPIRE_LOGS_DAYS
697-FAST_INDEX_CREATION
698-FLUSH
699-FLUSH_TIME
700-FOREIGN_KEY_CHECKS
701-FT_BOOLEAN_SYNTAX
702-FT_MAX_WORD_LEN
703-FT_MIN_WORD_LEN
704-FT_QUERY_EXPANSION_LIMIT
705-FT_STOPWORD_FILE
706-GENERAL_LOG
707-GENERAL_LOG_FILE
708-GROUP_CONCAT_MAX_LEN
709-HAVE_COMMUNITY_FEATURES
710-HAVE_COMPRESS
711-HAVE_CRYPT
712-HAVE_CSV
713-HAVE_DYNAMIC_LOADING
714-HAVE_GEOMETRY
715-HAVE_INNODB
716-HAVE_NDBCLUSTER
717-HAVE_OPENSSL
718-HAVE_PARTITIONING
719-HAVE_QUERY_CACHE
720-HAVE_RESPONSE_TIME_DISTRIBUTION
721-HAVE_RTREE_KEYS
722-HAVE_SSL
723-HAVE_SYMLINK
724-HOSTNAME
725-IDENTITY
726-IGNORE_BUILTIN_INNODB
727-INIT_CONNECT
728-INIT_FILE
729-INIT_SLAVE
730-INNODB_ADAPTIVE_CHECKPOINT
731-INNODB_ADAPTIVE_FLUSHING
732-INNODB_ADAPTIVE_HASH_INDEX
733-INNODB_ADDITIONAL_MEM_POOL_SIZE
734-INNODB_AUTOEXTEND_INCREMENT
735-INNODB_AUTOINC_LOCK_MODE
736-INNODB_AUTO_LRU_DUMP
737-INNODB_BUFFER_POOL_SHM_CHECKSUM
738-INNODB_BUFFER_POOL_SHM_KEY
739-INNODB_BUFFER_POOL_SIZE
740-INNODB_CHANGE_BUFFERING
741-INNODB_CHECKPOINT_AGE_TARGET
742-INNODB_CHECKSUMS
743-INNODB_COMMIT_CONCURRENCY
744-INNODB_CONCURRENCY_TICKETS
745-INNODB_DATA_FILE_PATH
746-INNODB_DATA_HOME_DIR
747-INNODB_DICT_SIZE_LIMIT
748-INNODB_DOUBLEWRITE
749-INNODB_DOUBLEWRITE_FILE
750-INNODB_ENABLE_UNSAFE_GROUP_COMMIT
751-INNODB_EXPAND_IMPORT
752-INNODB_EXTRA_RSEGMENTS
753-INNODB_EXTRA_UNDOSLOTS
754-INNODB_FAST_CHECKSUM
755-INNODB_FAST_RECOVERY
756-INNODB_FAST_SHUTDOWN
757-INNODB_FILE_FORMAT
758-INNODB_FILE_FORMAT_CHECK
759-INNODB_FILE_PER_TABLE
760-INNODB_FLUSH_LOG_AT_TRX_COMMIT
761-INNODB_FLUSH_LOG_AT_TRX_COMMIT_SESSION
762-INNODB_FLUSH_METHOD
763-INNODB_FLUSH_NEIGHBOR_PAGES
764-INNODB_FORCE_RECOVERY
765-INNODB_IBUF_ACCEL_RATE
766-INNODB_IBUF_ACTIVE_CONTRACT
767-INNODB_IBUF_MAX_SIZE
768-INNODB_IO_CAPACITY
769-INNODB_LAZY_DROP_TABLE
770-INNODB_LOCKS_UNSAFE_FOR_BINLOG
771-INNODB_LOCK_WAIT_TIMEOUT
772-INNODB_LOG_BLOCK_SIZE
773-INNODB_LOG_BUFFER_SIZE
774-INNODB_LOG_FILES_IN_GROUP
775-INNODB_LOG_FILE_SIZE
776-INNODB_LOG_GROUP_HOME_DIR
777-INNODB_MAX_DIRTY_PAGES_PCT
778-INNODB_MAX_PURGE_LAG
779-INNODB_MIRRORED_LOG_GROUPS
780-INNODB_OLD_BLOCKS_PCT
781-INNODB_OLD_BLOCKS_TIME
782-INNODB_OPEN_FILES
783-INNODB_OVERWRITE_RELAY_LOG_INFO
784-INNODB_PAGE_SIZE
785-INNODB_PASS_CORRUPT_TABLE
786-INNODB_READ_AHEAD
787-INNODB_READ_AHEAD_THRESHOLD
788-INNODB_READ_IO_THREADS
789-INNODB_RECOVERY_STATS
790-INNODB_REPLICATION_DELAY
791-INNODB_ROLLBACK_ON_TIMEOUT
792-INNODB_SHOW_LOCKS_HELD
793-INNODB_SHOW_VERBOSE_LOCKS
794-INNODB_SPIN_WAIT_DELAY
795-INNODB_STATS_AUTO_UPDATE
796-INNODB_STATS_METHOD
797-INNODB_STATS_ON_METADATA
798-INNODB_STATS_SAMPLE_PAGES
799-INNODB_STATS_UPDATE_NEED_LOCK
800-INNODB_STRICT_MODE
801-INNODB_SUPPORT_XA
802-INNODB_SYNC_SPIN_LOOPS
803-INNODB_TABLE_LOCKS
804-INNODB_THREAD_CONCURRENCY
805-INNODB_THREAD_CONCURRENCY_TIMER_BASED
806-INNODB_THREAD_SLEEP_DELAY
807-INNODB_USE_PURGE_THREAD
808-INNODB_USE_SYS_MALLOC
809-INNODB_USE_SYS_STATS_TABLE
810-INNODB_VERSION
811-INNODB_WRITE_IO_THREADS
812-INSERT_ID
813-INTERACTIVE_TIMEOUT
814-JOIN_BUFFER_SIZE
815-KEEP_FILES_ON_CREATE
816-KEY_BUFFER_SIZE
817-KEY_CACHE_AGE_THRESHOLD
818-KEY_CACHE_BLOCK_SIZE
819-KEY_CACHE_DIVISION_LIMIT
820-LANGUAGE
821-LARGE_FILES_SUPPORT
822-LARGE_PAGES
823-LARGE_PAGE_SIZE
824-LAST_INSERT_ID
825-LC_TIME_NAMES
826-LICENSE
827-LOCAL_INFILE
828-LOCKED_IN_MEMORY
829-LOG
830-LOG_BIN
831-LOG_BIN_TRUST_FUNCTION_CREATORS
832-LOG_BIN_TRUST_ROUTINE_CREATORS
833-LOG_ERROR
834-LOG_OUTPUT
835-LOG_QUERIES_NOT_USING_INDEXES
836-LOG_SLAVE_UPDATES
837-LOG_SLOW_FILTER
838-LOG_SLOW_QUERIES
839-LOG_SLOW_RATE_LIMIT
840-LOG_SLOW_SLAVE_STATEMENTS
841-LOG_SLOW_SP_STATEMENTS
842-LOG_SLOW_TIMESTAMP_EVERY
843-LOG_SLOW_VERBOSITY
844-LOG_WARNINGS
845-LONG_QUERY_TIME
846-LOWER_CASE_FILE_SYSTEM
847-LOWER_CASE_TABLE_NAMES
848-LOW_PRIORITY_UPDATES
849-MAX_ALLOWED_PACKET
850-MAX_BINLOG_CACHE_SIZE
851-MAX_BINLOG_SIZE
852-MAX_CONNECTIONS
853-MAX_CONNECT_ERRORS
854-MAX_DELAYED_THREADS
855-MAX_ERROR_COUNT
856-MAX_HEAP_TABLE_SIZE
857-MAX_INSERT_DELAYED_THREADS
858-MAX_JOIN_SIZE
859-MAX_LENGTH_FOR_SORT_DATA
860-MAX_LONG_DATA_SIZE
861-MAX_PREPARED_STMT_COUNT
862-MAX_RELAY_LOG_SIZE
863-MAX_SEEKS_FOR_KEY
864-MAX_SORT_LENGTH
865-MAX_SP_RECURSION_DEPTH
866-MAX_TMP_TABLES
867-MAX_USER_CONNECTIONS
868-MAX_WRITE_LOCK_COUNT
869-MIN_EXAMINED_ROW_LIMIT
870-MULTI_RANGE_COUNT
871-MYISAM_DATA_POINTER_SIZE
872-MYISAM_MAX_SORT_FILE_SIZE
873-MYISAM_MMAP_SIZE
874-MYISAM_RECOVER_OPTIONS
875-MYISAM_REPAIR_THREADS
876-MYISAM_SORT_BUFFER_SIZE
877-MYISAM_STATS_METHOD
878-MYISAM_USE_MMAP
879-NET_BUFFER_LENGTH
880-NET_READ_TIMEOUT
881-NET_RETRY_COUNT
882-NET_WRITE_TIMEOUT
883-NEW
884-OLD
885-OLD_ALTER_TABLE
886-OLD_PASSWORDS
887-OPEN_FILES_LIMIT
888-OPTIMIZER_FIX
889-OPTIMIZER_PRUNE_LEVEL
890-OPTIMIZER_SEARCH_DEPTH
891-OPTIMIZER_SWITCH
892-PID_FILE
893-PLUGIN_DIR
894-PORT
895-PRELOAD_BUFFER_SIZE
896-PROFILING
897-PROFILING_HISTORY_SIZE
898-PROFILING_SERVER
899-PROFILING_USE_GETRUSAGE
900-PROTOCOL_VERSION
901-PSEUDO_THREAD_ID
902-QUERY_ALLOC_BLOCK_SIZE
903-QUERY_CACHE_LIMIT
904-QUERY_CACHE_MIN_RES_UNIT
905-QUERY_CACHE_SIZE
906-QUERY_CACHE_STRIP_COMMENTS
907-QUERY_CACHE_TYPE
908-QUERY_CACHE_WLOCK_INVALIDATE
909-QUERY_PREALLOC_SIZE
910-QUERY_RESPONSE_TIME_RANGE_BASE
911-RAND_SEED1
912-RAND_SEED2
913-RANGE_ALLOC_BLOCK_SIZE
914-READ_BUFFER_SIZE
915-READ_ONLY
916-READ_RND_BUFFER_SIZE
917-RELAY_LOG
918-RELAY_LOG_INDEX
919-RELAY_LOG_INFO_FILE
920-RELAY_LOG_PURGE
921-RELAY_LOG_SPACE_LIMIT
922-REPORT_HOST
923-REPORT_PASSWORD
924-REPORT_PORT
925-REPORT_USER
926-RPL_RECOVERY_RANK
927-SECURE_AUTH
928-SECURE_FILE_PRIV
929-SERVER_ID
930-SKIP_EXTERNAL_LOCKING
931-SKIP_NAME_RESOLVE
932-SKIP_NETWORKING
933-SKIP_SHOW_DATABASE
934-SLAVE_COMPRESSED_PROTOCOL
935-SLAVE_EXEC_MODE
936-SLAVE_LOAD_TMPDIR
937-SLAVE_NET_TIMEOUT
938-SLAVE_SKIP_ERRORS
939-SLAVE_TRANSACTION_RETRIES
940-SLOW_LAUNCH_TIME
941-SLOW_QUERY_LOG
942-SLOW_QUERY_LOG_FILE
943-SLOW_QUERY_LOG_MICROSECONDS_TIMESTAMP
944-SOCKET
945-SORT_BUFFER_SIZE
946-SQL_AUTO_IS_NULL
947-SQL_BIG_SELECTS
948-SQL_BIG_TABLES
949-SQL_BUFFER_RESULT
950-SQL_LOG_BIN
951-SQL_LOG_OFF
952-SQL_LOG_UPDATE
953-SQL_LOW_PRIORITY_UPDATES
954-SQL_MAX_JOIN_SIZE
955-SQL_MODE
956-SQL_NOTES
957-SQL_QUOTE_SHOW_CREATE
958-SQL_SAFE_UPDATES
959-SQL_SELECT_LIMIT
960-SQL_SLAVE_SKIP_COUNTER
961-SQL_WARNINGS
962-SSL_CA
963-SSL_CAPATH
964-SSL_CERT
965-SSL_CIPHER
966-SSL_KEY
967-STORAGE_ENGINE
968-SUPPRESS_LOG_WARNING_1592
969-SYNC_BINLOG
970-SYNC_FRM
971-SYSTEM_TIME_ZONE
972-TABLE_DEFINITION_CACHE
973-TABLE_LOCK_WAIT_TIMEOUT
974-TABLE_OPEN_CACHE
975-TABLE_TYPE
976-THREAD_CACHE_SIZE
977-THREAD_HANDLING
978-THREAD_STACK
979-THREAD_STATISTICS
980-TIMED_MUTEXES
981-TIMESTAMP
982-TIME_FORMAT
983-TIME_ZONE
984-TMPDIR
985-TMP_TABLE_SIZE
986-TRANSACTION_ALLOC_BLOCK_SIZE
987-TRANSACTION_PREALLOC_SIZE
988-TX_ISOLATION
989-UNIQUE_CHECKS
990-UPDATABLE_VIEWS_WITH_LIMIT
991-USERSTAT_RUNNING
992-USE_GLOBAL_LOG_SLOW_CONTROL
993-USE_GLOBAL_LONG_QUERY_TIME
994-VERSION
995-VERSION_COMMENT
996-VERSION_COMPILE_MACHINE
997-VERSION_COMPILE_OS
998-WAIT_TIMEOUT
999-WARNING_COUNT
1000
1001=== removed file 'mysql-test/percona_server_variables_release.test'
1002--- mysql-test/percona_server_variables_release.test 2011-06-23 02:21:00 +0000
1003+++ mysql-test/percona_server_variables_release.test 1970-01-01 00:00:00 +0000
1004@@ -1,2 +0,0 @@
1005---source include/have_nodebug.inc
1006---source include/percona_server_variables.inc
1007
1008=== removed file 'mysql-test/percona_show_temp_tables.result'
1009--- mysql-test/percona_show_temp_tables.result 2010-05-20 10:47:38 +0000
1010+++ mysql-test/percona_show_temp_tables.result 1970-01-01 00:00:00 +0000
1011@@ -1,58 +0,0 @@
1012-drop table if exists t1,t2,t3;
1013-drop database if exists showtemp;
1014-create database if not exists showtemp;
1015-use test;
1016-create temporary table t1(id int);
1017-create temporary table t2(id int);
1018-create temporary table showtemp.t3(id int);
1019-insert into t1 values(10),(20),(30),(40);
1020-insert into showtemp.t3 values(999);
1021-show temporary tables;
1022-Temp_tables_in_test
1023-t2
1024-t1
1025-show temporary tables from test;
1026-Temp_tables_in_test
1027-t2
1028-t1
1029-show temporary tables in showtemp;
1030-Temp_tables_in_showtemp
1031-t3
1032-select table_schema, table_name, engine, table_rows from Information_schema.temporary_tables;
1033-table_schema table_name engine table_rows
1034-showtemp t3 MyISAM 1
1035-test t2 MyISAM 0
1036-test t1 MyISAM 4
1037-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables;
1038-table_schema table_name engine table_rows
1039-showtemp t3 MyISAM 1
1040-test t2 MyISAM 0
1041-test t1 MyISAM 4
1042-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables where table_schema='showtemp';
1043-table_schema table_name engine table_rows
1044-showtemp t3 MyISAM 1
1045-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables where table_schema='temp';
1046-table_schema table_name engine table_rows
1047-drop table if exists showtemp.t2;
1048-create temporary table t1(id int);
1049-create temporary table showtemp.t2(id int);
1050-show temporary tables;
1051-Temp_tables_in_test
1052-t1
1053-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables;
1054-table_schema table_name engine table_rows
1055-showtemp t2 MyISAM 0
1056-test t1 MyISAM 0
1057-showtemp t3 MyISAM 1
1058-test t2 MyISAM 0
1059-test t1 MyISAM 4
1060-drop table showtemp.t2;
1061-drop table t1;
1062-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables;
1063-table_schema table_name engine table_rows
1064-showtemp t3 MyISAM 1
1065-test t2 MyISAM 0
1066-test t1 MyISAM 4
1067-drop table t1, t2;
1068-drop table showtemp.t3;
1069-drop database showtemp;
1070
1071=== removed file 'mysql-test/percona_show_temp_tables.test'
1072--- mysql-test/percona_show_temp_tables.test 2010-05-20 10:47:38 +0000
1073+++ mysql-test/percona_show_temp_tables.test 1970-01-01 00:00:00 +0000
1074@@ -1,65 +0,0 @@
1075-# Uses GRANT commands that usually disabled in embedded server
1076--- source include/not_embedded.inc
1077-
1078-# Save the initial number of concurrent sessions
1079---source include/count_sessions.inc
1080-
1081-#
1082-# Test of SHOW [GLOBAL] TEMPORARY TABLES [FROM/IN] DB and
1083-# Information_schema.temporary_tables and global_temporary_tables
1084-#
1085-
1086-connect(stcon1,localhost,root,,test);
1087-connect(stcon2,localhost,root,,test);
1088-
1089-connection stcon1;
1090-
1091---disable_warnings
1092-drop table if exists t1,t2,t3;
1093-drop database if exists showtemp;
1094-create database if not exists showtemp;
1095---enable_warnings
1096-
1097-use test;
1098-create temporary table t1(id int);
1099-create temporary table t2(id int);
1100-create temporary table showtemp.t3(id int);
1101-insert into t1 values(10),(20),(30),(40);
1102-insert into showtemp.t3 values(999);
1103-
1104-show temporary tables;
1105-# "Session" is not same value always. mysql-test cannot test it always.
1106-#show global temporary tables;
1107-show temporary tables from test;
1108-show temporary tables in showtemp;
1109-select table_schema, table_name, engine, table_rows from Information_schema.temporary_tables;
1110-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables;
1111-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables where table_schema='showtemp';
1112-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables where table_schema='temp';
1113-
1114-connection stcon2;
1115-
1116---disable_warnings
1117-drop table if exists showtemp.t2;
1118---enable_warnings
1119-create temporary table t1(id int);
1120-create temporary table showtemp.t2(id int);
1121-show temporary tables;
1122-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables;
1123-drop table showtemp.t2;
1124-drop table t1;
1125-
1126-disconnect stcon2;
1127-
1128-connection stcon1;
1129-select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables;
1130-
1131-drop table t1, t2;
1132-drop table showtemp.t3;
1133-drop database showtemp;
1134-
1135-connection default;
1136-disconnect stcon1;
1137-
1138-# Wait till all disconnects are completed
1139---source include/wait_until_count_sessions.inc
1140
1141=== removed file 'mysql-test/percona_xtradb_admin_command.result'
1142--- mysql-test/percona_xtradb_admin_command.result 2010-05-20 10:47:38 +0000
1143+++ mysql-test/percona_xtradb_admin_command.result 1970-01-01 00:00:00 +0000
1144@@ -1,6 +0,0 @@
1145-select * from information_schema.XTRADB_ADMIN_COMMAND;
1146-result_message
1147-No XTRA_* command in the SQL statement. Please add /*!XTRA_xxxx*/ to the SQL.
1148-select * from information_schema.XTRADB_ADMIN_COMMAND /*!XTRA_HELLO*/;
1149-result_message
1150-Hello!
1151
1152=== removed file 'mysql-test/percona_xtradb_admin_command.test'
1153--- mysql-test/percona_xtradb_admin_command.test 2010-05-20 10:47:38 +0000
1154+++ mysql-test/percona_xtradb_admin_command.test 1970-01-01 00:00:00 +0000
1155@@ -1,3 +0,0 @@
1156---source include/have_innodb.inc
1157-select * from information_schema.XTRADB_ADMIN_COMMAND;
1158-select * from information_schema.XTRADB_ADMIN_COMMAND /*!XTRA_HELLO*/;
1159
1160=== removed file 'mysql-test/percona_xtradb_bug317074.result'
1161--- mysql-test/percona_xtradb_bug317074.result 2010-05-20 10:47:38 +0000
1162+++ mysql-test/percona_xtradb_bug317074.result 1970-01-01 00:00:00 +0000
1163@@ -1,4 +0,0 @@
1164-SET @old_innodb_file_format=@@innodb_file_format;
1165-SET @old_innodb_file_per_table=@@innodb_file_per_table;
1166-SET GLOBAL innodb_file_format='Barracuda';
1167-SET GLOBAL innodb_file_per_table=ON;
1168
1169=== removed file 'mysql-test/percona_xtradb_bug317074.test'
1170--- mysql-test/percona_xtradb_bug317074.test 2010-06-16 09:40:57 +0000
1171+++ mysql-test/percona_xtradb_bug317074.test 1970-01-01 00:00:00 +0000
1172@@ -1,47 +0,0 @@
1173--- source include/have_innodb.inc
1174-
1175-SET @old_innodb_file_format=@@innodb_file_format;
1176-SET @old_innodb_file_per_table=@@innodb_file_per_table;
1177-let $innodb_file_format_check_orig=`select @@innodb_file_format_check`;
1178-SET GLOBAL innodb_file_format='Barracuda';
1179-SET GLOBAL innodb_file_per_table=ON;
1180-
1181--- disable_query_log
1182--- disable_result_log
1183-
1184-DROP TABLE IF EXISTS `test1`;
1185-CREATE TABLE IF NOT EXISTS `test1` (
1186- `a` int primary key auto_increment,
1187- `b` int default 0,
1188- `c` char(100) default 'testtest'
1189-) ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
1190-
1191-delimiter |;
1192-CREATE PROCEDURE insert_many(p1 int)
1193-BEGIN
1194-SET @x = 0;
1195-SET @y = 0;
1196-start transaction;
1197-REPEAT
1198- insert into test1 set b=1;
1199- SET @x = @x + 1;
1200- SET @y = @y + 1;
1201- IF @y >= 1000 THEN
1202- commit;
1203- start transaction;
1204- SET @y = 0;
1205- END IF;
1206-UNTIL @x >= p1 END REPEAT;
1207-commit;
1208-END|
1209-delimiter ;|
1210-call insert_many(100000);
1211-DROP PROCEDURE insert_many;
1212-
1213-# The bug is hangup at the following statement
1214-ALTER TABLE test1 ENGINE=MyISAM;
1215-
1216-DROP TABLE test1;
1217-SET GLOBAL innodb_file_format=@old_innodb_file_format;
1218-SET GLOBAL innodb_file_per_table=@old_innodb_file_per_table;
1219-eval set global innodb_file_format_check=$innodb_file_format_check_orig;
1220
1221=== removed directory 'mysql-test/query_cache_enhance.patch'
1222=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc'
1223--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc 2010-11-05 11:51:45 +0000
1224+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc 1970-01-01 00:00:00 +0000
1225@@ -1,95 +0,0 @@
1226---source include/percona_query_cache_with_comments_clear.inc
1227-let $query=/* with comment first */select * from t1;
1228-eval $query;
1229---source include/percona_query_cache_with_comments_eval.inc
1230-
1231-let $query=# with comment first
1232-select * from t1;
1233---source include/percona_query_cache_with_comments_eval.inc
1234-
1235-let $query=-- with comment first
1236-select * from t1;
1237---source include/percona_query_cache_with_comments_eval.inc
1238-
1239-let $query=/* with comment first and "quote" */select * from t1;
1240---source include/percona_query_cache_with_comments_eval.inc
1241-
1242-let $query=# with comment first and "quote"
1243-select * from t1;
1244---source include/percona_query_cache_with_comments_eval.inc
1245-
1246-let $query=-- with comment first and "quote"
1247-select * from t1;
1248---source include/percona_query_cache_with_comments_eval.inc
1249-
1250-let $query=
1251- /* with comment and whitespaces first */select * from t1;
1252---source include/percona_query_cache_with_comments_eval.inc
1253-
1254-let $query=
1255- # with comment and whitespaces first
1256-select * from t1;
1257---source include/percona_query_cache_with_comments_eval.inc
1258-
1259-let $query=
1260- -- with comment and whitespaces first
1261-select * from t1;
1262---source include/percona_query_cache_with_comments_eval.inc
1263-
1264-let $internal=* internal comment *;
1265-
1266-let $query=select * /$internal/ from t1;
1267---source include/percona_query_cache_with_comments_eval.inc
1268-let $query=select */$internal/ from t1;
1269---source include/percona_query_cache_with_comments_eval.inc
1270-let $query=select */$internal/from t1;
1271---source include/percona_query_cache_with_comments_eval.inc
1272-
1273-let $internal=* internal comment with "quote" *;
1274-
1275-let $query=select * /$internal/ from t1;
1276---source include/percona_query_cache_with_comments_eval.inc
1277-let $query=select */$internal/ from t1;
1278---source include/percona_query_cache_with_comments_eval.inc
1279-let $query=select */$internal/from t1;
1280---source include/percona_query_cache_with_comments_eval.inc
1281-
1282-let $query=select * from t1
1283-;
1284---source include/percona_query_cache_with_comments_eval.inc
1285-
1286-let $query=select * from t1 ;
1287---source include/percona_query_cache_with_comments_eval.inc
1288-
1289-let $query=select * from t1 ;
1290---source include/percona_query_cache_with_comments_eval.inc
1291-
1292-let $query=select * from t1
1293-/* comment in the end */;
1294---source include/percona_query_cache_with_comments_eval.inc
1295-
1296-let $query=select * from t1
1297-/* *\/ */;
1298---source include/percona_query_cache_with_comments_eval.inc
1299-
1300-let $query=select * from t1
1301-/* comment in the end */
1302-;
1303---source include/percona_query_cache_with_comments_eval.inc
1304-
1305-let $query=select * from t1 #comment in the end;
1306---source include/percona_query_cache_with_comments_eval.inc
1307-
1308-let $query=select * from t1 #comment in the end
1309-;
1310---source include/percona_query_cache_with_comments_eval.inc
1311-
1312-let $query=select * from t1 -- comment in the end;
1313---source include/percona_query_cache_with_comments_eval.inc
1314-
1315-let $query=select * from t1 -- comment in the end
1316-;
1317---source include/percona_query_cache_with_comments_eval.inc
1318-
1319-let $query=select ' \' ' from t1;
1320---source include/percona_query_cache_with_comments_eval.inc
1321
1322=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc.backup'
1323--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc.backup 2010-11-05 11:51:45 +0000
1324+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc.backup 1970-01-01 00:00:00 +0000
1325@@ -1,88 +0,0 @@
1326---source include/percona_query_cache_with_comments_clear.inc
1327-let $query=/* with comment first */select * from t1;
1328-eval $query;
1329---source include/percona_query_cache_with_comments_eval.inc
1330-
1331-let $query=# with comment first
1332-select * from t1;
1333---source include/percona_query_cache_with_comments_eval.inc
1334-
1335-let $query=-- with comment first
1336-select * from t1;
1337---source include/percona_query_cache_with_comments_eval.inc
1338-
1339-let $query=/* with comment first and "quote" */select * from t1;
1340---source include/percona_query_cache_with_comments_eval.inc
1341-
1342-let $query=# with comment first and "quote"
1343-select * from t1;
1344---source include/percona_query_cache_with_comments_eval.inc
1345-
1346-let $query=-- with comment first and "quote"
1347-select * from t1;
1348---source include/percona_query_cache_with_comments_eval.inc
1349-
1350-let $query=
1351- /* with comment and whitespaces first */select * from t1;
1352---source include/percona_query_cache_with_comments_eval.inc
1353-
1354-let $query=
1355- # with comment and whitespaces first
1356-select * from t1;
1357---source include/percona_query_cache_with_comments_eval.inc
1358-
1359-let $query=
1360- -- with comment and whitespaces first
1361-select * from t1;
1362---source include/percona_query_cache_with_comments_eval.inc
1363-
1364-let $internal=* internal comment *;
1365-
1366-let $query=select * /$internal/ from t1;
1367---source include/percona_query_cache_with_comments_eval.inc
1368-let $query=select */$internal/ from t1;
1369---source include/percona_query_cache_with_comments_eval.inc
1370-let $query=select */$internal/from t1;
1371---source include/percona_query_cache_with_comments_eval.inc
1372-
1373-let $internal=* internal comment with "quote" *;
1374-
1375-let $query=select * /$internal/ from t1;
1376---source include/percona_query_cache_with_comments_eval.inc
1377-let $query=select */$internal/ from t1;
1378---source include/percona_query_cache_with_comments_eval.inc
1379-let $query=select */$internal/from t1;
1380---source include/percona_query_cache_with_comments_eval.inc
1381-
1382-let $query=select * from t1
1383-;
1384---source include/percona_query_cache_with_comments_eval.inc
1385-
1386-let $query=select * from t1 ;
1387---source include/percona_query_cache_with_comments_eval.inc
1388-
1389-let $query=select * from t1 ;
1390---source include/percona_query_cache_with_comments_eval.inc
1391-
1392-let $query=select * from t1
1393-/* comment in the end */;
1394---source include/percona_query_cache_with_comments_eval.inc
1395-
1396-let $query=select * from t1
1397-/* comment in the end */
1398-;
1399---source include/percona_query_cache_with_comments_eval.inc
1400-
1401-let $query=select * from t1 #comment in the end;
1402---source include/percona_query_cache_with_comments_eval.inc
1403-
1404-let $query=select * from t1 #comment in the end
1405-;
1406---source include/percona_query_cache_with_comments_eval.inc
1407-
1408-let $query=select * from t1 -- comment in the end;
1409---source include/percona_query_cache_with_comments_eval.inc
1410-
1411-let $query=select * from t1 -- comment in the end
1412-;
1413---source include/percona_query_cache_with_comments_eval.inc
1414
1415=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.result'
1416--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.result 2010-11-05 11:51:45 +0000
1417+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.result 1970-01-01 00:00:00 +0000
1418@@ -1,866 +0,0 @@
1419-set global query_cache_strip_comments=ON;
1420-set GLOBAL query_cache_size=1355776;
1421-drop table if exists t1;
1422-create table t1 (a int not null);
1423-insert into t1 values (1),(2),(3);
1424-flush query cache;
1425-flush query cache;
1426-reset query cache;
1427-flush status;
1428-flush query cache;
1429-flush query cache;
1430-reset query cache;
1431-flush status;
1432-/* with comment first */select * from t1;
1433-a
1434-1
1435-2
1436-3
1437------------------------------------------------------
1438-/* with comment first */select * from t1
1439------------------------------------------------------
1440-show status like "Qcache_queries_in_cache";
1441-Variable_name Value
1442-Qcache_queries_in_cache 1
1443-show status like "Qcache_inserts";
1444-Variable_name Value
1445-Qcache_inserts 1
1446-show status like "Qcache_hits";
1447-Variable_name Value
1448-Qcache_hits 0
1449-/* with comment first */select * from t1;
1450-a
1451-1
1452-2
1453-3
1454-/* with comment first */select * from t1;
1455-a
1456-1
1457-2
1458-3
1459-show status like "Qcache_queries_in_cache";
1460-Variable_name Value
1461-Qcache_queries_in_cache 1
1462-show status like "Qcache_inserts";
1463-Variable_name Value
1464-Qcache_inserts 1
1465-show status like "Qcache_hits";
1466-Variable_name Value
1467-Qcache_hits 2
1468------------------------------------------------------
1469-# with comment first
1470-select * from t1
1471------------------------------------------------------
1472-show status like "Qcache_queries_in_cache";
1473-Variable_name Value
1474-Qcache_queries_in_cache 1
1475-show status like "Qcache_inserts";
1476-Variable_name Value
1477-Qcache_inserts 1
1478-show status like "Qcache_hits";
1479-Variable_name Value
1480-Qcache_hits 2
1481-# with comment first
1482-select * from t1;
1483-a
1484-1
1485-2
1486-3
1487-# with comment first
1488-select * from t1;
1489-a
1490-1
1491-2
1492-3
1493-show status like "Qcache_queries_in_cache";
1494-Variable_name Value
1495-Qcache_queries_in_cache 1
1496-show status like "Qcache_inserts";
1497-Variable_name Value
1498-Qcache_inserts 1
1499-show status like "Qcache_hits";
1500-Variable_name Value
1501-Qcache_hits 4
1502------------------------------------------------------
1503--- with comment first
1504-select * from t1
1505------------------------------------------------------
1506-show status like "Qcache_queries_in_cache";
1507-Variable_name Value
1508-Qcache_queries_in_cache 1
1509-show status like "Qcache_inserts";
1510-Variable_name Value
1511-Qcache_inserts 1
1512-show status like "Qcache_hits";
1513-Variable_name Value
1514-Qcache_hits 4
1515--- with comment first
1516-select * from t1;
1517-a
1518-1
1519-2
1520-3
1521--- with comment first
1522-select * from t1;
1523-a
1524-1
1525-2
1526-3
1527-show status like "Qcache_queries_in_cache";
1528-Variable_name Value
1529-Qcache_queries_in_cache 1
1530-show status like "Qcache_inserts";
1531-Variable_name Value
1532-Qcache_inserts 1
1533-show status like "Qcache_hits";
1534-Variable_name Value
1535-Qcache_hits 6
1536------------------------------------------------------
1537-/* with comment first and "quote" */select * from t1
1538------------------------------------------------------
1539-show status like "Qcache_queries_in_cache";
1540-Variable_name Value
1541-Qcache_queries_in_cache 1
1542-show status like "Qcache_inserts";
1543-Variable_name Value
1544-Qcache_inserts 1
1545-show status like "Qcache_hits";
1546-Variable_name Value
1547-Qcache_hits 6
1548-/* with comment first and "quote" */select * from t1;
1549-a
1550-1
1551-2
1552-3
1553-/* with comment first and "quote" */select * from t1;
1554-a
1555-1
1556-2
1557-3
1558-show status like "Qcache_queries_in_cache";
1559-Variable_name Value
1560-Qcache_queries_in_cache 1
1561-show status like "Qcache_inserts";
1562-Variable_name Value
1563-Qcache_inserts 1
1564-show status like "Qcache_hits";
1565-Variable_name Value
1566-Qcache_hits 8
1567------------------------------------------------------
1568-# with comment first and "quote"
1569-select * from t1
1570------------------------------------------------------
1571-show status like "Qcache_queries_in_cache";
1572-Variable_name Value
1573-Qcache_queries_in_cache 1
1574-show status like "Qcache_inserts";
1575-Variable_name Value
1576-Qcache_inserts 1
1577-show status like "Qcache_hits";
1578-Variable_name Value
1579-Qcache_hits 8
1580-# with comment first and "quote"
1581-select * from t1;
1582-a
1583-1
1584-2
1585-3
1586-# with comment first and "quote"
1587-select * from t1;
1588-a
1589-1
1590-2
1591-3
1592-show status like "Qcache_queries_in_cache";
1593-Variable_name Value
1594-Qcache_queries_in_cache 1
1595-show status like "Qcache_inserts";
1596-Variable_name Value
1597-Qcache_inserts 1
1598-show status like "Qcache_hits";
1599-Variable_name Value
1600-Qcache_hits 10
1601------------------------------------------------------
1602--- with comment first and "quote"
1603-select * from t1
1604------------------------------------------------------
1605-show status like "Qcache_queries_in_cache";
1606-Variable_name Value
1607-Qcache_queries_in_cache 1
1608-show status like "Qcache_inserts";
1609-Variable_name Value
1610-Qcache_inserts 1
1611-show status like "Qcache_hits";
1612-Variable_name Value
1613-Qcache_hits 10
1614--- with comment first and "quote"
1615-select * from t1;
1616-a
1617-1
1618-2
1619-3
1620--- with comment first and "quote"
1621-select * from t1;
1622-a
1623-1
1624-2
1625-3
1626-show status like "Qcache_queries_in_cache";
1627-Variable_name Value
1628-Qcache_queries_in_cache 1
1629-show status like "Qcache_inserts";
1630-Variable_name Value
1631-Qcache_inserts 1
1632-show status like "Qcache_hits";
1633-Variable_name Value
1634-Qcache_hits 12
1635------------------------------------------------------
1636-/* with comment and whitespaces first */select * from t1
1637------------------------------------------------------
1638-show status like "Qcache_queries_in_cache";
1639-Variable_name Value
1640-Qcache_queries_in_cache 1
1641-show status like "Qcache_inserts";
1642-Variable_name Value
1643-Qcache_inserts 1
1644-show status like "Qcache_hits";
1645-Variable_name Value
1646-Qcache_hits 12
1647-/* with comment and whitespaces first */select * from t1;
1648-a
1649-1
1650-2
1651-3
1652-/* with comment and whitespaces first */select * from t1;
1653-a
1654-1
1655-2
1656-3
1657-show status like "Qcache_queries_in_cache";
1658-Variable_name Value
1659-Qcache_queries_in_cache 1
1660-show status like "Qcache_inserts";
1661-Variable_name Value
1662-Qcache_inserts 1
1663-show status like "Qcache_hits";
1664-Variable_name Value
1665-Qcache_hits 14
1666------------------------------------------------------
1667-# with comment and whitespaces first
1668-select * from t1
1669------------------------------------------------------
1670-show status like "Qcache_queries_in_cache";
1671-Variable_name Value
1672-Qcache_queries_in_cache 1
1673-show status like "Qcache_inserts";
1674-Variable_name Value
1675-Qcache_inserts 1
1676-show status like "Qcache_hits";
1677-Variable_name Value
1678-Qcache_hits 14
1679-# with comment and whitespaces first
1680-select * from t1;
1681-a
1682-1
1683-2
1684-3
1685-# with comment and whitespaces first
1686-select * from t1;
1687-a
1688-1
1689-2
1690-3
1691-show status like "Qcache_queries_in_cache";
1692-Variable_name Value
1693-Qcache_queries_in_cache 1
1694-show status like "Qcache_inserts";
1695-Variable_name Value
1696-Qcache_inserts 1
1697-show status like "Qcache_hits";
1698-Variable_name Value
1699-Qcache_hits 16
1700------------------------------------------------------
1701--- with comment and whitespaces first
1702-select * from t1
1703------------------------------------------------------
1704-show status like "Qcache_queries_in_cache";
1705-Variable_name Value
1706-Qcache_queries_in_cache 1
1707-show status like "Qcache_inserts";
1708-Variable_name Value
1709-Qcache_inserts 1
1710-show status like "Qcache_hits";
1711-Variable_name Value
1712-Qcache_hits 16
1713--- with comment and whitespaces first
1714-select * from t1;
1715-a
1716-1
1717-2
1718-3
1719--- with comment and whitespaces first
1720-select * from t1;
1721-a
1722-1
1723-2
1724-3
1725-show status like "Qcache_queries_in_cache";
1726-Variable_name Value
1727-Qcache_queries_in_cache 1
1728-show status like "Qcache_inserts";
1729-Variable_name Value
1730-Qcache_inserts 1
1731-show status like "Qcache_hits";
1732-Variable_name Value
1733-Qcache_hits 18
1734------------------------------------------------------
1735-select * /* internal comment */ from t1
1736------------------------------------------------------
1737-show status like "Qcache_queries_in_cache";
1738-Variable_name Value
1739-Qcache_queries_in_cache 1
1740-show status like "Qcache_inserts";
1741-Variable_name Value
1742-Qcache_inserts 1
1743-show status like "Qcache_hits";
1744-Variable_name Value
1745-Qcache_hits 18
1746-select * /* internal comment */ from t1;
1747-a
1748-1
1749-2
1750-3
1751-select * /* internal comment */ from t1;
1752-a
1753-1
1754-2
1755-3
1756-show status like "Qcache_queries_in_cache";
1757-Variable_name Value
1758-Qcache_queries_in_cache 1
1759-show status like "Qcache_inserts";
1760-Variable_name Value
1761-Qcache_inserts 1
1762-show status like "Qcache_hits";
1763-Variable_name Value
1764-Qcache_hits 20
1765------------------------------------------------------
1766-select */* internal comment */ from t1
1767------------------------------------------------------
1768-show status like "Qcache_queries_in_cache";
1769-Variable_name Value
1770-Qcache_queries_in_cache 1
1771-show status like "Qcache_inserts";
1772-Variable_name Value
1773-Qcache_inserts 1
1774-show status like "Qcache_hits";
1775-Variable_name Value
1776-Qcache_hits 20
1777-select */* internal comment */ from t1;
1778-a
1779-1
1780-2
1781-3
1782-select */* internal comment */ from t1;
1783-a
1784-1
1785-2
1786-3
1787-show status like "Qcache_queries_in_cache";
1788-Variable_name Value
1789-Qcache_queries_in_cache 1
1790-show status like "Qcache_inserts";
1791-Variable_name Value
1792-Qcache_inserts 1
1793-show status like "Qcache_hits";
1794-Variable_name Value
1795-Qcache_hits 22
1796------------------------------------------------------
1797-select */* internal comment */from t1
1798------------------------------------------------------
1799-show status like "Qcache_queries_in_cache";
1800-Variable_name Value
1801-Qcache_queries_in_cache 1
1802-show status like "Qcache_inserts";
1803-Variable_name Value
1804-Qcache_inserts 1
1805-show status like "Qcache_hits";
1806-Variable_name Value
1807-Qcache_hits 22
1808-select */* internal comment */from t1;
1809-a
1810-1
1811-2
1812-3
1813-select */* internal comment */from t1;
1814-a
1815-1
1816-2
1817-3
1818-show status like "Qcache_queries_in_cache";
1819-Variable_name Value
1820-Qcache_queries_in_cache 1
1821-show status like "Qcache_inserts";
1822-Variable_name Value
1823-Qcache_inserts 1
1824-show status like "Qcache_hits";
1825-Variable_name Value
1826-Qcache_hits 24
1827------------------------------------------------------
1828-select * /* internal comment with "quote" */ from t1
1829------------------------------------------------------
1830-show status like "Qcache_queries_in_cache";
1831-Variable_name Value
1832-Qcache_queries_in_cache 1
1833-show status like "Qcache_inserts";
1834-Variable_name Value
1835-Qcache_inserts 1
1836-show status like "Qcache_hits";
1837-Variable_name Value
1838-Qcache_hits 24
1839-select * /* internal comment with "quote" */ from t1;
1840-a
1841-1
1842-2
1843-3
1844-select * /* internal comment with "quote" */ from t1;
1845-a
1846-1
1847-2
1848-3
1849-show status like "Qcache_queries_in_cache";
1850-Variable_name Value
1851-Qcache_queries_in_cache 1
1852-show status like "Qcache_inserts";
1853-Variable_name Value
1854-Qcache_inserts 1
1855-show status like "Qcache_hits";
1856-Variable_name Value
1857-Qcache_hits 26
1858------------------------------------------------------
1859-select */* internal comment with "quote" */ from t1
1860------------------------------------------------------
1861-show status like "Qcache_queries_in_cache";
1862-Variable_name Value
1863-Qcache_queries_in_cache 1
1864-show status like "Qcache_inserts";
1865-Variable_name Value
1866-Qcache_inserts 1
1867-show status like "Qcache_hits";
1868-Variable_name Value
1869-Qcache_hits 26
1870-select */* internal comment with "quote" */ from t1;
1871-a
1872-1
1873-2
1874-3
1875-select */* internal comment with "quote" */ from t1;
1876-a
1877-1
1878-2
1879-3
1880-show status like "Qcache_queries_in_cache";
1881-Variable_name Value
1882-Qcache_queries_in_cache 1
1883-show status like "Qcache_inserts";
1884-Variable_name Value
1885-Qcache_inserts 1
1886-show status like "Qcache_hits";
1887-Variable_name Value
1888-Qcache_hits 28
1889------------------------------------------------------
1890-select */* internal comment with "quote" */from t1
1891------------------------------------------------------
1892-show status like "Qcache_queries_in_cache";
1893-Variable_name Value
1894-Qcache_queries_in_cache 1
1895-show status like "Qcache_inserts";
1896-Variable_name Value
1897-Qcache_inserts 1
1898-show status like "Qcache_hits";
1899-Variable_name Value
1900-Qcache_hits 28
1901-select */* internal comment with "quote" */from t1;
1902-a
1903-1
1904-2
1905-3
1906-select */* internal comment with "quote" */from t1;
1907-a
1908-1
1909-2
1910-3
1911-show status like "Qcache_queries_in_cache";
1912-Variable_name Value
1913-Qcache_queries_in_cache 1
1914-show status like "Qcache_inserts";
1915-Variable_name Value
1916-Qcache_inserts 1
1917-show status like "Qcache_hits";
1918-Variable_name Value
1919-Qcache_hits 30
1920------------------------------------------------------
1921-select * from t1
1922-
1923------------------------------------------------------
1924-show status like "Qcache_queries_in_cache";
1925-Variable_name Value
1926-Qcache_queries_in_cache 1
1927-show status like "Qcache_inserts";
1928-Variable_name Value
1929-Qcache_inserts 1
1930-show status like "Qcache_hits";
1931-Variable_name Value
1932-Qcache_hits 30
1933-select * from t1
1934-;
1935-a
1936-1
1937-2
1938-3
1939-select * from t1
1940-;
1941-a
1942-1
1943-2
1944-3
1945-show status like "Qcache_queries_in_cache";
1946-Variable_name Value
1947-Qcache_queries_in_cache 1
1948-show status like "Qcache_inserts";
1949-Variable_name Value
1950-Qcache_inserts 1
1951-show status like "Qcache_hits";
1952-Variable_name Value
1953-Qcache_hits 32
1954------------------------------------------------------
1955-select * from t1
1956------------------------------------------------------
1957-show status like "Qcache_queries_in_cache";
1958-Variable_name Value
1959-Qcache_queries_in_cache 1
1960-show status like "Qcache_inserts";
1961-Variable_name Value
1962-Qcache_inserts 1
1963-show status like "Qcache_hits";
1964-Variable_name Value
1965-Qcache_hits 32
1966-select * from t1 ;
1967-a
1968-1
1969-2
1970-3
1971-select * from t1 ;
1972-a
1973-1
1974-2
1975-3
1976-show status like "Qcache_queries_in_cache";
1977-Variable_name Value
1978-Qcache_queries_in_cache 1
1979-show status like "Qcache_inserts";
1980-Variable_name Value
1981-Qcache_inserts 1
1982-show status like "Qcache_hits";
1983-Variable_name Value
1984-Qcache_hits 34
1985------------------------------------------------------
1986-select * from t1
1987------------------------------------------------------
1988-show status like "Qcache_queries_in_cache";
1989-Variable_name Value
1990-Qcache_queries_in_cache 1
1991-show status like "Qcache_inserts";
1992-Variable_name Value
1993-Qcache_inserts 1
1994-show status like "Qcache_hits";
1995-Variable_name Value
1996-Qcache_hits 34
1997-select * from t1 ;
1998-a
1999-1
2000-2
2001-3
2002-select * from t1 ;
2003-a
2004-1
2005-2
2006-3
2007-show status like "Qcache_queries_in_cache";
2008-Variable_name Value
2009-Qcache_queries_in_cache 1
2010-show status like "Qcache_inserts";
2011-Variable_name Value
2012-Qcache_inserts 1
2013-show status like "Qcache_hits";
2014-Variable_name Value
2015-Qcache_hits 36
2016------------------------------------------------------
2017-select * from t1
2018-/* comment in the end */
2019------------------------------------------------------
2020-show status like "Qcache_queries_in_cache";
2021-Variable_name Value
2022-Qcache_queries_in_cache 1
2023-show status like "Qcache_inserts";
2024-Variable_name Value
2025-Qcache_inserts 1
2026-show status like "Qcache_hits";
2027-Variable_name Value
2028-Qcache_hits 36
2029-select * from t1
2030-/* comment in the end */;
2031-a
2032-1
2033-2
2034-3
2035-select * from t1
2036-/* comment in the end */;
2037-a
2038-1
2039-2
2040-3
2041-show status like "Qcache_queries_in_cache";
2042-Variable_name Value
2043-Qcache_queries_in_cache 1
2044-show status like "Qcache_inserts";
2045-Variable_name Value
2046-Qcache_inserts 1
2047-show status like "Qcache_hits";
2048-Variable_name Value
2049-Qcache_hits 38
2050------------------------------------------------------
2051-select * from t1
2052-/* *\/ */
2053------------------------------------------------------
2054-show status like "Qcache_queries_in_cache";
2055-Variable_name Value
2056-Qcache_queries_in_cache 1
2057-show status like "Qcache_inserts";
2058-Variable_name Value
2059-Qcache_inserts 1
2060-show status like "Qcache_hits";
2061-Variable_name Value
2062-Qcache_hits 38
2063-select * from t1
2064-/* *\/ */;
2065-a
2066-1
2067-2
2068-3
2069-select * from t1
2070-/* *\/ */;
2071-a
2072-1
2073-2
2074-3
2075-show status like "Qcache_queries_in_cache";
2076-Variable_name Value
2077-Qcache_queries_in_cache 1
2078-show status like "Qcache_inserts";
2079-Variable_name Value
2080-Qcache_inserts 1
2081-show status like "Qcache_hits";
2082-Variable_name Value
2083-Qcache_hits 40
2084------------------------------------------------------
2085-select * from t1
2086-/* comment in the end */
2087-
2088------------------------------------------------------
2089-show status like "Qcache_queries_in_cache";
2090-Variable_name Value
2091-Qcache_queries_in_cache 1
2092-show status like "Qcache_inserts";
2093-Variable_name Value
2094-Qcache_inserts 1
2095-show status like "Qcache_hits";
2096-Variable_name Value
2097-Qcache_hits 40
2098-select * from t1
2099-/* comment in the end */
2100-;
2101-a
2102-1
2103-2
2104-3
2105-select * from t1
2106-/* comment in the end */
2107-;
2108-a
2109-1
2110-2
2111-3
2112-show status like "Qcache_queries_in_cache";
2113-Variable_name Value
2114-Qcache_queries_in_cache 1
2115-show status like "Qcache_inserts";
2116-Variable_name Value
2117-Qcache_inserts 1
2118-show status like "Qcache_hits";
2119-Variable_name Value
2120-Qcache_hits 42
2121------------------------------------------------------
2122-select * from t1 #comment in the end
2123------------------------------------------------------
2124-show status like "Qcache_queries_in_cache";
2125-Variable_name Value
2126-Qcache_queries_in_cache 1
2127-show status like "Qcache_inserts";
2128-Variable_name Value
2129-Qcache_inserts 1
2130-show status like "Qcache_hits";
2131-Variable_name Value
2132-Qcache_hits 42
2133-select * from t1 #comment in the end;
2134-a
2135-1
2136-2
2137-3
2138-select * from t1 #comment in the end;
2139-a
2140-1
2141-2
2142-3
2143-show status like "Qcache_queries_in_cache";
2144-Variable_name Value
2145-Qcache_queries_in_cache 1
2146-show status like "Qcache_inserts";
2147-Variable_name Value
2148-Qcache_inserts 1
2149-show status like "Qcache_hits";
2150-Variable_name Value
2151-Qcache_hits 44
2152------------------------------------------------------
2153-select * from t1 #comment in the end
2154-
2155------------------------------------------------------
2156-show status like "Qcache_queries_in_cache";
2157-Variable_name Value
2158-Qcache_queries_in_cache 1
2159-show status like "Qcache_inserts";
2160-Variable_name Value
2161-Qcache_inserts 1
2162-show status like "Qcache_hits";
2163-Variable_name Value
2164-Qcache_hits 44
2165-select * from t1 #comment in the end
2166-;
2167-a
2168-1
2169-2
2170-3
2171-select * from t1 #comment in the end
2172-;
2173-a
2174-1
2175-2
2176-3
2177-show status like "Qcache_queries_in_cache";
2178-Variable_name Value
2179-Qcache_queries_in_cache 1
2180-show status like "Qcache_inserts";
2181-Variable_name Value
2182-Qcache_inserts 1
2183-show status like "Qcache_hits";
2184-Variable_name Value
2185-Qcache_hits 46
2186------------------------------------------------------
2187-select * from t1 -- comment in the end
2188------------------------------------------------------
2189-show status like "Qcache_queries_in_cache";
2190-Variable_name Value
2191-Qcache_queries_in_cache 1
2192-show status like "Qcache_inserts";
2193-Variable_name Value
2194-Qcache_inserts 1
2195-show status like "Qcache_hits";
2196-Variable_name Value
2197-Qcache_hits 46
2198-select * from t1 -- comment in the end;
2199-a
2200-1
2201-2
2202-3
2203-select * from t1 -- comment in the end;
2204-a
2205-1
2206-2
2207-3
2208-show status like "Qcache_queries_in_cache";
2209-Variable_name Value
2210-Qcache_queries_in_cache 1
2211-show status like "Qcache_inserts";
2212-Variable_name Value
2213-Qcache_inserts 1
2214-show status like "Qcache_hits";
2215-Variable_name Value
2216-Qcache_hits 48
2217------------------------------------------------------
2218-select * from t1 -- comment in the end
2219-
2220------------------------------------------------------
2221-show status like "Qcache_queries_in_cache";
2222-Variable_name Value
2223-Qcache_queries_in_cache 1
2224-show status like "Qcache_inserts";
2225-Variable_name Value
2226-Qcache_inserts 1
2227-show status like "Qcache_hits";
2228-Variable_name Value
2229-Qcache_hits 48
2230-select * from t1 -- comment in the end
2231-;
2232-a
2233-1
2234-2
2235-3
2236-select * from t1 -- comment in the end
2237-;
2238-a
2239-1
2240-2
2241-3
2242-show status like "Qcache_queries_in_cache";
2243-Variable_name Value
2244-Qcache_queries_in_cache 1
2245-show status like "Qcache_inserts";
2246-Variable_name Value
2247-Qcache_inserts 1
2248-show status like "Qcache_hits";
2249-Variable_name Value
2250-Qcache_hits 50
2251------------------------------------------------------
2252-select ' \' ' from t1
2253------------------------------------------------------
2254-show status like "Qcache_queries_in_cache";
2255-Variable_name Value
2256-Qcache_queries_in_cache 1
2257-show status like "Qcache_inserts";
2258-Variable_name Value
2259-Qcache_inserts 1
2260-show status like "Qcache_hits";
2261-Variable_name Value
2262-Qcache_hits 50
2263-select ' \' ' from t1;
2264-'
2265- '
2266- '
2267- '
2268-select ' \' ' from t1;
2269-'
2270- '
2271- '
2272- '
2273-show status like "Qcache_queries_in_cache";
2274-Variable_name Value
2275-Qcache_queries_in_cache 2
2276-show status like "Qcache_inserts";
2277-Variable_name Value
2278-Qcache_inserts 2
2279-show status like "Qcache_hits";
2280-Variable_name Value
2281-Qcache_hits 51
2282-DROP TABLE t1;
2283-SET GLOBAL query_cache_size=default;
2284-set global query_cache_strip_comments=OFF;
2285
2286=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.test'
2287--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.test 2010-11-18 10:48:03 +0000
2288+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.test 1970-01-01 00:00:00 +0000
2289@@ -1,5 +0,0 @@
2290---disable_ps_protocol
2291-set global query_cache_strip_comments=ON;
2292--- source include/percona_query_cache_with_comments_begin.inc
2293--- source include/percona_query_cache_with_comments.inc
2294--- source include/percona_query_cache_with_comments_end.inc
2295
2296=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_begin.inc'
2297--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_begin.inc 2010-11-05 11:51:45 +0000
2298+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_begin.inc 1970-01-01 00:00:00 +0000
2299@@ -1,12 +0,0 @@
2300--- source include/have_query_cache.inc
2301-
2302-set GLOBAL query_cache_size=1355776;
2303-
2304---disable_warnings
2305-drop table if exists t1;
2306---enable_warnings
2307-
2308-create table t1 (a int not null);
2309-insert into t1 values (1),(2),(3);
2310-
2311---source include/percona_query_cache_with_comments_clear.inc
2312
2313=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_clear.inc'
2314--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_clear.inc 2010-11-05 11:51:45 +0000
2315+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_clear.inc 1970-01-01 00:00:00 +0000
2316@@ -1,5 +0,0 @@
2317-# Reset query cache variables.
2318-flush query cache; # This crashed in some versions
2319-flush query cache; # This crashed in some versions
2320-reset query cache;
2321-flush status;
2322
2323=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_crash.result'
2324--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_crash.result 2010-11-05 11:51:45 +0000
2325+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_crash.result 1970-01-01 00:00:00 +0000
2326@@ -1,21 +0,0 @@
2327-set GLOBAL query_cache_size=1355776;
2328-drop table if exists t1;
2329-create table t1 (a int not null);
2330-insert into t1 values (1),(2),(3);
2331-flush query cache;
2332-flush query cache;
2333-reset query cache;
2334-flush status;
2335-( select * from t1 );
2336-a
2337-1
2338-2
2339-3
2340-/*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := REPLACE(REPLACE(@@SQL_MODE, 'ANSI_QUOTES', ''), ',,', ','), @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */;
2341-/* only comment */;
2342-# only comment
2343-;
2344--- only comment
2345-;
2346-DROP TABLE t1;
2347-SET GLOBAL query_cache_size= default;
2348
2349=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_crash.test'
2350--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_crash.test 2010-11-05 11:51:45 +0000
2351+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_crash.test 1970-01-01 00:00:00 +0000
2352@@ -1,22 +0,0 @@
2353--- source include/have_query_cache.inc
2354-set GLOBAL query_cache_size=1355776;
2355---disable_warnings
2356-drop table if exists t1;
2357---enable_warnings
2358-create table t1 (a int not null);
2359-insert into t1 values (1),(2),(3);
2360-flush query cache; # This crashed in some versions
2361-flush query cache; # This crashed in some versions
2362-reset query cache;
2363-flush status;
2364-( select * from t1 );
2365-/*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := REPLACE(REPLACE(@@SQL_MODE, 'ANSI_QUOTES', ''), ',,', ','), @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */;
2366-/* only comment */;
2367-let query=# only comment
2368-;
2369-eval $query;
2370-let query=-- only comment
2371-;
2372-eval $query;
2373-DROP TABLE t1;
2374-SET GLOBAL query_cache_size= default;
2375
2376=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_disable.result'
2377--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_disable.result 2010-11-05 11:51:45 +0000
2378+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_disable.result 1970-01-01 00:00:00 +0000
2379@@ -1,865 +0,0 @@
2380-set GLOBAL query_cache_size=1355776;
2381-drop table if exists t1;
2382-create table t1 (a int not null);
2383-insert into t1 values (1),(2),(3);
2384-flush query cache;
2385-flush query cache;
2386-reset query cache;
2387-flush status;
2388-flush query cache;
2389-flush query cache;
2390-reset query cache;
2391-flush status;
2392-/* with comment first */select * from t1;
2393-a
2394-1
2395-2
2396-3
2397------------------------------------------------------
2398-/* with comment first */select * from t1
2399------------------------------------------------------
2400-show status like "Qcache_queries_in_cache";
2401-Variable_name Value
2402-Qcache_queries_in_cache 1
2403-show status like "Qcache_inserts";
2404-Variable_name Value
2405-Qcache_inserts 1
2406-show status like "Qcache_hits";
2407-Variable_name Value
2408-Qcache_hits 0
2409-/* with comment first */select * from t1;
2410-a
2411-1
2412-2
2413-3
2414-/* with comment first */select * from t1;
2415-a
2416-1
2417-2
2418-3
2419-show status like "Qcache_queries_in_cache";
2420-Variable_name Value
2421-Qcache_queries_in_cache 1
2422-show status like "Qcache_inserts";
2423-Variable_name Value
2424-Qcache_inserts 1
2425-show status like "Qcache_hits";
2426-Variable_name Value
2427-Qcache_hits 2
2428------------------------------------------------------
2429-# with comment first
2430-select * from t1
2431------------------------------------------------------
2432-show status like "Qcache_queries_in_cache";
2433-Variable_name Value
2434-Qcache_queries_in_cache 1
2435-show status like "Qcache_inserts";
2436-Variable_name Value
2437-Qcache_inserts 1
2438-show status like "Qcache_hits";
2439-Variable_name Value
2440-Qcache_hits 2
2441-# with comment first
2442-select * from t1;
2443-a
2444-1
2445-2
2446-3
2447-# with comment first
2448-select * from t1;
2449-a
2450-1
2451-2
2452-3
2453-show status like "Qcache_queries_in_cache";
2454-Variable_name Value
2455-Qcache_queries_in_cache 2
2456-show status like "Qcache_inserts";
2457-Variable_name Value
2458-Qcache_inserts 2
2459-show status like "Qcache_hits";
2460-Variable_name Value
2461-Qcache_hits 2
2462------------------------------------------------------
2463--- with comment first
2464-select * from t1
2465------------------------------------------------------
2466-show status like "Qcache_queries_in_cache";
2467-Variable_name Value
2468-Qcache_queries_in_cache 2
2469-show status like "Qcache_inserts";
2470-Variable_name Value
2471-Qcache_inserts 2
2472-show status like "Qcache_hits";
2473-Variable_name Value
2474-Qcache_hits 2
2475--- with comment first
2476-select * from t1;
2477-a
2478-1
2479-2
2480-3
2481--- with comment first
2482-select * from t1;
2483-a
2484-1
2485-2
2486-3
2487-show status like "Qcache_queries_in_cache";
2488-Variable_name Value
2489-Qcache_queries_in_cache 3
2490-show status like "Qcache_inserts";
2491-Variable_name Value
2492-Qcache_inserts 3
2493-show status like "Qcache_hits";
2494-Variable_name Value
2495-Qcache_hits 2
2496------------------------------------------------------
2497-/* with comment first and "quote" */select * from t1
2498------------------------------------------------------
2499-show status like "Qcache_queries_in_cache";
2500-Variable_name Value
2501-Qcache_queries_in_cache 3
2502-show status like "Qcache_inserts";
2503-Variable_name Value
2504-Qcache_inserts 3
2505-show status like "Qcache_hits";
2506-Variable_name Value
2507-Qcache_hits 2
2508-/* with comment first and "quote" */select * from t1;
2509-a
2510-1
2511-2
2512-3
2513-/* with comment first and "quote" */select * from t1;
2514-a
2515-1
2516-2
2517-3
2518-show status like "Qcache_queries_in_cache";
2519-Variable_name Value
2520-Qcache_queries_in_cache 4
2521-show status like "Qcache_inserts";
2522-Variable_name Value
2523-Qcache_inserts 4
2524-show status like "Qcache_hits";
2525-Variable_name Value
2526-Qcache_hits 3
2527------------------------------------------------------
2528-# with comment first and "quote"
2529-select * from t1
2530------------------------------------------------------
2531-show status like "Qcache_queries_in_cache";
2532-Variable_name Value
2533-Qcache_queries_in_cache 4
2534-show status like "Qcache_inserts";
2535-Variable_name Value
2536-Qcache_inserts 4
2537-show status like "Qcache_hits";
2538-Variable_name Value
2539-Qcache_hits 3
2540-# with comment first and "quote"
2541-select * from t1;
2542-a
2543-1
2544-2
2545-3
2546-# with comment first and "quote"
2547-select * from t1;
2548-a
2549-1
2550-2
2551-3
2552-show status like "Qcache_queries_in_cache";
2553-Variable_name Value
2554-Qcache_queries_in_cache 5
2555-show status like "Qcache_inserts";
2556-Variable_name Value
2557-Qcache_inserts 5
2558-show status like "Qcache_hits";
2559-Variable_name Value
2560-Qcache_hits 3
2561------------------------------------------------------
2562--- with comment first and "quote"
2563-select * from t1
2564------------------------------------------------------
2565-show status like "Qcache_queries_in_cache";
2566-Variable_name Value
2567-Qcache_queries_in_cache 5
2568-show status like "Qcache_inserts";
2569-Variable_name Value
2570-Qcache_inserts 5
2571-show status like "Qcache_hits";
2572-Variable_name Value
2573-Qcache_hits 3
2574--- with comment first and "quote"
2575-select * from t1;
2576-a
2577-1
2578-2
2579-3
2580--- with comment first and "quote"
2581-select * from t1;
2582-a
2583-1
2584-2
2585-3
2586-show status like "Qcache_queries_in_cache";
2587-Variable_name Value
2588-Qcache_queries_in_cache 6
2589-show status like "Qcache_inserts";
2590-Variable_name Value
2591-Qcache_inserts 6
2592-show status like "Qcache_hits";
2593-Variable_name Value
2594-Qcache_hits 3
2595------------------------------------------------------
2596-/* with comment and whitespaces first */select * from t1
2597------------------------------------------------------
2598-show status like "Qcache_queries_in_cache";
2599-Variable_name Value
2600-Qcache_queries_in_cache 6
2601-show status like "Qcache_inserts";
2602-Variable_name Value
2603-Qcache_inserts 6
2604-show status like "Qcache_hits";
2605-Variable_name Value
2606-Qcache_hits 3
2607-/* with comment and whitespaces first */select * from t1;
2608-a
2609-1
2610-2
2611-3
2612-/* with comment and whitespaces first */select * from t1;
2613-a
2614-1
2615-2
2616-3
2617-show status like "Qcache_queries_in_cache";
2618-Variable_name Value
2619-Qcache_queries_in_cache 7
2620-show status like "Qcache_inserts";
2621-Variable_name Value
2622-Qcache_inserts 7
2623-show status like "Qcache_hits";
2624-Variable_name Value
2625-Qcache_hits 4
2626------------------------------------------------------
2627-# with comment and whitespaces first
2628-select * from t1
2629------------------------------------------------------
2630-show status like "Qcache_queries_in_cache";
2631-Variable_name Value
2632-Qcache_queries_in_cache 7
2633-show status like "Qcache_inserts";
2634-Variable_name Value
2635-Qcache_inserts 7
2636-show status like "Qcache_hits";
2637-Variable_name Value
2638-Qcache_hits 4
2639-# with comment and whitespaces first
2640-select * from t1;
2641-a
2642-1
2643-2
2644-3
2645-# with comment and whitespaces first
2646-select * from t1;
2647-a
2648-1
2649-2
2650-3
2651-show status like "Qcache_queries_in_cache";
2652-Variable_name Value
2653-Qcache_queries_in_cache 8
2654-show status like "Qcache_inserts";
2655-Variable_name Value
2656-Qcache_inserts 8
2657-show status like "Qcache_hits";
2658-Variable_name Value
2659-Qcache_hits 4
2660------------------------------------------------------
2661--- with comment and whitespaces first
2662-select * from t1
2663------------------------------------------------------
2664-show status like "Qcache_queries_in_cache";
2665-Variable_name Value
2666-Qcache_queries_in_cache 8
2667-show status like "Qcache_inserts";
2668-Variable_name Value
2669-Qcache_inserts 8
2670-show status like "Qcache_hits";
2671-Variable_name Value
2672-Qcache_hits 4
2673--- with comment and whitespaces first
2674-select * from t1;
2675-a
2676-1
2677-2
2678-3
2679--- with comment and whitespaces first
2680-select * from t1;
2681-a
2682-1
2683-2
2684-3
2685-show status like "Qcache_queries_in_cache";
2686-Variable_name Value
2687-Qcache_queries_in_cache 9
2688-show status like "Qcache_inserts";
2689-Variable_name Value
2690-Qcache_inserts 9
2691-show status like "Qcache_hits";
2692-Variable_name Value
2693-Qcache_hits 4
2694------------------------------------------------------
2695-select * /* internal comment */ from t1
2696------------------------------------------------------
2697-show status like "Qcache_queries_in_cache";
2698-Variable_name Value
2699-Qcache_queries_in_cache 9
2700-show status like "Qcache_inserts";
2701-Variable_name Value
2702-Qcache_inserts 9
2703-show status like "Qcache_hits";
2704-Variable_name Value
2705-Qcache_hits 4
2706-select * /* internal comment */ from t1;
2707-a
2708-1
2709-2
2710-3
2711-select * /* internal comment */ from t1;
2712-a
2713-1
2714-2
2715-3
2716-show status like "Qcache_queries_in_cache";
2717-Variable_name Value
2718-Qcache_queries_in_cache 10
2719-show status like "Qcache_inserts";
2720-Variable_name Value
2721-Qcache_inserts 10
2722-show status like "Qcache_hits";
2723-Variable_name Value
2724-Qcache_hits 5
2725------------------------------------------------------
2726-select */* internal comment */ from t1
2727------------------------------------------------------
2728-show status like "Qcache_queries_in_cache";
2729-Variable_name Value
2730-Qcache_queries_in_cache 10
2731-show status like "Qcache_inserts";
2732-Variable_name Value
2733-Qcache_inserts 10
2734-show status like "Qcache_hits";
2735-Variable_name Value
2736-Qcache_hits 5
2737-select */* internal comment */ from t1;
2738-a
2739-1
2740-2
2741-3
2742-select */* internal comment */ from t1;
2743-a
2744-1
2745-2
2746-3
2747-show status like "Qcache_queries_in_cache";
2748-Variable_name Value
2749-Qcache_queries_in_cache 11
2750-show status like "Qcache_inserts";
2751-Variable_name Value
2752-Qcache_inserts 11
2753-show status like "Qcache_hits";
2754-Variable_name Value
2755-Qcache_hits 6
2756------------------------------------------------------
2757-select */* internal comment */from t1
2758------------------------------------------------------
2759-show status like "Qcache_queries_in_cache";
2760-Variable_name Value
2761-Qcache_queries_in_cache 11
2762-show status like "Qcache_inserts";
2763-Variable_name Value
2764-Qcache_inserts 11
2765-show status like "Qcache_hits";
2766-Variable_name Value
2767-Qcache_hits 6
2768-select */* internal comment */from t1;
2769-a
2770-1
2771-2
2772-3
2773-select */* internal comment */from t1;
2774-a
2775-1
2776-2
2777-3
2778-show status like "Qcache_queries_in_cache";
2779-Variable_name Value
2780-Qcache_queries_in_cache 12
2781-show status like "Qcache_inserts";
2782-Variable_name Value
2783-Qcache_inserts 12
2784-show status like "Qcache_hits";
2785-Variable_name Value
2786-Qcache_hits 7
2787------------------------------------------------------
2788-select * /* internal comment with "quote" */ from t1
2789------------------------------------------------------
2790-show status like "Qcache_queries_in_cache";
2791-Variable_name Value
2792-Qcache_queries_in_cache 12
2793-show status like "Qcache_inserts";
2794-Variable_name Value
2795-Qcache_inserts 12
2796-show status like "Qcache_hits";
2797-Variable_name Value
2798-Qcache_hits 7
2799-select * /* internal comment with "quote" */ from t1;
2800-a
2801-1
2802-2
2803-3
2804-select * /* internal comment with "quote" */ from t1;
2805-a
2806-1
2807-2
2808-3
2809-show status like "Qcache_queries_in_cache";
2810-Variable_name Value
2811-Qcache_queries_in_cache 13
2812-show status like "Qcache_inserts";
2813-Variable_name Value
2814-Qcache_inserts 13
2815-show status like "Qcache_hits";
2816-Variable_name Value
2817-Qcache_hits 8
2818------------------------------------------------------
2819-select */* internal comment with "quote" */ from t1
2820------------------------------------------------------
2821-show status like "Qcache_queries_in_cache";
2822-Variable_name Value
2823-Qcache_queries_in_cache 13
2824-show status like "Qcache_inserts";
2825-Variable_name Value
2826-Qcache_inserts 13
2827-show status like "Qcache_hits";
2828-Variable_name Value
2829-Qcache_hits 8
2830-select */* internal comment with "quote" */ from t1;
2831-a
2832-1
2833-2
2834-3
2835-select */* internal comment with "quote" */ from t1;
2836-a
2837-1
2838-2
2839-3
2840-show status like "Qcache_queries_in_cache";
2841-Variable_name Value
2842-Qcache_queries_in_cache 14
2843-show status like "Qcache_inserts";
2844-Variable_name Value
2845-Qcache_inserts 14
2846-show status like "Qcache_hits";
2847-Variable_name Value
2848-Qcache_hits 9
2849------------------------------------------------------
2850-select */* internal comment with "quote" */from t1
2851------------------------------------------------------
2852-show status like "Qcache_queries_in_cache";
2853-Variable_name Value
2854-Qcache_queries_in_cache 14
2855-show status like "Qcache_inserts";
2856-Variable_name Value
2857-Qcache_inserts 14
2858-show status like "Qcache_hits";
2859-Variable_name Value
2860-Qcache_hits 9
2861-select */* internal comment with "quote" */from t1;
2862-a
2863-1
2864-2
2865-3
2866-select */* internal comment with "quote" */from t1;
2867-a
2868-1
2869-2
2870-3
2871-show status like "Qcache_queries_in_cache";
2872-Variable_name Value
2873-Qcache_queries_in_cache 15
2874-show status like "Qcache_inserts";
2875-Variable_name Value
2876-Qcache_inserts 15
2877-show status like "Qcache_hits";
2878-Variable_name Value
2879-Qcache_hits 10
2880------------------------------------------------------
2881-select * from t1
2882-
2883------------------------------------------------------
2884-show status like "Qcache_queries_in_cache";
2885-Variable_name Value
2886-Qcache_queries_in_cache 15
2887-show status like "Qcache_inserts";
2888-Variable_name Value
2889-Qcache_inserts 15
2890-show status like "Qcache_hits";
2891-Variable_name Value
2892-Qcache_hits 10
2893-select * from t1
2894-;
2895-a
2896-1
2897-2
2898-3
2899-select * from t1
2900-;
2901-a
2902-1
2903-2
2904-3
2905-show status like "Qcache_queries_in_cache";
2906-Variable_name Value
2907-Qcache_queries_in_cache 16
2908-show status like "Qcache_inserts";
2909-Variable_name Value
2910-Qcache_inserts 16
2911-show status like "Qcache_hits";
2912-Variable_name Value
2913-Qcache_hits 11
2914------------------------------------------------------
2915-select * from t1
2916------------------------------------------------------
2917-show status like "Qcache_queries_in_cache";
2918-Variable_name Value
2919-Qcache_queries_in_cache 16
2920-show status like "Qcache_inserts";
2921-Variable_name Value
2922-Qcache_inserts 16
2923-show status like "Qcache_hits";
2924-Variable_name Value
2925-Qcache_hits 11
2926-select * from t1 ;
2927-a
2928-1
2929-2
2930-3
2931-select * from t1 ;
2932-a
2933-1
2934-2
2935-3
2936-show status like "Qcache_queries_in_cache";
2937-Variable_name Value
2938-Qcache_queries_in_cache 16
2939-show status like "Qcache_inserts";
2940-Variable_name Value
2941-Qcache_inserts 16
2942-show status like "Qcache_hits";
2943-Variable_name Value
2944-Qcache_hits 13
2945------------------------------------------------------
2946-select * from t1
2947------------------------------------------------------
2948-show status like "Qcache_queries_in_cache";
2949-Variable_name Value
2950-Qcache_queries_in_cache 16
2951-show status like "Qcache_inserts";
2952-Variable_name Value
2953-Qcache_inserts 16
2954-show status like "Qcache_hits";
2955-Variable_name Value
2956-Qcache_hits 13
2957-select * from t1 ;
2958-a
2959-1
2960-2
2961-3
2962-select * from t1 ;
2963-a
2964-1
2965-2
2966-3
2967-show status like "Qcache_queries_in_cache";
2968-Variable_name Value
2969-Qcache_queries_in_cache 16
2970-show status like "Qcache_inserts";
2971-Variable_name Value
2972-Qcache_inserts 16
2973-show status like "Qcache_hits";
2974-Variable_name Value
2975-Qcache_hits 15
2976------------------------------------------------------
2977-select * from t1
2978-/* comment in the end */
2979------------------------------------------------------
2980-show status like "Qcache_queries_in_cache";
2981-Variable_name Value
2982-Qcache_queries_in_cache 16
2983-show status like "Qcache_inserts";
2984-Variable_name Value
2985-Qcache_inserts 16
2986-show status like "Qcache_hits";
2987-Variable_name Value
2988-Qcache_hits 15
2989-select * from t1
2990-/* comment in the end */;
2991-a
2992-1
2993-2
2994-3
2995-select * from t1
2996-/* comment in the end */;
2997-a
2998-1
2999-2
3000-3
3001-show status like "Qcache_queries_in_cache";
3002-Variable_name Value
3003-Qcache_queries_in_cache 17
3004-show status like "Qcache_inserts";
3005-Variable_name Value
3006-Qcache_inserts 17
3007-show status like "Qcache_hits";
3008-Variable_name Value
3009-Qcache_hits 16
3010------------------------------------------------------
3011-select * from t1
3012-/* *\/ */
3013------------------------------------------------------
3014-show status like "Qcache_queries_in_cache";
3015-Variable_name Value
3016-Qcache_queries_in_cache 17
3017-show status like "Qcache_inserts";
3018-Variable_name Value
3019-Qcache_inserts 17
3020-show status like "Qcache_hits";
3021-Variable_name Value
3022-Qcache_hits 16
3023-select * from t1
3024-/* *\/ */;
3025-a
3026-1
3027-2
3028-3
3029-select * from t1
3030-/* *\/ */;
3031-a
3032-1
3033-2
3034-3
3035-show status like "Qcache_queries_in_cache";
3036-Variable_name Value
3037-Qcache_queries_in_cache 18
3038-show status like "Qcache_inserts";
3039-Variable_name Value
3040-Qcache_inserts 18
3041-show status like "Qcache_hits";
3042-Variable_name Value
3043-Qcache_hits 17
3044------------------------------------------------------
3045-select * from t1
3046-/* comment in the end */
3047-
3048------------------------------------------------------
3049-show status like "Qcache_queries_in_cache";
3050-Variable_name Value
3051-Qcache_queries_in_cache 18
3052-show status like "Qcache_inserts";
3053-Variable_name Value
3054-Qcache_inserts 18
3055-show status like "Qcache_hits";
3056-Variable_name Value
3057-Qcache_hits 17
3058-select * from t1
3059-/* comment in the end */
3060-;
3061-a
3062-1
3063-2
3064-3
3065-select * from t1
3066-/* comment in the end */
3067-;
3068-a
3069-1
3070-2
3071-3
3072-show status like "Qcache_queries_in_cache";
3073-Variable_name Value
3074-Qcache_queries_in_cache 18
3075-show status like "Qcache_inserts";
3076-Variable_name Value
3077-Qcache_inserts 18
3078-show status like "Qcache_hits";
3079-Variable_name Value
3080-Qcache_hits 19
3081------------------------------------------------------
3082-select * from t1 #comment in the end
3083------------------------------------------------------
3084-show status like "Qcache_queries_in_cache";
3085-Variable_name Value
3086-Qcache_queries_in_cache 18
3087-show status like "Qcache_inserts";
3088-Variable_name Value
3089-Qcache_inserts 18
3090-show status like "Qcache_hits";
3091-Variable_name Value
3092-Qcache_hits 19
3093-select * from t1 #comment in the end;
3094-a
3095-1
3096-2
3097-3
3098-select * from t1 #comment in the end;
3099-a
3100-1
3101-2
3102-3
3103-show status like "Qcache_queries_in_cache";
3104-Variable_name Value
3105-Qcache_queries_in_cache 19
3106-show status like "Qcache_inserts";
3107-Variable_name Value
3108-Qcache_inserts 19
3109-show status like "Qcache_hits";
3110-Variable_name Value
3111-Qcache_hits 20
3112------------------------------------------------------
3113-select * from t1 #comment in the end
3114-
3115------------------------------------------------------
3116-show status like "Qcache_queries_in_cache";
3117-Variable_name Value
3118-Qcache_queries_in_cache 19
3119-show status like "Qcache_inserts";
3120-Variable_name Value
3121-Qcache_inserts 19
3122-show status like "Qcache_hits";
3123-Variable_name Value
3124-Qcache_hits 20
3125-select * from t1 #comment in the end
3126-;
3127-a
3128-1
3129-2
3130-3
3131-select * from t1 #comment in the end
3132-;
3133-a
3134-1
3135-2
3136-3
3137-show status like "Qcache_queries_in_cache";
3138-Variable_name Value
3139-Qcache_queries_in_cache 19
3140-show status like "Qcache_inserts";
3141-Variable_name Value
3142-Qcache_inserts 19
3143-show status like "Qcache_hits";
3144-Variable_name Value
3145-Qcache_hits 22
3146------------------------------------------------------
3147-select * from t1 -- comment in the end
3148------------------------------------------------------
3149-show status like "Qcache_queries_in_cache";
3150-Variable_name Value
3151-Qcache_queries_in_cache 19
3152-show status like "Qcache_inserts";
3153-Variable_name Value
3154-Qcache_inserts 19
3155-show status like "Qcache_hits";
3156-Variable_name Value
3157-Qcache_hits 22
3158-select * from t1 -- comment in the end;
3159-a
3160-1
3161-2
3162-3
3163-select * from t1 -- comment in the end;
3164-a
3165-1
3166-2
3167-3
3168-show status like "Qcache_queries_in_cache";
3169-Variable_name Value
3170-Qcache_queries_in_cache 20
3171-show status like "Qcache_inserts";
3172-Variable_name Value
3173-Qcache_inserts 20
3174-show status like "Qcache_hits";
3175-Variable_name Value
3176-Qcache_hits 23
3177------------------------------------------------------
3178-select * from t1 -- comment in the end
3179-
3180------------------------------------------------------
3181-show status like "Qcache_queries_in_cache";
3182-Variable_name Value
3183-Qcache_queries_in_cache 20
3184-show status like "Qcache_inserts";
3185-Variable_name Value
3186-Qcache_inserts 20
3187-show status like "Qcache_hits";
3188-Variable_name Value
3189-Qcache_hits 23
3190-select * from t1 -- comment in the end
3191-;
3192-a
3193-1
3194-2
3195-3
3196-select * from t1 -- comment in the end
3197-;
3198-a
3199-1
3200-2
3201-3
3202-show status like "Qcache_queries_in_cache";
3203-Variable_name Value
3204-Qcache_queries_in_cache 20
3205-show status like "Qcache_inserts";
3206-Variable_name Value
3207-Qcache_inserts 20
3208-show status like "Qcache_hits";
3209-Variable_name Value
3210-Qcache_hits 25
3211------------------------------------------------------
3212-select ' \' ' from t1
3213------------------------------------------------------
3214-show status like "Qcache_queries_in_cache";
3215-Variable_name Value
3216-Qcache_queries_in_cache 20
3217-show status like "Qcache_inserts";
3218-Variable_name Value
3219-Qcache_inserts 20
3220-show status like "Qcache_hits";
3221-Variable_name Value
3222-Qcache_hits 25
3223-select ' \' ' from t1;
3224-'
3225- '
3226- '
3227- '
3228-select ' \' ' from t1;
3229-'
3230- '
3231- '
3232- '
3233-show status like "Qcache_queries_in_cache";
3234-Variable_name Value
3235-Qcache_queries_in_cache 21
3236-show status like "Qcache_inserts";
3237-Variable_name Value
3238-Qcache_inserts 21
3239-show status like "Qcache_hits";
3240-Variable_name Value
3241-Qcache_hits 26
3242-DROP TABLE t1;
3243-SET GLOBAL query_cache_size=default;
3244-set global query_cache_strip_comments=OFF;
3245
3246=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_disable.test'
3247--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_disable.test 2010-11-05 11:51:45 +0000
3248+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_disable.test 1970-01-01 00:00:00 +0000
3249@@ -1,3 +0,0 @@
3250--- source include/percona_query_cache_with_comments_begin.inc
3251--- source include/percona_query_cache_with_comments.inc
3252--- source include/percona_query_cache_with_comments_end.inc
3253
3254=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_end.inc'
3255--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_end.inc 2010-11-05 11:51:45 +0000
3256+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_end.inc 1970-01-01 00:00:00 +0000
3257@@ -1,3 +0,0 @@
3258-DROP TABLE t1;
3259-SET GLOBAL query_cache_size=default;
3260-set global query_cache_strip_comments=OFF;
3261
3262=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_eval.inc'
3263--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_eval.inc 2010-11-05 11:51:45 +0000
3264+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_eval.inc 1970-01-01 00:00:00 +0000
3265@@ -1,7 +0,0 @@
3266-echo -----------------------------------------------------;
3267-echo $query;
3268-echo -----------------------------------------------------;
3269---source include/percona_query_cache_with_comments_show.inc
3270-eval $query;
3271-eval $query;
3272---source include/percona_query_cache_with_comments_show.inc
3273
3274=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_prepared_statements.result'
3275--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_prepared_statements.result 2010-11-05 11:51:45 +0000
3276+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_prepared_statements.result 1970-01-01 00:00:00 +0000
3277@@ -1,396 +0,0 @@
3278-set GLOBAL query_cache_size=1355776;
3279-flush query cache;
3280-flush query cache;
3281-reset query cache;
3282-flush status;
3283-drop table if exists t1;
3284-create table t1 (a int not null);
3285-insert into t1 values (1),(2),(3);
3286-set global query_cache_strip_comments=ON;
3287-show status like "Qcache_queries_in_cache";
3288-Variable_name Value
3289-Qcache_queries_in_cache 0
3290-show status like "Qcache_inserts";
3291-Variable_name Value
3292-Qcache_inserts 0
3293-show status like "Qcache_hits";
3294-Variable_name Value
3295-Qcache_hits 0
3296-prepare stmt from '/* with comment */ select * from t1';
3297-execute stmt;
3298-a
3299-1
3300-2
3301-3
3302-show status like "Qcache_queries_in_cache";
3303-Variable_name Value
3304-Qcache_queries_in_cache 1
3305-show status like "Qcache_inserts";
3306-Variable_name Value
3307-Qcache_inserts 1
3308-show status like "Qcache_hits";
3309-Variable_name Value
3310-Qcache_hits 0
3311-execute stmt;
3312-a
3313-1
3314-2
3315-3
3316-execute stmt;
3317-a
3318-1
3319-2
3320-3
3321-execute stmt;
3322-a
3323-1
3324-2
3325-3
3326-execute stmt;
3327-a
3328-1
3329-2
3330-3
3331-execute stmt;
3332-a
3333-1
3334-2
3335-3
3336-show status like "Qcache_queries_in_cache";
3337-Variable_name Value
3338-Qcache_queries_in_cache 1
3339-show status like "Qcache_inserts";
3340-Variable_name Value
3341-Qcache_inserts 1
3342-show status like "Qcache_hits";
3343-Variable_name Value
3344-Qcache_hits 5
3345-prepare stmt from 'select * from t1';
3346-execute stmt;
3347-a
3348-1
3349-2
3350-3
3351-show status like "Qcache_queries_in_cache";
3352-Variable_name Value
3353-Qcache_queries_in_cache 1
3354-show status like "Qcache_inserts";
3355-Variable_name Value
3356-Qcache_inserts 1
3357-show status like "Qcache_hits";
3358-Variable_name Value
3359-Qcache_hits 6
3360-prepare stmt from 'select * /*internal comment*/from t1';
3361-execute stmt;
3362-a
3363-1
3364-2
3365-3
3366-show status like "Qcache_queries_in_cache";
3367-Variable_name Value
3368-Qcache_queries_in_cache 1
3369-show status like "Qcache_inserts";
3370-Variable_name Value
3371-Qcache_inserts 1
3372-show status like "Qcache_hits";
3373-Variable_name Value
3374-Qcache_hits 7
3375-prepare stmt from 'select * /*internal comment*/ from t1';
3376-execute stmt;
3377-a
3378-1
3379-2
3380-3
3381-show status like "Qcache_queries_in_cache";
3382-Variable_name Value
3383-Qcache_queries_in_cache 1
3384-show status like "Qcache_inserts";
3385-Variable_name Value
3386-Qcache_inserts 1
3387-show status like "Qcache_hits";
3388-Variable_name Value
3389-Qcache_hits 8
3390-prepare stmt from 'select * from t1 /* at the end */';
3391-execute stmt;
3392-a
3393-1
3394-2
3395-3
3396-show status like "Qcache_queries_in_cache";
3397-Variable_name Value
3398-Qcache_queries_in_cache 1
3399-show status like "Qcache_inserts";
3400-Variable_name Value
3401-Qcache_inserts 1
3402-show status like "Qcache_hits";
3403-Variable_name Value
3404-Qcache_hits 9
3405-prepare stmt from 'select * from t1 /* with "quote" */';
3406-execute stmt;
3407-a
3408-1
3409-2
3410-3
3411-show status like "Qcache_queries_in_cache";
3412-Variable_name Value
3413-Qcache_queries_in_cache 1
3414-show status like "Qcache_inserts";
3415-Variable_name Value
3416-Qcache_inserts 1
3417-show status like "Qcache_hits";
3418-Variable_name Value
3419-Qcache_hits 10
3420-prepare stmt from 'select * from t1 /* with \'quote\' */';
3421-execute stmt;
3422-a
3423-1
3424-2
3425-3
3426-show status like "Qcache_queries_in_cache";
3427-Variable_name Value
3428-Qcache_queries_in_cache 1
3429-show status like "Qcache_inserts";
3430-Variable_name Value
3431-Qcache_inserts 1
3432-show status like "Qcache_hits";
3433-Variable_name Value
3434-Qcache_hits 11
3435-prepare stmt from 'select * from t1 # 123
3436-';
3437-execute stmt;
3438-a
3439-1
3440-2
3441-3
3442-show status like "Qcache_queries_in_cache";
3443-Variable_name Value
3444-Qcache_queries_in_cache 1
3445-show status like "Qcache_inserts";
3446-Variable_name Value
3447-Qcache_inserts 1
3448-show status like "Qcache_hits";
3449-Variable_name Value
3450-Qcache_hits 12
3451-prepare stmt from 'select * from t1 # 123 with "quote"
3452-';
3453-execute stmt;
3454-a
3455-1
3456-2
3457-3
3458-show status like "Qcache_queries_in_cache";
3459-Variable_name Value
3460-Qcache_queries_in_cache 1
3461-show status like "Qcache_inserts";
3462-Variable_name Value
3463-Qcache_inserts 1
3464-show status like "Qcache_hits";
3465-Variable_name Value
3466-Qcache_hits 13
3467-prepare stmt from 'select * from t1 # 123 with \'quote\'
3468-';
3469-execute stmt;
3470-a
3471-1
3472-2
3473-3
3474-show status like "Qcache_queries_in_cache";
3475-Variable_name Value
3476-Qcache_queries_in_cache 1
3477-show status like "Qcache_inserts";
3478-Variable_name Value
3479-Qcache_inserts 1
3480-show status like "Qcache_hits";
3481-Variable_name Value
3482-Qcache_hits 14
3483-prepare stmt from 'select * from t1
3484-# 123
3485-';
3486-execute stmt;
3487-a
3488-1
3489-2
3490-3
3491-show status like "Qcache_queries_in_cache";
3492-Variable_name Value
3493-Qcache_queries_in_cache 1
3494-show status like "Qcache_inserts";
3495-Variable_name Value
3496-Qcache_inserts 1
3497-show status like "Qcache_hits";
3498-Variable_name Value
3499-Qcache_hits 15
3500-prepare stmt from '#456
3501-select * from t1
3502-# 123
3503-';
3504-execute stmt;
3505-a
3506-1
3507-2
3508-3
3509-show status like "Qcache_queries_in_cache";
3510-Variable_name Value
3511-Qcache_queries_in_cache 1
3512-show status like "Qcache_inserts";
3513-Variable_name Value
3514-Qcache_inserts 1
3515-show status like "Qcache_hits";
3516-Variable_name Value
3517-Qcache_hits 16
3518-prepare stmt from 'select * from t1 -- 123
3519-';
3520-execute stmt;
3521-a
3522-1
3523-2
3524-3
3525-show status like "Qcache_queries_in_cache";
3526-Variable_name Value
3527-Qcache_queries_in_cache 1
3528-show status like "Qcache_inserts";
3529-Variable_name Value
3530-Qcache_inserts 1
3531-show status like "Qcache_hits";
3532-Variable_name Value
3533-Qcache_hits 17
3534-prepare stmt from 'select * from t1
3535--- 123
3536-';
3537-execute stmt;
3538-a
3539-1
3540-2
3541-3
3542-show status like "Qcache_queries_in_cache";
3543-Variable_name Value
3544-Qcache_queries_in_cache 1
3545-show status like "Qcache_inserts";
3546-Variable_name Value
3547-Qcache_inserts 1
3548-show status like "Qcache_hits";
3549-Variable_name Value
3550-Qcache_hits 18
3551-prepare stmt from '-- comment in first
3552-select * from t1
3553-# 123
3554-';
3555-execute stmt;
3556-a
3557-1
3558-2
3559-3
3560-show status like "Qcache_queries_in_cache";
3561-Variable_name Value
3562-Qcache_queries_in_cache 1
3563-show status like "Qcache_inserts";
3564-Variable_name Value
3565-Qcache_inserts 1
3566-show status like "Qcache_hits";
3567-Variable_name Value
3568-Qcache_hits 19
3569-prepare stmt from '(#456(
3570-select * from t1
3571-# 123(
3572-)';
3573-execute stmt;
3574-a
3575-1
3576-2
3577-3
3578-show status like "Qcache_queries_in_cache";
3579-Variable_name Value
3580-Qcache_queries_in_cache 2
3581-show status like "Qcache_inserts";
3582-Variable_name Value
3583-Qcache_inserts 2
3584-show status like "Qcache_hits";
3585-Variable_name Value
3586-Qcache_hits 19
3587-prepare stmt from '/*test*/(-- comment in first(
3588-select * from t1
3589--- 123 asdasd
3590-/* test */)';
3591-execute stmt;
3592-a
3593-1
3594-2
3595-3
3596-show status like "Qcache_queries_in_cache";
3597-Variable_name Value
3598-Qcache_queries_in_cache 2
3599-show status like "Qcache_inserts";
3600-Variable_name Value
3601-Qcache_inserts 2
3602-show status like "Qcache_hits";
3603-Variable_name Value
3604-Qcache_hits 20
3605-prepare stmt from 'select "test",a from t1';
3606-execute stmt;
3607-test a
3608-test 1
3609-test 2
3610-test 3
3611-execute stmt;
3612-test a
3613-test 1
3614-test 2
3615-test 3
3616-show status like "Qcache_queries_in_cache";
3617-Variable_name Value
3618-Qcache_queries_in_cache 3
3619-show status like "Qcache_inserts";
3620-Variable_name Value
3621-Qcache_inserts 3
3622-show status like "Qcache_hits";
3623-Variable_name Value
3624-Qcache_hits 21
3625-prepare stmt from 'select "test /* internal \'comment\' */",a from t1';
3626-execute stmt;
3627-test /* internal 'comment' */ a
3628-test /* internal 'comment' */ 1
3629-test /* internal 'comment' */ 2
3630-test /* internal 'comment' */ 3
3631-show status like "Qcache_queries_in_cache";
3632-Variable_name Value
3633-Qcache_queries_in_cache 4
3634-show status like "Qcache_inserts";
3635-Variable_name Value
3636-Qcache_inserts 4
3637-show status like "Qcache_hits";
3638-Variable_name Value
3639-Qcache_hits 21
3640-prepare stmt from 'select "test #internal comment" ,a from t1';
3641-execute stmt;
3642-test #internal comment a
3643-test #internal comment 1
3644-test #internal comment 2
3645-test #internal comment 3
3646-show status like "Qcache_queries_in_cache";
3647-Variable_name Value
3648-Qcache_queries_in_cache 5
3649-show status like "Qcache_inserts";
3650-Variable_name Value
3651-Qcache_inserts 5
3652-show status like "Qcache_hits";
3653-Variable_name Value
3654-Qcache_hits 21
3655-prepare stmt from 'select "test #internal comment" #external comment
3656-,a from t1';
3657-execute stmt;
3658-test #internal comment a
3659-test #internal comment 1
3660-test #internal comment 2
3661-test #internal comment 3
3662-show status like "Qcache_queries_in_cache";
3663-Variable_name Value
3664-Qcache_queries_in_cache 5
3665-show status like "Qcache_inserts";
3666-Variable_name Value
3667-Qcache_inserts 5
3668-show status like "Qcache_hits";
3669-Variable_name Value
3670-Qcache_hits 22
3671-DROP TABLE t1;
3672-SET GLOBAL query_cache_size= default;
3673-set global query_cache_strip_comments=OFF;
3674
3675=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_prepared_statements.test'
3676--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_prepared_statements.test 2010-11-05 11:51:45 +0000
3677+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_prepared_statements.test 1970-01-01 00:00:00 +0000
3678@@ -1,208 +0,0 @@
3679--- source include/have_query_cache.inc
3680-
3681-set GLOBAL query_cache_size=1355776;
3682-
3683-# Reset query cache variables.
3684-flush query cache; # This crashed in some versions
3685-flush query cache; # This crashed in some versions
3686-reset query cache;
3687-flush status;
3688---disable_warnings
3689-drop table if exists t1;
3690---enable_warnings
3691-
3692-#
3693-# First simple test
3694-#
3695-
3696-create table t1 (a int not null);
3697-insert into t1 values (1),(2),(3);
3698-
3699-set global query_cache_strip_comments=ON;
3700-
3701-show status like "Qcache_queries_in_cache";
3702-show status like "Qcache_inserts";
3703-show status like "Qcache_hits";
3704-
3705-prepare stmt from '/* with comment */ select * from t1';
3706-execute stmt;
3707-
3708-show status like "Qcache_queries_in_cache";
3709-show status like "Qcache_inserts";
3710-show status like "Qcache_hits";
3711-
3712-execute stmt;
3713-execute stmt;
3714-execute stmt;
3715-execute stmt;
3716-execute stmt;
3717-
3718-show status like "Qcache_queries_in_cache";
3719-show status like "Qcache_inserts";
3720-show status like "Qcache_hits";
3721-
3722-prepare stmt from 'select * from t1';
3723-execute stmt;
3724-
3725-show status like "Qcache_queries_in_cache";
3726-show status like "Qcache_inserts";
3727-show status like "Qcache_hits";
3728-
3729-prepare stmt from 'select * /*internal comment*/from t1';
3730-execute stmt;
3731-
3732-show status like "Qcache_queries_in_cache";
3733-show status like "Qcache_inserts";
3734-show status like "Qcache_hits";
3735-
3736-prepare stmt from 'select * /*internal comment*/ from t1';
3737-execute stmt;
3738-
3739-show status like "Qcache_queries_in_cache";
3740-show status like "Qcache_inserts";
3741-show status like "Qcache_hits";
3742-
3743-prepare stmt from 'select * from t1 /* at the end */';
3744-execute stmt;
3745-
3746-show status like "Qcache_queries_in_cache";
3747-show status like "Qcache_inserts";
3748-show status like "Qcache_hits";
3749-
3750-prepare stmt from 'select * from t1 /* with "quote" */';
3751-execute stmt;
3752-
3753-show status like "Qcache_queries_in_cache";
3754-show status like "Qcache_inserts";
3755-show status like "Qcache_hits";
3756-
3757-prepare stmt from 'select * from t1 /* with \'quote\' */';
3758-execute stmt;
3759-
3760-show status like "Qcache_queries_in_cache";
3761-show status like "Qcache_inserts";
3762-show status like "Qcache_hits";
3763-
3764-prepare stmt from 'select * from t1 # 123
3765-';
3766-execute stmt;
3767-
3768-show status like "Qcache_queries_in_cache";
3769-show status like "Qcache_inserts";
3770-show status like "Qcache_hits";
3771-
3772-prepare stmt from 'select * from t1 # 123 with "quote"
3773-';
3774-execute stmt;
3775-
3776-show status like "Qcache_queries_in_cache";
3777-show status like "Qcache_inserts";
3778-show status like "Qcache_hits";
3779-
3780-prepare stmt from 'select * from t1 # 123 with \'quote\'
3781-';
3782-execute stmt;
3783-
3784-show status like "Qcache_queries_in_cache";
3785-show status like "Qcache_inserts";
3786-show status like "Qcache_hits";
3787-
3788-prepare stmt from 'select * from t1
3789-# 123
3790-';
3791-execute stmt;
3792-
3793-show status like "Qcache_queries_in_cache";
3794-show status like "Qcache_inserts";
3795-show status like "Qcache_hits";
3796-
3797-prepare stmt from '#456
3798-select * from t1
3799-# 123
3800-';
3801-execute stmt;
3802-
3803-show status like "Qcache_queries_in_cache";
3804-show status like "Qcache_inserts";
3805-show status like "Qcache_hits";
3806-
3807-prepare stmt from 'select * from t1 -- 123
3808-';
3809-execute stmt;
3810-
3811-show status like "Qcache_queries_in_cache";
3812-show status like "Qcache_inserts";
3813-show status like "Qcache_hits";
3814-
3815-prepare stmt from 'select * from t1
3816--- 123
3817-';
3818-execute stmt;
3819-
3820-show status like "Qcache_queries_in_cache";
3821-show status like "Qcache_inserts";
3822-show status like "Qcache_hits";
3823-
3824-prepare stmt from '-- comment in first
3825-select * from t1
3826-# 123
3827-';
3828-execute stmt;
3829-
3830-show status like "Qcache_queries_in_cache";
3831-show status like "Qcache_inserts";
3832-show status like "Qcache_hits";
3833-
3834-prepare stmt from '(#456(
3835-select * from t1
3836-# 123(
3837-)';
3838-execute stmt;
3839-
3840-show status like "Qcache_queries_in_cache";
3841-show status like "Qcache_inserts";
3842-show status like "Qcache_hits";
3843-
3844-prepare stmt from '/*test*/(-- comment in first(
3845-select * from t1
3846--- 123 asdasd
3847-/* test */)';
3848-execute stmt;
3849-
3850-show status like "Qcache_queries_in_cache";
3851-show status like "Qcache_inserts";
3852-show status like "Qcache_hits";
3853-
3854-prepare stmt from 'select "test",a from t1';
3855-execute stmt;
3856-execute stmt;
3857-
3858-show status like "Qcache_queries_in_cache";
3859-show status like "Qcache_inserts";
3860-show status like "Qcache_hits";
3861-
3862-prepare stmt from 'select "test /* internal \'comment\' */",a from t1';
3863-execute stmt;
3864-
3865-show status like "Qcache_queries_in_cache";
3866-show status like "Qcache_inserts";
3867-show status like "Qcache_hits";
3868-
3869-prepare stmt from 'select "test #internal comment" ,a from t1';
3870-execute stmt;
3871-
3872-show status like "Qcache_queries_in_cache";
3873-show status like "Qcache_inserts";
3874-show status like "Qcache_hits";
3875-
3876-prepare stmt from 'select "test #internal comment" #external comment
3877-,a from t1';
3878-execute stmt;
3879-
3880-show status like "Qcache_queries_in_cache";
3881-show status like "Qcache_inserts";
3882-show status like "Qcache_hits";
3883-
3884-DROP TABLE t1;
3885-SET GLOBAL query_cache_size= default;
3886-set global query_cache_strip_comments=OFF;
3887
3888=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_show.inc'
3889--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_show.inc 2010-11-05 11:51:45 +0000
3890+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_show.inc 1970-01-01 00:00:00 +0000
3891@@ -1,8 +0,0 @@
3892-let $show=show status like "Qcache_queries_in_cache";
3893-eval $show;
3894-let $show=show status like "Qcache_inserts";
3895-eval $show;
3896-let $show=show status like "Qcache_hits";
3897-eval $show;
3898-
3899-
3900
3901=== removed file 'mysql-test/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.result'
3902--- mysql-test/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.result 2010-11-05 11:51:45 +0000
3903+++ mysql-test/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.result 1970-01-01 00:00:00 +0000
3904@@ -1,27 +0,0 @@
3905-set GLOBAL query_cache_size=1355776;
3906-flush query cache;
3907-flush query cache;
3908-reset query cache;
3909-flush status;
3910-DROP TABLE IF EXISTS t;
3911-CREATE TABLE t(id INT, number INT);
3912-INSERT INTO t VALUES (0,1);
3913-INSERT INTO t VALUES (1,2);
3914-INSERT INTO t VALUES (2,3);
3915-SELECT number from t where id > 0;
3916-number
3917-2
3918-3
3919-SET SESSION debug="+d,status_wait_query_cache_mutex_sleep";
3920-SELECT number from t where id > 0;
3921-SET SESSION debug="+d,status_wait_query_cache_mutex_sleep";
3922-SELECT number from t where id > 0;
3923-SET SESSION debug="+d,status_wait_query_cache_mutex_sleep";
3924-SHOW PROCESSLIST;
3925-Id User Host db Command Time State Info
3926-Id root localhost test Sleep Time NULL
3927-Id root localhost test Query Time Waiting on query cache mutex SELECT number from t where id > 0
3928-Id root localhost test Query Time Waiting on query cache mutex SELECT number from t where id > 0
3929-Id root localhost test Query Time NULL SHOW PROCESSLIST
3930-DROP TABLE t;
3931-set GLOBAL query_cache_size=0;
3932
3933=== removed file 'mysql-test/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.test'
3934--- mysql-test/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.test 2010-12-06 03:50:48 +0000
3935+++ mysql-test/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.test 1970-01-01 00:00:00 +0000
3936@@ -1,37 +0,0 @@
3937---source include/have_query_cache.inc
3938---source include/have_debug.inc
3939-set GLOBAL query_cache_size=1355776;
3940---source include/percona_query_cache_with_comments_clear.inc
3941-
3942--- disable_warnings
3943-DROP TABLE IF EXISTS t;
3944--- enable_warnings
3945-CREATE TABLE t(id INT, number INT);
3946-INSERT INTO t VALUES (0,1);
3947-INSERT INTO t VALUES (1,2);
3948-INSERT INTO t VALUES (2,3);
3949-SELECT number from t where id > 0;
3950---connect (conn0,localhost,root,,)
3951---connect (conn1,localhost,root,,)
3952---connect (conn2,localhost,root,,)
3953-
3954---connection conn0
3955---error 0, ER_UNKNOWN_SYSTEM_VARIABLE
3956-SET SESSION debug="+d,status_wait_query_cache_mutex_sleep";
3957-SEND SELECT number from t where id > 0;
3958-SLEEP 1.0;
3959-
3960---connection conn1
3961---error 0, ER_UNKNOWN_SYSTEM_VARIABLE
3962-SET SESSION debug="+d,status_wait_query_cache_mutex_sleep";
3963-SEND SELECT number from t where id > 0;
3964-SLEEP 1.0;
3965-
3966---connection conn2
3967---error 0, ER_UNKNOWN_SYSTEM_VARIABLE
3968-SET SESSION debug="+d,status_wait_query_cache_mutex_sleep";
3969---replace_column 1 Id 6 Time
3970-SHOW PROCESSLIST;
3971-
3972-DROP TABLE t;
3973-set GLOBAL query_cache_size=0;
3974
3975=== removed directory 'mysql-test/show_slave_status_nolock.patch'
3976=== removed file 'mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.result'
3977--- mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.result 2011-03-01 10:05:10 +0000
3978+++ mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.result 1970-01-01 00:00:00 +0000
3979@@ -1,21 +0,0 @@
3980-include/master-slave.inc
3981-[connection master]
3982-DROP TABLE IF EXISTS t;
3983-CREATE TABLE t(id INT);
3984-INSERT INTO t SELECT SLEEP(10);
3985-STOP SLAVE;
3986-Warnings:
3987-Note 1592 Statement may not be safe to log in statement format.
3988-master count(*)
3989-master 1
3990-slave count(*)
3991-slave 0
3992-SHOW SLAVE STATUS NOLOCK;
3993-include/wait_for_slave_to_stop.inc
3994-START SLAVE;
3995-include/wait_for_slave_to_start.inc
3996-slave count(*)
3997-slave 1
3998-DROP TABLE t;
3999-STOP SLAVE;
4000-include/wait_for_slave_to_stop.inc
4001
4002=== removed file 'mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.test'
4003--- mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.test 2011-03-01 10:05:10 +0000
4004+++ mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.test 1970-01-01 00:00:00 +0000
4005@@ -1,50 +0,0 @@
4006---source include/master-slave.inc
4007---source include/have_binlog_format_statement.inc
4008-
4009-connection master;
4010- --disable_warnings
4011- DROP TABLE IF EXISTS t;
4012- --enable_warnings
4013- CREATE TABLE t(id INT);
4014- sync_slave_with_master;
4015-
4016-connection master;
4017- send INSERT INTO t SELECT SLEEP(10);
4018-
4019-connection slave;
4020- sleep 15;
4021- send STOP SLAVE;
4022-
4023-connection master;
4024- reap;
4025-
4026- --disable_query_log
4027- select "master",count(*) from t;
4028- --enable_query_log
4029-
4030-connection slave1;
4031- --disable_query_log
4032- select "slave",count(*) from t;
4033- --enable_query_log
4034-
4035- --disable_result_log
4036- SHOW SLAVE STATUS NOLOCK;
4037- --enable_result_log
4038-
4039-connection slave;
4040- reap;
4041-
4042- --source include/wait_for_slave_to_stop.inc
4043- START SLAVE;
4044- --source include/wait_for_slave_to_start.inc
4045-
4046- --disable_query_log
4047- select "slave",count(*) from t;
4048- --enable_query_log
4049-
4050-connection master;
4051- DROP TABLE t;
4052-sync_slave_with_master;
4053-
4054-STOP SLAVE;
4055---source include/wait_for_slave_to_stop.inc
4056
4057=== removed directory 'mysql-test/sql_no_fcache.patch'
4058=== removed file 'mysql-test/sql_no_fcache.patch/percona_sql_no_fcache.result'
4059--- mysql-test/sql_no_fcache.patch/percona_sql_no_fcache.result 2010-11-05 11:57:13 +0000
4060+++ mysql-test/sql_no_fcache.patch/percona_sql_no_fcache.result 1970-01-01 00:00:00 +0000
4061@@ -1,12 +0,0 @@
4062-drop table if exists t1;
4063-create table t (a int not null);
4064-insert into t values (1),(2),(3);
4065-SELECT SQL_NO_FCACHE SLEEP(0);
4066-SLEEP(0)
4067-0
4068-SELECT /*!40001 SQL_NO_CACHE */ /*!50084 SQL_NO_FCACHE */ * FROM t;
4069-a
4070-1
4071-2
4072-3
4073-DROP TABLE t;
4074
4075=== removed file 'mysql-test/sql_no_fcache.patch/percona_sql_no_fcache.test'
4076--- mysql-test/sql_no_fcache.patch/percona_sql_no_fcache.test 2010-12-06 03:50:48 +0000
4077+++ mysql-test/sql_no_fcache.patch/percona_sql_no_fcache.test 1970-01-01 00:00:00 +0000
4078@@ -1,11 +0,0 @@
4079---disable_warnings
4080-drop table if exists t1;
4081---enable_warnings
4082-
4083-create table t (a int not null);
4084-insert into t values (1),(2),(3);
4085-
4086-SELECT SQL_NO_FCACHE SLEEP(0);
4087-SELECT /*!40001 SQL_NO_CACHE */ /*!50084 SQL_NO_FCACHE */ * FROM t;
4088-
4089-DROP TABLE t;
4090
4091=== removed file 'mysql-test/userstat_bug602047.result'
4092--- mysql-test/userstat_bug602047.result 2011-02-26 09:03:28 +0000
4093+++ mysql-test/userstat_bug602047.result 1970-01-01 00:00:00 +0000
4094@@ -1,16 +0,0 @@
4095-DROP TABLE IF EXISTS t1;
4096-SET @userstat_running_old= @@userstat_running;
4097-SET GLOBAL userstat_running=ON;
4098-CREATE TABLE t1 ( id int(10), PRIMARY KEY (id)) ENGINE=InnoDB;
4099-INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
4100-SELECT COUNT(*) FROM t1;
4101-COUNT(*)
4102-10
4103-SELECT ROWS_READ FROM information_schema.table_statistics WHERE TABLE_NAME='t1';
4104-ROWS_READ
4105-10
4106-SELECT ROWS_READ FROM information_schema.index_statistics WHERE TABLE_NAME='t1';
4107-ROWS_READ
4108-10
4109-SET GLOBAL userstat_running= @userstat_running_old;
4110-DROP TABLE t1;
4111
4112=== removed file 'mysql-test/userstat_bug602047.test'
4113--- mysql-test/userstat_bug602047.test 2011-02-26 09:03:28 +0000
4114+++ mysql-test/userstat_bug602047.test 1970-01-01 00:00:00 +0000
4115@@ -1,13 +0,0 @@
4116---source include/have_innodb.inc
4117---disable_warnings
4118-DROP TABLE IF EXISTS t1;
4119---enable_warnings
4120-SET @userstat_running_old= @@userstat_running;
4121-SET GLOBAL userstat_running=ON;
4122-CREATE TABLE t1 ( id int(10), PRIMARY KEY (id)) ENGINE=InnoDB;
4123-INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
4124-SELECT COUNT(*) FROM t1;
4125-SELECT ROWS_READ FROM information_schema.table_statistics WHERE TABLE_NAME='t1';
4126-SELECT ROWS_READ FROM information_schema.index_statistics WHERE TABLE_NAME='t1';
4127-SET GLOBAL userstat_running= @userstat_running_old;
4128-DROP TABLE t1;
4129
4130=== modified file 'patches/innodb_admin_command_base.patch'
4131--- patches/innodb_admin_command_base.patch 2011-08-09 13:35:34 +0000
4132+++ patches/innodb_admin_command_base.patch 2011-09-06 08:39:24 +0000
4133@@ -175,3 +175,18 @@
4134 +{"innodb_admin_command_base","XtraDB specific command interface through i_s","","http://www.percona.com/docs/wiki/percona-xtradb"},
4135 {NULL, NULL, NULL, NULL}
4136 };
4137+--- /dev/null
4138++++ b/mysql-test/r/percona_xtradb_admin_command.result
4139+@@ -0,0 +1,6 @@
4140++select * from information_schema.XTRADB_ADMIN_COMMAND;
4141++result_message
4142++No XTRA_* command in the SQL statement. Please add /*!XTRA_xxxx*/ to the SQL.
4143++select * from information_schema.XTRADB_ADMIN_COMMAND /*!XTRA_HELLO*/;
4144++result_message
4145++Hello!
4146+--- /dev/null
4147++++ b/mysql-test/t/percona_xtradb_admin_command.test
4148+@@ -0,0 +1,3 @@
4149++--source include/have_innodb.inc
4150++select * from information_schema.XTRADB_ADMIN_COMMAND;
4151++select * from information_schema.XTRADB_ADMIN_COMMAND /*!XTRA_HELLO*/;
4152
4153=== modified file 'patches/innodb_buffer_pool_shm.patch'
4154--- patches/innodb_buffer_pool_shm.patch 2011-07-30 22:04:31 +0000
4155+++ patches/innodb_buffer_pool_shm.patch 2011-09-06 08:39:24 +0000
4156@@ -81,3 +81,21 @@
4157 MYSQL_SYSVAR(checksums),
4158 MYSQL_SYSVAR(fast_checksum),
4159 MYSQL_SYSVAR(commit_concurrency),
4160+--- /dev/null
4161++++ b/mysql-test/r/percona_innodb_buffer_pool_shm.result
4162+@@ -0,0 +1,4 @@
4163++show variables like 'innodb_buffer_pool_shm%';
4164++Variable_name Value
4165++innodb_buffer_pool_shm_checksum ON
4166++innodb_buffer_pool_shm_key 123456
4167+--- /dev/null
4168++++ b/mysql-test/t/percona_innodb_buffer_pool_shm-master.opt
4169+@@ -0,0 +1,2 @@
4170++--innodb_buffer_pool_shm_key=123456
4171++--innodb=FORCE
4172+--- /dev/null
4173++++ b/mysql-test/t/percona_innodb_buffer_pool_shm.test
4174+@@ -0,0 +1,3 @@
4175++--source include/have_innodb.inc
4176++show variables like 'innodb_buffer_pool_shm%';
4177++
4178
4179=== modified file 'patches/innodb_deadlock_count.patch'
4180--- patches/innodb_deadlock_count.patch 2011-08-09 13:35:34 +0000
4181+++ patches/innodb_deadlock_count.patch 2011-09-06 08:39:24 +0000
4182@@ -66,3 +66,98 @@
4183 #ifdef UNIV_DEBUG
4184 export_vars.innodb_buffer_pool_pages_latched
4185 = buf_get_latched_pages_number();
4186+--- /dev/null
4187++++ b/mysql-test/r/percona_innodb_deadlock_count.result
4188+@@ -0,0 +1,28 @@
4189++# Establish connection con1 (user=root)
4190++# Establish connection con2 (user=root)
4191++# Establish connection con3 (user=root)
4192++# Drop test table
4193++drop table if exists t;
4194++# Create test table
4195++create table t(a INT PRIMARY KEY, b INT) engine=InnoDB;
4196++# Insert two rows to test table
4197++insert into t values(2,1);
4198++insert into t values(1,2);
4199++# Switch to connection con1
4200++BEGIN;
4201++SELECT b FROM t WHERE a=1 FOR UPDATE;
4202++# Switch to connection con2
4203++BEGIN;
4204++SELECT b FROM t WHERE a=2 FOR UPDATE;
4205++# Switch to connection con1
4206++SELECT b FROM t WHERE a=2 FOR UPDATE;
4207++# Switch to connection con2
4208++SELECT b FROM t WHERE a=1 FOR UPDATE;
4209++# Switch to connection con1
4210++ROLLBACK;
4211++# Switch to connection con2
4212++ROLLBACK;
4213++# Switch to connection con3
4214++Deadlocks: 1
4215++# Drop test table
4216++drop table t;
4217+--- /dev/null
4218++++ b/mysql-test/t/percona_innodb_deadlock_count.test
4219+@@ -0,0 +1,61 @@
4220++--source include/have_innodb.inc
4221++--echo # Establish connection con1 (user=root)
4222++connect (con1,localhost,root,,);
4223++--echo # Establish connection con2 (user=root)
4224++connect (con2,localhost,root,,);
4225++--echo # Establish connection con3 (user=root)
4226++connect (con3,localhost,root,,);
4227++--echo # Drop test table
4228++--disable_warnings
4229++drop table if exists t;
4230++--enable_warnings
4231++
4232++--echo # Create test table
4233++create table t(a INT PRIMARY KEY, b INT) engine=InnoDB;
4234++--echo # Insert two rows to test table
4235++insert into t values(2,1);
4236++insert into t values(1,2);
4237++
4238++#--echo # Save current deadlock count
4239++let $current = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Innodb_deadlocks'`;
4240++
4241++--disable_result_log
4242++
4243++--echo # Switch to connection con1
4244++connection con1;
4245++BEGIN; SELECT b FROM t WHERE a=1 FOR UPDATE;
4246++
4247++--echo # Switch to connection con2
4248++connection con2;
4249++BEGIN; SELECT b FROM t WHERE a=2 FOR UPDATE;
4250++
4251++--echo # Switch to connection con1
4252++connection con1;
4253++SEND SELECT b FROM t WHERE a=2 FOR UPDATE;
4254++
4255++--echo # Switch to connection con2
4256++connection con2;
4257++SEND SELECT b FROM t WHERE a=1 FOR UPDATE;
4258++
4259++--echo # Switch to connection con1
4260++connection con1;
4261++--error 0, ER_LOCK_DEADLOCK
4262++reap;
4263++ROLLBACK;
4264++
4265++--echo # Switch to connection con2
4266++connection con2;
4267++--error 0, ER_LOCK_DEADLOCK
4268++reap;
4269++ROLLBACK;
4270++
4271++--echo # Switch to connection con3
4272++connection con3;
4273++let $result = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Innodb_deadlocks'`;
4274++
4275++--enable_result_log
4276++
4277++let $diff = `SELECT $result - $current`;
4278++echo Deadlocks: $diff;
4279++--echo # Drop test table
4280++drop table t;
4281
4282=== modified file 'patches/innodb_fix_misc.patch'
4283--- patches/innodb_fix_misc.patch 2011-08-09 13:35:34 +0000
4284+++ patches/innodb_fix_misc.patch 2011-09-06 08:39:24 +0000
4285@@ -1359,3 +1359,35 @@
4286 float ratio = (float) trx_sys->rseg_history_len
4287 / srv_max_purge_lag;
4288 if (ratio > ULINT_MAX / 10000) {
4289+--- /dev/null
4290++++ b/mysql-test/r/innodb_fix_misc_bug51325.result
4291+@@ -0,0 +1,13 @@
4292++DROP TABLE IF EXISTS t1;
4293++SET GLOBAL innodb_file_per_table=ON;
4294++SHOW VARIABLES LIKE 'innodb_lazy_drop_table';
4295++Variable_name Value
4296++innodb_lazy_drop_table 0
4297++SET GLOBAL innodb_lazy_drop_table=1;
4298++SHOW VARIABLES LIKE 'innodb_lazy_drop_table';
4299++Variable_name Value
4300++innodb_lazy_drop_table 1
4301++CREATE TABLE t1 (a INT) ENGINE=InnoDB;
4302++DROP TABLE t1;
4303++SET GLOBAL innodb_lazy_drop_table=default;
4304++SET GLOBAL innodb_file_per_table=default;
4305+--- /dev/null
4306++++ b/mysql-test/t/innodb_fix_misc_bug51325.test
4307+@@ -0,0 +1,13 @@
4308++# Test for 'innodb_lazy_drop_table' variable
4309++--source include/have_innodb.inc
4310++--disable_warnings
4311++DROP TABLE IF EXISTS t1;
4312++--enable_warnings
4313++SET GLOBAL innodb_file_per_table=ON;
4314++SHOW VARIABLES LIKE 'innodb_lazy_drop_table';
4315++SET GLOBAL innodb_lazy_drop_table=1;
4316++SHOW VARIABLES LIKE 'innodb_lazy_drop_table';
4317++CREATE TABLE t1 (a INT) ENGINE=InnoDB;
4318++DROP TABLE t1;
4319++SET GLOBAL innodb_lazy_drop_table=default;
4320++SET GLOBAL innodb_file_per_table=default;
4321
4322=== modified file 'patches/innodb_separate_doublewrite.patch'
4323--- patches/innodb_separate_doublewrite.patch 2011-08-09 13:35:34 +0000
4324+++ patches/innodb_separate_doublewrite.patch 2011-09-06 08:39:24 +0000
4325@@ -1078,3 +1078,19 @@
4326 /*********************************************************************
4327 Create extra rollback segments when create_new_db */
4328 UNIV_INTERN
4329+--- /dev/null
4330++++ b/mysql-test/r/percona_innodb_doublewrite_file.result
4331+@@ -0,0 +1,4 @@
4332++show variables like 'innodb_doublewrite%';
4333++Variable_name Value
4334++innodb_doublewrite ON
4335++innodb_doublewrite_file ib_doublewrite
4336+--- /dev/null
4337++++ b/mysql-test/t/percona_innodb_doublewrite_file-master.opt
4338+@@ -0,0 +1 @@
4339++--innodb_doublewrite_file=ib_doublewrite
4340+--- /dev/null
4341++++ b/mysql-test/t/percona_innodb_doublewrite_file.test
4342+@@ -0,0 +1,2 @@
4343++--source include/have_innodb.inc
4344++show variables like 'innodb_doublewrite%';
4345
4346=== modified file 'patches/innodb_show_sys_tables.patch'
4347--- patches/innodb_show_sys_tables.patch 2011-08-09 13:35:34 +0000
4348+++ patches/innodb_show_sys_tables.patch 2011-09-06 08:39:24 +0000
4349@@ -719,3 +719,18 @@
4350 +{"innodb_sys_tables_sys_indexes","Expose InnoDB SYS_TABLES and SYS_INDEXES schema tables","","http://www.percona.com/docs/wiki/percona-xtradb"},
4351 {NULL, NULL, NULL, NULL}
4352 };
4353+--- /dev/null
4354++++ b/mysql-test/r/percona_innodb_use_sys_stats_table.result
4355+@@ -0,0 +1,3 @@
4356++show variables like 'innodb_use_sys_stats%';
4357++Variable_name Value
4358++innodb_use_sys_stats_table ON
4359+--- /dev/null
4360++++ b/mysql-test/t/percona_innodb_use_sys_stats_table-master.opt
4361+@@ -0,0 +1 @@
4362++--innodb_use_sys_stats_table
4363+--- /dev/null
4364++++ b/mysql-test/t/percona_innodb_use_sys_stats_table.test
4365+@@ -0,0 +1,2 @@
4366++--source include/have_innodb.inc
4367++show variables like 'innodb_use_sys_stats%';
4368
4369=== modified file 'patches/mysql-test.diff'
4370--- patches/mysql-test.diff 2011-08-13 01:47:38 +0000
4371+++ patches/mysql-test.diff 2011-09-06 08:39:24 +0000
4372@@ -3989,4 +3989,728 @@
4373
4374 connection slave;
4375 drop table first_db.t1;
4376-
4377+--- /dev/null
4378++++ b/mysql-test/include/have_nodebug.inc
4379+@@ -0,0 +1,4 @@
4380++-- require r/have_nodebug.require
4381++disable_query_log;
4382++select (version() like '%debug%') as debug;
4383++enable_query_log;
4384+--- /dev/null
4385++++ b/mysql-test/include/percona_server_variables.inc
4386+@@ -0,0 +1,3 @@
4387++--source include/have_response_time_distribution.inc
4388++--source include/have_innodb.inc
4389++SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
4390+--- /dev/null
4391++++ b/mysql-test/r/have_nodebug.require
4392+@@ -0,0 +1,2 @@
4393++debug
4394++0
4395+--- /dev/null
4396++++ b/mysql-test/r/percona_server_variables_debug.result
4397+@@ -0,0 +1,347 @@
4398++SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
4399++Variable_name
4400++AUTOCOMMIT
4401++AUTOMATIC_SP_PRIVILEGES
4402++AUTO_INCREMENT_INCREMENT
4403++AUTO_INCREMENT_OFFSET
4404++BACK_LOG
4405++BASEDIR
4406++BIG_TABLES
4407++BINLOG_CACHE_SIZE
4408++BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES
4409++BINLOG_FORMAT
4410++BULK_INSERT_BUFFER_SIZE
4411++CHARACTER_SETS_DIR
4412++CHARACTER_SET_CLIENT
4413++CHARACTER_SET_CONNECTION
4414++CHARACTER_SET_DATABASE
4415++CHARACTER_SET_FILESYSTEM
4416++CHARACTER_SET_RESULTS
4417++CHARACTER_SET_SERVER
4418++CHARACTER_SET_SYSTEM
4419++COLLATION_CONNECTION
4420++COLLATION_DATABASE
4421++COLLATION_SERVER
4422++COMPLETION_TYPE
4423++CONCURRENT_INSERT
4424++CONNECT_TIMEOUT
4425++DATADIR
4426++DATETIME_FORMAT
4427++DATE_FORMAT
4428++DEBUG
4429++DEBUG_SYNC
4430++DEFAULT_WEEK_FORMAT
4431++DELAYED_INSERT_LIMIT
4432++DELAYED_INSERT_TIMEOUT
4433++DELAYED_QUEUE_SIZE
4434++DELAY_KEY_WRITE
4435++DIV_PRECISION_INCREMENT
4436++ENABLE_QUERY_RESPONSE_TIME_STATS
4437++ENGINE_CONDITION_PUSHDOWN
4438++ERROR_COUNT
4439++EVENT_SCHEDULER
4440++EXPIRE_LOGS_DAYS
4441++FAST_INDEX_CREATION
4442++FLUSH
4443++FLUSH_TIME
4444++FOREIGN_KEY_CHECKS
4445++FT_BOOLEAN_SYNTAX
4446++FT_MAX_WORD_LEN
4447++FT_MIN_WORD_LEN
4448++FT_QUERY_EXPANSION_LIMIT
4449++FT_STOPWORD_FILE
4450++GENERAL_LOG
4451++GENERAL_LOG_FILE
4452++GROUP_CONCAT_MAX_LEN
4453++HAVE_COMMUNITY_FEATURES
4454++HAVE_COMPRESS
4455++HAVE_CRYPT
4456++HAVE_CSV
4457++HAVE_DYNAMIC_LOADING
4458++HAVE_GEOMETRY
4459++HAVE_INNODB
4460++HAVE_NDBCLUSTER
4461++HAVE_OPENSSL
4462++HAVE_PARTITIONING
4463++HAVE_QUERY_CACHE
4464++HAVE_RESPONSE_TIME_DISTRIBUTION
4465++HAVE_RTREE_KEYS
4466++HAVE_SSL
4467++HAVE_SYMLINK
4468++HOSTNAME
4469++IDENTITY
4470++IGNORE_BUILTIN_INNODB
4471++INIT_CONNECT
4472++INIT_FILE
4473++INIT_SLAVE
4474++INNODB_ADAPTIVE_CHECKPOINT
4475++INNODB_ADAPTIVE_FLUSHING
4476++INNODB_ADAPTIVE_HASH_INDEX
4477++INNODB_ADDITIONAL_MEM_POOL_SIZE
4478++INNODB_AUTOEXTEND_INCREMENT
4479++INNODB_AUTOINC_LOCK_MODE
4480++INNODB_AUTO_LRU_DUMP
4481++INNODB_BUFFER_POOL_SHM_CHECKSUM
4482++INNODB_BUFFER_POOL_SHM_KEY
4483++INNODB_BUFFER_POOL_SIZE
4484++INNODB_CHANGE_BUFFERING
4485++INNODB_CHECKPOINT_AGE_TARGET
4486++INNODB_CHECKSUMS
4487++INNODB_COMMIT_CONCURRENCY
4488++INNODB_CONCURRENCY_TICKETS
4489++INNODB_DATA_FILE_PATH
4490++INNODB_DATA_HOME_DIR
4491++INNODB_DICT_SIZE_LIMIT
4492++INNODB_DOUBLEWRITE
4493++INNODB_DOUBLEWRITE_FILE
4494++INNODB_ENABLE_UNSAFE_GROUP_COMMIT
4495++INNODB_EXPAND_IMPORT
4496++INNODB_EXTRA_RSEGMENTS
4497++INNODB_EXTRA_UNDOSLOTS
4498++INNODB_FAST_CHECKSUM
4499++INNODB_FAST_RECOVERY
4500++INNODB_FAST_SHUTDOWN
4501++INNODB_FILE_FORMAT
4502++INNODB_FILE_FORMAT_CHECK
4503++INNODB_FILE_PER_TABLE
4504++INNODB_FLUSH_LOG_AT_TRX_COMMIT
4505++INNODB_FLUSH_LOG_AT_TRX_COMMIT_SESSION
4506++INNODB_FLUSH_METHOD
4507++INNODB_FLUSH_NEIGHBOR_PAGES
4508++INNODB_FORCE_RECOVERY
4509++INNODB_IBUF_ACCEL_RATE
4510++INNODB_IBUF_ACTIVE_CONTRACT
4511++INNODB_IBUF_MAX_SIZE
4512++INNODB_IO_CAPACITY
4513++INNODB_LAZY_DROP_TABLE
4514++INNODB_LOCKS_UNSAFE_FOR_BINLOG
4515++INNODB_LOCK_WAIT_TIMEOUT
4516++INNODB_LOG_BLOCK_SIZE
4517++INNODB_LOG_BUFFER_SIZE
4518++INNODB_LOG_FILES_IN_GROUP
4519++INNODB_LOG_FILE_SIZE
4520++INNODB_LOG_GROUP_HOME_DIR
4521++INNODB_MAX_DIRTY_PAGES_PCT
4522++INNODB_MAX_PURGE_LAG
4523++INNODB_MIRRORED_LOG_GROUPS
4524++INNODB_OLD_BLOCKS_PCT
4525++INNODB_OLD_BLOCKS_TIME
4526++INNODB_OPEN_FILES
4527++INNODB_OVERWRITE_RELAY_LOG_INFO
4528++INNODB_PAGE_SIZE
4529++INNODB_PASS_CORRUPT_TABLE
4530++INNODB_READ_AHEAD
4531++INNODB_READ_AHEAD_THRESHOLD
4532++INNODB_READ_IO_THREADS
4533++INNODB_RECOVERY_STATS
4534++INNODB_REPLICATION_DELAY
4535++INNODB_ROLLBACK_ON_TIMEOUT
4536++INNODB_SHOW_LOCKS_HELD
4537++INNODB_SHOW_VERBOSE_LOCKS
4538++INNODB_SPIN_WAIT_DELAY
4539++INNODB_STATS_AUTO_UPDATE
4540++INNODB_STATS_METHOD
4541++INNODB_STATS_ON_METADATA
4542++INNODB_STATS_SAMPLE_PAGES
4543++INNODB_STATS_UPDATE_NEED_LOCK
4544++INNODB_STRICT_MODE
4545++INNODB_SUPPORT_XA
4546++INNODB_SYNC_SPIN_LOOPS
4547++INNODB_TABLE_LOCKS
4548++INNODB_THREAD_CONCURRENCY
4549++INNODB_THREAD_CONCURRENCY_TIMER_BASED
4550++INNODB_THREAD_SLEEP_DELAY
4551++INNODB_USE_PURGE_THREAD
4552++INNODB_USE_SYS_MALLOC
4553++INNODB_USE_SYS_STATS_TABLE
4554++INNODB_VERSION
4555++INNODB_WRITE_IO_THREADS
4556++INSERT_ID
4557++INTERACTIVE_TIMEOUT
4558++JOIN_BUFFER_SIZE
4559++KEEP_FILES_ON_CREATE
4560++KEY_BUFFER_SIZE
4561++KEY_CACHE_AGE_THRESHOLD
4562++KEY_CACHE_BLOCK_SIZE
4563++KEY_CACHE_DIVISION_LIMIT
4564++LANGUAGE
4565++LARGE_FILES_SUPPORT
4566++LARGE_PAGES
4567++LARGE_PAGE_SIZE
4568++LAST_INSERT_ID
4569++LC_TIME_NAMES
4570++LICENSE
4571++LOCAL_INFILE
4572++LOCKED_IN_MEMORY
4573++LOG
4574++LOG_BIN
4575++LOG_BIN_TRUST_FUNCTION_CREATORS
4576++LOG_BIN_TRUST_ROUTINE_CREATORS
4577++LOG_ERROR
4578++LOG_OUTPUT
4579++LOG_QUERIES_NOT_USING_INDEXES
4580++LOG_SLAVE_UPDATES
4581++LOG_SLOW_FILTER
4582++LOG_SLOW_QUERIES
4583++LOG_SLOW_RATE_LIMIT
4584++LOG_SLOW_SLAVE_STATEMENTS
4585++LOG_SLOW_SP_STATEMENTS
4586++LOG_SLOW_TIMESTAMP_EVERY
4587++LOG_SLOW_VERBOSITY
4588++LOG_WARNINGS
4589++LONG_QUERY_TIME
4590++LOWER_CASE_FILE_SYSTEM
4591++LOWER_CASE_TABLE_NAMES
4592++LOW_PRIORITY_UPDATES
4593++MAX_ALLOWED_PACKET
4594++MAX_BINLOG_CACHE_SIZE
4595++MAX_BINLOG_SIZE
4596++MAX_CONNECTIONS
4597++MAX_CONNECT_ERRORS
4598++MAX_DELAYED_THREADS
4599++MAX_ERROR_COUNT
4600++MAX_HEAP_TABLE_SIZE
4601++MAX_INSERT_DELAYED_THREADS
4602++MAX_JOIN_SIZE
4603++MAX_LENGTH_FOR_SORT_DATA
4604++MAX_LONG_DATA_SIZE
4605++MAX_PREPARED_STMT_COUNT
4606++MAX_RELAY_LOG_SIZE
4607++MAX_SEEKS_FOR_KEY
4608++MAX_SORT_LENGTH
4609++MAX_SP_RECURSION_DEPTH
4610++MAX_TMP_TABLES
4611++MAX_USER_CONNECTIONS
4612++MAX_WRITE_LOCK_COUNT
4613++MIN_EXAMINED_ROW_LIMIT
4614++MULTI_RANGE_COUNT
4615++MYISAM_DATA_POINTER_SIZE
4616++MYISAM_MAX_SORT_FILE_SIZE
4617++MYISAM_MMAP_SIZE
4618++MYISAM_RECOVER_OPTIONS
4619++MYISAM_REPAIR_THREADS
4620++MYISAM_SORT_BUFFER_SIZE
4621++MYISAM_STATS_METHOD
4622++MYISAM_USE_MMAP
4623++NET_BUFFER_LENGTH
4624++NET_READ_TIMEOUT
4625++NET_RETRY_COUNT
4626++NET_WRITE_TIMEOUT
4627++NEW
4628++OLD
4629++OLD_ALTER_TABLE
4630++OLD_PASSWORDS
4631++OPEN_FILES_LIMIT
4632++OPTIMIZER_FIX
4633++OPTIMIZER_PRUNE_LEVEL
4634++OPTIMIZER_SEARCH_DEPTH
4635++OPTIMIZER_SWITCH
4636++PID_FILE
4637++PLUGIN_DIR
4638++PORT
4639++PRELOAD_BUFFER_SIZE
4640++PROFILING
4641++PROFILING_HISTORY_SIZE
4642++PROFILING_SERVER
4643++PROFILING_USE_GETRUSAGE
4644++PROTOCOL_VERSION
4645++PSEUDO_THREAD_ID
4646++QUERY_ALLOC_BLOCK_SIZE
4647++QUERY_CACHE_LIMIT
4648++QUERY_CACHE_MIN_RES_UNIT
4649++QUERY_CACHE_SIZE
4650++QUERY_CACHE_STRIP_COMMENTS
4651++QUERY_CACHE_TYPE
4652++QUERY_CACHE_WLOCK_INVALIDATE
4653++QUERY_EXEC_TIME
4654++QUERY_PREALLOC_SIZE
4655++QUERY_RESPONSE_TIME_RANGE_BASE
4656++RAND_SEED1
4657++RAND_SEED2
4658++RANGE_ALLOC_BLOCK_SIZE
4659++READ_BUFFER_SIZE
4660++READ_ONLY
4661++READ_RND_BUFFER_SIZE
4662++RELAY_LOG
4663++RELAY_LOG_INDEX
4664++RELAY_LOG_INFO_FILE
4665++RELAY_LOG_PURGE
4666++RELAY_LOG_SPACE_LIMIT
4667++REPORT_HOST
4668++REPORT_PASSWORD
4669++REPORT_PORT
4670++REPORT_USER
4671++RPL_RECOVERY_RANK
4672++SECURE_AUTH
4673++SECURE_FILE_PRIV
4674++SERVER_ID
4675++SKIP_EXTERNAL_LOCKING
4676++SKIP_NAME_RESOLVE
4677++SKIP_NETWORKING
4678++SKIP_SHOW_DATABASE
4679++SLAVE_COMPRESSED_PROTOCOL
4680++SLAVE_EXEC_MODE
4681++SLAVE_LOAD_TMPDIR
4682++SLAVE_NET_TIMEOUT
4683++SLAVE_SKIP_ERRORS
4684++SLAVE_TRANSACTION_RETRIES
4685++SLOW_LAUNCH_TIME
4686++SLOW_QUERY_LOG
4687++SLOW_QUERY_LOG_FILE
4688++SLOW_QUERY_LOG_MICROSECONDS_TIMESTAMP
4689++SOCKET
4690++SORT_BUFFER_SIZE
4691++SQL_AUTO_IS_NULL
4692++SQL_BIG_SELECTS
4693++SQL_BIG_TABLES
4694++SQL_BUFFER_RESULT
4695++SQL_LOG_BIN
4696++SQL_LOG_OFF
4697++SQL_LOG_UPDATE
4698++SQL_LOW_PRIORITY_UPDATES
4699++SQL_MAX_JOIN_SIZE
4700++SQL_MODE
4701++SQL_NOTES
4702++SQL_QUOTE_SHOW_CREATE
4703++SQL_SAFE_UPDATES
4704++SQL_SELECT_LIMIT
4705++SQL_SLAVE_SKIP_COUNTER
4706++SQL_WARNINGS
4707++SSL_CA
4708++SSL_CAPATH
4709++SSL_CERT
4710++SSL_CIPHER
4711++SSL_KEY
4712++STORAGE_ENGINE
4713++SUPPRESS_LOG_WARNING_1592
4714++SYNC_BINLOG
4715++SYNC_FRM
4716++SYSTEM_TIME_ZONE
4717++TABLE_DEFINITION_CACHE
4718++TABLE_LOCK_WAIT_TIMEOUT
4719++TABLE_OPEN_CACHE
4720++TABLE_TYPE
4721++THREAD_CACHE_SIZE
4722++THREAD_HANDLING
4723++THREAD_STACK
4724++THREAD_STATISTICS
4725++TIMED_MUTEXES
4726++TIMESTAMP
4727++TIME_FORMAT
4728++TIME_ZONE
4729++TMPDIR
4730++TMP_TABLE_SIZE
4731++TRANSACTION_ALLOC_BLOCK_SIZE
4732++TRANSACTION_PREALLOC_SIZE
4733++TX_ISOLATION
4734++UNIQUE_CHECKS
4735++UPDATABLE_VIEWS_WITH_LIMIT
4736++USERSTAT_RUNNING
4737++USE_GLOBAL_LOG_SLOW_CONTROL
4738++USE_GLOBAL_LONG_QUERY_TIME
4739++VERSION
4740++VERSION_COMMENT
4741++VERSION_COMPILE_MACHINE
4742++VERSION_COMPILE_OS
4743++WAIT_TIMEOUT
4744++WARNING_COUNT
4745+--- /dev/null
4746++++ b/mysql-test/r/percona_server_variables_release.result
4747+@@ -0,0 +1,344 @@
4748++SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
4749++Variable_name
4750++AUTOCOMMIT
4751++AUTOMATIC_SP_PRIVILEGES
4752++AUTO_INCREMENT_INCREMENT
4753++AUTO_INCREMENT_OFFSET
4754++BACK_LOG
4755++BASEDIR
4756++BIG_TABLES
4757++BINLOG_CACHE_SIZE
4758++BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES
4759++BINLOG_FORMAT
4760++BULK_INSERT_BUFFER_SIZE
4761++CHARACTER_SETS_DIR
4762++CHARACTER_SET_CLIENT
4763++CHARACTER_SET_CONNECTION
4764++CHARACTER_SET_DATABASE
4765++CHARACTER_SET_FILESYSTEM
4766++CHARACTER_SET_RESULTS
4767++CHARACTER_SET_SERVER
4768++CHARACTER_SET_SYSTEM
4769++COLLATION_CONNECTION
4770++COLLATION_DATABASE
4771++COLLATION_SERVER
4772++COMPLETION_TYPE
4773++CONCURRENT_INSERT
4774++CONNECT_TIMEOUT
4775++DATADIR
4776++DATETIME_FORMAT
4777++DATE_FORMAT
4778++DEFAULT_WEEK_FORMAT
4779++DELAYED_INSERT_LIMIT
4780++DELAYED_INSERT_TIMEOUT
4781++DELAYED_QUEUE_SIZE
4782++DELAY_KEY_WRITE
4783++DIV_PRECISION_INCREMENT
4784++ENABLE_QUERY_RESPONSE_TIME_STATS
4785++ENGINE_CONDITION_PUSHDOWN
4786++ERROR_COUNT
4787++EVENT_SCHEDULER
4788++EXPIRE_LOGS_DAYS
4789++FAST_INDEX_CREATION
4790++FLUSH
4791++FLUSH_TIME
4792++FOREIGN_KEY_CHECKS
4793++FT_BOOLEAN_SYNTAX
4794++FT_MAX_WORD_LEN
4795++FT_MIN_WORD_LEN
4796++FT_QUERY_EXPANSION_LIMIT
4797++FT_STOPWORD_FILE
4798++GENERAL_LOG
4799++GENERAL_LOG_FILE
4800++GROUP_CONCAT_MAX_LEN
4801++HAVE_COMMUNITY_FEATURES
4802++HAVE_COMPRESS
4803++HAVE_CRYPT
4804++HAVE_CSV
4805++HAVE_DYNAMIC_LOADING
4806++HAVE_GEOMETRY
4807++HAVE_INNODB
4808++HAVE_NDBCLUSTER
4809++HAVE_OPENSSL
4810++HAVE_PARTITIONING
4811++HAVE_QUERY_CACHE
4812++HAVE_RESPONSE_TIME_DISTRIBUTION
4813++HAVE_RTREE_KEYS
4814++HAVE_SSL
4815++HAVE_SYMLINK
4816++HOSTNAME
4817++IDENTITY
4818++IGNORE_BUILTIN_INNODB
4819++INIT_CONNECT
4820++INIT_FILE
4821++INIT_SLAVE
4822++INNODB_ADAPTIVE_CHECKPOINT
4823++INNODB_ADAPTIVE_FLUSHING
4824++INNODB_ADAPTIVE_HASH_INDEX
4825++INNODB_ADDITIONAL_MEM_POOL_SIZE
4826++INNODB_AUTOEXTEND_INCREMENT
4827++INNODB_AUTOINC_LOCK_MODE
4828++INNODB_AUTO_LRU_DUMP
4829++INNODB_BUFFER_POOL_SHM_CHECKSUM
4830++INNODB_BUFFER_POOL_SHM_KEY
4831++INNODB_BUFFER_POOL_SIZE
4832++INNODB_CHANGE_BUFFERING
4833++INNODB_CHECKPOINT_AGE_TARGET
4834++INNODB_CHECKSUMS
4835++INNODB_COMMIT_CONCURRENCY
4836++INNODB_CONCURRENCY_TICKETS
4837++INNODB_DATA_FILE_PATH
4838++INNODB_DATA_HOME_DIR
4839++INNODB_DICT_SIZE_LIMIT
4840++INNODB_DOUBLEWRITE
4841++INNODB_DOUBLEWRITE_FILE
4842++INNODB_ENABLE_UNSAFE_GROUP_COMMIT
4843++INNODB_EXPAND_IMPORT
4844++INNODB_EXTRA_RSEGMENTS
4845++INNODB_EXTRA_UNDOSLOTS
4846++INNODB_FAST_CHECKSUM
4847++INNODB_FAST_RECOVERY
4848++INNODB_FAST_SHUTDOWN
4849++INNODB_FILE_FORMAT
4850++INNODB_FILE_FORMAT_CHECK
4851++INNODB_FILE_PER_TABLE
4852++INNODB_FLUSH_LOG_AT_TRX_COMMIT
4853++INNODB_FLUSH_LOG_AT_TRX_COMMIT_SESSION
4854++INNODB_FLUSH_METHOD
4855++INNODB_FLUSH_NEIGHBOR_PAGES
4856++INNODB_FORCE_RECOVERY
4857++INNODB_IBUF_ACCEL_RATE
4858++INNODB_IBUF_ACTIVE_CONTRACT
4859++INNODB_IBUF_MAX_SIZE
4860++INNODB_IO_CAPACITY
4861++INNODB_LAZY_DROP_TABLE
4862++INNODB_LOCKS_UNSAFE_FOR_BINLOG
4863++INNODB_LOCK_WAIT_TIMEOUT
4864++INNODB_LOG_BLOCK_SIZE
4865++INNODB_LOG_BUFFER_SIZE
4866++INNODB_LOG_FILES_IN_GROUP
4867++INNODB_LOG_FILE_SIZE
4868++INNODB_LOG_GROUP_HOME_DIR
4869++INNODB_MAX_DIRTY_PAGES_PCT
4870++INNODB_MAX_PURGE_LAG
4871++INNODB_MIRRORED_LOG_GROUPS
4872++INNODB_OLD_BLOCKS_PCT
4873++INNODB_OLD_BLOCKS_TIME
4874++INNODB_OPEN_FILES
4875++INNODB_OVERWRITE_RELAY_LOG_INFO
4876++INNODB_PAGE_SIZE
4877++INNODB_PASS_CORRUPT_TABLE
4878++INNODB_READ_AHEAD
4879++INNODB_READ_AHEAD_THRESHOLD
4880++INNODB_READ_IO_THREADS
4881++INNODB_RECOVERY_STATS
4882++INNODB_REPLICATION_DELAY
4883++INNODB_ROLLBACK_ON_TIMEOUT
4884++INNODB_SHOW_LOCKS_HELD
4885++INNODB_SHOW_VERBOSE_LOCKS
4886++INNODB_SPIN_WAIT_DELAY
4887++INNODB_STATS_AUTO_UPDATE
4888++INNODB_STATS_METHOD
4889++INNODB_STATS_ON_METADATA
4890++INNODB_STATS_SAMPLE_PAGES
4891++INNODB_STATS_UPDATE_NEED_LOCK
4892++INNODB_STRICT_MODE
4893++INNODB_SUPPORT_XA
4894++INNODB_SYNC_SPIN_LOOPS
4895++INNODB_TABLE_LOCKS
4896++INNODB_THREAD_CONCURRENCY
4897++INNODB_THREAD_CONCURRENCY_TIMER_BASED
4898++INNODB_THREAD_SLEEP_DELAY
4899++INNODB_USE_PURGE_THREAD
4900++INNODB_USE_SYS_MALLOC
4901++INNODB_USE_SYS_STATS_TABLE
4902++INNODB_VERSION
4903++INNODB_WRITE_IO_THREADS
4904++INSERT_ID
4905++INTERACTIVE_TIMEOUT
4906++JOIN_BUFFER_SIZE
4907++KEEP_FILES_ON_CREATE
4908++KEY_BUFFER_SIZE
4909++KEY_CACHE_AGE_THRESHOLD
4910++KEY_CACHE_BLOCK_SIZE
4911++KEY_CACHE_DIVISION_LIMIT
4912++LANGUAGE
4913++LARGE_FILES_SUPPORT
4914++LARGE_PAGES
4915++LARGE_PAGE_SIZE
4916++LAST_INSERT_ID
4917++LC_TIME_NAMES
4918++LICENSE
4919++LOCAL_INFILE
4920++LOCKED_IN_MEMORY
4921++LOG
4922++LOG_BIN
4923++LOG_BIN_TRUST_FUNCTION_CREATORS
4924++LOG_BIN_TRUST_ROUTINE_CREATORS
4925++LOG_ERROR
4926++LOG_OUTPUT
4927++LOG_QUERIES_NOT_USING_INDEXES
4928++LOG_SLAVE_UPDATES
4929++LOG_SLOW_FILTER
4930++LOG_SLOW_QUERIES
4931++LOG_SLOW_RATE_LIMIT
4932++LOG_SLOW_SLAVE_STATEMENTS
4933++LOG_SLOW_SP_STATEMENTS
4934++LOG_SLOW_TIMESTAMP_EVERY
4935++LOG_SLOW_VERBOSITY
4936++LOG_WARNINGS
4937++LONG_QUERY_TIME
4938++LOWER_CASE_FILE_SYSTEM
4939++LOWER_CASE_TABLE_NAMES
4940++LOW_PRIORITY_UPDATES
4941++MAX_ALLOWED_PACKET
4942++MAX_BINLOG_CACHE_SIZE
4943++MAX_BINLOG_SIZE
4944++MAX_CONNECTIONS
4945++MAX_CONNECT_ERRORS
4946++MAX_DELAYED_THREADS
4947++MAX_ERROR_COUNT
4948++MAX_HEAP_TABLE_SIZE
4949++MAX_INSERT_DELAYED_THREADS
4950++MAX_JOIN_SIZE
4951++MAX_LENGTH_FOR_SORT_DATA
4952++MAX_LONG_DATA_SIZE
4953++MAX_PREPARED_STMT_COUNT
4954++MAX_RELAY_LOG_SIZE
4955++MAX_SEEKS_FOR_KEY
4956++MAX_SORT_LENGTH
4957++MAX_SP_RECURSION_DEPTH
4958++MAX_TMP_TABLES
4959++MAX_USER_CONNECTIONS
4960++MAX_WRITE_LOCK_COUNT
4961++MIN_EXAMINED_ROW_LIMIT
4962++MULTI_RANGE_COUNT
4963++MYISAM_DATA_POINTER_SIZE
4964++MYISAM_MAX_SORT_FILE_SIZE
4965++MYISAM_MMAP_SIZE
4966++MYISAM_RECOVER_OPTIONS
4967++MYISAM_REPAIR_THREADS
4968++MYISAM_SORT_BUFFER_SIZE
4969++MYISAM_STATS_METHOD
4970++MYISAM_USE_MMAP
4971++NET_BUFFER_LENGTH
4972++NET_READ_TIMEOUT
4973++NET_RETRY_COUNT
4974++NET_WRITE_TIMEOUT
4975++NEW
4976++OLD
4977++OLD_ALTER_TABLE
4978++OLD_PASSWORDS
4979++OPEN_FILES_LIMIT
4980++OPTIMIZER_FIX
4981++OPTIMIZER_PRUNE_LEVEL
4982++OPTIMIZER_SEARCH_DEPTH
4983++OPTIMIZER_SWITCH
4984++PID_FILE
4985++PLUGIN_DIR
4986++PORT
4987++PRELOAD_BUFFER_SIZE
4988++PROFILING
4989++PROFILING_HISTORY_SIZE
4990++PROFILING_SERVER
4991++PROFILING_USE_GETRUSAGE
4992++PROTOCOL_VERSION
4993++PSEUDO_THREAD_ID
4994++QUERY_ALLOC_BLOCK_SIZE
4995++QUERY_CACHE_LIMIT
4996++QUERY_CACHE_MIN_RES_UNIT
4997++QUERY_CACHE_SIZE
4998++QUERY_CACHE_STRIP_COMMENTS
4999++QUERY_CACHE_TYPE
5000++QUERY_CACHE_WLOCK_INVALIDATE
The diff has been truncated for viewing.

Subscribers

People subscribed via source and target branches