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
=== modified file 'Makefile'
--- Makefile 2011-08-12 19:09:19 +0000
+++ Makefile 2011-09-06 08:39:24 +0000
@@ -6,7 +6,7 @@
6PERCONA_SERVER_SHORT_1 ?=Percona-Server-$(MYSQL_VERSION)6PERCONA_SERVER_SHORT_1 ?=Percona-Server-$(MYSQL_VERSION)
7PERCONA_SERVER_SHORT_2 ?=Percona-Server7PERCONA_SERVER_SHORT_2 ?=Percona-Server
88
9all: main install-lic tests misc handlersocket maatkit-udf autorun9all: main install-lic misc handlersocket maatkit-udf autorun
10 @echo ""10 @echo ""
11 @echo "Percona Server source code is ready"11 @echo "Percona Server source code is ready"
12 @echo "Now change directory to $(PERCONA_SERVER) define variables as show below"12 @echo "Now change directory to $(PERCONA_SERVER) define variables as show below"
@@ -56,8 +56,6 @@
56 @echo "Downloading MySQL sources from $(MASTER_SITE)"56 @echo "Downloading MySQL sources from $(MASTER_SITE)"
57 $(FETCH_CMD) $(MASTER_SITE)/mysql-$(MYSQL_VERSION).tar.gz57 $(FETCH_CMD) $(MASTER_SITE)/mysql-$(MYSQL_VERSION).tar.gz
5858
59tests:
60 PERCONA_SERVER=${PERCONA_SERVER} sh install_tests
6159
62misc:60misc:
63 @echo "Installing other files"61 @echo "Installing other files"
6462
=== removed file 'install_tests'
--- install_tests 2011-07-27 10:28:37 +0000
+++ install_tests 1970-01-01 00:00:00 +0000
@@ -1,37 +0,0 @@
1#!/bin/sh
2
3set -u
4
5MYSQL_VERSION="$(grep ^MYSQL_VERSION= "Makefile" \
6 | cut -d = -f 2)"
7PERCONA_SERVER_VERSION="$(grep ^PERCONA_SERVER_VERSION= "Makefile" \
8 | cut -d = -f 2)"
9PERCONA_SERVER="Percona-Server-${MYSQL_VERSION}-${PERCONA_SERVER_VERSION}"
10
11install_file_type()
12{
13 for file in `ls $1/*.$2 2>/dev/null`; do
14 test -f $file && install -m 644 $file ${PERCONA_SERVER}/mysql-test/$3
15 done;
16}
17do_install_path()
18{
19 install_file_type $1 test t
20 install_file_type $1 opt t
21 install_file_type $1 result r
22 install_file_type $1 require r
23 install_file_type $1 inc include
24}
25install_path()
26{
27 echo "[$3/$4] Installing mysql-test files: $2"
28 test -d $1 && do_install_path $1 $2
29}
30current=0;
31count=`wc -l patches/series`;
32install_path mysql-test "global" $current $count
33for test_name in `cat patches/series`; do
34 current=$((current+1));
35 install_path mysql-test/$test_name $test_name $current $count
36done
37echo "Done"
380
=== removed directory 'mysql-test'
=== removed file 'mysql-test/have_nodebug.inc'
--- mysql-test/have_nodebug.inc 2011-06-23 02:21:00 +0000
+++ mysql-test/have_nodebug.inc 1970-01-01 00:00:00 +0000
@@ -1,4 +0,0 @@
1-- require r/have_nodebug.require
2disable_query_log;
3select (version() like '%debug%') as debug;
4enable_query_log;
50
=== removed file 'mysql-test/have_nodebug.require'
--- mysql-test/have_nodebug.require 2011-06-23 02:21:00 +0000
+++ mysql-test/have_nodebug.require 1970-01-01 00:00:00 +0000
@@ -1,2 +0,0 @@
1debug
20
30
=== removed directory 'mysql-test/innodb_deadlock_count.patch'
=== removed file 'mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.result'
--- mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.result 2011-06-22 10:21:58 +0000
+++ mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.result 1970-01-01 00:00:00 +0000
@@ -1,28 +0,0 @@
1# Establish connection con1 (user=root)
2# Establish connection con2 (user=root)
3# Establish connection con3 (user=root)
4# Drop test table
5drop table if exists t;
6# Create test table
7create table t(a INT PRIMARY KEY, b INT) engine=InnoDB;
8# Insert two rows to test table
9insert into t values(2,1);
10insert into t values(1,2);
11# Switch to connection con1
12BEGIN;
13SELECT b FROM t WHERE a=1 FOR UPDATE;
14# Switch to connection con2
15BEGIN;
16SELECT b FROM t WHERE a=2 FOR UPDATE;
17# Switch to connection con1
18SELECT b FROM t WHERE a=2 FOR UPDATE;
19# Switch to connection con2
20SELECT b FROM t WHERE a=1 FOR UPDATE;
21# Switch to connection con1
22ROLLBACK;
23# Switch to connection con2
24ROLLBACK;
25# Switch to connection con3
26Deadlocks: 1
27# Drop test table
28drop table t;
290
=== removed file 'mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.test'
--- mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.test 2011-06-22 10:21:58 +0000
+++ mysql-test/innodb_deadlock_count.patch/percona_innodb_deadlock_count.test 1970-01-01 00:00:00 +0000
@@ -1,61 +0,0 @@
1--source include/have_innodb.inc
2--echo # Establish connection con1 (user=root)
3connect (con1,localhost,root,,);
4--echo # Establish connection con2 (user=root)
5connect (con2,localhost,root,,);
6--echo # Establish connection con3 (user=root)
7connect (con3,localhost,root,,);
8--echo # Drop test table
9--disable_warnings
10drop table if exists t;
11--enable_warnings
12
13--echo # Create test table
14create table t(a INT PRIMARY KEY, b INT) engine=InnoDB;
15--echo # Insert two rows to test table
16insert into t values(2,1);
17insert into t values(1,2);
18
19#--echo # Save current deadlock count
20let $current = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Innodb_deadlocks'`;
21
22--disable_result_log
23
24--echo # Switch to connection con1
25connection con1;
26BEGIN; SELECT b FROM t WHERE a=1 FOR UPDATE;
27
28--echo # Switch to connection con2
29connection con2;
30BEGIN; SELECT b FROM t WHERE a=2 FOR UPDATE;
31
32--echo # Switch to connection con1
33connection con1;
34SEND SELECT b FROM t WHERE a=2 FOR UPDATE;
35
36--echo # Switch to connection con2
37connection con2;
38SEND SELECT b FROM t WHERE a=1 FOR UPDATE;
39
40--echo # Switch to connection con1
41connection con1;
42--error 0, ER_LOCK_DEADLOCK
43reap;
44ROLLBACK;
45
46--echo # Switch to connection con2
47connection con2;
48--error 0, ER_LOCK_DEADLOCK
49reap;
50ROLLBACK;
51
52--echo # Switch to connection con3
53connection con3;
54let $result = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Innodb_deadlocks'`;
55
56--enable_result_log
57
58let $diff = `SELECT $result - $current`;
59echo Deadlocks: $diff;
60--echo # Drop test table
61drop table t;
620
=== removed file 'mysql-test/innodb_fix_misc_bug51325.result'
--- mysql-test/innodb_fix_misc_bug51325.result 2011-05-25 15:11:57 +0000
+++ mysql-test/innodb_fix_misc_bug51325.result 1970-01-01 00:00:00 +0000
@@ -1,13 +0,0 @@
1DROP TABLE IF EXISTS t1;
2SET GLOBAL innodb_file_per_table=ON;
3SHOW VARIABLES LIKE 'innodb_lazy_drop_table';
4Variable_name Value
5innodb_lazy_drop_table 0
6SET GLOBAL innodb_lazy_drop_table=1;
7SHOW VARIABLES LIKE 'innodb_lazy_drop_table';
8Variable_name Value
9innodb_lazy_drop_table 1
10CREATE TABLE t1 (a INT) ENGINE=InnoDB;
11DROP TABLE t1;
12SET GLOBAL innodb_lazy_drop_table=default;
13SET GLOBAL innodb_file_per_table=default;
140
=== removed file 'mysql-test/innodb_fix_misc_bug51325.test'
--- mysql-test/innodb_fix_misc_bug51325.test 2011-03-09 21:00:46 +0000
+++ mysql-test/innodb_fix_misc_bug51325.test 1970-01-01 00:00:00 +0000
@@ -1,13 +0,0 @@
1# Test for 'innodb_lazy_drop_table' variable
2--source include/have_innodb.inc
3--disable_warnings
4DROP TABLE IF EXISTS t1;
5--enable_warnings
6SET GLOBAL innodb_file_per_table=ON;
7SHOW VARIABLES LIKE 'innodb_lazy_drop_table';
8SET GLOBAL innodb_lazy_drop_table=1;
9SHOW VARIABLES LIKE 'innodb_lazy_drop_table';
10CREATE TABLE t1 (a INT) ENGINE=InnoDB;
11DROP TABLE t1;
12SET GLOBAL innodb_lazy_drop_table=default;
13SET GLOBAL innodb_file_per_table=default;
140
=== removed file 'mysql-test/percona_innodb_buffer_pool_shm-master.opt'
--- mysql-test/percona_innodb_buffer_pool_shm-master.opt 2010-12-28 17:35:28 +0000
+++ mysql-test/percona_innodb_buffer_pool_shm-master.opt 1970-01-01 00:00:00 +0000
@@ -1,2 +0,0 @@
1--innodb_buffer_pool_shm_key=123456
2--innodb=FORCE
30
=== removed file 'mysql-test/percona_innodb_buffer_pool_shm.result'
--- mysql-test/percona_innodb_buffer_pool_shm.result 2011-06-22 02:53:48 +0000
+++ mysql-test/percona_innodb_buffer_pool_shm.result 1970-01-01 00:00:00 +0000
@@ -1,4 +0,0 @@
1show variables like 'innodb_buffer_pool_shm%';
2Variable_name Value
3innodb_buffer_pool_shm_checksum ON
4innodb_buffer_pool_shm_key 123456
50
=== removed file 'mysql-test/percona_innodb_buffer_pool_shm.test'
--- mysql-test/percona_innodb_buffer_pool_shm.test 2011-06-22 02:53:48 +0000
+++ mysql-test/percona_innodb_buffer_pool_shm.test 1970-01-01 00:00:00 +0000
@@ -1,3 +0,0 @@
1--source include/have_innodb.inc
2show variables like 'innodb_buffer_pool_shm%';
3
40
=== removed file 'mysql-test/percona_innodb_doublewrite_file-master.opt'
--- mysql-test/percona_innodb_doublewrite_file-master.opt 2010-05-26 10:15:29 +0000
+++ mysql-test/percona_innodb_doublewrite_file-master.opt 1970-01-01 00:00:00 +0000
@@ -1,1 +0,0 @@
1--innodb_doublewrite_file=ib_doublewrite
20
=== removed file 'mysql-test/percona_innodb_doublewrite_file.result'
--- mysql-test/percona_innodb_doublewrite_file.result 2010-05-26 10:15:29 +0000
+++ mysql-test/percona_innodb_doublewrite_file.result 1970-01-01 00:00:00 +0000
@@ -1,4 +0,0 @@
1show variables like 'innodb_doublewrite%';
2Variable_name Value
3innodb_doublewrite ON
4innodb_doublewrite_file ib_doublewrite
50
=== removed file 'mysql-test/percona_innodb_doublewrite_file.test'
--- mysql-test/percona_innodb_doublewrite_file.test 2010-05-26 10:15:29 +0000
+++ mysql-test/percona_innodb_doublewrite_file.test 1970-01-01 00:00:00 +0000
@@ -1,2 +0,0 @@
1--source include/have_innodb.inc
2show variables like 'innodb_doublewrite%';
30
=== removed file 'mysql-test/percona_innodb_use_sys_stats_table-master.opt'
--- mysql-test/percona_innodb_use_sys_stats_table-master.opt 2010-07-06 08:20:44 +0000
+++ mysql-test/percona_innodb_use_sys_stats_table-master.opt 1970-01-01 00:00:00 +0000
@@ -1,1 +0,0 @@
1--innodb_use_sys_stats_table
20
=== removed file 'mysql-test/percona_innodb_use_sys_stats_table.result'
--- mysql-test/percona_innodb_use_sys_stats_table.result 2010-07-06 08:20:44 +0000
+++ mysql-test/percona_innodb_use_sys_stats_table.result 1970-01-01 00:00:00 +0000
@@ -1,3 +0,0 @@
1show variables like 'innodb_use_sys_stats%';
2Variable_name Value
3innodb_use_sys_stats_table ON
40
=== removed file 'mysql-test/percona_innodb_use_sys_stats_table.test'
--- mysql-test/percona_innodb_use_sys_stats_table.test 2010-07-06 08:20:44 +0000
+++ mysql-test/percona_innodb_use_sys_stats_table.test 1970-01-01 00:00:00 +0000
@@ -1,2 +0,0 @@
1--source include/have_innodb.inc
2show variables like 'innodb_use_sys_stats%';
30
=== removed file 'mysql-test/percona_server_variables.inc'
--- mysql-test/percona_server_variables.inc 2011-06-23 02:21:00 +0000
+++ mysql-test/percona_server_variables.inc 1970-01-01 00:00:00 +0000
@@ -1,3 +0,0 @@
1--source include/have_response_time_distribution.inc
2--source include/have_innodb.inc
3SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
40
=== removed file 'mysql-test/percona_server_variables_debug.result'
--- mysql-test/percona_server_variables_debug.result 2011-07-30 22:04:31 +0000
+++ mysql-test/percona_server_variables_debug.result 1970-01-01 00:00:00 +0000
@@ -1,347 +0,0 @@
1SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
2Variable_name
3AUTOCOMMIT
4AUTOMATIC_SP_PRIVILEGES
5AUTO_INCREMENT_INCREMENT
6AUTO_INCREMENT_OFFSET
7BACK_LOG
8BASEDIR
9BIG_TABLES
10BINLOG_CACHE_SIZE
11BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES
12BINLOG_FORMAT
13BULK_INSERT_BUFFER_SIZE
14CHARACTER_SETS_DIR
15CHARACTER_SET_CLIENT
16CHARACTER_SET_CONNECTION
17CHARACTER_SET_DATABASE
18CHARACTER_SET_FILESYSTEM
19CHARACTER_SET_RESULTS
20CHARACTER_SET_SERVER
21CHARACTER_SET_SYSTEM
22COLLATION_CONNECTION
23COLLATION_DATABASE
24COLLATION_SERVER
25COMPLETION_TYPE
26CONCURRENT_INSERT
27CONNECT_TIMEOUT
28DATADIR
29DATETIME_FORMAT
30DATE_FORMAT
31DEBUG
32DEBUG_SYNC
33DEFAULT_WEEK_FORMAT
34DELAYED_INSERT_LIMIT
35DELAYED_INSERT_TIMEOUT
36DELAYED_QUEUE_SIZE
37DELAY_KEY_WRITE
38DIV_PRECISION_INCREMENT
39ENABLE_QUERY_RESPONSE_TIME_STATS
40ENGINE_CONDITION_PUSHDOWN
41ERROR_COUNT
42EVENT_SCHEDULER
43EXPIRE_LOGS_DAYS
44FAST_INDEX_CREATION
45FLUSH
46FLUSH_TIME
47FOREIGN_KEY_CHECKS
48FT_BOOLEAN_SYNTAX
49FT_MAX_WORD_LEN
50FT_MIN_WORD_LEN
51FT_QUERY_EXPANSION_LIMIT
52FT_STOPWORD_FILE
53GENERAL_LOG
54GENERAL_LOG_FILE
55GROUP_CONCAT_MAX_LEN
56HAVE_COMMUNITY_FEATURES
57HAVE_COMPRESS
58HAVE_CRYPT
59HAVE_CSV
60HAVE_DYNAMIC_LOADING
61HAVE_GEOMETRY
62HAVE_INNODB
63HAVE_NDBCLUSTER
64HAVE_OPENSSL
65HAVE_PARTITIONING
66HAVE_QUERY_CACHE
67HAVE_RESPONSE_TIME_DISTRIBUTION
68HAVE_RTREE_KEYS
69HAVE_SSL
70HAVE_SYMLINK
71HOSTNAME
72IDENTITY
73IGNORE_BUILTIN_INNODB
74INIT_CONNECT
75INIT_FILE
76INIT_SLAVE
77INNODB_ADAPTIVE_CHECKPOINT
78INNODB_ADAPTIVE_FLUSHING
79INNODB_ADAPTIVE_HASH_INDEX
80INNODB_ADDITIONAL_MEM_POOL_SIZE
81INNODB_AUTOEXTEND_INCREMENT
82INNODB_AUTOINC_LOCK_MODE
83INNODB_AUTO_LRU_DUMP
84INNODB_BUFFER_POOL_SHM_CHECKSUM
85INNODB_BUFFER_POOL_SHM_KEY
86INNODB_BUFFER_POOL_SIZE
87INNODB_CHANGE_BUFFERING
88INNODB_CHECKPOINT_AGE_TARGET
89INNODB_CHECKSUMS
90INNODB_COMMIT_CONCURRENCY
91INNODB_CONCURRENCY_TICKETS
92INNODB_DATA_FILE_PATH
93INNODB_DATA_HOME_DIR
94INNODB_DICT_SIZE_LIMIT
95INNODB_DOUBLEWRITE
96INNODB_DOUBLEWRITE_FILE
97INNODB_ENABLE_UNSAFE_GROUP_COMMIT
98INNODB_EXPAND_IMPORT
99INNODB_EXTRA_RSEGMENTS
100INNODB_EXTRA_UNDOSLOTS
101INNODB_FAST_CHECKSUM
102INNODB_FAST_RECOVERY
103INNODB_FAST_SHUTDOWN
104INNODB_FILE_FORMAT
105INNODB_FILE_FORMAT_CHECK
106INNODB_FILE_PER_TABLE
107INNODB_FLUSH_LOG_AT_TRX_COMMIT
108INNODB_FLUSH_LOG_AT_TRX_COMMIT_SESSION
109INNODB_FLUSH_METHOD
110INNODB_FLUSH_NEIGHBOR_PAGES
111INNODB_FORCE_RECOVERY
112INNODB_IBUF_ACCEL_RATE
113INNODB_IBUF_ACTIVE_CONTRACT
114INNODB_IBUF_MAX_SIZE
115INNODB_IO_CAPACITY
116INNODB_LAZY_DROP_TABLE
117INNODB_LOCKS_UNSAFE_FOR_BINLOG
118INNODB_LOCK_WAIT_TIMEOUT
119INNODB_LOG_BLOCK_SIZE
120INNODB_LOG_BUFFER_SIZE
121INNODB_LOG_FILES_IN_GROUP
122INNODB_LOG_FILE_SIZE
123INNODB_LOG_GROUP_HOME_DIR
124INNODB_MAX_DIRTY_PAGES_PCT
125INNODB_MAX_PURGE_LAG
126INNODB_MIRRORED_LOG_GROUPS
127INNODB_OLD_BLOCKS_PCT
128INNODB_OLD_BLOCKS_TIME
129INNODB_OPEN_FILES
130INNODB_OVERWRITE_RELAY_LOG_INFO
131INNODB_PAGE_SIZE
132INNODB_PASS_CORRUPT_TABLE
133INNODB_READ_AHEAD
134INNODB_READ_AHEAD_THRESHOLD
135INNODB_READ_IO_THREADS
136INNODB_RECOVERY_STATS
137INNODB_REPLICATION_DELAY
138INNODB_ROLLBACK_ON_TIMEOUT
139INNODB_SHOW_LOCKS_HELD
140INNODB_SHOW_VERBOSE_LOCKS
141INNODB_SPIN_WAIT_DELAY
142INNODB_STATS_AUTO_UPDATE
143INNODB_STATS_METHOD
144INNODB_STATS_ON_METADATA
145INNODB_STATS_SAMPLE_PAGES
146INNODB_STATS_UPDATE_NEED_LOCK
147INNODB_STRICT_MODE
148INNODB_SUPPORT_XA
149INNODB_SYNC_SPIN_LOOPS
150INNODB_TABLE_LOCKS
151INNODB_THREAD_CONCURRENCY
152INNODB_THREAD_CONCURRENCY_TIMER_BASED
153INNODB_THREAD_SLEEP_DELAY
154INNODB_USE_PURGE_THREAD
155INNODB_USE_SYS_MALLOC
156INNODB_USE_SYS_STATS_TABLE
157INNODB_VERSION
158INNODB_WRITE_IO_THREADS
159INSERT_ID
160INTERACTIVE_TIMEOUT
161JOIN_BUFFER_SIZE
162KEEP_FILES_ON_CREATE
163KEY_BUFFER_SIZE
164KEY_CACHE_AGE_THRESHOLD
165KEY_CACHE_BLOCK_SIZE
166KEY_CACHE_DIVISION_LIMIT
167LANGUAGE
168LARGE_FILES_SUPPORT
169LARGE_PAGES
170LARGE_PAGE_SIZE
171LAST_INSERT_ID
172LC_TIME_NAMES
173LICENSE
174LOCAL_INFILE
175LOCKED_IN_MEMORY
176LOG
177LOG_BIN
178LOG_BIN_TRUST_FUNCTION_CREATORS
179LOG_BIN_TRUST_ROUTINE_CREATORS
180LOG_ERROR
181LOG_OUTPUT
182LOG_QUERIES_NOT_USING_INDEXES
183LOG_SLAVE_UPDATES
184LOG_SLOW_FILTER
185LOG_SLOW_QUERIES
186LOG_SLOW_RATE_LIMIT
187LOG_SLOW_SLAVE_STATEMENTS
188LOG_SLOW_SP_STATEMENTS
189LOG_SLOW_TIMESTAMP_EVERY
190LOG_SLOW_VERBOSITY
191LOG_WARNINGS
192LONG_QUERY_TIME
193LOWER_CASE_FILE_SYSTEM
194LOWER_CASE_TABLE_NAMES
195LOW_PRIORITY_UPDATES
196MAX_ALLOWED_PACKET
197MAX_BINLOG_CACHE_SIZE
198MAX_BINLOG_SIZE
199MAX_CONNECTIONS
200MAX_CONNECT_ERRORS
201MAX_DELAYED_THREADS
202MAX_ERROR_COUNT
203MAX_HEAP_TABLE_SIZE
204MAX_INSERT_DELAYED_THREADS
205MAX_JOIN_SIZE
206MAX_LENGTH_FOR_SORT_DATA
207MAX_LONG_DATA_SIZE
208MAX_PREPARED_STMT_COUNT
209MAX_RELAY_LOG_SIZE
210MAX_SEEKS_FOR_KEY
211MAX_SORT_LENGTH
212MAX_SP_RECURSION_DEPTH
213MAX_TMP_TABLES
214MAX_USER_CONNECTIONS
215MAX_WRITE_LOCK_COUNT
216MIN_EXAMINED_ROW_LIMIT
217MULTI_RANGE_COUNT
218MYISAM_DATA_POINTER_SIZE
219MYISAM_MAX_SORT_FILE_SIZE
220MYISAM_MMAP_SIZE
221MYISAM_RECOVER_OPTIONS
222MYISAM_REPAIR_THREADS
223MYISAM_SORT_BUFFER_SIZE
224MYISAM_STATS_METHOD
225MYISAM_USE_MMAP
226NET_BUFFER_LENGTH
227NET_READ_TIMEOUT
228NET_RETRY_COUNT
229NET_WRITE_TIMEOUT
230NEW
231OLD
232OLD_ALTER_TABLE
233OLD_PASSWORDS
234OPEN_FILES_LIMIT
235OPTIMIZER_FIX
236OPTIMIZER_PRUNE_LEVEL
237OPTIMIZER_SEARCH_DEPTH
238OPTIMIZER_SWITCH
239PID_FILE
240PLUGIN_DIR
241PORT
242PRELOAD_BUFFER_SIZE
243PROFILING
244PROFILING_HISTORY_SIZE
245PROFILING_SERVER
246PROFILING_USE_GETRUSAGE
247PROTOCOL_VERSION
248PSEUDO_THREAD_ID
249QUERY_ALLOC_BLOCK_SIZE
250QUERY_CACHE_LIMIT
251QUERY_CACHE_MIN_RES_UNIT
252QUERY_CACHE_SIZE
253QUERY_CACHE_STRIP_COMMENTS
254QUERY_CACHE_TYPE
255QUERY_CACHE_WLOCK_INVALIDATE
256QUERY_EXEC_TIME
257QUERY_PREALLOC_SIZE
258QUERY_RESPONSE_TIME_RANGE_BASE
259RAND_SEED1
260RAND_SEED2
261RANGE_ALLOC_BLOCK_SIZE
262READ_BUFFER_SIZE
263READ_ONLY
264READ_RND_BUFFER_SIZE
265RELAY_LOG
266RELAY_LOG_INDEX
267RELAY_LOG_INFO_FILE
268RELAY_LOG_PURGE
269RELAY_LOG_SPACE_LIMIT
270REPORT_HOST
271REPORT_PASSWORD
272REPORT_PORT
273REPORT_USER
274RPL_RECOVERY_RANK
275SECURE_AUTH
276SECURE_FILE_PRIV
277SERVER_ID
278SKIP_EXTERNAL_LOCKING
279SKIP_NAME_RESOLVE
280SKIP_NETWORKING
281SKIP_SHOW_DATABASE
282SLAVE_COMPRESSED_PROTOCOL
283SLAVE_EXEC_MODE
284SLAVE_LOAD_TMPDIR
285SLAVE_NET_TIMEOUT
286SLAVE_SKIP_ERRORS
287SLAVE_TRANSACTION_RETRIES
288SLOW_LAUNCH_TIME
289SLOW_QUERY_LOG
290SLOW_QUERY_LOG_FILE
291SLOW_QUERY_LOG_MICROSECONDS_TIMESTAMP
292SOCKET
293SORT_BUFFER_SIZE
294SQL_AUTO_IS_NULL
295SQL_BIG_SELECTS
296SQL_BIG_TABLES
297SQL_BUFFER_RESULT
298SQL_LOG_BIN
299SQL_LOG_OFF
300SQL_LOG_UPDATE
301SQL_LOW_PRIORITY_UPDATES
302SQL_MAX_JOIN_SIZE
303SQL_MODE
304SQL_NOTES
305SQL_QUOTE_SHOW_CREATE
306SQL_SAFE_UPDATES
307SQL_SELECT_LIMIT
308SQL_SLAVE_SKIP_COUNTER
309SQL_WARNINGS
310SSL_CA
311SSL_CAPATH
312SSL_CERT
313SSL_CIPHER
314SSL_KEY
315STORAGE_ENGINE
316SUPPRESS_LOG_WARNING_1592
317SYNC_BINLOG
318SYNC_FRM
319SYSTEM_TIME_ZONE
320TABLE_DEFINITION_CACHE
321TABLE_LOCK_WAIT_TIMEOUT
322TABLE_OPEN_CACHE
323TABLE_TYPE
324THREAD_CACHE_SIZE
325THREAD_HANDLING
326THREAD_STACK
327THREAD_STATISTICS
328TIMED_MUTEXES
329TIMESTAMP
330TIME_FORMAT
331TIME_ZONE
332TMPDIR
333TMP_TABLE_SIZE
334TRANSACTION_ALLOC_BLOCK_SIZE
335TRANSACTION_PREALLOC_SIZE
336TX_ISOLATION
337UNIQUE_CHECKS
338UPDATABLE_VIEWS_WITH_LIMIT
339USERSTAT_RUNNING
340USE_GLOBAL_LOG_SLOW_CONTROL
341USE_GLOBAL_LONG_QUERY_TIME
342VERSION
343VERSION_COMMENT
344VERSION_COMPILE_MACHINE
345VERSION_COMPILE_OS
346WAIT_TIMEOUT
347WARNING_COUNT
3480
=== removed file 'mysql-test/percona_server_variables_debug.test'
--- mysql-test/percona_server_variables_debug.test 2011-06-23 02:21:00 +0000
+++ mysql-test/percona_server_variables_debug.test 1970-01-01 00:00:00 +0000
@@ -1,2 +0,0 @@
1--source include/have_debug.inc
2--source include/percona_server_variables.inc
30
=== removed file 'mysql-test/percona_server_variables_release.result'
--- mysql-test/percona_server_variables_release.result 2011-07-28 18:07:09 +0000
+++ mysql-test/percona_server_variables_release.result 1970-01-01 00:00:00 +0000
@@ -1,344 +0,0 @@
1SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
2Variable_name
3AUTOCOMMIT
4AUTOMATIC_SP_PRIVILEGES
5AUTO_INCREMENT_INCREMENT
6AUTO_INCREMENT_OFFSET
7BACK_LOG
8BASEDIR
9BIG_TABLES
10BINLOG_CACHE_SIZE
11BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES
12BINLOG_FORMAT
13BULK_INSERT_BUFFER_SIZE
14CHARACTER_SETS_DIR
15CHARACTER_SET_CLIENT
16CHARACTER_SET_CONNECTION
17CHARACTER_SET_DATABASE
18CHARACTER_SET_FILESYSTEM
19CHARACTER_SET_RESULTS
20CHARACTER_SET_SERVER
21CHARACTER_SET_SYSTEM
22COLLATION_CONNECTION
23COLLATION_DATABASE
24COLLATION_SERVER
25COMPLETION_TYPE
26CONCURRENT_INSERT
27CONNECT_TIMEOUT
28DATADIR
29DATETIME_FORMAT
30DATE_FORMAT
31DEFAULT_WEEK_FORMAT
32DELAYED_INSERT_LIMIT
33DELAYED_INSERT_TIMEOUT
34DELAYED_QUEUE_SIZE
35DELAY_KEY_WRITE
36DIV_PRECISION_INCREMENT
37ENABLE_QUERY_RESPONSE_TIME_STATS
38ENGINE_CONDITION_PUSHDOWN
39ERROR_COUNT
40EVENT_SCHEDULER
41EXPIRE_LOGS_DAYS
42FAST_INDEX_CREATION
43FLUSH
44FLUSH_TIME
45FOREIGN_KEY_CHECKS
46FT_BOOLEAN_SYNTAX
47FT_MAX_WORD_LEN
48FT_MIN_WORD_LEN
49FT_QUERY_EXPANSION_LIMIT
50FT_STOPWORD_FILE
51GENERAL_LOG
52GENERAL_LOG_FILE
53GROUP_CONCAT_MAX_LEN
54HAVE_COMMUNITY_FEATURES
55HAVE_COMPRESS
56HAVE_CRYPT
57HAVE_CSV
58HAVE_DYNAMIC_LOADING
59HAVE_GEOMETRY
60HAVE_INNODB
61HAVE_NDBCLUSTER
62HAVE_OPENSSL
63HAVE_PARTITIONING
64HAVE_QUERY_CACHE
65HAVE_RESPONSE_TIME_DISTRIBUTION
66HAVE_RTREE_KEYS
67HAVE_SSL
68HAVE_SYMLINK
69HOSTNAME
70IDENTITY
71IGNORE_BUILTIN_INNODB
72INIT_CONNECT
73INIT_FILE
74INIT_SLAVE
75INNODB_ADAPTIVE_CHECKPOINT
76INNODB_ADAPTIVE_FLUSHING
77INNODB_ADAPTIVE_HASH_INDEX
78INNODB_ADDITIONAL_MEM_POOL_SIZE
79INNODB_AUTOEXTEND_INCREMENT
80INNODB_AUTOINC_LOCK_MODE
81INNODB_AUTO_LRU_DUMP
82INNODB_BUFFER_POOL_SHM_CHECKSUM
83INNODB_BUFFER_POOL_SHM_KEY
84INNODB_BUFFER_POOL_SIZE
85INNODB_CHANGE_BUFFERING
86INNODB_CHECKPOINT_AGE_TARGET
87INNODB_CHECKSUMS
88INNODB_COMMIT_CONCURRENCY
89INNODB_CONCURRENCY_TICKETS
90INNODB_DATA_FILE_PATH
91INNODB_DATA_HOME_DIR
92INNODB_DICT_SIZE_LIMIT
93INNODB_DOUBLEWRITE
94INNODB_DOUBLEWRITE_FILE
95INNODB_ENABLE_UNSAFE_GROUP_COMMIT
96INNODB_EXPAND_IMPORT
97INNODB_EXTRA_RSEGMENTS
98INNODB_EXTRA_UNDOSLOTS
99INNODB_FAST_CHECKSUM
100INNODB_FAST_RECOVERY
101INNODB_FAST_SHUTDOWN
102INNODB_FILE_FORMAT
103INNODB_FILE_FORMAT_CHECK
104INNODB_FILE_PER_TABLE
105INNODB_FLUSH_LOG_AT_TRX_COMMIT
106INNODB_FLUSH_LOG_AT_TRX_COMMIT_SESSION
107INNODB_FLUSH_METHOD
108INNODB_FLUSH_NEIGHBOR_PAGES
109INNODB_FORCE_RECOVERY
110INNODB_IBUF_ACCEL_RATE
111INNODB_IBUF_ACTIVE_CONTRACT
112INNODB_IBUF_MAX_SIZE
113INNODB_IO_CAPACITY
114INNODB_LAZY_DROP_TABLE
115INNODB_LOCKS_UNSAFE_FOR_BINLOG
116INNODB_LOCK_WAIT_TIMEOUT
117INNODB_LOG_BLOCK_SIZE
118INNODB_LOG_BUFFER_SIZE
119INNODB_LOG_FILES_IN_GROUP
120INNODB_LOG_FILE_SIZE
121INNODB_LOG_GROUP_HOME_DIR
122INNODB_MAX_DIRTY_PAGES_PCT
123INNODB_MAX_PURGE_LAG
124INNODB_MIRRORED_LOG_GROUPS
125INNODB_OLD_BLOCKS_PCT
126INNODB_OLD_BLOCKS_TIME
127INNODB_OPEN_FILES
128INNODB_OVERWRITE_RELAY_LOG_INFO
129INNODB_PAGE_SIZE
130INNODB_PASS_CORRUPT_TABLE
131INNODB_READ_AHEAD
132INNODB_READ_AHEAD_THRESHOLD
133INNODB_READ_IO_THREADS
134INNODB_RECOVERY_STATS
135INNODB_REPLICATION_DELAY
136INNODB_ROLLBACK_ON_TIMEOUT
137INNODB_SHOW_LOCKS_HELD
138INNODB_SHOW_VERBOSE_LOCKS
139INNODB_SPIN_WAIT_DELAY
140INNODB_STATS_AUTO_UPDATE
141INNODB_STATS_METHOD
142INNODB_STATS_ON_METADATA
143INNODB_STATS_SAMPLE_PAGES
144INNODB_STATS_UPDATE_NEED_LOCK
145INNODB_STRICT_MODE
146INNODB_SUPPORT_XA
147INNODB_SYNC_SPIN_LOOPS
148INNODB_TABLE_LOCKS
149INNODB_THREAD_CONCURRENCY
150INNODB_THREAD_CONCURRENCY_TIMER_BASED
151INNODB_THREAD_SLEEP_DELAY
152INNODB_USE_PURGE_THREAD
153INNODB_USE_SYS_MALLOC
154INNODB_USE_SYS_STATS_TABLE
155INNODB_VERSION
156INNODB_WRITE_IO_THREADS
157INSERT_ID
158INTERACTIVE_TIMEOUT
159JOIN_BUFFER_SIZE
160KEEP_FILES_ON_CREATE
161KEY_BUFFER_SIZE
162KEY_CACHE_AGE_THRESHOLD
163KEY_CACHE_BLOCK_SIZE
164KEY_CACHE_DIVISION_LIMIT
165LANGUAGE
166LARGE_FILES_SUPPORT
167LARGE_PAGES
168LARGE_PAGE_SIZE
169LAST_INSERT_ID
170LC_TIME_NAMES
171LICENSE
172LOCAL_INFILE
173LOCKED_IN_MEMORY
174LOG
175LOG_BIN
176LOG_BIN_TRUST_FUNCTION_CREATORS
177LOG_BIN_TRUST_ROUTINE_CREATORS
178LOG_ERROR
179LOG_OUTPUT
180LOG_QUERIES_NOT_USING_INDEXES
181LOG_SLAVE_UPDATES
182LOG_SLOW_FILTER
183LOG_SLOW_QUERIES
184LOG_SLOW_RATE_LIMIT
185LOG_SLOW_SLAVE_STATEMENTS
186LOG_SLOW_SP_STATEMENTS
187LOG_SLOW_TIMESTAMP_EVERY
188LOG_SLOW_VERBOSITY
189LOG_WARNINGS
190LONG_QUERY_TIME
191LOWER_CASE_FILE_SYSTEM
192LOWER_CASE_TABLE_NAMES
193LOW_PRIORITY_UPDATES
194MAX_ALLOWED_PACKET
195MAX_BINLOG_CACHE_SIZE
196MAX_BINLOG_SIZE
197MAX_CONNECTIONS
198MAX_CONNECT_ERRORS
199MAX_DELAYED_THREADS
200MAX_ERROR_COUNT
201MAX_HEAP_TABLE_SIZE
202MAX_INSERT_DELAYED_THREADS
203MAX_JOIN_SIZE
204MAX_LENGTH_FOR_SORT_DATA
205MAX_LONG_DATA_SIZE
206MAX_PREPARED_STMT_COUNT
207MAX_RELAY_LOG_SIZE
208MAX_SEEKS_FOR_KEY
209MAX_SORT_LENGTH
210MAX_SP_RECURSION_DEPTH
211MAX_TMP_TABLES
212MAX_USER_CONNECTIONS
213MAX_WRITE_LOCK_COUNT
214MIN_EXAMINED_ROW_LIMIT
215MULTI_RANGE_COUNT
216MYISAM_DATA_POINTER_SIZE
217MYISAM_MAX_SORT_FILE_SIZE
218MYISAM_MMAP_SIZE
219MYISAM_RECOVER_OPTIONS
220MYISAM_REPAIR_THREADS
221MYISAM_SORT_BUFFER_SIZE
222MYISAM_STATS_METHOD
223MYISAM_USE_MMAP
224NET_BUFFER_LENGTH
225NET_READ_TIMEOUT
226NET_RETRY_COUNT
227NET_WRITE_TIMEOUT
228NEW
229OLD
230OLD_ALTER_TABLE
231OLD_PASSWORDS
232OPEN_FILES_LIMIT
233OPTIMIZER_FIX
234OPTIMIZER_PRUNE_LEVEL
235OPTIMIZER_SEARCH_DEPTH
236OPTIMIZER_SWITCH
237PID_FILE
238PLUGIN_DIR
239PORT
240PRELOAD_BUFFER_SIZE
241PROFILING
242PROFILING_HISTORY_SIZE
243PROFILING_SERVER
244PROFILING_USE_GETRUSAGE
245PROTOCOL_VERSION
246PSEUDO_THREAD_ID
247QUERY_ALLOC_BLOCK_SIZE
248QUERY_CACHE_LIMIT
249QUERY_CACHE_MIN_RES_UNIT
250QUERY_CACHE_SIZE
251QUERY_CACHE_STRIP_COMMENTS
252QUERY_CACHE_TYPE
253QUERY_CACHE_WLOCK_INVALIDATE
254QUERY_PREALLOC_SIZE
255QUERY_RESPONSE_TIME_RANGE_BASE
256RAND_SEED1
257RAND_SEED2
258RANGE_ALLOC_BLOCK_SIZE
259READ_BUFFER_SIZE
260READ_ONLY
261READ_RND_BUFFER_SIZE
262RELAY_LOG
263RELAY_LOG_INDEX
264RELAY_LOG_INFO_FILE
265RELAY_LOG_PURGE
266RELAY_LOG_SPACE_LIMIT
267REPORT_HOST
268REPORT_PASSWORD
269REPORT_PORT
270REPORT_USER
271RPL_RECOVERY_RANK
272SECURE_AUTH
273SECURE_FILE_PRIV
274SERVER_ID
275SKIP_EXTERNAL_LOCKING
276SKIP_NAME_RESOLVE
277SKIP_NETWORKING
278SKIP_SHOW_DATABASE
279SLAVE_COMPRESSED_PROTOCOL
280SLAVE_EXEC_MODE
281SLAVE_LOAD_TMPDIR
282SLAVE_NET_TIMEOUT
283SLAVE_SKIP_ERRORS
284SLAVE_TRANSACTION_RETRIES
285SLOW_LAUNCH_TIME
286SLOW_QUERY_LOG
287SLOW_QUERY_LOG_FILE
288SLOW_QUERY_LOG_MICROSECONDS_TIMESTAMP
289SOCKET
290SORT_BUFFER_SIZE
291SQL_AUTO_IS_NULL
292SQL_BIG_SELECTS
293SQL_BIG_TABLES
294SQL_BUFFER_RESULT
295SQL_LOG_BIN
296SQL_LOG_OFF
297SQL_LOG_UPDATE
298SQL_LOW_PRIORITY_UPDATES
299SQL_MAX_JOIN_SIZE
300SQL_MODE
301SQL_NOTES
302SQL_QUOTE_SHOW_CREATE
303SQL_SAFE_UPDATES
304SQL_SELECT_LIMIT
305SQL_SLAVE_SKIP_COUNTER
306SQL_WARNINGS
307SSL_CA
308SSL_CAPATH
309SSL_CERT
310SSL_CIPHER
311SSL_KEY
312STORAGE_ENGINE
313SUPPRESS_LOG_WARNING_1592
314SYNC_BINLOG
315SYNC_FRM
316SYSTEM_TIME_ZONE
317TABLE_DEFINITION_CACHE
318TABLE_LOCK_WAIT_TIMEOUT
319TABLE_OPEN_CACHE
320TABLE_TYPE
321THREAD_CACHE_SIZE
322THREAD_HANDLING
323THREAD_STACK
324THREAD_STATISTICS
325TIMED_MUTEXES
326TIMESTAMP
327TIME_FORMAT
328TIME_ZONE
329TMPDIR
330TMP_TABLE_SIZE
331TRANSACTION_ALLOC_BLOCK_SIZE
332TRANSACTION_PREALLOC_SIZE
333TX_ISOLATION
334UNIQUE_CHECKS
335UPDATABLE_VIEWS_WITH_LIMIT
336USERSTAT_RUNNING
337USE_GLOBAL_LOG_SLOW_CONTROL
338USE_GLOBAL_LONG_QUERY_TIME
339VERSION
340VERSION_COMMENT
341VERSION_COMPILE_MACHINE
342VERSION_COMPILE_OS
343WAIT_TIMEOUT
344WARNING_COUNT
3450
=== removed file 'mysql-test/percona_server_variables_release.test'
--- mysql-test/percona_server_variables_release.test 2011-06-23 02:21:00 +0000
+++ mysql-test/percona_server_variables_release.test 1970-01-01 00:00:00 +0000
@@ -1,2 +0,0 @@
1--source include/have_nodebug.inc
2--source include/percona_server_variables.inc
30
=== removed file 'mysql-test/percona_show_temp_tables.result'
--- mysql-test/percona_show_temp_tables.result 2010-05-20 10:47:38 +0000
+++ mysql-test/percona_show_temp_tables.result 1970-01-01 00:00:00 +0000
@@ -1,58 +0,0 @@
1drop table if exists t1,t2,t3;
2drop database if exists showtemp;
3create database if not exists showtemp;
4use test;
5create temporary table t1(id int);
6create temporary table t2(id int);
7create temporary table showtemp.t3(id int);
8insert into t1 values(10),(20),(30),(40);
9insert into showtemp.t3 values(999);
10show temporary tables;
11Temp_tables_in_test
12t2
13t1
14show temporary tables from test;
15Temp_tables_in_test
16t2
17t1
18show temporary tables in showtemp;
19Temp_tables_in_showtemp
20t3
21select table_schema, table_name, engine, table_rows from Information_schema.temporary_tables;
22table_schema table_name engine table_rows
23showtemp t3 MyISAM 1
24test t2 MyISAM 0
25test t1 MyISAM 4
26select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables;
27table_schema table_name engine table_rows
28showtemp t3 MyISAM 1
29test t2 MyISAM 0
30test t1 MyISAM 4
31select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables where table_schema='showtemp';
32table_schema table_name engine table_rows
33showtemp t3 MyISAM 1
34select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables where table_schema='temp';
35table_schema table_name engine table_rows
36drop table if exists showtemp.t2;
37create temporary table t1(id int);
38create temporary table showtemp.t2(id int);
39show temporary tables;
40Temp_tables_in_test
41t1
42select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables;
43table_schema table_name engine table_rows
44showtemp t2 MyISAM 0
45test t1 MyISAM 0
46showtemp t3 MyISAM 1
47test t2 MyISAM 0
48test t1 MyISAM 4
49drop table showtemp.t2;
50drop table t1;
51select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables;
52table_schema table_name engine table_rows
53showtemp t3 MyISAM 1
54test t2 MyISAM 0
55test t1 MyISAM 4
56drop table t1, t2;
57drop table showtemp.t3;
58drop database showtemp;
590
=== removed file 'mysql-test/percona_show_temp_tables.test'
--- mysql-test/percona_show_temp_tables.test 2010-05-20 10:47:38 +0000
+++ mysql-test/percona_show_temp_tables.test 1970-01-01 00:00:00 +0000
@@ -1,65 +0,0 @@
1# Uses GRANT commands that usually disabled in embedded server
2-- source include/not_embedded.inc
3
4# Save the initial number of concurrent sessions
5--source include/count_sessions.inc
6
7#
8# Test of SHOW [GLOBAL] TEMPORARY TABLES [FROM/IN] DB and
9# Information_schema.temporary_tables and global_temporary_tables
10#
11
12connect(stcon1,localhost,root,,test);
13connect(stcon2,localhost,root,,test);
14
15connection stcon1;
16
17--disable_warnings
18drop table if exists t1,t2,t3;
19drop database if exists showtemp;
20create database if not exists showtemp;
21--enable_warnings
22
23use test;
24create temporary table t1(id int);
25create temporary table t2(id int);
26create temporary table showtemp.t3(id int);
27insert into t1 values(10),(20),(30),(40);
28insert into showtemp.t3 values(999);
29
30show temporary tables;
31# "Session" is not same value always. mysql-test cannot test it always.
32#show global temporary tables;
33show temporary tables from test;
34show temporary tables in showtemp;
35select table_schema, table_name, engine, table_rows from Information_schema.temporary_tables;
36select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables;
37select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables where table_schema='showtemp';
38select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables where table_schema='temp';
39
40connection stcon2;
41
42--disable_warnings
43drop table if exists showtemp.t2;
44--enable_warnings
45create temporary table t1(id int);
46create temporary table showtemp.t2(id int);
47show temporary tables;
48select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables;
49drop table showtemp.t2;
50drop table t1;
51
52disconnect stcon2;
53
54connection stcon1;
55select table_schema, table_name, engine, table_rows from Information_schema.global_temporary_tables;
56
57drop table t1, t2;
58drop table showtemp.t3;
59drop database showtemp;
60
61connection default;
62disconnect stcon1;
63
64# Wait till all disconnects are completed
65--source include/wait_until_count_sessions.inc
660
=== removed file 'mysql-test/percona_xtradb_admin_command.result'
--- mysql-test/percona_xtradb_admin_command.result 2010-05-20 10:47:38 +0000
+++ mysql-test/percona_xtradb_admin_command.result 1970-01-01 00:00:00 +0000
@@ -1,6 +0,0 @@
1select * from information_schema.XTRADB_ADMIN_COMMAND;
2result_message
3No XTRA_* command in the SQL statement. Please add /*!XTRA_xxxx*/ to the SQL.
4select * from information_schema.XTRADB_ADMIN_COMMAND /*!XTRA_HELLO*/;
5result_message
6Hello!
70
=== removed file 'mysql-test/percona_xtradb_admin_command.test'
--- mysql-test/percona_xtradb_admin_command.test 2010-05-20 10:47:38 +0000
+++ mysql-test/percona_xtradb_admin_command.test 1970-01-01 00:00:00 +0000
@@ -1,3 +0,0 @@
1--source include/have_innodb.inc
2select * from information_schema.XTRADB_ADMIN_COMMAND;
3select * from information_schema.XTRADB_ADMIN_COMMAND /*!XTRA_HELLO*/;
40
=== removed file 'mysql-test/percona_xtradb_bug317074.result'
--- mysql-test/percona_xtradb_bug317074.result 2010-05-20 10:47:38 +0000
+++ mysql-test/percona_xtradb_bug317074.result 1970-01-01 00:00:00 +0000
@@ -1,4 +0,0 @@
1SET @old_innodb_file_format=@@innodb_file_format;
2SET @old_innodb_file_per_table=@@innodb_file_per_table;
3SET GLOBAL innodb_file_format='Barracuda';
4SET GLOBAL innodb_file_per_table=ON;
50
=== removed file 'mysql-test/percona_xtradb_bug317074.test'
--- mysql-test/percona_xtradb_bug317074.test 2010-06-16 09:40:57 +0000
+++ mysql-test/percona_xtradb_bug317074.test 1970-01-01 00:00:00 +0000
@@ -1,47 +0,0 @@
1-- source include/have_innodb.inc
2
3SET @old_innodb_file_format=@@innodb_file_format;
4SET @old_innodb_file_per_table=@@innodb_file_per_table;
5let $innodb_file_format_check_orig=`select @@innodb_file_format_check`;
6SET GLOBAL innodb_file_format='Barracuda';
7SET GLOBAL innodb_file_per_table=ON;
8
9-- disable_query_log
10-- disable_result_log
11
12DROP TABLE IF EXISTS `test1`;
13CREATE TABLE IF NOT EXISTS `test1` (
14 `a` int primary key auto_increment,
15 `b` int default 0,
16 `c` char(100) default 'testtest'
17) ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
18
19delimiter |;
20CREATE PROCEDURE insert_many(p1 int)
21BEGIN
22SET @x = 0;
23SET @y = 0;
24start transaction;
25REPEAT
26 insert into test1 set b=1;
27 SET @x = @x + 1;
28 SET @y = @y + 1;
29 IF @y >= 1000 THEN
30 commit;
31 start transaction;
32 SET @y = 0;
33 END IF;
34UNTIL @x >= p1 END REPEAT;
35commit;
36END|
37delimiter ;|
38call insert_many(100000);
39DROP PROCEDURE insert_many;
40
41# The bug is hangup at the following statement
42ALTER TABLE test1 ENGINE=MyISAM;
43
44DROP TABLE test1;
45SET GLOBAL innodb_file_format=@old_innodb_file_format;
46SET GLOBAL innodb_file_per_table=@old_innodb_file_per_table;
47eval set global innodb_file_format_check=$innodb_file_format_check_orig;
480
=== removed directory 'mysql-test/query_cache_enhance.patch'
=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc'
--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc 2010-11-05 11:51:45 +0000
+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc 1970-01-01 00:00:00 +0000
@@ -1,95 +0,0 @@
1--source include/percona_query_cache_with_comments_clear.inc
2let $query=/* with comment first */select * from t1;
3eval $query;
4--source include/percona_query_cache_with_comments_eval.inc
5
6let $query=# with comment first
7select * from t1;
8--source include/percona_query_cache_with_comments_eval.inc
9
10let $query=-- with comment first
11select * from t1;
12--source include/percona_query_cache_with_comments_eval.inc
13
14let $query=/* with comment first and "quote" */select * from t1;
15--source include/percona_query_cache_with_comments_eval.inc
16
17let $query=# with comment first and "quote"
18select * from t1;
19--source include/percona_query_cache_with_comments_eval.inc
20
21let $query=-- with comment first and "quote"
22select * from t1;
23--source include/percona_query_cache_with_comments_eval.inc
24
25let $query=
26 /* with comment and whitespaces first */select * from t1;
27--source include/percona_query_cache_with_comments_eval.inc
28
29let $query=
30 # with comment and whitespaces first
31select * from t1;
32--source include/percona_query_cache_with_comments_eval.inc
33
34let $query=
35 -- with comment and whitespaces first
36select * from t1;
37--source include/percona_query_cache_with_comments_eval.inc
38
39let $internal=* internal comment *;
40
41let $query=select * /$internal/ from t1;
42--source include/percona_query_cache_with_comments_eval.inc
43let $query=select */$internal/ from t1;
44--source include/percona_query_cache_with_comments_eval.inc
45let $query=select */$internal/from t1;
46--source include/percona_query_cache_with_comments_eval.inc
47
48let $internal=* internal comment with "quote" *;
49
50let $query=select * /$internal/ from t1;
51--source include/percona_query_cache_with_comments_eval.inc
52let $query=select */$internal/ from t1;
53--source include/percona_query_cache_with_comments_eval.inc
54let $query=select */$internal/from t1;
55--source include/percona_query_cache_with_comments_eval.inc
56
57let $query=select * from t1
58;
59--source include/percona_query_cache_with_comments_eval.inc
60
61let $query=select * from t1 ;
62--source include/percona_query_cache_with_comments_eval.inc
63
64let $query=select * from t1 ;
65--source include/percona_query_cache_with_comments_eval.inc
66
67let $query=select * from t1
68/* comment in the end */;
69--source include/percona_query_cache_with_comments_eval.inc
70
71let $query=select * from t1
72/* *\/ */;
73--source include/percona_query_cache_with_comments_eval.inc
74
75let $query=select * from t1
76/* comment in the end */
77;
78--source include/percona_query_cache_with_comments_eval.inc
79
80let $query=select * from t1 #comment in the end;
81--source include/percona_query_cache_with_comments_eval.inc
82
83let $query=select * from t1 #comment in the end
84;
85--source include/percona_query_cache_with_comments_eval.inc
86
87let $query=select * from t1 -- comment in the end;
88--source include/percona_query_cache_with_comments_eval.inc
89
90let $query=select * from t1 -- comment in the end
91;
92--source include/percona_query_cache_with_comments_eval.inc
93
94let $query=select ' \' ' from t1;
95--source include/percona_query_cache_with_comments_eval.inc
960
=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc.backup'
--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc.backup 2010-11-05 11:51:45 +0000
+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.inc.backup 1970-01-01 00:00:00 +0000
@@ -1,88 +0,0 @@
1--source include/percona_query_cache_with_comments_clear.inc
2let $query=/* with comment first */select * from t1;
3eval $query;
4--source include/percona_query_cache_with_comments_eval.inc
5
6let $query=# with comment first
7select * from t1;
8--source include/percona_query_cache_with_comments_eval.inc
9
10let $query=-- with comment first
11select * from t1;
12--source include/percona_query_cache_with_comments_eval.inc
13
14let $query=/* with comment first and "quote" */select * from t1;
15--source include/percona_query_cache_with_comments_eval.inc
16
17let $query=# with comment first and "quote"
18select * from t1;
19--source include/percona_query_cache_with_comments_eval.inc
20
21let $query=-- with comment first and "quote"
22select * from t1;
23--source include/percona_query_cache_with_comments_eval.inc
24
25let $query=
26 /* with comment and whitespaces first */select * from t1;
27--source include/percona_query_cache_with_comments_eval.inc
28
29let $query=
30 # with comment and whitespaces first
31select * from t1;
32--source include/percona_query_cache_with_comments_eval.inc
33
34let $query=
35 -- with comment and whitespaces first
36select * from t1;
37--source include/percona_query_cache_with_comments_eval.inc
38
39let $internal=* internal comment *;
40
41let $query=select * /$internal/ from t1;
42--source include/percona_query_cache_with_comments_eval.inc
43let $query=select */$internal/ from t1;
44--source include/percona_query_cache_with_comments_eval.inc
45let $query=select */$internal/from t1;
46--source include/percona_query_cache_with_comments_eval.inc
47
48let $internal=* internal comment with "quote" *;
49
50let $query=select * /$internal/ from t1;
51--source include/percona_query_cache_with_comments_eval.inc
52let $query=select */$internal/ from t1;
53--source include/percona_query_cache_with_comments_eval.inc
54let $query=select */$internal/from t1;
55--source include/percona_query_cache_with_comments_eval.inc
56
57let $query=select * from t1
58;
59--source include/percona_query_cache_with_comments_eval.inc
60
61let $query=select * from t1 ;
62--source include/percona_query_cache_with_comments_eval.inc
63
64let $query=select * from t1 ;
65--source include/percona_query_cache_with_comments_eval.inc
66
67let $query=select * from t1
68/* comment in the end */;
69--source include/percona_query_cache_with_comments_eval.inc
70
71let $query=select * from t1
72/* comment in the end */
73;
74--source include/percona_query_cache_with_comments_eval.inc
75
76let $query=select * from t1 #comment in the end;
77--source include/percona_query_cache_with_comments_eval.inc
78
79let $query=select * from t1 #comment in the end
80;
81--source include/percona_query_cache_with_comments_eval.inc
82
83let $query=select * from t1 -- comment in the end;
84--source include/percona_query_cache_with_comments_eval.inc
85
86let $query=select * from t1 -- comment in the end
87;
88--source include/percona_query_cache_with_comments_eval.inc
890
=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.result'
--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.result 2010-11-05 11:51:45 +0000
+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.result 1970-01-01 00:00:00 +0000
@@ -1,866 +0,0 @@
1set global query_cache_strip_comments=ON;
2set GLOBAL query_cache_size=1355776;
3drop table if exists t1;
4create table t1 (a int not null);
5insert into t1 values (1),(2),(3);
6flush query cache;
7flush query cache;
8reset query cache;
9flush status;
10flush query cache;
11flush query cache;
12reset query cache;
13flush status;
14/* with comment first */select * from t1;
15a
161
172
183
19-----------------------------------------------------
20/* with comment first */select * from t1
21-----------------------------------------------------
22show status like "Qcache_queries_in_cache";
23Variable_name Value
24Qcache_queries_in_cache 1
25show status like "Qcache_inserts";
26Variable_name Value
27Qcache_inserts 1
28show status like "Qcache_hits";
29Variable_name Value
30Qcache_hits 0
31/* with comment first */select * from t1;
32a
331
342
353
36/* with comment first */select * from t1;
37a
381
392
403
41show status like "Qcache_queries_in_cache";
42Variable_name Value
43Qcache_queries_in_cache 1
44show status like "Qcache_inserts";
45Variable_name Value
46Qcache_inserts 1
47show status like "Qcache_hits";
48Variable_name Value
49Qcache_hits 2
50-----------------------------------------------------
51# with comment first
52select * from t1
53-----------------------------------------------------
54show status like "Qcache_queries_in_cache";
55Variable_name Value
56Qcache_queries_in_cache 1
57show status like "Qcache_inserts";
58Variable_name Value
59Qcache_inserts 1
60show status like "Qcache_hits";
61Variable_name Value
62Qcache_hits 2
63# with comment first
64select * from t1;
65a
661
672
683
69# with comment first
70select * from t1;
71a
721
732
743
75show status like "Qcache_queries_in_cache";
76Variable_name Value
77Qcache_queries_in_cache 1
78show status like "Qcache_inserts";
79Variable_name Value
80Qcache_inserts 1
81show status like "Qcache_hits";
82Variable_name Value
83Qcache_hits 4
84-----------------------------------------------------
85-- with comment first
86select * from t1
87-----------------------------------------------------
88show status like "Qcache_queries_in_cache";
89Variable_name Value
90Qcache_queries_in_cache 1
91show status like "Qcache_inserts";
92Variable_name Value
93Qcache_inserts 1
94show status like "Qcache_hits";
95Variable_name Value
96Qcache_hits 4
97-- with comment first
98select * from t1;
99a
1001
1012
1023
103-- with comment first
104select * from t1;
105a
1061
1072
1083
109show status like "Qcache_queries_in_cache";
110Variable_name Value
111Qcache_queries_in_cache 1
112show status like "Qcache_inserts";
113Variable_name Value
114Qcache_inserts 1
115show status like "Qcache_hits";
116Variable_name Value
117Qcache_hits 6
118-----------------------------------------------------
119/* with comment first and "quote" */select * from t1
120-----------------------------------------------------
121show status like "Qcache_queries_in_cache";
122Variable_name Value
123Qcache_queries_in_cache 1
124show status like "Qcache_inserts";
125Variable_name Value
126Qcache_inserts 1
127show status like "Qcache_hits";
128Variable_name Value
129Qcache_hits 6
130/* with comment first and "quote" */select * from t1;
131a
1321
1332
1343
135/* with comment first and "quote" */select * from t1;
136a
1371
1382
1393
140show status like "Qcache_queries_in_cache";
141Variable_name Value
142Qcache_queries_in_cache 1
143show status like "Qcache_inserts";
144Variable_name Value
145Qcache_inserts 1
146show status like "Qcache_hits";
147Variable_name Value
148Qcache_hits 8
149-----------------------------------------------------
150# with comment first and "quote"
151select * from t1
152-----------------------------------------------------
153show status like "Qcache_queries_in_cache";
154Variable_name Value
155Qcache_queries_in_cache 1
156show status like "Qcache_inserts";
157Variable_name Value
158Qcache_inserts 1
159show status like "Qcache_hits";
160Variable_name Value
161Qcache_hits 8
162# with comment first and "quote"
163select * from t1;
164a
1651
1662
1673
168# with comment first and "quote"
169select * from t1;
170a
1711
1722
1733
174show status like "Qcache_queries_in_cache";
175Variable_name Value
176Qcache_queries_in_cache 1
177show status like "Qcache_inserts";
178Variable_name Value
179Qcache_inserts 1
180show status like "Qcache_hits";
181Variable_name Value
182Qcache_hits 10
183-----------------------------------------------------
184-- with comment first and "quote"
185select * from t1
186-----------------------------------------------------
187show status like "Qcache_queries_in_cache";
188Variable_name Value
189Qcache_queries_in_cache 1
190show status like "Qcache_inserts";
191Variable_name Value
192Qcache_inserts 1
193show status like "Qcache_hits";
194Variable_name Value
195Qcache_hits 10
196-- with comment first and "quote"
197select * from t1;
198a
1991
2002
2013
202-- with comment first and "quote"
203select * from t1;
204a
2051
2062
2073
208show status like "Qcache_queries_in_cache";
209Variable_name Value
210Qcache_queries_in_cache 1
211show status like "Qcache_inserts";
212Variable_name Value
213Qcache_inserts 1
214show status like "Qcache_hits";
215Variable_name Value
216Qcache_hits 12
217-----------------------------------------------------
218/* with comment and whitespaces first */select * from t1
219-----------------------------------------------------
220show status like "Qcache_queries_in_cache";
221Variable_name Value
222Qcache_queries_in_cache 1
223show status like "Qcache_inserts";
224Variable_name Value
225Qcache_inserts 1
226show status like "Qcache_hits";
227Variable_name Value
228Qcache_hits 12
229/* with comment and whitespaces first */select * from t1;
230a
2311
2322
2333
234/* with comment and whitespaces first */select * from t1;
235a
2361
2372
2383
239show status like "Qcache_queries_in_cache";
240Variable_name Value
241Qcache_queries_in_cache 1
242show status like "Qcache_inserts";
243Variable_name Value
244Qcache_inserts 1
245show status like "Qcache_hits";
246Variable_name Value
247Qcache_hits 14
248-----------------------------------------------------
249# with comment and whitespaces first
250select * from t1
251-----------------------------------------------------
252show status like "Qcache_queries_in_cache";
253Variable_name Value
254Qcache_queries_in_cache 1
255show status like "Qcache_inserts";
256Variable_name Value
257Qcache_inserts 1
258show status like "Qcache_hits";
259Variable_name Value
260Qcache_hits 14
261# with comment and whitespaces first
262select * from t1;
263a
2641
2652
2663
267# with comment and whitespaces first
268select * from t1;
269a
2701
2712
2723
273show status like "Qcache_queries_in_cache";
274Variable_name Value
275Qcache_queries_in_cache 1
276show status like "Qcache_inserts";
277Variable_name Value
278Qcache_inserts 1
279show status like "Qcache_hits";
280Variable_name Value
281Qcache_hits 16
282-----------------------------------------------------
283-- with comment and whitespaces first
284select * from t1
285-----------------------------------------------------
286show status like "Qcache_queries_in_cache";
287Variable_name Value
288Qcache_queries_in_cache 1
289show status like "Qcache_inserts";
290Variable_name Value
291Qcache_inserts 1
292show status like "Qcache_hits";
293Variable_name Value
294Qcache_hits 16
295-- with comment and whitespaces first
296select * from t1;
297a
2981
2992
3003
301-- with comment and whitespaces first
302select * from t1;
303a
3041
3052
3063
307show status like "Qcache_queries_in_cache";
308Variable_name Value
309Qcache_queries_in_cache 1
310show status like "Qcache_inserts";
311Variable_name Value
312Qcache_inserts 1
313show status like "Qcache_hits";
314Variable_name Value
315Qcache_hits 18
316-----------------------------------------------------
317select * /* internal comment */ from t1
318-----------------------------------------------------
319show status like "Qcache_queries_in_cache";
320Variable_name Value
321Qcache_queries_in_cache 1
322show status like "Qcache_inserts";
323Variable_name Value
324Qcache_inserts 1
325show status like "Qcache_hits";
326Variable_name Value
327Qcache_hits 18
328select * /* internal comment */ from t1;
329a
3301
3312
3323
333select * /* internal comment */ from t1;
334a
3351
3362
3373
338show status like "Qcache_queries_in_cache";
339Variable_name Value
340Qcache_queries_in_cache 1
341show status like "Qcache_inserts";
342Variable_name Value
343Qcache_inserts 1
344show status like "Qcache_hits";
345Variable_name Value
346Qcache_hits 20
347-----------------------------------------------------
348select */* internal comment */ from t1
349-----------------------------------------------------
350show status like "Qcache_queries_in_cache";
351Variable_name Value
352Qcache_queries_in_cache 1
353show status like "Qcache_inserts";
354Variable_name Value
355Qcache_inserts 1
356show status like "Qcache_hits";
357Variable_name Value
358Qcache_hits 20
359select */* internal comment */ from t1;
360a
3611
3622
3633
364select */* internal comment */ from t1;
365a
3661
3672
3683
369show status like "Qcache_queries_in_cache";
370Variable_name Value
371Qcache_queries_in_cache 1
372show status like "Qcache_inserts";
373Variable_name Value
374Qcache_inserts 1
375show status like "Qcache_hits";
376Variable_name Value
377Qcache_hits 22
378-----------------------------------------------------
379select */* internal comment */from t1
380-----------------------------------------------------
381show status like "Qcache_queries_in_cache";
382Variable_name Value
383Qcache_queries_in_cache 1
384show status like "Qcache_inserts";
385Variable_name Value
386Qcache_inserts 1
387show status like "Qcache_hits";
388Variable_name Value
389Qcache_hits 22
390select */* internal comment */from t1;
391a
3921
3932
3943
395select */* internal comment */from t1;
396a
3971
3982
3993
400show status like "Qcache_queries_in_cache";
401Variable_name Value
402Qcache_queries_in_cache 1
403show status like "Qcache_inserts";
404Variable_name Value
405Qcache_inserts 1
406show status like "Qcache_hits";
407Variable_name Value
408Qcache_hits 24
409-----------------------------------------------------
410select * /* internal comment with "quote" */ from t1
411-----------------------------------------------------
412show status like "Qcache_queries_in_cache";
413Variable_name Value
414Qcache_queries_in_cache 1
415show status like "Qcache_inserts";
416Variable_name Value
417Qcache_inserts 1
418show status like "Qcache_hits";
419Variable_name Value
420Qcache_hits 24
421select * /* internal comment with "quote" */ from t1;
422a
4231
4242
4253
426select * /* internal comment with "quote" */ from t1;
427a
4281
4292
4303
431show status like "Qcache_queries_in_cache";
432Variable_name Value
433Qcache_queries_in_cache 1
434show status like "Qcache_inserts";
435Variable_name Value
436Qcache_inserts 1
437show status like "Qcache_hits";
438Variable_name Value
439Qcache_hits 26
440-----------------------------------------------------
441select */* internal comment with "quote" */ from t1
442-----------------------------------------------------
443show status like "Qcache_queries_in_cache";
444Variable_name Value
445Qcache_queries_in_cache 1
446show status like "Qcache_inserts";
447Variable_name Value
448Qcache_inserts 1
449show status like "Qcache_hits";
450Variable_name Value
451Qcache_hits 26
452select */* internal comment with "quote" */ from t1;
453a
4541
4552
4563
457select */* internal comment with "quote" */ from t1;
458a
4591
4602
4613
462show status like "Qcache_queries_in_cache";
463Variable_name Value
464Qcache_queries_in_cache 1
465show status like "Qcache_inserts";
466Variable_name Value
467Qcache_inserts 1
468show status like "Qcache_hits";
469Variable_name Value
470Qcache_hits 28
471-----------------------------------------------------
472select */* internal comment with "quote" */from t1
473-----------------------------------------------------
474show status like "Qcache_queries_in_cache";
475Variable_name Value
476Qcache_queries_in_cache 1
477show status like "Qcache_inserts";
478Variable_name Value
479Qcache_inserts 1
480show status like "Qcache_hits";
481Variable_name Value
482Qcache_hits 28
483select */* internal comment with "quote" */from t1;
484a
4851
4862
4873
488select */* internal comment with "quote" */from t1;
489a
4901
4912
4923
493show status like "Qcache_queries_in_cache";
494Variable_name Value
495Qcache_queries_in_cache 1
496show status like "Qcache_inserts";
497Variable_name Value
498Qcache_inserts 1
499show status like "Qcache_hits";
500Variable_name Value
501Qcache_hits 30
502-----------------------------------------------------
503select * from t1
504
505-----------------------------------------------------
506show status like "Qcache_queries_in_cache";
507Variable_name Value
508Qcache_queries_in_cache 1
509show status like "Qcache_inserts";
510Variable_name Value
511Qcache_inserts 1
512show status like "Qcache_hits";
513Variable_name Value
514Qcache_hits 30
515select * from t1
516;
517a
5181
5192
5203
521select * from t1
522;
523a
5241
5252
5263
527show status like "Qcache_queries_in_cache";
528Variable_name Value
529Qcache_queries_in_cache 1
530show status like "Qcache_inserts";
531Variable_name Value
532Qcache_inserts 1
533show status like "Qcache_hits";
534Variable_name Value
535Qcache_hits 32
536-----------------------------------------------------
537select * from t1
538-----------------------------------------------------
539show status like "Qcache_queries_in_cache";
540Variable_name Value
541Qcache_queries_in_cache 1
542show status like "Qcache_inserts";
543Variable_name Value
544Qcache_inserts 1
545show status like "Qcache_hits";
546Variable_name Value
547Qcache_hits 32
548select * from t1 ;
549a
5501
5512
5523
553select * from t1 ;
554a
5551
5562
5573
558show status like "Qcache_queries_in_cache";
559Variable_name Value
560Qcache_queries_in_cache 1
561show status like "Qcache_inserts";
562Variable_name Value
563Qcache_inserts 1
564show status like "Qcache_hits";
565Variable_name Value
566Qcache_hits 34
567-----------------------------------------------------
568select * from t1
569-----------------------------------------------------
570show status like "Qcache_queries_in_cache";
571Variable_name Value
572Qcache_queries_in_cache 1
573show status like "Qcache_inserts";
574Variable_name Value
575Qcache_inserts 1
576show status like "Qcache_hits";
577Variable_name Value
578Qcache_hits 34
579select * from t1 ;
580a
5811
5822
5833
584select * from t1 ;
585a
5861
5872
5883
589show status like "Qcache_queries_in_cache";
590Variable_name Value
591Qcache_queries_in_cache 1
592show status like "Qcache_inserts";
593Variable_name Value
594Qcache_inserts 1
595show status like "Qcache_hits";
596Variable_name Value
597Qcache_hits 36
598-----------------------------------------------------
599select * from t1
600/* comment in the end */
601-----------------------------------------------------
602show status like "Qcache_queries_in_cache";
603Variable_name Value
604Qcache_queries_in_cache 1
605show status like "Qcache_inserts";
606Variable_name Value
607Qcache_inserts 1
608show status like "Qcache_hits";
609Variable_name Value
610Qcache_hits 36
611select * from t1
612/* comment in the end */;
613a
6141
6152
6163
617select * from t1
618/* comment in the end */;
619a
6201
6212
6223
623show status like "Qcache_queries_in_cache";
624Variable_name Value
625Qcache_queries_in_cache 1
626show status like "Qcache_inserts";
627Variable_name Value
628Qcache_inserts 1
629show status like "Qcache_hits";
630Variable_name Value
631Qcache_hits 38
632-----------------------------------------------------
633select * from t1
634/* *\/ */
635-----------------------------------------------------
636show status like "Qcache_queries_in_cache";
637Variable_name Value
638Qcache_queries_in_cache 1
639show status like "Qcache_inserts";
640Variable_name Value
641Qcache_inserts 1
642show status like "Qcache_hits";
643Variable_name Value
644Qcache_hits 38
645select * from t1
646/* *\/ */;
647a
6481
6492
6503
651select * from t1
652/* *\/ */;
653a
6541
6552
6563
657show status like "Qcache_queries_in_cache";
658Variable_name Value
659Qcache_queries_in_cache 1
660show status like "Qcache_inserts";
661Variable_name Value
662Qcache_inserts 1
663show status like "Qcache_hits";
664Variable_name Value
665Qcache_hits 40
666-----------------------------------------------------
667select * from t1
668/* comment in the end */
669
670-----------------------------------------------------
671show status like "Qcache_queries_in_cache";
672Variable_name Value
673Qcache_queries_in_cache 1
674show status like "Qcache_inserts";
675Variable_name Value
676Qcache_inserts 1
677show status like "Qcache_hits";
678Variable_name Value
679Qcache_hits 40
680select * from t1
681/* comment in the end */
682;
683a
6841
6852
6863
687select * from t1
688/* comment in the end */
689;
690a
6911
6922
6933
694show status like "Qcache_queries_in_cache";
695Variable_name Value
696Qcache_queries_in_cache 1
697show status like "Qcache_inserts";
698Variable_name Value
699Qcache_inserts 1
700show status like "Qcache_hits";
701Variable_name Value
702Qcache_hits 42
703-----------------------------------------------------
704select * from t1 #comment in the end
705-----------------------------------------------------
706show status like "Qcache_queries_in_cache";
707Variable_name Value
708Qcache_queries_in_cache 1
709show status like "Qcache_inserts";
710Variable_name Value
711Qcache_inserts 1
712show status like "Qcache_hits";
713Variable_name Value
714Qcache_hits 42
715select * from t1 #comment in the end;
716a
7171
7182
7193
720select * from t1 #comment in the end;
721a
7221
7232
7243
725show status like "Qcache_queries_in_cache";
726Variable_name Value
727Qcache_queries_in_cache 1
728show status like "Qcache_inserts";
729Variable_name Value
730Qcache_inserts 1
731show status like "Qcache_hits";
732Variable_name Value
733Qcache_hits 44
734-----------------------------------------------------
735select * from t1 #comment in the end
736
737-----------------------------------------------------
738show status like "Qcache_queries_in_cache";
739Variable_name Value
740Qcache_queries_in_cache 1
741show status like "Qcache_inserts";
742Variable_name Value
743Qcache_inserts 1
744show status like "Qcache_hits";
745Variable_name Value
746Qcache_hits 44
747select * from t1 #comment in the end
748;
749a
7501
7512
7523
753select * from t1 #comment in the end
754;
755a
7561
7572
7583
759show status like "Qcache_queries_in_cache";
760Variable_name Value
761Qcache_queries_in_cache 1
762show status like "Qcache_inserts";
763Variable_name Value
764Qcache_inserts 1
765show status like "Qcache_hits";
766Variable_name Value
767Qcache_hits 46
768-----------------------------------------------------
769select * from t1 -- comment in the end
770-----------------------------------------------------
771show status like "Qcache_queries_in_cache";
772Variable_name Value
773Qcache_queries_in_cache 1
774show status like "Qcache_inserts";
775Variable_name Value
776Qcache_inserts 1
777show status like "Qcache_hits";
778Variable_name Value
779Qcache_hits 46
780select * from t1 -- comment in the end;
781a
7821
7832
7843
785select * from t1 -- comment in the end;
786a
7871
7882
7893
790show status like "Qcache_queries_in_cache";
791Variable_name Value
792Qcache_queries_in_cache 1
793show status like "Qcache_inserts";
794Variable_name Value
795Qcache_inserts 1
796show status like "Qcache_hits";
797Variable_name Value
798Qcache_hits 48
799-----------------------------------------------------
800select * from t1 -- comment in the end
801
802-----------------------------------------------------
803show status like "Qcache_queries_in_cache";
804Variable_name Value
805Qcache_queries_in_cache 1
806show status like "Qcache_inserts";
807Variable_name Value
808Qcache_inserts 1
809show status like "Qcache_hits";
810Variable_name Value
811Qcache_hits 48
812select * from t1 -- comment in the end
813;
814a
8151
8162
8173
818select * from t1 -- comment in the end
819;
820a
8211
8222
8233
824show status like "Qcache_queries_in_cache";
825Variable_name Value
826Qcache_queries_in_cache 1
827show status like "Qcache_inserts";
828Variable_name Value
829Qcache_inserts 1
830show status like "Qcache_hits";
831Variable_name Value
832Qcache_hits 50
833-----------------------------------------------------
834select ' \' ' from t1
835-----------------------------------------------------
836show status like "Qcache_queries_in_cache";
837Variable_name Value
838Qcache_queries_in_cache 1
839show status like "Qcache_inserts";
840Variable_name Value
841Qcache_inserts 1
842show status like "Qcache_hits";
843Variable_name Value
844Qcache_hits 50
845select ' \' ' from t1;
846'
847 '
848 '
849 '
850select ' \' ' from t1;
851'
852 '
853 '
854 '
855show status like "Qcache_queries_in_cache";
856Variable_name Value
857Qcache_queries_in_cache 2
858show status like "Qcache_inserts";
859Variable_name Value
860Qcache_inserts 2
861show status like "Qcache_hits";
862Variable_name Value
863Qcache_hits 51
864DROP TABLE t1;
865SET GLOBAL query_cache_size=default;
866set global query_cache_strip_comments=OFF;
8670
=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.test'
--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.test 2010-11-18 10:48:03 +0000
+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments.test 1970-01-01 00:00:00 +0000
@@ -1,5 +0,0 @@
1--disable_ps_protocol
2set global query_cache_strip_comments=ON;
3-- source include/percona_query_cache_with_comments_begin.inc
4-- source include/percona_query_cache_with_comments.inc
5-- source include/percona_query_cache_with_comments_end.inc
60
=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_begin.inc'
--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_begin.inc 2010-11-05 11:51:45 +0000
+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_begin.inc 1970-01-01 00:00:00 +0000
@@ -1,12 +0,0 @@
1-- source include/have_query_cache.inc
2
3set GLOBAL query_cache_size=1355776;
4
5--disable_warnings
6drop table if exists t1;
7--enable_warnings
8
9create table t1 (a int not null);
10insert into t1 values (1),(2),(3);
11
12--source include/percona_query_cache_with_comments_clear.inc
130
=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_clear.inc'
--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_clear.inc 2010-11-05 11:51:45 +0000
+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_clear.inc 1970-01-01 00:00:00 +0000
@@ -1,5 +0,0 @@
1# Reset query cache variables.
2flush query cache; # This crashed in some versions
3flush query cache; # This crashed in some versions
4reset query cache;
5flush status;
60
=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_crash.result'
--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_crash.result 2010-11-05 11:51:45 +0000
+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_crash.result 1970-01-01 00:00:00 +0000
@@ -1,21 +0,0 @@
1set GLOBAL query_cache_size=1355776;
2drop table if exists t1;
3create table t1 (a int not null);
4insert into t1 values (1),(2),(3);
5flush query cache;
6flush query cache;
7reset query cache;
8flush status;
9( select * from t1 );
10a
111
122
133
14/*!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 */;
15/* only comment */;
16# only comment
17;
18-- only comment
19;
20DROP TABLE t1;
21SET GLOBAL query_cache_size= default;
220
=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_crash.test'
--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_crash.test 2010-11-05 11:51:45 +0000
+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_crash.test 1970-01-01 00:00:00 +0000
@@ -1,22 +0,0 @@
1-- source include/have_query_cache.inc
2set GLOBAL query_cache_size=1355776;
3--disable_warnings
4drop table if exists t1;
5--enable_warnings
6create table t1 (a int not null);
7insert into t1 values (1),(2),(3);
8flush query cache; # This crashed in some versions
9flush query cache; # This crashed in some versions
10reset query cache;
11flush status;
12( select * from t1 );
13/*!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 */;
14/* only comment */;
15let query=# only comment
16;
17eval $query;
18let query=-- only comment
19;
20eval $query;
21DROP TABLE t1;
22SET GLOBAL query_cache_size= default;
230
=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_disable.result'
--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_disable.result 2010-11-05 11:51:45 +0000
+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_disable.result 1970-01-01 00:00:00 +0000
@@ -1,865 +0,0 @@
1set GLOBAL query_cache_size=1355776;
2drop table if exists t1;
3create table t1 (a int not null);
4insert into t1 values (1),(2),(3);
5flush query cache;
6flush query cache;
7reset query cache;
8flush status;
9flush query cache;
10flush query cache;
11reset query cache;
12flush status;
13/* with comment first */select * from t1;
14a
151
162
173
18-----------------------------------------------------
19/* with comment first */select * from t1
20-----------------------------------------------------
21show status like "Qcache_queries_in_cache";
22Variable_name Value
23Qcache_queries_in_cache 1
24show status like "Qcache_inserts";
25Variable_name Value
26Qcache_inserts 1
27show status like "Qcache_hits";
28Variable_name Value
29Qcache_hits 0
30/* with comment first */select * from t1;
31a
321
332
343
35/* with comment first */select * from t1;
36a
371
382
393
40show status like "Qcache_queries_in_cache";
41Variable_name Value
42Qcache_queries_in_cache 1
43show status like "Qcache_inserts";
44Variable_name Value
45Qcache_inserts 1
46show status like "Qcache_hits";
47Variable_name Value
48Qcache_hits 2
49-----------------------------------------------------
50# with comment first
51select * from t1
52-----------------------------------------------------
53show status like "Qcache_queries_in_cache";
54Variable_name Value
55Qcache_queries_in_cache 1
56show status like "Qcache_inserts";
57Variable_name Value
58Qcache_inserts 1
59show status like "Qcache_hits";
60Variable_name Value
61Qcache_hits 2
62# with comment first
63select * from t1;
64a
651
662
673
68# with comment first
69select * from t1;
70a
711
722
733
74show status like "Qcache_queries_in_cache";
75Variable_name Value
76Qcache_queries_in_cache 2
77show status like "Qcache_inserts";
78Variable_name Value
79Qcache_inserts 2
80show status like "Qcache_hits";
81Variable_name Value
82Qcache_hits 2
83-----------------------------------------------------
84-- with comment first
85select * from t1
86-----------------------------------------------------
87show status like "Qcache_queries_in_cache";
88Variable_name Value
89Qcache_queries_in_cache 2
90show status like "Qcache_inserts";
91Variable_name Value
92Qcache_inserts 2
93show status like "Qcache_hits";
94Variable_name Value
95Qcache_hits 2
96-- with comment first
97select * from t1;
98a
991
1002
1013
102-- with comment first
103select * from t1;
104a
1051
1062
1073
108show status like "Qcache_queries_in_cache";
109Variable_name Value
110Qcache_queries_in_cache 3
111show status like "Qcache_inserts";
112Variable_name Value
113Qcache_inserts 3
114show status like "Qcache_hits";
115Variable_name Value
116Qcache_hits 2
117-----------------------------------------------------
118/* with comment first and "quote" */select * from t1
119-----------------------------------------------------
120show status like "Qcache_queries_in_cache";
121Variable_name Value
122Qcache_queries_in_cache 3
123show status like "Qcache_inserts";
124Variable_name Value
125Qcache_inserts 3
126show status like "Qcache_hits";
127Variable_name Value
128Qcache_hits 2
129/* with comment first and "quote" */select * from t1;
130a
1311
1322
1333
134/* with comment first and "quote" */select * from t1;
135a
1361
1372
1383
139show status like "Qcache_queries_in_cache";
140Variable_name Value
141Qcache_queries_in_cache 4
142show status like "Qcache_inserts";
143Variable_name Value
144Qcache_inserts 4
145show status like "Qcache_hits";
146Variable_name Value
147Qcache_hits 3
148-----------------------------------------------------
149# with comment first and "quote"
150select * from t1
151-----------------------------------------------------
152show status like "Qcache_queries_in_cache";
153Variable_name Value
154Qcache_queries_in_cache 4
155show status like "Qcache_inserts";
156Variable_name Value
157Qcache_inserts 4
158show status like "Qcache_hits";
159Variable_name Value
160Qcache_hits 3
161# with comment first and "quote"
162select * from t1;
163a
1641
1652
1663
167# with comment first and "quote"
168select * from t1;
169a
1701
1712
1723
173show status like "Qcache_queries_in_cache";
174Variable_name Value
175Qcache_queries_in_cache 5
176show status like "Qcache_inserts";
177Variable_name Value
178Qcache_inserts 5
179show status like "Qcache_hits";
180Variable_name Value
181Qcache_hits 3
182-----------------------------------------------------
183-- with comment first and "quote"
184select * from t1
185-----------------------------------------------------
186show status like "Qcache_queries_in_cache";
187Variable_name Value
188Qcache_queries_in_cache 5
189show status like "Qcache_inserts";
190Variable_name Value
191Qcache_inserts 5
192show status like "Qcache_hits";
193Variable_name Value
194Qcache_hits 3
195-- with comment first and "quote"
196select * from t1;
197a
1981
1992
2003
201-- with comment first and "quote"
202select * from t1;
203a
2041
2052
2063
207show status like "Qcache_queries_in_cache";
208Variable_name Value
209Qcache_queries_in_cache 6
210show status like "Qcache_inserts";
211Variable_name Value
212Qcache_inserts 6
213show status like "Qcache_hits";
214Variable_name Value
215Qcache_hits 3
216-----------------------------------------------------
217/* with comment and whitespaces first */select * from t1
218-----------------------------------------------------
219show status like "Qcache_queries_in_cache";
220Variable_name Value
221Qcache_queries_in_cache 6
222show status like "Qcache_inserts";
223Variable_name Value
224Qcache_inserts 6
225show status like "Qcache_hits";
226Variable_name Value
227Qcache_hits 3
228/* with comment and whitespaces first */select * from t1;
229a
2301
2312
2323
233/* with comment and whitespaces first */select * from t1;
234a
2351
2362
2373
238show status like "Qcache_queries_in_cache";
239Variable_name Value
240Qcache_queries_in_cache 7
241show status like "Qcache_inserts";
242Variable_name Value
243Qcache_inserts 7
244show status like "Qcache_hits";
245Variable_name Value
246Qcache_hits 4
247-----------------------------------------------------
248# with comment and whitespaces first
249select * from t1
250-----------------------------------------------------
251show status like "Qcache_queries_in_cache";
252Variable_name Value
253Qcache_queries_in_cache 7
254show status like "Qcache_inserts";
255Variable_name Value
256Qcache_inserts 7
257show status like "Qcache_hits";
258Variable_name Value
259Qcache_hits 4
260# with comment and whitespaces first
261select * from t1;
262a
2631
2642
2653
266# with comment and whitespaces first
267select * from t1;
268a
2691
2702
2713
272show status like "Qcache_queries_in_cache";
273Variable_name Value
274Qcache_queries_in_cache 8
275show status like "Qcache_inserts";
276Variable_name Value
277Qcache_inserts 8
278show status like "Qcache_hits";
279Variable_name Value
280Qcache_hits 4
281-----------------------------------------------------
282-- with comment and whitespaces first
283select * from t1
284-----------------------------------------------------
285show status like "Qcache_queries_in_cache";
286Variable_name Value
287Qcache_queries_in_cache 8
288show status like "Qcache_inserts";
289Variable_name Value
290Qcache_inserts 8
291show status like "Qcache_hits";
292Variable_name Value
293Qcache_hits 4
294-- with comment and whitespaces first
295select * from t1;
296a
2971
2982
2993
300-- with comment and whitespaces first
301select * from t1;
302a
3031
3042
3053
306show status like "Qcache_queries_in_cache";
307Variable_name Value
308Qcache_queries_in_cache 9
309show status like "Qcache_inserts";
310Variable_name Value
311Qcache_inserts 9
312show status like "Qcache_hits";
313Variable_name Value
314Qcache_hits 4
315-----------------------------------------------------
316select * /* internal comment */ from t1
317-----------------------------------------------------
318show status like "Qcache_queries_in_cache";
319Variable_name Value
320Qcache_queries_in_cache 9
321show status like "Qcache_inserts";
322Variable_name Value
323Qcache_inserts 9
324show status like "Qcache_hits";
325Variable_name Value
326Qcache_hits 4
327select * /* internal comment */ from t1;
328a
3291
3302
3313
332select * /* internal comment */ from t1;
333a
3341
3352
3363
337show status like "Qcache_queries_in_cache";
338Variable_name Value
339Qcache_queries_in_cache 10
340show status like "Qcache_inserts";
341Variable_name Value
342Qcache_inserts 10
343show status like "Qcache_hits";
344Variable_name Value
345Qcache_hits 5
346-----------------------------------------------------
347select */* internal comment */ from t1
348-----------------------------------------------------
349show status like "Qcache_queries_in_cache";
350Variable_name Value
351Qcache_queries_in_cache 10
352show status like "Qcache_inserts";
353Variable_name Value
354Qcache_inserts 10
355show status like "Qcache_hits";
356Variable_name Value
357Qcache_hits 5
358select */* internal comment */ from t1;
359a
3601
3612
3623
363select */* internal comment */ from t1;
364a
3651
3662
3673
368show status like "Qcache_queries_in_cache";
369Variable_name Value
370Qcache_queries_in_cache 11
371show status like "Qcache_inserts";
372Variable_name Value
373Qcache_inserts 11
374show status like "Qcache_hits";
375Variable_name Value
376Qcache_hits 6
377-----------------------------------------------------
378select */* internal comment */from t1
379-----------------------------------------------------
380show status like "Qcache_queries_in_cache";
381Variable_name Value
382Qcache_queries_in_cache 11
383show status like "Qcache_inserts";
384Variable_name Value
385Qcache_inserts 11
386show status like "Qcache_hits";
387Variable_name Value
388Qcache_hits 6
389select */* internal comment */from t1;
390a
3911
3922
3933
394select */* internal comment */from t1;
395a
3961
3972
3983
399show status like "Qcache_queries_in_cache";
400Variable_name Value
401Qcache_queries_in_cache 12
402show status like "Qcache_inserts";
403Variable_name Value
404Qcache_inserts 12
405show status like "Qcache_hits";
406Variable_name Value
407Qcache_hits 7
408-----------------------------------------------------
409select * /* internal comment with "quote" */ from t1
410-----------------------------------------------------
411show status like "Qcache_queries_in_cache";
412Variable_name Value
413Qcache_queries_in_cache 12
414show status like "Qcache_inserts";
415Variable_name Value
416Qcache_inserts 12
417show status like "Qcache_hits";
418Variable_name Value
419Qcache_hits 7
420select * /* internal comment with "quote" */ from t1;
421a
4221
4232
4243
425select * /* internal comment with "quote" */ from t1;
426a
4271
4282
4293
430show status like "Qcache_queries_in_cache";
431Variable_name Value
432Qcache_queries_in_cache 13
433show status like "Qcache_inserts";
434Variable_name Value
435Qcache_inserts 13
436show status like "Qcache_hits";
437Variable_name Value
438Qcache_hits 8
439-----------------------------------------------------
440select */* internal comment with "quote" */ from t1
441-----------------------------------------------------
442show status like "Qcache_queries_in_cache";
443Variable_name Value
444Qcache_queries_in_cache 13
445show status like "Qcache_inserts";
446Variable_name Value
447Qcache_inserts 13
448show status like "Qcache_hits";
449Variable_name Value
450Qcache_hits 8
451select */* internal comment with "quote" */ from t1;
452a
4531
4542
4553
456select */* internal comment with "quote" */ from t1;
457a
4581
4592
4603
461show status like "Qcache_queries_in_cache";
462Variable_name Value
463Qcache_queries_in_cache 14
464show status like "Qcache_inserts";
465Variable_name Value
466Qcache_inserts 14
467show status like "Qcache_hits";
468Variable_name Value
469Qcache_hits 9
470-----------------------------------------------------
471select */* internal comment with "quote" */from t1
472-----------------------------------------------------
473show status like "Qcache_queries_in_cache";
474Variable_name Value
475Qcache_queries_in_cache 14
476show status like "Qcache_inserts";
477Variable_name Value
478Qcache_inserts 14
479show status like "Qcache_hits";
480Variable_name Value
481Qcache_hits 9
482select */* internal comment with "quote" */from t1;
483a
4841
4852
4863
487select */* internal comment with "quote" */from t1;
488a
4891
4902
4913
492show status like "Qcache_queries_in_cache";
493Variable_name Value
494Qcache_queries_in_cache 15
495show status like "Qcache_inserts";
496Variable_name Value
497Qcache_inserts 15
498show status like "Qcache_hits";
499Variable_name Value
500Qcache_hits 10
501-----------------------------------------------------
502select * from t1
503
504-----------------------------------------------------
505show status like "Qcache_queries_in_cache";
506Variable_name Value
507Qcache_queries_in_cache 15
508show status like "Qcache_inserts";
509Variable_name Value
510Qcache_inserts 15
511show status like "Qcache_hits";
512Variable_name Value
513Qcache_hits 10
514select * from t1
515;
516a
5171
5182
5193
520select * from t1
521;
522a
5231
5242
5253
526show status like "Qcache_queries_in_cache";
527Variable_name Value
528Qcache_queries_in_cache 16
529show status like "Qcache_inserts";
530Variable_name Value
531Qcache_inserts 16
532show status like "Qcache_hits";
533Variable_name Value
534Qcache_hits 11
535-----------------------------------------------------
536select * from t1
537-----------------------------------------------------
538show status like "Qcache_queries_in_cache";
539Variable_name Value
540Qcache_queries_in_cache 16
541show status like "Qcache_inserts";
542Variable_name Value
543Qcache_inserts 16
544show status like "Qcache_hits";
545Variable_name Value
546Qcache_hits 11
547select * from t1 ;
548a
5491
5502
5513
552select * from t1 ;
553a
5541
5552
5563
557show status like "Qcache_queries_in_cache";
558Variable_name Value
559Qcache_queries_in_cache 16
560show status like "Qcache_inserts";
561Variable_name Value
562Qcache_inserts 16
563show status like "Qcache_hits";
564Variable_name Value
565Qcache_hits 13
566-----------------------------------------------------
567select * from t1
568-----------------------------------------------------
569show status like "Qcache_queries_in_cache";
570Variable_name Value
571Qcache_queries_in_cache 16
572show status like "Qcache_inserts";
573Variable_name Value
574Qcache_inserts 16
575show status like "Qcache_hits";
576Variable_name Value
577Qcache_hits 13
578select * from t1 ;
579a
5801
5812
5823
583select * from t1 ;
584a
5851
5862
5873
588show status like "Qcache_queries_in_cache";
589Variable_name Value
590Qcache_queries_in_cache 16
591show status like "Qcache_inserts";
592Variable_name Value
593Qcache_inserts 16
594show status like "Qcache_hits";
595Variable_name Value
596Qcache_hits 15
597-----------------------------------------------------
598select * from t1
599/* comment in the end */
600-----------------------------------------------------
601show status like "Qcache_queries_in_cache";
602Variable_name Value
603Qcache_queries_in_cache 16
604show status like "Qcache_inserts";
605Variable_name Value
606Qcache_inserts 16
607show status like "Qcache_hits";
608Variable_name Value
609Qcache_hits 15
610select * from t1
611/* comment in the end */;
612a
6131
6142
6153
616select * from t1
617/* comment in the end */;
618a
6191
6202
6213
622show status like "Qcache_queries_in_cache";
623Variable_name Value
624Qcache_queries_in_cache 17
625show status like "Qcache_inserts";
626Variable_name Value
627Qcache_inserts 17
628show status like "Qcache_hits";
629Variable_name Value
630Qcache_hits 16
631-----------------------------------------------------
632select * from t1
633/* *\/ */
634-----------------------------------------------------
635show status like "Qcache_queries_in_cache";
636Variable_name Value
637Qcache_queries_in_cache 17
638show status like "Qcache_inserts";
639Variable_name Value
640Qcache_inserts 17
641show status like "Qcache_hits";
642Variable_name Value
643Qcache_hits 16
644select * from t1
645/* *\/ */;
646a
6471
6482
6493
650select * from t1
651/* *\/ */;
652a
6531
6542
6553
656show status like "Qcache_queries_in_cache";
657Variable_name Value
658Qcache_queries_in_cache 18
659show status like "Qcache_inserts";
660Variable_name Value
661Qcache_inserts 18
662show status like "Qcache_hits";
663Variable_name Value
664Qcache_hits 17
665-----------------------------------------------------
666select * from t1
667/* comment in the end */
668
669-----------------------------------------------------
670show status like "Qcache_queries_in_cache";
671Variable_name Value
672Qcache_queries_in_cache 18
673show status like "Qcache_inserts";
674Variable_name Value
675Qcache_inserts 18
676show status like "Qcache_hits";
677Variable_name Value
678Qcache_hits 17
679select * from t1
680/* comment in the end */
681;
682a
6831
6842
6853
686select * from t1
687/* comment in the end */
688;
689a
6901
6912
6923
693show status like "Qcache_queries_in_cache";
694Variable_name Value
695Qcache_queries_in_cache 18
696show status like "Qcache_inserts";
697Variable_name Value
698Qcache_inserts 18
699show status like "Qcache_hits";
700Variable_name Value
701Qcache_hits 19
702-----------------------------------------------------
703select * from t1 #comment in the end
704-----------------------------------------------------
705show status like "Qcache_queries_in_cache";
706Variable_name Value
707Qcache_queries_in_cache 18
708show status like "Qcache_inserts";
709Variable_name Value
710Qcache_inserts 18
711show status like "Qcache_hits";
712Variable_name Value
713Qcache_hits 19
714select * from t1 #comment in the end;
715a
7161
7172
7183
719select * from t1 #comment in the end;
720a
7211
7222
7233
724show status like "Qcache_queries_in_cache";
725Variable_name Value
726Qcache_queries_in_cache 19
727show status like "Qcache_inserts";
728Variable_name Value
729Qcache_inserts 19
730show status like "Qcache_hits";
731Variable_name Value
732Qcache_hits 20
733-----------------------------------------------------
734select * from t1 #comment in the end
735
736-----------------------------------------------------
737show status like "Qcache_queries_in_cache";
738Variable_name Value
739Qcache_queries_in_cache 19
740show status like "Qcache_inserts";
741Variable_name Value
742Qcache_inserts 19
743show status like "Qcache_hits";
744Variable_name Value
745Qcache_hits 20
746select * from t1 #comment in the end
747;
748a
7491
7502
7513
752select * from t1 #comment in the end
753;
754a
7551
7562
7573
758show status like "Qcache_queries_in_cache";
759Variable_name Value
760Qcache_queries_in_cache 19
761show status like "Qcache_inserts";
762Variable_name Value
763Qcache_inserts 19
764show status like "Qcache_hits";
765Variable_name Value
766Qcache_hits 22
767-----------------------------------------------------
768select * from t1 -- comment in the end
769-----------------------------------------------------
770show status like "Qcache_queries_in_cache";
771Variable_name Value
772Qcache_queries_in_cache 19
773show status like "Qcache_inserts";
774Variable_name Value
775Qcache_inserts 19
776show status like "Qcache_hits";
777Variable_name Value
778Qcache_hits 22
779select * from t1 -- comment in the end;
780a
7811
7822
7833
784select * from t1 -- comment in the end;
785a
7861
7872
7883
789show status like "Qcache_queries_in_cache";
790Variable_name Value
791Qcache_queries_in_cache 20
792show status like "Qcache_inserts";
793Variable_name Value
794Qcache_inserts 20
795show status like "Qcache_hits";
796Variable_name Value
797Qcache_hits 23
798-----------------------------------------------------
799select * from t1 -- comment in the end
800
801-----------------------------------------------------
802show status like "Qcache_queries_in_cache";
803Variable_name Value
804Qcache_queries_in_cache 20
805show status like "Qcache_inserts";
806Variable_name Value
807Qcache_inserts 20
808show status like "Qcache_hits";
809Variable_name Value
810Qcache_hits 23
811select * from t1 -- comment in the end
812;
813a
8141
8152
8163
817select * from t1 -- comment in the end
818;
819a
8201
8212
8223
823show status like "Qcache_queries_in_cache";
824Variable_name Value
825Qcache_queries_in_cache 20
826show status like "Qcache_inserts";
827Variable_name Value
828Qcache_inserts 20
829show status like "Qcache_hits";
830Variable_name Value
831Qcache_hits 25
832-----------------------------------------------------
833select ' \' ' from t1
834-----------------------------------------------------
835show status like "Qcache_queries_in_cache";
836Variable_name Value
837Qcache_queries_in_cache 20
838show status like "Qcache_inserts";
839Variable_name Value
840Qcache_inserts 20
841show status like "Qcache_hits";
842Variable_name Value
843Qcache_hits 25
844select ' \' ' from t1;
845'
846 '
847 '
848 '
849select ' \' ' from t1;
850'
851 '
852 '
853 '
854show status like "Qcache_queries_in_cache";
855Variable_name Value
856Qcache_queries_in_cache 21
857show status like "Qcache_inserts";
858Variable_name Value
859Qcache_inserts 21
860show status like "Qcache_hits";
861Variable_name Value
862Qcache_hits 26
863DROP TABLE t1;
864SET GLOBAL query_cache_size=default;
865set global query_cache_strip_comments=OFF;
8660
=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_disable.test'
--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_disable.test 2010-11-05 11:51:45 +0000
+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_disable.test 1970-01-01 00:00:00 +0000
@@ -1,3 +0,0 @@
1-- source include/percona_query_cache_with_comments_begin.inc
2-- source include/percona_query_cache_with_comments.inc
3-- source include/percona_query_cache_with_comments_end.inc
40
=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_end.inc'
--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_end.inc 2010-11-05 11:51:45 +0000
+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_end.inc 1970-01-01 00:00:00 +0000
@@ -1,3 +0,0 @@
1DROP TABLE t1;
2SET GLOBAL query_cache_size=default;
3set global query_cache_strip_comments=OFF;
40
=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_eval.inc'
--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_eval.inc 2010-11-05 11:51:45 +0000
+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_eval.inc 1970-01-01 00:00:00 +0000
@@ -1,7 +0,0 @@
1echo -----------------------------------------------------;
2echo $query;
3echo -----------------------------------------------------;
4--source include/percona_query_cache_with_comments_show.inc
5eval $query;
6eval $query;
7--source include/percona_query_cache_with_comments_show.inc
80
=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_prepared_statements.result'
--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_prepared_statements.result 2010-11-05 11:51:45 +0000
+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_prepared_statements.result 1970-01-01 00:00:00 +0000
@@ -1,396 +0,0 @@
1set GLOBAL query_cache_size=1355776;
2flush query cache;
3flush query cache;
4reset query cache;
5flush status;
6drop table if exists t1;
7create table t1 (a int not null);
8insert into t1 values (1),(2),(3);
9set global query_cache_strip_comments=ON;
10show status like "Qcache_queries_in_cache";
11Variable_name Value
12Qcache_queries_in_cache 0
13show status like "Qcache_inserts";
14Variable_name Value
15Qcache_inserts 0
16show status like "Qcache_hits";
17Variable_name Value
18Qcache_hits 0
19prepare stmt from '/* with comment */ select * from t1';
20execute stmt;
21a
221
232
243
25show status like "Qcache_queries_in_cache";
26Variable_name Value
27Qcache_queries_in_cache 1
28show status like "Qcache_inserts";
29Variable_name Value
30Qcache_inserts 1
31show status like "Qcache_hits";
32Variable_name Value
33Qcache_hits 0
34execute stmt;
35a
361
372
383
39execute stmt;
40a
411
422
433
44execute stmt;
45a
461
472
483
49execute stmt;
50a
511
522
533
54execute stmt;
55a
561
572
583
59show status like "Qcache_queries_in_cache";
60Variable_name Value
61Qcache_queries_in_cache 1
62show status like "Qcache_inserts";
63Variable_name Value
64Qcache_inserts 1
65show status like "Qcache_hits";
66Variable_name Value
67Qcache_hits 5
68prepare stmt from 'select * from t1';
69execute stmt;
70a
711
722
733
74show status like "Qcache_queries_in_cache";
75Variable_name Value
76Qcache_queries_in_cache 1
77show status like "Qcache_inserts";
78Variable_name Value
79Qcache_inserts 1
80show status like "Qcache_hits";
81Variable_name Value
82Qcache_hits 6
83prepare stmt from 'select * /*internal comment*/from t1';
84execute stmt;
85a
861
872
883
89show status like "Qcache_queries_in_cache";
90Variable_name Value
91Qcache_queries_in_cache 1
92show status like "Qcache_inserts";
93Variable_name Value
94Qcache_inserts 1
95show status like "Qcache_hits";
96Variable_name Value
97Qcache_hits 7
98prepare stmt from 'select * /*internal comment*/ from t1';
99execute stmt;
100a
1011
1022
1033
104show status like "Qcache_queries_in_cache";
105Variable_name Value
106Qcache_queries_in_cache 1
107show status like "Qcache_inserts";
108Variable_name Value
109Qcache_inserts 1
110show status like "Qcache_hits";
111Variable_name Value
112Qcache_hits 8
113prepare stmt from 'select * from t1 /* at the end */';
114execute stmt;
115a
1161
1172
1183
119show status like "Qcache_queries_in_cache";
120Variable_name Value
121Qcache_queries_in_cache 1
122show status like "Qcache_inserts";
123Variable_name Value
124Qcache_inserts 1
125show status like "Qcache_hits";
126Variable_name Value
127Qcache_hits 9
128prepare stmt from 'select * from t1 /* with "quote" */';
129execute stmt;
130a
1311
1322
1333
134show status like "Qcache_queries_in_cache";
135Variable_name Value
136Qcache_queries_in_cache 1
137show status like "Qcache_inserts";
138Variable_name Value
139Qcache_inserts 1
140show status like "Qcache_hits";
141Variable_name Value
142Qcache_hits 10
143prepare stmt from 'select * from t1 /* with \'quote\' */';
144execute stmt;
145a
1461
1472
1483
149show status like "Qcache_queries_in_cache";
150Variable_name Value
151Qcache_queries_in_cache 1
152show status like "Qcache_inserts";
153Variable_name Value
154Qcache_inserts 1
155show status like "Qcache_hits";
156Variable_name Value
157Qcache_hits 11
158prepare stmt from 'select * from t1 # 123
159';
160execute stmt;
161a
1621
1632
1643
165show status like "Qcache_queries_in_cache";
166Variable_name Value
167Qcache_queries_in_cache 1
168show status like "Qcache_inserts";
169Variable_name Value
170Qcache_inserts 1
171show status like "Qcache_hits";
172Variable_name Value
173Qcache_hits 12
174prepare stmt from 'select * from t1 # 123 with "quote"
175';
176execute stmt;
177a
1781
1792
1803
181show status like "Qcache_queries_in_cache";
182Variable_name Value
183Qcache_queries_in_cache 1
184show status like "Qcache_inserts";
185Variable_name Value
186Qcache_inserts 1
187show status like "Qcache_hits";
188Variable_name Value
189Qcache_hits 13
190prepare stmt from 'select * from t1 # 123 with \'quote\'
191';
192execute stmt;
193a
1941
1952
1963
197show status like "Qcache_queries_in_cache";
198Variable_name Value
199Qcache_queries_in_cache 1
200show status like "Qcache_inserts";
201Variable_name Value
202Qcache_inserts 1
203show status like "Qcache_hits";
204Variable_name Value
205Qcache_hits 14
206prepare stmt from 'select * from t1
207# 123
208';
209execute stmt;
210a
2111
2122
2133
214show status like "Qcache_queries_in_cache";
215Variable_name Value
216Qcache_queries_in_cache 1
217show status like "Qcache_inserts";
218Variable_name Value
219Qcache_inserts 1
220show status like "Qcache_hits";
221Variable_name Value
222Qcache_hits 15
223prepare stmt from '#456
224select * from t1
225# 123
226';
227execute stmt;
228a
2291
2302
2313
232show status like "Qcache_queries_in_cache";
233Variable_name Value
234Qcache_queries_in_cache 1
235show status like "Qcache_inserts";
236Variable_name Value
237Qcache_inserts 1
238show status like "Qcache_hits";
239Variable_name Value
240Qcache_hits 16
241prepare stmt from 'select * from t1 -- 123
242';
243execute stmt;
244a
2451
2462
2473
248show status like "Qcache_queries_in_cache";
249Variable_name Value
250Qcache_queries_in_cache 1
251show status like "Qcache_inserts";
252Variable_name Value
253Qcache_inserts 1
254show status like "Qcache_hits";
255Variable_name Value
256Qcache_hits 17
257prepare stmt from 'select * from t1
258-- 123
259';
260execute stmt;
261a
2621
2632
2643
265show status like "Qcache_queries_in_cache";
266Variable_name Value
267Qcache_queries_in_cache 1
268show status like "Qcache_inserts";
269Variable_name Value
270Qcache_inserts 1
271show status like "Qcache_hits";
272Variable_name Value
273Qcache_hits 18
274prepare stmt from '-- comment in first
275select * from t1
276# 123
277';
278execute stmt;
279a
2801
2812
2823
283show status like "Qcache_queries_in_cache";
284Variable_name Value
285Qcache_queries_in_cache 1
286show status like "Qcache_inserts";
287Variable_name Value
288Qcache_inserts 1
289show status like "Qcache_hits";
290Variable_name Value
291Qcache_hits 19
292prepare stmt from '(#456(
293select * from t1
294# 123(
295)';
296execute stmt;
297a
2981
2992
3003
301show status like "Qcache_queries_in_cache";
302Variable_name Value
303Qcache_queries_in_cache 2
304show status like "Qcache_inserts";
305Variable_name Value
306Qcache_inserts 2
307show status like "Qcache_hits";
308Variable_name Value
309Qcache_hits 19
310prepare stmt from '/*test*/(-- comment in first(
311select * from t1
312-- 123 asdasd
313/* test */)';
314execute stmt;
315a
3161
3172
3183
319show status like "Qcache_queries_in_cache";
320Variable_name Value
321Qcache_queries_in_cache 2
322show status like "Qcache_inserts";
323Variable_name Value
324Qcache_inserts 2
325show status like "Qcache_hits";
326Variable_name Value
327Qcache_hits 20
328prepare stmt from 'select "test",a from t1';
329execute stmt;
330test a
331test 1
332test 2
333test 3
334execute stmt;
335test a
336test 1
337test 2
338test 3
339show status like "Qcache_queries_in_cache";
340Variable_name Value
341Qcache_queries_in_cache 3
342show status like "Qcache_inserts";
343Variable_name Value
344Qcache_inserts 3
345show status like "Qcache_hits";
346Variable_name Value
347Qcache_hits 21
348prepare stmt from 'select "test /* internal \'comment\' */",a from t1';
349execute stmt;
350test /* internal 'comment' */ a
351test /* internal 'comment' */ 1
352test /* internal 'comment' */ 2
353test /* internal 'comment' */ 3
354show status like "Qcache_queries_in_cache";
355Variable_name Value
356Qcache_queries_in_cache 4
357show status like "Qcache_inserts";
358Variable_name Value
359Qcache_inserts 4
360show status like "Qcache_hits";
361Variable_name Value
362Qcache_hits 21
363prepare stmt from 'select "test #internal comment" ,a from t1';
364execute stmt;
365test #internal comment a
366test #internal comment 1
367test #internal comment 2
368test #internal comment 3
369show status like "Qcache_queries_in_cache";
370Variable_name Value
371Qcache_queries_in_cache 5
372show status like "Qcache_inserts";
373Variable_name Value
374Qcache_inserts 5
375show status like "Qcache_hits";
376Variable_name Value
377Qcache_hits 21
378prepare stmt from 'select "test #internal comment" #external comment
379,a from t1';
380execute stmt;
381test #internal comment a
382test #internal comment 1
383test #internal comment 2
384test #internal comment 3
385show status like "Qcache_queries_in_cache";
386Variable_name Value
387Qcache_queries_in_cache 5
388show status like "Qcache_inserts";
389Variable_name Value
390Qcache_inserts 5
391show status like "Qcache_hits";
392Variable_name Value
393Qcache_hits 22
394DROP TABLE t1;
395SET GLOBAL query_cache_size= default;
396set global query_cache_strip_comments=OFF;
3970
=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_prepared_statements.test'
--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_prepared_statements.test 2010-11-05 11:51:45 +0000
+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_prepared_statements.test 1970-01-01 00:00:00 +0000
@@ -1,208 +0,0 @@
1-- source include/have_query_cache.inc
2
3set GLOBAL query_cache_size=1355776;
4
5# Reset query cache variables.
6flush query cache; # This crashed in some versions
7flush query cache; # This crashed in some versions
8reset query cache;
9flush status;
10--disable_warnings
11drop table if exists t1;
12--enable_warnings
13
14#
15# First simple test
16#
17
18create table t1 (a int not null);
19insert into t1 values (1),(2),(3);
20
21set global query_cache_strip_comments=ON;
22
23show status like "Qcache_queries_in_cache";
24show status like "Qcache_inserts";
25show status like "Qcache_hits";
26
27prepare stmt from '/* with comment */ select * from t1';
28execute stmt;
29
30show status like "Qcache_queries_in_cache";
31show status like "Qcache_inserts";
32show status like "Qcache_hits";
33
34execute stmt;
35execute stmt;
36execute stmt;
37execute stmt;
38execute stmt;
39
40show status like "Qcache_queries_in_cache";
41show status like "Qcache_inserts";
42show status like "Qcache_hits";
43
44prepare stmt from 'select * from t1';
45execute stmt;
46
47show status like "Qcache_queries_in_cache";
48show status like "Qcache_inserts";
49show status like "Qcache_hits";
50
51prepare stmt from 'select * /*internal comment*/from t1';
52execute stmt;
53
54show status like "Qcache_queries_in_cache";
55show status like "Qcache_inserts";
56show status like "Qcache_hits";
57
58prepare stmt from 'select * /*internal comment*/ from t1';
59execute stmt;
60
61show status like "Qcache_queries_in_cache";
62show status like "Qcache_inserts";
63show status like "Qcache_hits";
64
65prepare stmt from 'select * from t1 /* at the end */';
66execute stmt;
67
68show status like "Qcache_queries_in_cache";
69show status like "Qcache_inserts";
70show status like "Qcache_hits";
71
72prepare stmt from 'select * from t1 /* with "quote" */';
73execute stmt;
74
75show status like "Qcache_queries_in_cache";
76show status like "Qcache_inserts";
77show status like "Qcache_hits";
78
79prepare stmt from 'select * from t1 /* with \'quote\' */';
80execute stmt;
81
82show status like "Qcache_queries_in_cache";
83show status like "Qcache_inserts";
84show status like "Qcache_hits";
85
86prepare stmt from 'select * from t1 # 123
87';
88execute stmt;
89
90show status like "Qcache_queries_in_cache";
91show status like "Qcache_inserts";
92show status like "Qcache_hits";
93
94prepare stmt from 'select * from t1 # 123 with "quote"
95';
96execute stmt;
97
98show status like "Qcache_queries_in_cache";
99show status like "Qcache_inserts";
100show status like "Qcache_hits";
101
102prepare stmt from 'select * from t1 # 123 with \'quote\'
103';
104execute stmt;
105
106show status like "Qcache_queries_in_cache";
107show status like "Qcache_inserts";
108show status like "Qcache_hits";
109
110prepare stmt from 'select * from t1
111# 123
112';
113execute stmt;
114
115show status like "Qcache_queries_in_cache";
116show status like "Qcache_inserts";
117show status like "Qcache_hits";
118
119prepare stmt from '#456
120select * from t1
121# 123
122';
123execute stmt;
124
125show status like "Qcache_queries_in_cache";
126show status like "Qcache_inserts";
127show status like "Qcache_hits";
128
129prepare stmt from 'select * from t1 -- 123
130';
131execute stmt;
132
133show status like "Qcache_queries_in_cache";
134show status like "Qcache_inserts";
135show status like "Qcache_hits";
136
137prepare stmt from 'select * from t1
138-- 123
139';
140execute stmt;
141
142show status like "Qcache_queries_in_cache";
143show status like "Qcache_inserts";
144show status like "Qcache_hits";
145
146prepare stmt from '-- comment in first
147select * from t1
148# 123
149';
150execute stmt;
151
152show status like "Qcache_queries_in_cache";
153show status like "Qcache_inserts";
154show status like "Qcache_hits";
155
156prepare stmt from '(#456(
157select * from t1
158# 123(
159)';
160execute stmt;
161
162show status like "Qcache_queries_in_cache";
163show status like "Qcache_inserts";
164show status like "Qcache_hits";
165
166prepare stmt from '/*test*/(-- comment in first(
167select * from t1
168-- 123 asdasd
169/* test */)';
170execute stmt;
171
172show status like "Qcache_queries_in_cache";
173show status like "Qcache_inserts";
174show status like "Qcache_hits";
175
176prepare stmt from 'select "test",a from t1';
177execute stmt;
178execute stmt;
179
180show status like "Qcache_queries_in_cache";
181show status like "Qcache_inserts";
182show status like "Qcache_hits";
183
184prepare stmt from 'select "test /* internal \'comment\' */",a from t1';
185execute stmt;
186
187show status like "Qcache_queries_in_cache";
188show status like "Qcache_inserts";
189show status like "Qcache_hits";
190
191prepare stmt from 'select "test #internal comment" ,a from t1';
192execute stmt;
193
194show status like "Qcache_queries_in_cache";
195show status like "Qcache_inserts";
196show status like "Qcache_hits";
197
198prepare stmt from 'select "test #internal comment" #external comment
199,a from t1';
200execute stmt;
201
202show status like "Qcache_queries_in_cache";
203show status like "Qcache_inserts";
204show status like "Qcache_hits";
205
206DROP TABLE t1;
207SET GLOBAL query_cache_size= default;
208set global query_cache_strip_comments=OFF;
2090
=== removed file 'mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_show.inc'
--- mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_show.inc 2010-11-05 11:51:45 +0000
+++ mysql-test/query_cache_enhance.patch/percona_query_cache_with_comments_show.inc 1970-01-01 00:00:00 +0000
@@ -1,8 +0,0 @@
1let $show=show status like "Qcache_queries_in_cache";
2eval $show;
3let $show=show status like "Qcache_inserts";
4eval $show;
5let $show=show status like "Qcache_hits";
6eval $show;
7
8
90
=== removed file 'mysql-test/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.result'
--- mysql-test/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.result 2010-11-05 11:51:45 +0000
+++ mysql-test/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.result 1970-01-01 00:00:00 +0000
@@ -1,27 +0,0 @@
1set GLOBAL query_cache_size=1355776;
2flush query cache;
3flush query cache;
4reset query cache;
5flush status;
6DROP TABLE IF EXISTS t;
7CREATE TABLE t(id INT, number INT);
8INSERT INTO t VALUES (0,1);
9INSERT INTO t VALUES (1,2);
10INSERT INTO t VALUES (2,3);
11SELECT number from t where id > 0;
12number
132
143
15SET SESSION debug="+d,status_wait_query_cache_mutex_sleep";
16SELECT number from t where id > 0;
17SET SESSION debug="+d,status_wait_query_cache_mutex_sleep";
18SELECT number from t where id > 0;
19SET SESSION debug="+d,status_wait_query_cache_mutex_sleep";
20SHOW PROCESSLIST;
21Id User Host db Command Time State Info
22Id root localhost test Sleep Time NULL
23Id root localhost test Query Time Waiting on query cache mutex SELECT number from t where id > 0
24Id root localhost test Query Time Waiting on query cache mutex SELECT number from t where id > 0
25Id root localhost test Query Time NULL SHOW PROCESSLIST
26DROP TABLE t;
27set GLOBAL query_cache_size=0;
280
=== removed file 'mysql-test/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.test'
--- mysql-test/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.test 2010-12-06 03:50:48 +0000
+++ mysql-test/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.test 1970-01-01 00:00:00 +0000
@@ -1,37 +0,0 @@
1--source include/have_query_cache.inc
2--source include/have_debug.inc
3set GLOBAL query_cache_size=1355776;
4--source include/percona_query_cache_with_comments_clear.inc
5
6-- disable_warnings
7DROP TABLE IF EXISTS t;
8-- enable_warnings
9CREATE TABLE t(id INT, number INT);
10INSERT INTO t VALUES (0,1);
11INSERT INTO t VALUES (1,2);
12INSERT INTO t VALUES (2,3);
13SELECT number from t where id > 0;
14--connect (conn0,localhost,root,,)
15--connect (conn1,localhost,root,,)
16--connect (conn2,localhost,root,,)
17
18--connection conn0
19--error 0, ER_UNKNOWN_SYSTEM_VARIABLE
20SET SESSION debug="+d,status_wait_query_cache_mutex_sleep";
21SEND SELECT number from t where id > 0;
22SLEEP 1.0;
23
24--connection conn1
25--error 0, ER_UNKNOWN_SYSTEM_VARIABLE
26SET SESSION debug="+d,status_wait_query_cache_mutex_sleep";
27SEND SELECT number from t where id > 0;
28SLEEP 1.0;
29
30--connection conn2
31--error 0, ER_UNKNOWN_SYSTEM_VARIABLE
32SET SESSION debug="+d,status_wait_query_cache_mutex_sleep";
33--replace_column 1 Id 6 Time
34SHOW PROCESSLIST;
35
36DROP TABLE t;
37set GLOBAL query_cache_size=0;
380
=== removed directory 'mysql-test/show_slave_status_nolock.patch'
=== removed file 'mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.result'
--- mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.result 2011-03-01 10:05:10 +0000
+++ mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.result 1970-01-01 00:00:00 +0000
@@ -1,21 +0,0 @@
1include/master-slave.inc
2[connection master]
3DROP TABLE IF EXISTS t;
4CREATE TABLE t(id INT);
5INSERT INTO t SELECT SLEEP(10);
6STOP SLAVE;
7Warnings:
8Note 1592 Statement may not be safe to log in statement format.
9master count(*)
10master 1
11slave count(*)
12slave 0
13SHOW SLAVE STATUS NOLOCK;
14include/wait_for_slave_to_stop.inc
15START SLAVE;
16include/wait_for_slave_to_start.inc
17slave count(*)
18slave 1
19DROP TABLE t;
20STOP SLAVE;
21include/wait_for_slave_to_stop.inc
220
=== removed file 'mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.test'
--- mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.test 2011-03-01 10:05:10 +0000
+++ mysql-test/show_slave_status_nolock.patch/percona_show_slave_status_nolock.test 1970-01-01 00:00:00 +0000
@@ -1,50 +0,0 @@
1--source include/master-slave.inc
2--source include/have_binlog_format_statement.inc
3
4connection master;
5 --disable_warnings
6 DROP TABLE IF EXISTS t;
7 --enable_warnings
8 CREATE TABLE t(id INT);
9 sync_slave_with_master;
10
11connection master;
12 send INSERT INTO t SELECT SLEEP(10);
13
14connection slave;
15 sleep 15;
16 send STOP SLAVE;
17
18connection master;
19 reap;
20
21 --disable_query_log
22 select "master",count(*) from t;
23 --enable_query_log
24
25connection slave1;
26 --disable_query_log
27 select "slave",count(*) from t;
28 --enable_query_log
29
30 --disable_result_log
31 SHOW SLAVE STATUS NOLOCK;
32 --enable_result_log
33
34connection slave;
35 reap;
36
37 --source include/wait_for_slave_to_stop.inc
38 START SLAVE;
39 --source include/wait_for_slave_to_start.inc
40
41 --disable_query_log
42 select "slave",count(*) from t;
43 --enable_query_log
44
45connection master;
46 DROP TABLE t;
47sync_slave_with_master;
48
49STOP SLAVE;
50--source include/wait_for_slave_to_stop.inc
510
=== removed directory 'mysql-test/sql_no_fcache.patch'
=== removed file 'mysql-test/sql_no_fcache.patch/percona_sql_no_fcache.result'
--- mysql-test/sql_no_fcache.patch/percona_sql_no_fcache.result 2010-11-05 11:57:13 +0000
+++ mysql-test/sql_no_fcache.patch/percona_sql_no_fcache.result 1970-01-01 00:00:00 +0000
@@ -1,12 +0,0 @@
1drop table if exists t1;
2create table t (a int not null);
3insert into t values (1),(2),(3);
4SELECT SQL_NO_FCACHE SLEEP(0);
5SLEEP(0)
60
7SELECT /*!40001 SQL_NO_CACHE */ /*!50084 SQL_NO_FCACHE */ * FROM t;
8a
91
102
113
12DROP TABLE t;
130
=== removed file 'mysql-test/sql_no_fcache.patch/percona_sql_no_fcache.test'
--- mysql-test/sql_no_fcache.patch/percona_sql_no_fcache.test 2010-12-06 03:50:48 +0000
+++ mysql-test/sql_no_fcache.patch/percona_sql_no_fcache.test 1970-01-01 00:00:00 +0000
@@ -1,11 +0,0 @@
1--disable_warnings
2drop table if exists t1;
3--enable_warnings
4
5create table t (a int not null);
6insert into t values (1),(2),(3);
7
8SELECT SQL_NO_FCACHE SLEEP(0);
9SELECT /*!40001 SQL_NO_CACHE */ /*!50084 SQL_NO_FCACHE */ * FROM t;
10
11DROP TABLE t;
120
=== removed file 'mysql-test/userstat_bug602047.result'
--- mysql-test/userstat_bug602047.result 2011-02-26 09:03:28 +0000
+++ mysql-test/userstat_bug602047.result 1970-01-01 00:00:00 +0000
@@ -1,16 +0,0 @@
1DROP TABLE IF EXISTS t1;
2SET @userstat_running_old= @@userstat_running;
3SET GLOBAL userstat_running=ON;
4CREATE TABLE t1 ( id int(10), PRIMARY KEY (id)) ENGINE=InnoDB;
5INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
6SELECT COUNT(*) FROM t1;
7COUNT(*)
810
9SELECT ROWS_READ FROM information_schema.table_statistics WHERE TABLE_NAME='t1';
10ROWS_READ
1110
12SELECT ROWS_READ FROM information_schema.index_statistics WHERE TABLE_NAME='t1';
13ROWS_READ
1410
15SET GLOBAL userstat_running= @userstat_running_old;
16DROP TABLE t1;
170
=== removed file 'mysql-test/userstat_bug602047.test'
--- mysql-test/userstat_bug602047.test 2011-02-26 09:03:28 +0000
+++ mysql-test/userstat_bug602047.test 1970-01-01 00:00:00 +0000
@@ -1,13 +0,0 @@
1--source include/have_innodb.inc
2--disable_warnings
3DROP TABLE IF EXISTS t1;
4--enable_warnings
5SET @userstat_running_old= @@userstat_running;
6SET GLOBAL userstat_running=ON;
7CREATE TABLE t1 ( id int(10), PRIMARY KEY (id)) ENGINE=InnoDB;
8INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
9SELECT COUNT(*) FROM t1;
10SELECT ROWS_READ FROM information_schema.table_statistics WHERE TABLE_NAME='t1';
11SELECT ROWS_READ FROM information_schema.index_statistics WHERE TABLE_NAME='t1';
12SET GLOBAL userstat_running= @userstat_running_old;
13DROP TABLE t1;
140
=== modified file 'patches/innodb_admin_command_base.patch'
--- patches/innodb_admin_command_base.patch 2011-08-09 13:35:34 +0000
+++ patches/innodb_admin_command_base.patch 2011-09-06 08:39:24 +0000
@@ -175,3 +175,18 @@
175+{"innodb_admin_command_base","XtraDB specific command interface through i_s","","http://www.percona.com/docs/wiki/percona-xtradb"},175+{"innodb_admin_command_base","XtraDB specific command interface through i_s","","http://www.percona.com/docs/wiki/percona-xtradb"},
176 {NULL, NULL, NULL, NULL}176 {NULL, NULL, NULL, NULL}
177 };177 };
178--- /dev/null
179+++ b/mysql-test/r/percona_xtradb_admin_command.result
180@@ -0,0 +1,6 @@
181+select * from information_schema.XTRADB_ADMIN_COMMAND;
182+result_message
183+No XTRA_* command in the SQL statement. Please add /*!XTRA_xxxx*/ to the SQL.
184+select * from information_schema.XTRADB_ADMIN_COMMAND /*!XTRA_HELLO*/;
185+result_message
186+Hello!
187--- /dev/null
188+++ b/mysql-test/t/percona_xtradb_admin_command.test
189@@ -0,0 +1,3 @@
190+--source include/have_innodb.inc
191+select * from information_schema.XTRADB_ADMIN_COMMAND;
192+select * from information_schema.XTRADB_ADMIN_COMMAND /*!XTRA_HELLO*/;
178193
=== modified file 'patches/innodb_buffer_pool_shm.patch'
--- patches/innodb_buffer_pool_shm.patch 2011-07-30 22:04:31 +0000
+++ patches/innodb_buffer_pool_shm.patch 2011-09-06 08:39:24 +0000
@@ -81,3 +81,21 @@
81 MYSQL_SYSVAR(checksums),81 MYSQL_SYSVAR(checksums),
82 MYSQL_SYSVAR(fast_checksum),82 MYSQL_SYSVAR(fast_checksum),
83 MYSQL_SYSVAR(commit_concurrency),83 MYSQL_SYSVAR(commit_concurrency),
84--- /dev/null
85+++ b/mysql-test/r/percona_innodb_buffer_pool_shm.result
86@@ -0,0 +1,4 @@
87+show variables like 'innodb_buffer_pool_shm%';
88+Variable_name Value
89+innodb_buffer_pool_shm_checksum ON
90+innodb_buffer_pool_shm_key 123456
91--- /dev/null
92+++ b/mysql-test/t/percona_innodb_buffer_pool_shm-master.opt
93@@ -0,0 +1,2 @@
94+--innodb_buffer_pool_shm_key=123456
95+--innodb=FORCE
96--- /dev/null
97+++ b/mysql-test/t/percona_innodb_buffer_pool_shm.test
98@@ -0,0 +1,3 @@
99+--source include/have_innodb.inc
100+show variables like 'innodb_buffer_pool_shm%';
101+
84102
=== modified file 'patches/innodb_deadlock_count.patch'
--- patches/innodb_deadlock_count.patch 2011-08-09 13:35:34 +0000
+++ patches/innodb_deadlock_count.patch 2011-09-06 08:39:24 +0000
@@ -66,3 +66,98 @@
66 #ifdef UNIV_DEBUG66 #ifdef UNIV_DEBUG
67 export_vars.innodb_buffer_pool_pages_latched67 export_vars.innodb_buffer_pool_pages_latched
68 = buf_get_latched_pages_number();68 = buf_get_latched_pages_number();
69--- /dev/null
70+++ b/mysql-test/r/percona_innodb_deadlock_count.result
71@@ -0,0 +1,28 @@
72+# Establish connection con1 (user=root)
73+# Establish connection con2 (user=root)
74+# Establish connection con3 (user=root)
75+# Drop test table
76+drop table if exists t;
77+# Create test table
78+create table t(a INT PRIMARY KEY, b INT) engine=InnoDB;
79+# Insert two rows to test table
80+insert into t values(2,1);
81+insert into t values(1,2);
82+# Switch to connection con1
83+BEGIN;
84+SELECT b FROM t WHERE a=1 FOR UPDATE;
85+# Switch to connection con2
86+BEGIN;
87+SELECT b FROM t WHERE a=2 FOR UPDATE;
88+# Switch to connection con1
89+SELECT b FROM t WHERE a=2 FOR UPDATE;
90+# Switch to connection con2
91+SELECT b FROM t WHERE a=1 FOR UPDATE;
92+# Switch to connection con1
93+ROLLBACK;
94+# Switch to connection con2
95+ROLLBACK;
96+# Switch to connection con3
97+Deadlocks: 1
98+# Drop test table
99+drop table t;
100--- /dev/null
101+++ b/mysql-test/t/percona_innodb_deadlock_count.test
102@@ -0,0 +1,61 @@
103+--source include/have_innodb.inc
104+--echo # Establish connection con1 (user=root)
105+connect (con1,localhost,root,,);
106+--echo # Establish connection con2 (user=root)
107+connect (con2,localhost,root,,);
108+--echo # Establish connection con3 (user=root)
109+connect (con3,localhost,root,,);
110+--echo # Drop test table
111+--disable_warnings
112+drop table if exists t;
113+--enable_warnings
114+
115+--echo # Create test table
116+create table t(a INT PRIMARY KEY, b INT) engine=InnoDB;
117+--echo # Insert two rows to test table
118+insert into t values(2,1);
119+insert into t values(1,2);
120+
121+#--echo # Save current deadlock count
122+let $current = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Innodb_deadlocks'`;
123+
124+--disable_result_log
125+
126+--echo # Switch to connection con1
127+connection con1;
128+BEGIN; SELECT b FROM t WHERE a=1 FOR UPDATE;
129+
130+--echo # Switch to connection con2
131+connection con2;
132+BEGIN; SELECT b FROM t WHERE a=2 FOR UPDATE;
133+
134+--echo # Switch to connection con1
135+connection con1;
136+SEND SELECT b FROM t WHERE a=2 FOR UPDATE;
137+
138+--echo # Switch to connection con2
139+connection con2;
140+SEND SELECT b FROM t WHERE a=1 FOR UPDATE;
141+
142+--echo # Switch to connection con1
143+connection con1;
144+--error 0, ER_LOCK_DEADLOCK
145+reap;
146+ROLLBACK;
147+
148+--echo # Switch to connection con2
149+connection con2;
150+--error 0, ER_LOCK_DEADLOCK
151+reap;
152+ROLLBACK;
153+
154+--echo # Switch to connection con3
155+connection con3;
156+let $result = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Innodb_deadlocks'`;
157+
158+--enable_result_log
159+
160+let $diff = `SELECT $result - $current`;
161+echo Deadlocks: $diff;
162+--echo # Drop test table
163+drop table t;
69164
=== modified file 'patches/innodb_fix_misc.patch'
--- patches/innodb_fix_misc.patch 2011-08-09 13:35:34 +0000
+++ patches/innodb_fix_misc.patch 2011-09-06 08:39:24 +0000
@@ -1359,3 +1359,35 @@
1359 float ratio = (float) trx_sys->rseg_history_len1359 float ratio = (float) trx_sys->rseg_history_len
1360 / srv_max_purge_lag;1360 / srv_max_purge_lag;
1361 if (ratio > ULINT_MAX / 10000) {1361 if (ratio > ULINT_MAX / 10000) {
1362--- /dev/null
1363+++ b/mysql-test/r/innodb_fix_misc_bug51325.result
1364@@ -0,0 +1,13 @@
1365+DROP TABLE IF EXISTS t1;
1366+SET GLOBAL innodb_file_per_table=ON;
1367+SHOW VARIABLES LIKE 'innodb_lazy_drop_table';
1368+Variable_name Value
1369+innodb_lazy_drop_table 0
1370+SET GLOBAL innodb_lazy_drop_table=1;
1371+SHOW VARIABLES LIKE 'innodb_lazy_drop_table';
1372+Variable_name Value
1373+innodb_lazy_drop_table 1
1374+CREATE TABLE t1 (a INT) ENGINE=InnoDB;
1375+DROP TABLE t1;
1376+SET GLOBAL innodb_lazy_drop_table=default;
1377+SET GLOBAL innodb_file_per_table=default;
1378--- /dev/null
1379+++ b/mysql-test/t/innodb_fix_misc_bug51325.test
1380@@ -0,0 +1,13 @@
1381+# Test for 'innodb_lazy_drop_table' variable
1382+--source include/have_innodb.inc
1383+--disable_warnings
1384+DROP TABLE IF EXISTS t1;
1385+--enable_warnings
1386+SET GLOBAL innodb_file_per_table=ON;
1387+SHOW VARIABLES LIKE 'innodb_lazy_drop_table';
1388+SET GLOBAL innodb_lazy_drop_table=1;
1389+SHOW VARIABLES LIKE 'innodb_lazy_drop_table';
1390+CREATE TABLE t1 (a INT) ENGINE=InnoDB;
1391+DROP TABLE t1;
1392+SET GLOBAL innodb_lazy_drop_table=default;
1393+SET GLOBAL innodb_file_per_table=default;
13621394
=== modified file 'patches/innodb_separate_doublewrite.patch'
--- patches/innodb_separate_doublewrite.patch 2011-08-09 13:35:34 +0000
+++ patches/innodb_separate_doublewrite.patch 2011-09-06 08:39:24 +0000
@@ -1078,3 +1078,19 @@
1078 /*********************************************************************1078 /*********************************************************************
1079 Create extra rollback segments when create_new_db */1079 Create extra rollback segments when create_new_db */
1080 UNIV_INTERN1080 UNIV_INTERN
1081--- /dev/null
1082+++ b/mysql-test/r/percona_innodb_doublewrite_file.result
1083@@ -0,0 +1,4 @@
1084+show variables like 'innodb_doublewrite%';
1085+Variable_name Value
1086+innodb_doublewrite ON
1087+innodb_doublewrite_file ib_doublewrite
1088--- /dev/null
1089+++ b/mysql-test/t/percona_innodb_doublewrite_file-master.opt
1090@@ -0,0 +1 @@
1091+--innodb_doublewrite_file=ib_doublewrite
1092--- /dev/null
1093+++ b/mysql-test/t/percona_innodb_doublewrite_file.test
1094@@ -0,0 +1,2 @@
1095+--source include/have_innodb.inc
1096+show variables like 'innodb_doublewrite%';
10811097
=== modified file 'patches/innodb_show_sys_tables.patch'
--- patches/innodb_show_sys_tables.patch 2011-08-09 13:35:34 +0000
+++ patches/innodb_show_sys_tables.patch 2011-09-06 08:39:24 +0000
@@ -719,3 +719,18 @@
719+{"innodb_sys_tables_sys_indexes","Expose InnoDB SYS_TABLES and SYS_INDEXES schema tables","","http://www.percona.com/docs/wiki/percona-xtradb"},719+{"innodb_sys_tables_sys_indexes","Expose InnoDB SYS_TABLES and SYS_INDEXES schema tables","","http://www.percona.com/docs/wiki/percona-xtradb"},
720 {NULL, NULL, NULL, NULL}720 {NULL, NULL, NULL, NULL}
721 };721 };
722--- /dev/null
723+++ b/mysql-test/r/percona_innodb_use_sys_stats_table.result
724@@ -0,0 +1,3 @@
725+show variables like 'innodb_use_sys_stats%';
726+Variable_name Value
727+innodb_use_sys_stats_table ON
728--- /dev/null
729+++ b/mysql-test/t/percona_innodb_use_sys_stats_table-master.opt
730@@ -0,0 +1 @@
731+--innodb_use_sys_stats_table
732--- /dev/null
733+++ b/mysql-test/t/percona_innodb_use_sys_stats_table.test
734@@ -0,0 +1,2 @@
735+--source include/have_innodb.inc
736+show variables like 'innodb_use_sys_stats%';
722737
=== modified file 'patches/mysql-test.diff'
--- patches/mysql-test.diff 2011-08-13 01:47:38 +0000
+++ patches/mysql-test.diff 2011-09-06 08:39:24 +0000
@@ -3989,4 +3989,728 @@
3989 3989
3990 connection slave;3990 connection slave;
3991 drop table first_db.t1;3991 drop table first_db.t1;
39923992--- /dev/null
3993+++ b/mysql-test/include/have_nodebug.inc
3994@@ -0,0 +1,4 @@
3995+-- require r/have_nodebug.require
3996+disable_query_log;
3997+select (version() like '%debug%') as debug;
3998+enable_query_log;
3999--- /dev/null
4000+++ b/mysql-test/include/percona_server_variables.inc
4001@@ -0,0 +1,3 @@
4002+--source include/have_response_time_distribution.inc
4003+--source include/have_innodb.inc
4004+SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
4005--- /dev/null
4006+++ b/mysql-test/r/have_nodebug.require
4007@@ -0,0 +1,2 @@
4008+debug
4009+0
4010--- /dev/null
4011+++ b/mysql-test/r/percona_server_variables_debug.result
4012@@ -0,0 +1,347 @@
4013+SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
4014+Variable_name
4015+AUTOCOMMIT
4016+AUTOMATIC_SP_PRIVILEGES
4017+AUTO_INCREMENT_INCREMENT
4018+AUTO_INCREMENT_OFFSET
4019+BACK_LOG
4020+BASEDIR
4021+BIG_TABLES
4022+BINLOG_CACHE_SIZE
4023+BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES
4024+BINLOG_FORMAT
4025+BULK_INSERT_BUFFER_SIZE
4026+CHARACTER_SETS_DIR
4027+CHARACTER_SET_CLIENT
4028+CHARACTER_SET_CONNECTION
4029+CHARACTER_SET_DATABASE
4030+CHARACTER_SET_FILESYSTEM
4031+CHARACTER_SET_RESULTS
4032+CHARACTER_SET_SERVER
4033+CHARACTER_SET_SYSTEM
4034+COLLATION_CONNECTION
4035+COLLATION_DATABASE
4036+COLLATION_SERVER
4037+COMPLETION_TYPE
4038+CONCURRENT_INSERT
4039+CONNECT_TIMEOUT
4040+DATADIR
4041+DATETIME_FORMAT
4042+DATE_FORMAT
4043+DEBUG
4044+DEBUG_SYNC
4045+DEFAULT_WEEK_FORMAT
4046+DELAYED_INSERT_LIMIT
4047+DELAYED_INSERT_TIMEOUT
4048+DELAYED_QUEUE_SIZE
4049+DELAY_KEY_WRITE
4050+DIV_PRECISION_INCREMENT
4051+ENABLE_QUERY_RESPONSE_TIME_STATS
4052+ENGINE_CONDITION_PUSHDOWN
4053+ERROR_COUNT
4054+EVENT_SCHEDULER
4055+EXPIRE_LOGS_DAYS
4056+FAST_INDEX_CREATION
4057+FLUSH
4058+FLUSH_TIME
4059+FOREIGN_KEY_CHECKS
4060+FT_BOOLEAN_SYNTAX
4061+FT_MAX_WORD_LEN
4062+FT_MIN_WORD_LEN
4063+FT_QUERY_EXPANSION_LIMIT
4064+FT_STOPWORD_FILE
4065+GENERAL_LOG
4066+GENERAL_LOG_FILE
4067+GROUP_CONCAT_MAX_LEN
4068+HAVE_COMMUNITY_FEATURES
4069+HAVE_COMPRESS
4070+HAVE_CRYPT
4071+HAVE_CSV
4072+HAVE_DYNAMIC_LOADING
4073+HAVE_GEOMETRY
4074+HAVE_INNODB
4075+HAVE_NDBCLUSTER
4076+HAVE_OPENSSL
4077+HAVE_PARTITIONING
4078+HAVE_QUERY_CACHE
4079+HAVE_RESPONSE_TIME_DISTRIBUTION
4080+HAVE_RTREE_KEYS
4081+HAVE_SSL
4082+HAVE_SYMLINK
4083+HOSTNAME
4084+IDENTITY
4085+IGNORE_BUILTIN_INNODB
4086+INIT_CONNECT
4087+INIT_FILE
4088+INIT_SLAVE
4089+INNODB_ADAPTIVE_CHECKPOINT
4090+INNODB_ADAPTIVE_FLUSHING
4091+INNODB_ADAPTIVE_HASH_INDEX
4092+INNODB_ADDITIONAL_MEM_POOL_SIZE
4093+INNODB_AUTOEXTEND_INCREMENT
4094+INNODB_AUTOINC_LOCK_MODE
4095+INNODB_AUTO_LRU_DUMP
4096+INNODB_BUFFER_POOL_SHM_CHECKSUM
4097+INNODB_BUFFER_POOL_SHM_KEY
4098+INNODB_BUFFER_POOL_SIZE
4099+INNODB_CHANGE_BUFFERING
4100+INNODB_CHECKPOINT_AGE_TARGET
4101+INNODB_CHECKSUMS
4102+INNODB_COMMIT_CONCURRENCY
4103+INNODB_CONCURRENCY_TICKETS
4104+INNODB_DATA_FILE_PATH
4105+INNODB_DATA_HOME_DIR
4106+INNODB_DICT_SIZE_LIMIT
4107+INNODB_DOUBLEWRITE
4108+INNODB_DOUBLEWRITE_FILE
4109+INNODB_ENABLE_UNSAFE_GROUP_COMMIT
4110+INNODB_EXPAND_IMPORT
4111+INNODB_EXTRA_RSEGMENTS
4112+INNODB_EXTRA_UNDOSLOTS
4113+INNODB_FAST_CHECKSUM
4114+INNODB_FAST_RECOVERY
4115+INNODB_FAST_SHUTDOWN
4116+INNODB_FILE_FORMAT
4117+INNODB_FILE_FORMAT_CHECK
4118+INNODB_FILE_PER_TABLE
4119+INNODB_FLUSH_LOG_AT_TRX_COMMIT
4120+INNODB_FLUSH_LOG_AT_TRX_COMMIT_SESSION
4121+INNODB_FLUSH_METHOD
4122+INNODB_FLUSH_NEIGHBOR_PAGES
4123+INNODB_FORCE_RECOVERY
4124+INNODB_IBUF_ACCEL_RATE
4125+INNODB_IBUF_ACTIVE_CONTRACT
4126+INNODB_IBUF_MAX_SIZE
4127+INNODB_IO_CAPACITY
4128+INNODB_LAZY_DROP_TABLE
4129+INNODB_LOCKS_UNSAFE_FOR_BINLOG
4130+INNODB_LOCK_WAIT_TIMEOUT
4131+INNODB_LOG_BLOCK_SIZE
4132+INNODB_LOG_BUFFER_SIZE
4133+INNODB_LOG_FILES_IN_GROUP
4134+INNODB_LOG_FILE_SIZE
4135+INNODB_LOG_GROUP_HOME_DIR
4136+INNODB_MAX_DIRTY_PAGES_PCT
4137+INNODB_MAX_PURGE_LAG
4138+INNODB_MIRRORED_LOG_GROUPS
4139+INNODB_OLD_BLOCKS_PCT
4140+INNODB_OLD_BLOCKS_TIME
4141+INNODB_OPEN_FILES
4142+INNODB_OVERWRITE_RELAY_LOG_INFO
4143+INNODB_PAGE_SIZE
4144+INNODB_PASS_CORRUPT_TABLE
4145+INNODB_READ_AHEAD
4146+INNODB_READ_AHEAD_THRESHOLD
4147+INNODB_READ_IO_THREADS
4148+INNODB_RECOVERY_STATS
4149+INNODB_REPLICATION_DELAY
4150+INNODB_ROLLBACK_ON_TIMEOUT
4151+INNODB_SHOW_LOCKS_HELD
4152+INNODB_SHOW_VERBOSE_LOCKS
4153+INNODB_SPIN_WAIT_DELAY
4154+INNODB_STATS_AUTO_UPDATE
4155+INNODB_STATS_METHOD
4156+INNODB_STATS_ON_METADATA
4157+INNODB_STATS_SAMPLE_PAGES
4158+INNODB_STATS_UPDATE_NEED_LOCK
4159+INNODB_STRICT_MODE
4160+INNODB_SUPPORT_XA
4161+INNODB_SYNC_SPIN_LOOPS
4162+INNODB_TABLE_LOCKS
4163+INNODB_THREAD_CONCURRENCY
4164+INNODB_THREAD_CONCURRENCY_TIMER_BASED
4165+INNODB_THREAD_SLEEP_DELAY
4166+INNODB_USE_PURGE_THREAD
4167+INNODB_USE_SYS_MALLOC
4168+INNODB_USE_SYS_STATS_TABLE
4169+INNODB_VERSION
4170+INNODB_WRITE_IO_THREADS
4171+INSERT_ID
4172+INTERACTIVE_TIMEOUT
4173+JOIN_BUFFER_SIZE
4174+KEEP_FILES_ON_CREATE
4175+KEY_BUFFER_SIZE
4176+KEY_CACHE_AGE_THRESHOLD
4177+KEY_CACHE_BLOCK_SIZE
4178+KEY_CACHE_DIVISION_LIMIT
4179+LANGUAGE
4180+LARGE_FILES_SUPPORT
4181+LARGE_PAGES
4182+LARGE_PAGE_SIZE
4183+LAST_INSERT_ID
4184+LC_TIME_NAMES
4185+LICENSE
4186+LOCAL_INFILE
4187+LOCKED_IN_MEMORY
4188+LOG
4189+LOG_BIN
4190+LOG_BIN_TRUST_FUNCTION_CREATORS
4191+LOG_BIN_TRUST_ROUTINE_CREATORS
4192+LOG_ERROR
4193+LOG_OUTPUT
4194+LOG_QUERIES_NOT_USING_INDEXES
4195+LOG_SLAVE_UPDATES
4196+LOG_SLOW_FILTER
4197+LOG_SLOW_QUERIES
4198+LOG_SLOW_RATE_LIMIT
4199+LOG_SLOW_SLAVE_STATEMENTS
4200+LOG_SLOW_SP_STATEMENTS
4201+LOG_SLOW_TIMESTAMP_EVERY
4202+LOG_SLOW_VERBOSITY
4203+LOG_WARNINGS
4204+LONG_QUERY_TIME
4205+LOWER_CASE_FILE_SYSTEM
4206+LOWER_CASE_TABLE_NAMES
4207+LOW_PRIORITY_UPDATES
4208+MAX_ALLOWED_PACKET
4209+MAX_BINLOG_CACHE_SIZE
4210+MAX_BINLOG_SIZE
4211+MAX_CONNECTIONS
4212+MAX_CONNECT_ERRORS
4213+MAX_DELAYED_THREADS
4214+MAX_ERROR_COUNT
4215+MAX_HEAP_TABLE_SIZE
4216+MAX_INSERT_DELAYED_THREADS
4217+MAX_JOIN_SIZE
4218+MAX_LENGTH_FOR_SORT_DATA
4219+MAX_LONG_DATA_SIZE
4220+MAX_PREPARED_STMT_COUNT
4221+MAX_RELAY_LOG_SIZE
4222+MAX_SEEKS_FOR_KEY
4223+MAX_SORT_LENGTH
4224+MAX_SP_RECURSION_DEPTH
4225+MAX_TMP_TABLES
4226+MAX_USER_CONNECTIONS
4227+MAX_WRITE_LOCK_COUNT
4228+MIN_EXAMINED_ROW_LIMIT
4229+MULTI_RANGE_COUNT
4230+MYISAM_DATA_POINTER_SIZE
4231+MYISAM_MAX_SORT_FILE_SIZE
4232+MYISAM_MMAP_SIZE
4233+MYISAM_RECOVER_OPTIONS
4234+MYISAM_REPAIR_THREADS
4235+MYISAM_SORT_BUFFER_SIZE
4236+MYISAM_STATS_METHOD
4237+MYISAM_USE_MMAP
4238+NET_BUFFER_LENGTH
4239+NET_READ_TIMEOUT
4240+NET_RETRY_COUNT
4241+NET_WRITE_TIMEOUT
4242+NEW
4243+OLD
4244+OLD_ALTER_TABLE
4245+OLD_PASSWORDS
4246+OPEN_FILES_LIMIT
4247+OPTIMIZER_FIX
4248+OPTIMIZER_PRUNE_LEVEL
4249+OPTIMIZER_SEARCH_DEPTH
4250+OPTIMIZER_SWITCH
4251+PID_FILE
4252+PLUGIN_DIR
4253+PORT
4254+PRELOAD_BUFFER_SIZE
4255+PROFILING
4256+PROFILING_HISTORY_SIZE
4257+PROFILING_SERVER
4258+PROFILING_USE_GETRUSAGE
4259+PROTOCOL_VERSION
4260+PSEUDO_THREAD_ID
4261+QUERY_ALLOC_BLOCK_SIZE
4262+QUERY_CACHE_LIMIT
4263+QUERY_CACHE_MIN_RES_UNIT
4264+QUERY_CACHE_SIZE
4265+QUERY_CACHE_STRIP_COMMENTS
4266+QUERY_CACHE_TYPE
4267+QUERY_CACHE_WLOCK_INVALIDATE
4268+QUERY_EXEC_TIME
4269+QUERY_PREALLOC_SIZE
4270+QUERY_RESPONSE_TIME_RANGE_BASE
4271+RAND_SEED1
4272+RAND_SEED2
4273+RANGE_ALLOC_BLOCK_SIZE
4274+READ_BUFFER_SIZE
4275+READ_ONLY
4276+READ_RND_BUFFER_SIZE
4277+RELAY_LOG
4278+RELAY_LOG_INDEX
4279+RELAY_LOG_INFO_FILE
4280+RELAY_LOG_PURGE
4281+RELAY_LOG_SPACE_LIMIT
4282+REPORT_HOST
4283+REPORT_PASSWORD
4284+REPORT_PORT
4285+REPORT_USER
4286+RPL_RECOVERY_RANK
4287+SECURE_AUTH
4288+SECURE_FILE_PRIV
4289+SERVER_ID
4290+SKIP_EXTERNAL_LOCKING
4291+SKIP_NAME_RESOLVE
4292+SKIP_NETWORKING
4293+SKIP_SHOW_DATABASE
4294+SLAVE_COMPRESSED_PROTOCOL
4295+SLAVE_EXEC_MODE
4296+SLAVE_LOAD_TMPDIR
4297+SLAVE_NET_TIMEOUT
4298+SLAVE_SKIP_ERRORS
4299+SLAVE_TRANSACTION_RETRIES
4300+SLOW_LAUNCH_TIME
4301+SLOW_QUERY_LOG
4302+SLOW_QUERY_LOG_FILE
4303+SLOW_QUERY_LOG_MICROSECONDS_TIMESTAMP
4304+SOCKET
4305+SORT_BUFFER_SIZE
4306+SQL_AUTO_IS_NULL
4307+SQL_BIG_SELECTS
4308+SQL_BIG_TABLES
4309+SQL_BUFFER_RESULT
4310+SQL_LOG_BIN
4311+SQL_LOG_OFF
4312+SQL_LOG_UPDATE
4313+SQL_LOW_PRIORITY_UPDATES
4314+SQL_MAX_JOIN_SIZE
4315+SQL_MODE
4316+SQL_NOTES
4317+SQL_QUOTE_SHOW_CREATE
4318+SQL_SAFE_UPDATES
4319+SQL_SELECT_LIMIT
4320+SQL_SLAVE_SKIP_COUNTER
4321+SQL_WARNINGS
4322+SSL_CA
4323+SSL_CAPATH
4324+SSL_CERT
4325+SSL_CIPHER
4326+SSL_KEY
4327+STORAGE_ENGINE
4328+SUPPRESS_LOG_WARNING_1592
4329+SYNC_BINLOG
4330+SYNC_FRM
4331+SYSTEM_TIME_ZONE
4332+TABLE_DEFINITION_CACHE
4333+TABLE_LOCK_WAIT_TIMEOUT
4334+TABLE_OPEN_CACHE
4335+TABLE_TYPE
4336+THREAD_CACHE_SIZE
4337+THREAD_HANDLING
4338+THREAD_STACK
4339+THREAD_STATISTICS
4340+TIMED_MUTEXES
4341+TIMESTAMP
4342+TIME_FORMAT
4343+TIME_ZONE
4344+TMPDIR
4345+TMP_TABLE_SIZE
4346+TRANSACTION_ALLOC_BLOCK_SIZE
4347+TRANSACTION_PREALLOC_SIZE
4348+TX_ISOLATION
4349+UNIQUE_CHECKS
4350+UPDATABLE_VIEWS_WITH_LIMIT
4351+USERSTAT_RUNNING
4352+USE_GLOBAL_LOG_SLOW_CONTROL
4353+USE_GLOBAL_LONG_QUERY_TIME
4354+VERSION
4355+VERSION_COMMENT
4356+VERSION_COMPILE_MACHINE
4357+VERSION_COMPILE_OS
4358+WAIT_TIMEOUT
4359+WARNING_COUNT
4360--- /dev/null
4361+++ b/mysql-test/r/percona_server_variables_release.result
4362@@ -0,0 +1,344 @@
4363+SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
4364+Variable_name
4365+AUTOCOMMIT
4366+AUTOMATIC_SP_PRIVILEGES
4367+AUTO_INCREMENT_INCREMENT
4368+AUTO_INCREMENT_OFFSET
4369+BACK_LOG
4370+BASEDIR
4371+BIG_TABLES
4372+BINLOG_CACHE_SIZE
4373+BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES
4374+BINLOG_FORMAT
4375+BULK_INSERT_BUFFER_SIZE
4376+CHARACTER_SETS_DIR
4377+CHARACTER_SET_CLIENT
4378+CHARACTER_SET_CONNECTION
4379+CHARACTER_SET_DATABASE
4380+CHARACTER_SET_FILESYSTEM
4381+CHARACTER_SET_RESULTS
4382+CHARACTER_SET_SERVER
4383+CHARACTER_SET_SYSTEM
4384+COLLATION_CONNECTION
4385+COLLATION_DATABASE
4386+COLLATION_SERVER
4387+COMPLETION_TYPE
4388+CONCURRENT_INSERT
4389+CONNECT_TIMEOUT
4390+DATADIR
4391+DATETIME_FORMAT
4392+DATE_FORMAT
4393+DEFAULT_WEEK_FORMAT
4394+DELAYED_INSERT_LIMIT
4395+DELAYED_INSERT_TIMEOUT
4396+DELAYED_QUEUE_SIZE
4397+DELAY_KEY_WRITE
4398+DIV_PRECISION_INCREMENT
4399+ENABLE_QUERY_RESPONSE_TIME_STATS
4400+ENGINE_CONDITION_PUSHDOWN
4401+ERROR_COUNT
4402+EVENT_SCHEDULER
4403+EXPIRE_LOGS_DAYS
4404+FAST_INDEX_CREATION
4405+FLUSH
4406+FLUSH_TIME
4407+FOREIGN_KEY_CHECKS
4408+FT_BOOLEAN_SYNTAX
4409+FT_MAX_WORD_LEN
4410+FT_MIN_WORD_LEN
4411+FT_QUERY_EXPANSION_LIMIT
4412+FT_STOPWORD_FILE
4413+GENERAL_LOG
4414+GENERAL_LOG_FILE
4415+GROUP_CONCAT_MAX_LEN
4416+HAVE_COMMUNITY_FEATURES
4417+HAVE_COMPRESS
4418+HAVE_CRYPT
4419+HAVE_CSV
4420+HAVE_DYNAMIC_LOADING
4421+HAVE_GEOMETRY
4422+HAVE_INNODB
4423+HAVE_NDBCLUSTER
4424+HAVE_OPENSSL
4425+HAVE_PARTITIONING
4426+HAVE_QUERY_CACHE
4427+HAVE_RESPONSE_TIME_DISTRIBUTION
4428+HAVE_RTREE_KEYS
4429+HAVE_SSL
4430+HAVE_SYMLINK
4431+HOSTNAME
4432+IDENTITY
4433+IGNORE_BUILTIN_INNODB
4434+INIT_CONNECT
4435+INIT_FILE
4436+INIT_SLAVE
4437+INNODB_ADAPTIVE_CHECKPOINT
4438+INNODB_ADAPTIVE_FLUSHING
4439+INNODB_ADAPTIVE_HASH_INDEX
4440+INNODB_ADDITIONAL_MEM_POOL_SIZE
4441+INNODB_AUTOEXTEND_INCREMENT
4442+INNODB_AUTOINC_LOCK_MODE
4443+INNODB_AUTO_LRU_DUMP
4444+INNODB_BUFFER_POOL_SHM_CHECKSUM
4445+INNODB_BUFFER_POOL_SHM_KEY
4446+INNODB_BUFFER_POOL_SIZE
4447+INNODB_CHANGE_BUFFERING
4448+INNODB_CHECKPOINT_AGE_TARGET
4449+INNODB_CHECKSUMS
4450+INNODB_COMMIT_CONCURRENCY
4451+INNODB_CONCURRENCY_TICKETS
4452+INNODB_DATA_FILE_PATH
4453+INNODB_DATA_HOME_DIR
4454+INNODB_DICT_SIZE_LIMIT
4455+INNODB_DOUBLEWRITE
4456+INNODB_DOUBLEWRITE_FILE
4457+INNODB_ENABLE_UNSAFE_GROUP_COMMIT
4458+INNODB_EXPAND_IMPORT
4459+INNODB_EXTRA_RSEGMENTS
4460+INNODB_EXTRA_UNDOSLOTS
4461+INNODB_FAST_CHECKSUM
4462+INNODB_FAST_RECOVERY
4463+INNODB_FAST_SHUTDOWN
4464+INNODB_FILE_FORMAT
4465+INNODB_FILE_FORMAT_CHECK
4466+INNODB_FILE_PER_TABLE
4467+INNODB_FLUSH_LOG_AT_TRX_COMMIT
4468+INNODB_FLUSH_LOG_AT_TRX_COMMIT_SESSION
4469+INNODB_FLUSH_METHOD
4470+INNODB_FLUSH_NEIGHBOR_PAGES
4471+INNODB_FORCE_RECOVERY
4472+INNODB_IBUF_ACCEL_RATE
4473+INNODB_IBUF_ACTIVE_CONTRACT
4474+INNODB_IBUF_MAX_SIZE
4475+INNODB_IO_CAPACITY
4476+INNODB_LAZY_DROP_TABLE
4477+INNODB_LOCKS_UNSAFE_FOR_BINLOG
4478+INNODB_LOCK_WAIT_TIMEOUT
4479+INNODB_LOG_BLOCK_SIZE
4480+INNODB_LOG_BUFFER_SIZE
4481+INNODB_LOG_FILES_IN_GROUP
4482+INNODB_LOG_FILE_SIZE
4483+INNODB_LOG_GROUP_HOME_DIR
4484+INNODB_MAX_DIRTY_PAGES_PCT
4485+INNODB_MAX_PURGE_LAG
4486+INNODB_MIRRORED_LOG_GROUPS
4487+INNODB_OLD_BLOCKS_PCT
4488+INNODB_OLD_BLOCKS_TIME
4489+INNODB_OPEN_FILES
4490+INNODB_OVERWRITE_RELAY_LOG_INFO
4491+INNODB_PAGE_SIZE
4492+INNODB_PASS_CORRUPT_TABLE
4493+INNODB_READ_AHEAD
4494+INNODB_READ_AHEAD_THRESHOLD
4495+INNODB_READ_IO_THREADS
4496+INNODB_RECOVERY_STATS
4497+INNODB_REPLICATION_DELAY
4498+INNODB_ROLLBACK_ON_TIMEOUT
4499+INNODB_SHOW_LOCKS_HELD
4500+INNODB_SHOW_VERBOSE_LOCKS
4501+INNODB_SPIN_WAIT_DELAY
4502+INNODB_STATS_AUTO_UPDATE
4503+INNODB_STATS_METHOD
4504+INNODB_STATS_ON_METADATA
4505+INNODB_STATS_SAMPLE_PAGES
4506+INNODB_STATS_UPDATE_NEED_LOCK
4507+INNODB_STRICT_MODE
4508+INNODB_SUPPORT_XA
4509+INNODB_SYNC_SPIN_LOOPS
4510+INNODB_TABLE_LOCKS
4511+INNODB_THREAD_CONCURRENCY
4512+INNODB_THREAD_CONCURRENCY_TIMER_BASED
4513+INNODB_THREAD_SLEEP_DELAY
4514+INNODB_USE_PURGE_THREAD
4515+INNODB_USE_SYS_MALLOC
4516+INNODB_USE_SYS_STATS_TABLE
4517+INNODB_VERSION
4518+INNODB_WRITE_IO_THREADS
4519+INSERT_ID
4520+INTERACTIVE_TIMEOUT
4521+JOIN_BUFFER_SIZE
4522+KEEP_FILES_ON_CREATE
4523+KEY_BUFFER_SIZE
4524+KEY_CACHE_AGE_THRESHOLD
4525+KEY_CACHE_BLOCK_SIZE
4526+KEY_CACHE_DIVISION_LIMIT
4527+LANGUAGE
4528+LARGE_FILES_SUPPORT
4529+LARGE_PAGES
4530+LARGE_PAGE_SIZE
4531+LAST_INSERT_ID
4532+LC_TIME_NAMES
4533+LICENSE
4534+LOCAL_INFILE
4535+LOCKED_IN_MEMORY
4536+LOG
4537+LOG_BIN
4538+LOG_BIN_TRUST_FUNCTION_CREATORS
4539+LOG_BIN_TRUST_ROUTINE_CREATORS
4540+LOG_ERROR
4541+LOG_OUTPUT
4542+LOG_QUERIES_NOT_USING_INDEXES
4543+LOG_SLAVE_UPDATES
4544+LOG_SLOW_FILTER
4545+LOG_SLOW_QUERIES
4546+LOG_SLOW_RATE_LIMIT
4547+LOG_SLOW_SLAVE_STATEMENTS
4548+LOG_SLOW_SP_STATEMENTS
4549+LOG_SLOW_TIMESTAMP_EVERY
4550+LOG_SLOW_VERBOSITY
4551+LOG_WARNINGS
4552+LONG_QUERY_TIME
4553+LOWER_CASE_FILE_SYSTEM
4554+LOWER_CASE_TABLE_NAMES
4555+LOW_PRIORITY_UPDATES
4556+MAX_ALLOWED_PACKET
4557+MAX_BINLOG_CACHE_SIZE
4558+MAX_BINLOG_SIZE
4559+MAX_CONNECTIONS
4560+MAX_CONNECT_ERRORS
4561+MAX_DELAYED_THREADS
4562+MAX_ERROR_COUNT
4563+MAX_HEAP_TABLE_SIZE
4564+MAX_INSERT_DELAYED_THREADS
4565+MAX_JOIN_SIZE
4566+MAX_LENGTH_FOR_SORT_DATA
4567+MAX_LONG_DATA_SIZE
4568+MAX_PREPARED_STMT_COUNT
4569+MAX_RELAY_LOG_SIZE
4570+MAX_SEEKS_FOR_KEY
4571+MAX_SORT_LENGTH
4572+MAX_SP_RECURSION_DEPTH
4573+MAX_TMP_TABLES
4574+MAX_USER_CONNECTIONS
4575+MAX_WRITE_LOCK_COUNT
4576+MIN_EXAMINED_ROW_LIMIT
4577+MULTI_RANGE_COUNT
4578+MYISAM_DATA_POINTER_SIZE
4579+MYISAM_MAX_SORT_FILE_SIZE
4580+MYISAM_MMAP_SIZE
4581+MYISAM_RECOVER_OPTIONS
4582+MYISAM_REPAIR_THREADS
4583+MYISAM_SORT_BUFFER_SIZE
4584+MYISAM_STATS_METHOD
4585+MYISAM_USE_MMAP
4586+NET_BUFFER_LENGTH
4587+NET_READ_TIMEOUT
4588+NET_RETRY_COUNT
4589+NET_WRITE_TIMEOUT
4590+NEW
4591+OLD
4592+OLD_ALTER_TABLE
4593+OLD_PASSWORDS
4594+OPEN_FILES_LIMIT
4595+OPTIMIZER_FIX
4596+OPTIMIZER_PRUNE_LEVEL
4597+OPTIMIZER_SEARCH_DEPTH
4598+OPTIMIZER_SWITCH
4599+PID_FILE
4600+PLUGIN_DIR
4601+PORT
4602+PRELOAD_BUFFER_SIZE
4603+PROFILING
4604+PROFILING_HISTORY_SIZE
4605+PROFILING_SERVER
4606+PROFILING_USE_GETRUSAGE
4607+PROTOCOL_VERSION
4608+PSEUDO_THREAD_ID
4609+QUERY_ALLOC_BLOCK_SIZE
4610+QUERY_CACHE_LIMIT
4611+QUERY_CACHE_MIN_RES_UNIT
4612+QUERY_CACHE_SIZE
4613+QUERY_CACHE_STRIP_COMMENTS
4614+QUERY_CACHE_TYPE
4615+QUERY_CACHE_WLOCK_INVALIDATE
The diff has been truncated for viewing.

Subscribers

People subscribed via source and target branches