Merge lp:~laurynas-biveinis/percona-server/slow-log-fixes-5.1 into lp:percona-server/5.1

[Laurynas Biveinis]

Multiple slow query log fixes and testsuite improvements. The MP corresponds to the 5.6 feature port in progress, that is, all these fixes have been backported from the 5.6 work.

The MP is big but should be relatively easy to review.

The updated testcases, notably percona_mysqldumpslow, still are unstable in Jenkins sometimes (but overall they fail much less now). I am putting this out anyway, and prefer to fix it as a follow-up.
Jenkins: http://jenkins.percona.com/job/percona-server-5.1-param/505/

[Stewart Smith (stewart)]

review: Approve

[Stewart Smith (stewart)]

When attempting to empty merge to 5.5:

http://jenkins.percona.com/view/Merge/job/merge-PS-5.1-merge-to-5.5/41/console

Text conflict in Percona-Server/mysql-test/r/percona_bug643149.result
Text conflict in Percona-Server/mysql-test/r/percona_log_slow_admin_statements.result
Text conflict in Percona-Server/mysql-test/r/percona_log_slow_query_plan.result
Text conflict in Percona-Server/mysql-test/r/percona_log_slow_query_plan_qc.result
Text conflict in Percona-Server/mysql-test/r/percona_log_slow_slave_statements.result
Text conflict in Percona-Server/mysql-test/r/percona_log_slow_sp_statements.result
Contents conflict in Percona-Server/mysql-test/r/percona_log_slow_timestamp_every.result
Text conflict in Percona-Server/mysql-test/r/percona_log_slow_verbosity.result
Contents conflict in Percona-Server/mysql-test/r/percona_mysqldumpslow.result
Text conflict in Percona-Server/mysql-test/r/percona_slow_extended_error_on_quit.result
Text conflict in Percona-Server/mysql-test/r/percona_slow_extended_log_error.result
Contents conflict in Percona-Server/mysql-test/r/percona_slow_query_log_microseconds_timestamp.result
Contents conflict in Percona-Server/mysql-test/r/percona_use_global_log_slow_control.result
Contents conflict in Percona-Server/mysql-test/r/percona_use_global_long_query_time.result
Text conflict in Percona-Server/mysql-test/t/disabled.def
Text conflict in Percona-Server/mysql-test/t/percona_log_slow_innodb.test
Text conflict in Percona-Server/mysql-test/t/percona_log_slow_query_plan.test
Text conflict in Percona-Server/mysql-test/t/percona_log_slow_query_plan_qc.test
Text conflict in Percona-Server/mysql-test/t/percona_log_slow_slave_statements-innodb.test
Text conflict in Percona-Server/mysql-test/t/percona_log_slow_slave_statements.test
Contents conflict in Percona-Server/mysql-test/t/percona_log_slow_timestamp_every.test
Text conflict in Percona-Server/mysql-test/t/percona_log_slow_verbosity.test
Contents conflict in Percona-Server/mysql-test/t/percona_mysqldumpslow.test
Text conflict in Percona-Server/mysql-test/t/percona_slow_extended_error_on_quit.test
Contents conflict in Percona-Server/mysql-test/t/percona_slow_query_log_microseconds_timestamp.test
Contents conflict in Percona-Server/mysql-test/t/percona_use_global_log_slow_control.test
Contents conflict in Percona-Server/mysql-test/t/percona_use_global_long_query_time.test
Text conflict in Percona-Server/scripts/mysqldumpslow.sh
Text conflict in Percona-Server/sql/event_scheduler.cc
Text conflict in Percona-Server/sql/log.cc
Text conflict in Percona-Server/sql/log_event.cc
Text conflict in Percona-Server/sql/sql_connect.cc
Text conflict in Percona-Server/sql/sql_parse.cc
33 conflicts encountered.
Build step 'Execute shell' marked build as failure
Finished: FAILURE

review: Needs Fixing

[Stewart Smith (stewart)]

Discussed on IRC with Laurynas, will by hand null merge to 5.5

review: Approve

=== added file 'Percona-Server/mysql-test/include/log_cleanup.inc'
--- Percona-Server/mysql-test/include/log_cleanup.inc	1970-01-01 00:00:00 +0000
+++ Percona-Server/mysql-test/include/log_cleanup.inc	2013-01-21 06:26:24 +0000
@@ -0,0 +1,1 @@
+--remove_files_wildcard $MYSQLTEST_VARDIR *.slog

=== modified file 'Percona-Server/mysql-test/include/log_start.inc'
--- Percona-Server/mysql-test/include/log_start.inc	2011-11-24 01:59:42 +0000
+++ Percona-Server/mysql-test/include/log_start.inc	2013-01-21 06:26:24 +0000
@@ -1,15 +1,10 @@
 --let slow_query_log_file_old=`SELECT Variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE Variable_name = 'slow_query_log_file';`
 --let slow_query_log_old=`SELECT Variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE Variable_name = 'slow_query_log';`
+--let log_output_old=`SELECT Variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE Variable_name = 'log_output';`
 --disable_query_log
---let log_file_full_path = $MYSQLTEST_VARDIR/$log_file
+--let log_file_full_path = $MYSQLTEST_VARDIR/$log_file.slog
 SET GLOBAL slow_query_log=0;
-perl;
-  $log_file_full_path= $ENV{'log_file_full_path'};
-  unlink $log_file_full_path;
-  open(FILE, '>', $log_file_full_path)
-    or die "Cannot create log file $log_file_full_path, reason: $!";
-  close(FILE);
-EOF
+SET GLOBAL log_output=FILE;
 --echo [log_start.inc] $log_file
 EVAL SET GLOBAL slow_query_log_file="$log_file_full_path";
 SET GLOBAL slow_query_log=1;

=== modified file 'Percona-Server/mysql-test/include/log_stop.inc'
--- Percona-Server/mysql-test/include/log_stop.inc	2011-11-24 01:59:42 +0000
+++ Percona-Server/mysql-test/include/log_stop.inc	2013-01-21 06:26:24 +0000
@@ -1,7 +1,7 @@
 --disable_query_log
-FLUSH LOGS;
 SET GLOBAL slow_query_log=0;
 --echo [log_stop.inc] $log_file
+EVAL SET GLOBAL log_output= $log_output_old;
 EVAL SET GLOBAL slow_query_log_file= "$slow_query_log_file_old";
-EVAL SET GLOBAL slow_query_log=      $slow_query_log_old ;
+EVAL SET GLOBAL slow_query_log=      $slow_query_log_old;
 --enable_query_log

=== removed file 'Percona-Server/mysql-test/include/percona_slow_extended_error_on_quit.inc'
--- Percona-Server/mysql-test/include/percona_slow_extended_error_on_quit.inc	2011-11-24 01:59:42 +0000
+++ Percona-Server/mysql-test/include/percona_slow_extended_error_on_quit.inc	1970-01-01 00:00:00 +0000
@@ -1,50 +0,0 @@
---echo ################################################################################
---let grep_pattern=CREATE
---source include/log_grep.inc
---let grep_pattern=INSERT
---source include/log_grep.inc
---let grep_pattern=SELECT
---source include/log_grep.inc
---let grep_pattern=Quit
---source include/log_grep.inc
---let grep_pattern=Last_errno: [^0]+
---source include/log_grep.inc
---let grep_pattern=Last_errno: 0
---source include/log_grep.inc
---let grep_pattern=Rows_sent: [^0]+
---source include/log_grep.inc
---let grep_pattern=Rows_sent: 0
---source include/log_grep.inc
---let grep_pattern=Rows_examined: [^0]+
---source include/log_grep.inc
---let grep_pattern=Rows_examined: 0
---source include/log_grep.inc
---let grep_pattern=Rows_affected: [^0]+
---source include/log_grep.inc
---let grep_pattern=Rows_affected: 0
---source include/log_grep.inc
---let grep_pattern=Rows_read: [^0]+
---source include/log_grep.inc
---let grep_pattern=Rows_read: 0
---source include/log_grep.inc
---let grep_pattern=Bytes_sent: [^0]+
---source include/log_grep.inc
---let grep_pattern=Bytes_sent: 0
---source include/log_grep.inc
---let grep_pattern=Tmp_tables: [^0]+
---source include/log_grep.inc
---let grep_pattern=Tmp_tables: 0
---source include/log_grep.inc
---let grep_pattern=Tmp_disk_tables: [^0]+
---source include/log_grep.inc
---let grep_pattern=Tmp_disk_tables: 0
---source include/log_grep.inc
---let grep_pattern=Tmp_table_sizes: [^0]+
---source include/log_grep.inc
---let grep_pattern=Tmp_table_sizes: 0
---source include/log_grep.inc
---let grep_pattern=# No InnoDB statistics available for this query
---source include/log_grep.inc
---let grep_pattern=# InnoDB_trx_id: 
---source include/log_grep.inc
---echo ################################################################################

=== added file 'Percona-Server/mysql-test/include/percona_slow_log_verbosity_grep.inc'
--- Percona-Server/mysql-test/include/percona_slow_log_verbosity_grep.inc	1970-01-01 00:00:00 +0000
+++ Percona-Server/mysql-test/include/percona_slow_log_verbosity_grep.inc	2013-01-21 06:26:24 +0000
@@ -0,0 +1,26 @@
+# Common extensions to the slow query log
+--let grep_pattern = ^# Thread_id: \d+  Schema: .+  Last_errno: \d+  Killed: \d+\$
+--source include/log_grep.inc
+--let grep_pattern = ^#.*Rows_affected: \d+  Rows_read: \d+\$
+--source include/log_grep.inc
+--let grep_pattern = ^# Bytes_sent: \d+.*\$
+--source include/log_grep.inc
+# InnoDB
+--let grep_pattern = ^# InnoDB_trx_id: \w+\$
+--source include/log_grep.inc
+# Query plan
+--let grep_pattern = ^# Bytes_sent: \d+  Tmp_tables: \d+  Tmp_disk_tables: \d+  Tmp_table_sizes: \d+\$
+--source include/log_grep.inc
+--let grep_pattern = ^# QC_Hit: (Yes|No)  Full_scan: (Yes|No)  Full_join: (Yes|No)  Tmp_table: (Yes|No)  Tmp_table_on_disk: (Yes|No)\$
+--source include/log_grep.inc
+--let grep_pattern = ^# Filesort: (Yes|No)  Filesort_on_disk: (Yes|No)  Merge_passes: \d+\$
+--source include/log_grep.inc
+# InnoDB
+--let grep_pattern = ^#   InnoDB_IO_r_ops: \d+  InnoDB_IO_r_bytes: \d+  InnoDB_IO_r_wait: \d*\.\d*\$
+--source include/log_grep.inc
+--let grep_pattern = ^#   InnoDB_rec_lock_wait: \d*\.\d*  InnoDB_queue_wait: \d*\.\d*\$
+--source include/log_grep.inc
+--let grep_pattern = ^#   InnoDB_pages_distinct: \d+\$
+--source include/log_grep.inc
+--let grep_pattern = ^# No InnoDB statistics available for this query\$
+--source include/log_grep.inc

=== modified file 'Percona-Server/mysql-test/r/percona_bug643149.result'
--- Percona-Server/mysql-test/r/percona_bug643149.result	2011-11-24 01:59:44 +0000
+++ Percona-Server/mysql-test/r/percona_bug643149.result	2013-01-21 06:26:24 +0000
@@ -9,13 +9,13 @@
 # User@Host: root[root] @ localhost []
 # Thread_id: X  Schema: test  Last_errno: X  Killed: X
 # Query_time: X.X  Lock_time: X.X  Rows_sent: X  Rows_examined: X  Rows_affected: X  Rows_read: X
-# Bytes_sent: X  Tmp_tables: X  Tmp_disk_tables: X  Tmp_table_sizes: X
+# Bytes_sent: X
 # Profile_starting: X.X Profile_starting_cpu: X.X Profile_Opening_tables: X.X Profile_Opening_tables_cpu: X.X Profile_query_end: X.X Profile_query_end_cpu: X.X Profile_freeing_items: X.X Profile_freeing_items_cpu: X.X Profile_logging_slow_query: X.X Profile_logging_slow_query_cpu: X.X 
 # Profile_total: X.X Profile_total_cpu: X.X 
 # User@Host: root[root] @ localhost []
 # Thread_id: X  Schema: test  Last_errno: X  Killed: X
 # Query_time: X.X  Lock_time: X.X  Rows_sent: X  Rows_examined: X  Rows_affected: X  Rows_read: X
-# Bytes_sent: X  Tmp_tables: X  Tmp_disk_tables: X  Tmp_table_sizes: X
+# Bytes_sent: X
 # Profile_starting: X.X Profile_starting_cpu: X.X Profile_checking_permissions: X.X Profile_checking_permissions_cpu: X.X Profile_Opening_tables: X.X Profile_Opening_tables_cpu: X.X Profile_init: X.X Profile_init_cpu: X.X Profile_optimizing: X.X Profile_optimizing_cpu: X.X Profile_executing: X.X Profile_executing_cpu: X.X Profile_end: X.X Profile_end_cpu: X.X Profile_query_end: X.X Profile_query_end_cpu: X.X Profile_freeing_items: X.X Profile_freeing_items_cpu: X.X Profile_logging_slow_query: X.X Profile_logging_slow_query_cpu: X.X 
 # Profile_total: X.X Profile_total_cpu: X.X 
 SET GLOBAL slow_query_log_file=@old_slow_query_log_file;

=== modified file 'Percona-Server/mysql-test/r/percona_log_slow_admin_statements.result'
--- Percona-Server/mysql-test/r/percona_log_slow_admin_statements.result	2011-11-24 01:59:42 +0000
+++ Percona-Server/mysql-test/r/percona_log_slow_admin_statements.result	2013-01-21 06:26:24 +0000
@@ -1,6 +1,15 @@
-SHOW GLOBAL VARIABLES like 'log_slow_admin_statements';
-Variable_name	Value
-log_slow_admin_statements	OFF
-SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='log_slow_admin_statements';
-VARIABLE_NAME	VARIABLE_VALUE
-LOG_SLOW_ADMIN_STATEMENTS	OFF
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (a INT);
+SET SESSION min_examined_row_limit=0;
+SET SESSION long_query_time=0;
+SET GLOBAL log_slow_admin_statements=ON;
+[log_start.inc] percona_log_slow_admin_stmt_1
+ALTER TABLE t1 ADD INDEX a(a);
+[log_stop.inc] percona_log_slow_admin_stmt_1
+[log_grep.inc] file: percona_log_slow_admin_stmt_1 pattern: ALTER TABLE t1 ADD INDEX a\(a\);
+[log_grep.inc] lines:   1
+[log_start.inc] percona_log_slow_admin_stmt_2
+ALTER TABLE t1 DROP INDEX a;
+[log_stop.inc] percona_log_slow_admin_stmt_2
+[log_grep.inc] file: percona_log_slow_admin_stmt_2 pattern: ALTER TABLE t1 DROP INDEX a;
+[log_grep.inc] lines:   0

=== removed file 'Percona-Server/mysql-test/r/percona_log_slow_filter.result'
--- Percona-Server/mysql-test/r/percona_log_slow_filter.result	2011-11-24 01:59:42 +0000
+++ Percona-Server/mysql-test/r/percona_log_slow_filter.result	1970-01-01 00:00:00 +0000
@@ -1,15 +0,0 @@
-CREATE TABLE t(id INT PRIMARY KEY);
-INSERT INTO t VALUES(1);
-INSERT INTO t VALUES(2);
-INSERT INTO t VALUES(3);
-SET long_query_time=1;
-SET log_slow_filter=full_join;
-[log_start.inc] percona.slow_extended.log_slow_filter
-SET query_exec_time = 1.1;
-SELECT * FROM t AS t1, t AS t2;
-SET query_exec_time = default;
-[log_stop.inc] percona.slow_extended.log_slow_filter
-SET log_slow_filter=default;
-SET long_query_time=default;
-[log_grep.inc] file: percona.slow_extended.log_slow_filter pattern: Query_time
-[log_grep.inc] lines:   1

=== added file 'Percona-Server/mysql-test/r/percona_log_slow_innodb.result'
--- Percona-Server/mysql-test/r/percona_log_slow_innodb.result	1970-01-01 00:00:00 +0000
+++ Percona-Server/mysql-test/r/percona_log_slow_innodb.result	2013-01-21 06:26:24 +0000
@@ -0,0 +1,42 @@
+DROP TABLE IF EXISTS t1, t2;
+CREATE TABLE t1(a INT) ENGINE=InnoDB;
+INSERT INTO t1 VALUE(1);
+CREATE TABLE t2(a INT) ENGINE=InnoDB;
+INSERT INTO t2 VALUE(1);
+SET SESSION min_examined_row_limit=0;
+SET SESSION long_query_time=0;
+SET @old_log_slow_verbosity := @@log_slow_verbosity;
+SET SESSION log_slow_verbosity='microtime,innodb';
+[log_start.inc] percona.slow_extended.innodb_0
+INSERT INTO t1 VALUES(2);
+INSERT INTO t2 VALUES(2);
+INSERT INTO t1 VALUES(3);
+SELECT 5;
+5
+5
+[log_stop.inc] percona.slow_extended.innodb_0
+LOCK TABLE t1 WRITE;
+[log_start.inc] percona.slow_extended.innodb_3
+LOCK TABLE t1 WRITE;
+SELECT SLEEP(5);
+SLEEP(5)
+0
+UNLOCK TABLES;
+[log_stop.inc] percona.slow_extended.innodb_3
+UNLOCK TABLES;
+BEGIN;
+SELECT * FROM t2 FOR UPDATE;
+a
+1
+2
+[log_start.inc] percona.slow_extended.innodb_4
+DELETE FROM t2 WHERE a=2;
+SELECT SLEEP(5);
+SLEEP(5)
+0
+COMMIT;
+[log_stop.inc] percona.slow_extended.innodb_4
+SET SESSION min_examined_row_limit=default;
+SET SESSION long_query_time=default;
+SET SESSION log_slow_verbosity=@old_log_slow_verbosity;
+DROP TABLE t1, t2;

=== added file 'Percona-Server/mysql-test/r/percona_log_slow_query_plan.result'
--- Percona-Server/mysql-test/r/percona_log_slow_query_plan.result	1970-01-01 00:00:00 +0000
+++ Percona-Server/mysql-test/r/percona_log_slow_query_plan.result	2013-01-21 06:26:24 +0000
@@ -0,0 +1,202 @@
+FLUSH STATUS;
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1(
+a INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
+b INT) ENGINE=InnoDB;
+INSERT INTO t1 VALUES(NULL, 10), (NULL, 5);
+SET SESSION long_query_time=0;
+SET SESSION min_examined_row_limit=0;
+SET SESSION log_slow_verbosity='microtime,query_plan';
+EXPLAIN SELECT * FROM t1;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	
+[log_start.inc] percona_slow_query_log.query_plan_0
+SELECT * FROM t1;
+a	b
+1	10
+2	5
+[log_stop.inc] percona_slow_query_log.query_plan_0
+[log_grep.inc] file: percona_slow_query_log.query_plan_0 pattern: ^# Filesort: No  Filesort_on_disk: No  Merge_passes: 0$
+[log_grep.inc] lines:   2
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	Using filesort
+[log_start.inc] percona_slow_query_log.query_plan_1
+SELECT * FROM t1 ORDER BY b;
+a	b
+2	5
+1	10
+[log_stop.inc] percona_slow_query_log.query_plan_1
+[log_grep.inc] file: percona_slow_query_log.query_plan_1 pattern: ^# Filesort: Yes  Filesort_on_disk: No  Merge_passes: 0$
+[log_grep.inc] lines:   1
+[log_start.inc] percona_slow_query_log.query_plan_1a
+SELECT * FROM t1 ORDER BY b;
+a	b
+2	5
+1	10
+[log_stop.inc] percona_slow_query_log.query_plan_1a
+[log_grep.inc] file: percona_slow_query_log.query_plan_1a pattern: ^# Filesort: Yes  Filesort_on_disk: No  Merge_passes: 0$
+[log_grep.inc] lines:   0
+Variable_name	Value
+Sort_merge_passes	0
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t2	ALL	NULL	NULL	NULL	NULL	ROWS	Using filesort
+[log_start.inc] percona_slow_query_log.query_plan_2
+SELECT * FROM t2 ORDER BY a;
+[log_stop.inc] percona_slow_query_log.query_plan_2
+[log_grep.inc] file: percona_slow_query_log.query_plan_2 pattern: ^# Filesort: Yes  Filesort_on_disk: Yes  Merge_passes: 1$
+[log_grep.inc] lines:   1
+Variable_name	Value
+Sort_merge_passes	1
+[log_start.inc] percona_slow_query_log.query_plan_2a
+SELECT * FROM t2 ORDER BY a;
+[log_stop.inc] percona_slow_query_log.query_plan_2a
+[log_grep.inc] file: percona_slow_query_log.query_plan_2a pattern: ^# Filesort: Yes  Filesort_on_disk: Yes  Merge_passes: 1$
+[log_grep.inc] lines:   0
+Variable_name	Value
+Sort_merge_passes	2
+[log_start.inc] percona_slow_query_log.query_plan_3
+SELECT * FROM t2 ORDER BY a;
+[log_stop.inc] percona_slow_query_log.query_plan_3
+[log_grep.inc] file: percona_slow_query_log.query_plan_3 pattern: ^# Filesort: Yes  Filesort_on_disk: Yes  Merge_passes: 4$
+[log_grep.inc] lines:   1
+Variable_name	Value
+Sort_merge_passes	6
+Variable_name	Value
+Select_scan	37
+[log_start.inc] percona_slow_query_log.query_plan_4
+SELECT * FROM t1 WHERE a=1;
+a	b
+1	10
+[log_stop.inc] percona_slow_query_log.query_plan_4
+[log_grep.inc] file: percona_slow_query_log.query_plan_4 pattern: ^#.*Full_scan: No.*$
+[log_grep.inc] lines:   2
+Variable_name	Value
+Select_scan	40
+[log_start.inc] percona_slow_query_log.query_plan_5
+SELECT COUNT(*) FROM t1;
+COUNT(*)
+2
+[log_stop.inc] percona_slow_query_log.query_plan_5
+[log_grep.inc] file: percona_slow_query_log.query_plan_5 pattern: ^#.*Full_scan: Yes.*$
+[log_grep.inc] lines:   1
+Variable_name	Value
+Select_scan	44
+[log_start.inc] percona_slow_query_log.query_plan_5a
+SELECT COUNT(*) FROM t1;
+COUNT(*)
+2
+[log_stop.inc] percona_slow_query_log.query_plan_5a
+[log_grep.inc] file: percona_slow_query_log.query_plan_5a pattern: ^#.*Full_scan: Yes.*$
+[log_grep.inc] lines:   0
+Variable_name	Value
+Select_scan	48
+Variable_name	Value
+Select_full_join	0
+[log_start.inc] percona_slow_query_log.query_plan_6
+SELECT COUNT(*) FROM t1, t3 WHERE t1.a = t3.a;
+COUNT(*)
+2
+[log_stop.inc] percona_slow_query_log.query_plan_6
+[log_grep.inc] file: percona_slow_query_log.query_plan_6 pattern: ^#.*Full_join: No.*$
+[log_grep.inc] lines:   2
+Variable_name	Value
+Select_full_join	0
+[log_start.inc] percona_slow_query_log.query_plan_7
+SELECT COUNT(*) FROM t1, t2 WHERE t1.b = t2.a;
+COUNT(*)
+8192
+[log_stop.inc] percona_slow_query_log.query_plan_7
+[log_grep.inc] file: percona_slow_query_log.query_plan_7 pattern: ^#.*Full_join: Yes.*$
+[log_grep.inc] lines:   1
+Variable_name	Value
+Select_full_join	1
+[log_start.inc] percona_slow_query_log.query_plan_7a
+SELECT COUNT(*) FROM t1, t2 WHERE t1.b = t2.a;
+COUNT(*)
+8192
+[log_stop.inc] percona_slow_query_log.query_plan_7a
+[log_grep.inc] file: percona_slow_query_log.query_plan_7a pattern: ^#.*Full_join: Yes.*$
+[log_grep.inc] lines:   0
+Variable_name	Value
+Select_full_join	2
+Variable_name	Value
+Created_tmp_tables	49
+Variable_name	Value
+Created_tmp_disk_tables	0
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	index	NULL	PRIMARY	4	NULL	2	Using index
+[log_start.inc] percona_slow_query_log.query_plan_8
+SELECT COUNT(*) FROM t1;
+COUNT(*)
+2
+[log_stop.inc] percona_slow_query_log.query_plan_8
+[log_grep.inc] file: percona_slow_query_log.query_plan_8 pattern: ^#.*Tmp_tables: 0  Tmp_disk_tables: 0  Tmp_table_sizes: 0$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona_slow_query_log.query_plan_8 pattern: ^#.*Tmp_table: No  Tmp_table_on_disk: No$
+[log_grep.inc] lines:   2
+Variable_name	Value
+Created_tmp_tables	52
+Variable_name	Value
+Created_tmp_disk_tables	0
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	index	PRIMARY	PRIMARY	4	NULL	2	Using index; Using temporary; Using filesort
+1	SIMPLE	t3	eq_ref	PRIMARY	PRIMARY	4	test.t1.a	1	Using index
+[log_start.inc] percona_slow_query_log.query_plan_9
+SELECT COUNT(*) FROM t1, t3 WHERE t1.a = t3.a GROUP BY t3.a;
+COUNT(*)
+1
+1
+[log_stop.inc] percona_slow_query_log.query_plan_9
+[log_grep.inc] file: percona_slow_query_log.query_plan_9 pattern: ^#.*Tmp_tables: 1  Tmp_disk_tables: 0  Tmp_table_sizes: [1-9][0-9]*$
+[log_grep.inc] lines:   1
+[log_grep.inc] file: percona_slow_query_log.query_plan_9 pattern: ^#.*Tmp_table: Yes  Tmp_table_on_disk: No$
+[log_grep.inc] lines:   1
+Variable_name	Value
+Created_tmp_tables	56
+Variable_name	Value
+Created_tmp_disk_tables	0
+[log_start.inc] percona_slow_query_log.query_plan_9a
+SELECT COUNT(*) FROM t1, t3 WHERE t1.a = t3.a GROUP BY t3.a;
+COUNT(*)
+1
+1
+[log_stop.inc] percona_slow_query_log.query_plan_9a
+[log_grep.inc] file: percona_slow_query_log.query_plan_9a pattern: ^#.*Tmp_tables: 1  Tmp_disk_tables: 0  Tmp_table_sizes: [1-9][0-9]*$
+[log_grep.inc] lines:   0
+[log_grep.inc] file: percona_slow_query_log.query_plan_9a pattern: ^#.*Tmp_table: Yes  Tmp_table_on_disk: No$
+[log_grep.inc] lines:   0
+Variable_name	Value
+Created_tmp_tables	60
+Variable_name	Value
+Created_tmp_disk_tables	0
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t1	index	PRIMARY	PRIMARY	4	NULL	2	Using index; Using temporary; Using filesort
+1	SIMPLE	t4	eq_ref	PRIMARY	PRIMARY	4	test.t1.a	1	Using index
+[log_start.inc] percona_slow_query_log.query_plan_10
+SELECT COUNT(*) FROM t1, t4 WHERE t1.a = t4.a GROUP BY t4.b;
+COUNT(*)
+1
+1
+[log_stop.inc] percona_slow_query_log.query_plan_10
+[log_grep.inc] file: percona_slow_query_log.query_plan_10 pattern: ^#.*Tmp_tables: 1  Tmp_disk_tables: 1  Tmp_table_sizes: [1-9][0-9]*$
+[log_grep.inc] lines:   1
+[log_grep.inc] file: percona_slow_query_log.query_plan_10 pattern: ^#.*Tmp_table: Yes  Tmp_table_on_disk: Yes$
+[log_grep.inc] lines:   1
+Variable_name	Value
+Created_tmp_tables	64
+Variable_name	Value
+Created_tmp_disk_tables	1
+[log_start.inc] percona_slow_query_log.query_plan_10a
+SELECT COUNT(*) FROM t1, t4 WHERE t1.a = t4.a GROUP BY t4.b;
+COUNT(*)
+1
+1
+[log_stop.inc] percona_slow_query_log.query_plan_10a
+[log_grep.inc] file: percona_slow_query_log.query_plan_10a pattern: ^#.*Tmp_tables: 1  Tmp_disk_tables: 1  Tmp_table_sizes: [1-9][0-9]*$
+[log_grep.inc] lines:   0
+[log_grep.inc] file: percona_slow_query_log.query_plan_10a pattern: ^#.*Tmp_table: Yes  Tmp_table_on_disk: Yes$
+[log_grep.inc] lines:   0
+Variable_name	Value
+Created_tmp_tables	68
+Variable_name	Value
+Created_tmp_disk_tables	2

=== added file 'Percona-Server/mysql-test/r/percona_log_slow_query_plan_qc.result'
--- Percona-Server/mysql-test/r/percona_log_slow_query_plan_qc.result	1970-01-01 00:00:00 +0000
+++ Percona-Server/mysql-test/r/percona_log_slow_query_plan_qc.result	2013-01-21 06:26:24 +0000
@@ -0,0 +1,35 @@
+FLUSH STATUS;
+SET SESSION min_examined_row_limit=0;
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (a INT) ENGINE=InnoDB;
+INSERT INTO t1 VALUE(5);
+SET SESSION query_cache_type=1;
+SET GLOBAL query_cache_size=1355776;
+SET SESSION long_query_time=0;
+SET SESSION log_slow_verbosity='microtime,query_plan';
+[log_start.inc] percona_slow_query_log.query_plan_qc_1
+SELECT * FROM t1;
+a
+5
+[log_stop.inc] percona_slow_query_log.query_plan_qc_1
+[log_grep.inc] file: percona_slow_query_log.query_plan_qc_1 pattern: ^# QC_Hit: No.*$
+[log_grep.inc] lines:   2
+Variable_name	Value
+Qcache_hits	0
+[log_start.inc] percona_slow_query_log.query_plan_qc_2
+SELECT * FROM t1;
+a
+5
+[log_stop.inc] percona_slow_query_log.query_plan_qc_2
+[log_grep.inc] file: percona_slow_query_log.query_plan_qc_2 pattern: ^# QC_Hit: Yes.*$
+[log_grep.inc] lines:   1
+Variable_name	Value
+Qcache_hits	1
+[log_start.inc] percona_slow_query_log.query_plan_qc_3
+SELECT * FROM t1 WHERE a > 5;
+a
+[log_stop.inc] percona_slow_query_log.query_plan_qc_3
+[log_grep.inc] file: percona_slow_query_log.query_plan_qc_3 pattern: ^# QC_Hit: No.*$
+[log_grep.inc] lines:   0
+Variable_name	Value
+Qcache_hits	1

=== modified file 'Percona-Server/mysql-test/r/percona_log_slow_slave_statements-innodb.result'
--- Percona-Server/mysql-test/r/percona_log_slow_slave_statements-innodb.result	2011-11-24 01:59:42 +0000
+++ Percona-Server/mysql-test/r/percona_log_slow_slave_statements-innodb.result	2013-01-21 06:26:24 +0000
@@ -1,5 +1,6 @@
 include/master-slave.inc
 [connection master]
+SET SESSION min_examined_row_limit=0;
 DROP TABLE IF EXISTS t;
 CREATE TABLE t(id INT,data CHAR(30)) ENGINE=InnoDB;
 INSERT INTO t VALUES
@@ -10,8 +11,12 @@
 (5,"aaaaabbbbbcccccdddddeeeeefffff");
 INSERT INTO t SELECT t2.id,t2.data from t as t1, t as t2;
 INSERT INTO t SELECT t2.id,t2.data from t as t1, t as t2;
-include/rpl_restart_server.inc [server_number=1]
+SET GLOBAL long_query_time=0;
+SET GLOBAL log_slow_slave_statements=TRUE;
+SET GLOBAL log_slow_verbosity='innodb';
+include/restart_slave.inc
 [log_start.inc] percona.slow_extended.log_slow_slave_statements-innodb
+INSERT INTO t SELECT t.id,t.data from t;
 [log_stop.inc] percona.slow_extended.log_slow_slave_statements-innodb
 [log_grep.inc] file: percona.slow_extended.log_slow_slave_statements-innodb pattern: InnoDB_IO_r_ops
 [log_grep.inc] lines:   1

=== modified file 'Percona-Server/mysql-test/r/percona_log_slow_slave_statements.result'
--- Percona-Server/mysql-test/r/percona_log_slow_slave_statements.result	2011-11-24 01:59:42 +0000
+++ Percona-Server/mysql-test/r/percona_log_slow_slave_statements.result	2013-01-21 06:26:24 +0000
@@ -1,46 +1,26 @@
 include/master-slave.inc
 [connection master]
 DROP TABLE IF EXISTS t;
-CREATE TABLE t(id INT);
+CREATE TABLE t(id INT) ENGINE=InnoDB;
+SET GLOBAL min_examined_row_limit=0;
+SET GLOBAL long_query_time=0;
+SET GLOBAL log_slow_slave_statements=OFF;
+include/restart_slave.inc
 [log_start.inc] percona.slow_extended.log_slow_slave_statements
-LINE 1
-LOG_SLOW_SLAVE_STATAMENTS is OFF
-LOG_SLOW_SLAVE_STATEMENTS=1
-LOG_SLOW_SLAVE_STATAMENTS is ON
-LINE 2
-include/restart_slave.inc
-LOG_SLOW_SLAVE_STATAMENTS is ON
-LINE 3
-LOG_SLOW_SLAVE_STATAMENTS is ON
-LOG_SLOW_SLAVE_STATEMENTS=0
-LOG_SLOW_SLAVE_STATAMENTS is OFF
-LINE 4
-include/restart_slave.inc
-LOG_SLOW_SLAVE_STATAMENTS is OFF
-LINE 5
-LOG_SLOW_SLAVE_STATAMENTS is OFF
-LOG_SLOW_SLAVE_STATEMENTS=1
-LOG_SLOW_SLAVE_STATAMENTS is ON
-LINE 6
-include/restart_slave.inc
-LOG_SLOW_SLAVE_STATAMENTS is ON
-LINE 7
+INSERT INTO t VALUES (1);
+SET GLOBAL log_slow_slave_statements=ON;
+BEGIN;
+INSERT INTO t VALUES (2);
+COMMIT;
+SET GLOBAL log_slow_slave_statements=OFF;
+INSERT INTO t VALUES (3);
 [log_stop.inc] percona.slow_extended.log_slow_slave_statements
-SET GLOBAL log_slow_slave_statements=default;
 [log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(1\)
 [log_grep.inc] lines:   0
 [log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(2\)
-[log_grep.inc] lines:   0
+[log_grep.inc] lines:   1
 [log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(3\)
-[log_grep.inc] lines:   1
-[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(4\)
-[log_grep.inc] lines:   0
-[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(5\)
-[log_grep.inc] lines:   0
-[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(6\)
-[log_grep.inc] lines:   0
-[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(7\)
-[log_grep.inc] lines:   1
-[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(8\)
-[log_grep.inc] lines:   0
+[log_grep.inc] lines:   0
+[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: ^# User@Host: \[SQL_SLAVE\] @  \[\]
+[log_grep.inc] lines:   2
 include/rpl_end.inc

=== modified file 'Percona-Server/mysql-test/r/percona_log_slow_sp_statements.result'
--- Percona-Server/mysql-test/r/percona_log_slow_sp_statements.result	2011-11-24 01:59:42 +0000
+++ Percona-Server/mysql-test/r/percona_log_slow_sp_statements.result	2013-01-21 06:26:24 +0000
@@ -1,22 +1,23 @@
-SET long_query_time=1;
-SET GLOBAL log_slow_sp_statements=1;
-[log_start.inc] percona.slow_extended.log_slow_sp_statements
+DROP PROCEDURE IF EXISTS test_f;
+SET SESSION min_examined_row_limit=0;
+SET SESSION long_query_time=0;
+SET SESSION query_cache_type=0;
 CREATE PROCEDURE test_f()
 BEGIN
-SET SESSION query_exec_time=1.1; SELECT 1;
-SET SESSION query_exec_time=2.1; SELECT 1;
-SET SESSION query_exec_time=3.1; SELECT 1;
-SET SESSION query_exec_time=default;
+SELECT 1;
 END^
-CALL test_f();
-1
-1
-1
-1
-1
-1
-[log_stop.inc] percona.slow_extended.log_slow_sp_statements
-SET GLOBAL log_slow_sp_statements=default;
-SET long_query_time=default;
-[log_grep.inc] file: percona.slow_extended.log_slow_sp_statements pattern: Query_time
-[log_grep.inc] lines:   3
+SET GLOBAL log_slow_sp_statements=ON;
+[log_start.inc] percona.slow_extended.sp1
+CALL test_f();
+1
+1
+[log_stop.inc] percona.slow_extended.sp1
+[log_grep.inc] file: percona.slow_extended.sp1 pattern: SELECT 1;
+[log_grep.inc] lines:   1
+[log_start.inc] percona.slow_extended.sp2
+CALL test_f();
+1
+1
+[log_stop.inc] percona.slow_extended.sp2
+[log_grep.inc] file: percona.slow_extended.sp2 pattern: SELECT 1;
+[log_grep.inc] lines:   0

=== modified file 'Percona-Server/mysql-test/r/percona_log_slow_timestamp_every.result'
--- Percona-Server/mysql-test/r/percona_log_slow_timestamp_every.result	2011-11-24 01:59:42 +0000
+++ Percona-Server/mysql-test/r/percona_log_slow_timestamp_every.result	2013-01-21 06:26:24 +0000
@@ -1,39 +1,13 @@
-SET long_query_time=2;
-SET GLOBAL log_slow_timestamp_every=1;
-[log_start.inc] percona.slow_extended.log_slow_timestamp_every
-SET SESSION query_exec_time=2.1;
-SELECT 1;
-1
-1
-SELECT 2;
-2
-2
-SELECT 3;
-3
-3
-SET GLOBAL log_slow_timestamp_every=0;
-SELECT 1;
-1
-1
-SELECT 2;
-2
-2
-SELECT 3;
-3
-3
-SET GLOBAL log_slow_timestamp_every=1;
-SELECT 1;
-1
-1
-SELECT 2;
-2
-2
-SELECT 3;
-3
-3
-SET SESSION query_exec_time = default;
-[log_stop.inc] percona.slow_extended.log_slow_timestamp_every
-SET GLOBAL log_slow_timestamp_every=default;
-SET long_query_time=default;
-[log_grep.inc] file: percona.slow_extended.log_slow_timestamp_every pattern: # Time: [0-9]+[ ]+[0-9]+:[0-9]+:[0-9]+
-[log_grep.inc] lines:   6
+SET SESSION min_examined_row_limit=0;
+SET SESSION long_query_time=0;
+SET GLOBAL log_slow_timestamp_every=TRUE;
+[log_start.inc] percona_slow_extended_query_log_1
+SELECT 1;
+1
+1
+SELECT 2;
+2
+2
+[log_stop.inc] percona_slow_extended_query_log_1
+[log_grep.inc] file: percona_slow_extended_query_log_1 pattern: ^# Time: \d{6} (\d| )\d:\d\d:\d\d$
+[log_grep.inc] lines:   3

=== modified file 'Percona-Server/mysql-test/r/percona_log_slow_verbosity.result'
--- Percona-Server/mysql-test/r/percona_log_slow_verbosity.result	2011-11-24 01:59:42 +0000
+++ Percona-Server/mysql-test/r/percona_log_slow_verbosity.result	2013-01-21 06:26:24 +0000
@@ -1,16 +1,111 @@
-SET SESSION long_query_time=1;
-[log_start.inc] percona.slow_extended.log_slow_verbosity
-SET SESSION query_exec_time=2.1;
-SELECT 1;
-1
-1
-SET SESSION log_slow_verbosity=innodb;
-SELECT 1;
-1
-1
-SET SESSION query_exec_time=default;
-[log_stop.inc] percona.slow_extended.log_slow_verbosity
-SET log_slow_verbosity='';
-SET long_query_time=default;
-[log_grep.inc] file: percona.slow_extended.log_slow_verbosity pattern: No InnoDB statistics available for this query
-[log_grep.inc] lines:   1
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1(a INT) ENGINE=InnoDB;
+SET SESSION min_examined_row_limit=0;
+SET SESSION long_query_time=0;
+SET SESSION log_slow_verbosity='microtime,innodb,query_plan';
+[log_start.inc] percona.slow_extended.log_slow_verbosity_0
+INSERT INTO t1 VALUE(0);
+[log_stop.inc] percona.slow_extended.log_slow_verbosity_0
+log_slow_verbosity='microtime,innodb,query_plan':
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^# Thread_id: \d+  Schema: .+  Last_errno: \d+  Killed: \d+$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^#.*Rows_affected: \d+  Rows_read: \d+$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^# Bytes_sent: \d+.*$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^# InnoDB_trx_id: \w+$
+[log_grep.inc] lines:   1
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^# Bytes_sent: \d+  Tmp_tables: \d+  Tmp_disk_tables: \d+  Tmp_table_sizes: \d+$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^# QC_Hit: (Yes|No)  Full_scan: (Yes|No)  Full_join: (Yes|No)  Tmp_table: (Yes|No)  Tmp_table_on_disk: (Yes|No)$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^# Filesort: (Yes|No)  Filesort_on_disk: (Yes|No)  Merge_passes: \d+$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^#   InnoDB_IO_r_ops: \d+  InnoDB_IO_r_bytes: \d+  InnoDB_IO_r_wait: \d*\.\d*$
+[log_grep.inc] lines:   1
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^#   InnoDB_rec_lock_wait: \d*\.\d*  InnoDB_queue_wait: \d*\.\d*$
+[log_grep.inc] lines:   1
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^#   InnoDB_pages_distinct: \d+$
+[log_grep.inc] lines:   1
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^# No InnoDB statistics available for this query$
+[log_grep.inc] lines:   1
+[log_start.inc] percona.slow_extended.log_slow_verbosity_1
+SELECT 1;
+1
+1
+[log_stop.inc] percona.slow_extended.log_slow_verbosity_1
+log_slow_verbosity='microtime,innodb,query_plan':
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# Thread_id: \d+  Schema: .+  Last_errno: \d+  Killed: \d+$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^#.*Rows_affected: \d+  Rows_read: \d+$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# Bytes_sent: \d+.*$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# InnoDB_trx_id: \w+$
+[log_grep.inc] lines:   0
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# Bytes_sent: \d+  Tmp_tables: \d+  Tmp_disk_tables: \d+  Tmp_table_sizes: \d+$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# QC_Hit: (Yes|No)  Full_scan: (Yes|No)  Full_join: (Yes|No)  Tmp_table: (Yes|No)  Tmp_table_on_disk: (Yes|No)$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# Filesort: (Yes|No)  Filesort_on_disk: (Yes|No)  Merge_passes: \d+$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^#   InnoDB_IO_r_ops: \d+  InnoDB_IO_r_bytes: \d+  InnoDB_IO_r_wait: \d*\.\d*$
+[log_grep.inc] lines:   0
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^#   InnoDB_rec_lock_wait: \d*\.\d*  InnoDB_queue_wait: \d*\.\d*$
+[log_grep.inc] lines:   0
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^#   InnoDB_pages_distinct: \d+$
+[log_grep.inc] lines:   0
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# No InnoDB statistics available for this query$
+[log_grep.inc] lines:   2
+[log_start.inc] percona.slow_extended.log_slow_verbosity_2
+INSERT INTO t1 VALUE(1);
+[log_stop.inc] percona.slow_extended.log_slow_verbosity_2
+log_slow_verbosity='microtime':
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^# Thread_id: \d+  Schema: .+  Last_errno: \d+  Killed: \d+$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^#.*Rows_affected: \d+  Rows_read: \d+$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^# Bytes_sent: \d+.*$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^# InnoDB_trx_id: \w+$
+[log_grep.inc] lines:   0
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^# Bytes_sent: \d+  Tmp_tables: \d+  Tmp_disk_tables: \d+  Tmp_table_sizes: \d+$
+[log_grep.inc] lines:   0
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^# QC_Hit: (Yes|No)  Full_scan: (Yes|No)  Full_join: (Yes|No)  Tmp_table: (Yes|No)  Tmp_table_on_disk: (Yes|No)$
+[log_grep.inc] lines:   0
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^# Filesort: (Yes|No)  Filesort_on_disk: (Yes|No)  Merge_passes: \d+$
+[log_grep.inc] lines:   0
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^#   InnoDB_IO_r_ops: \d+  InnoDB_IO_r_bytes: \d+  InnoDB_IO_r_wait: \d*\.\d*$
+[log_grep.inc] lines:   0
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^#   InnoDB_rec_lock_wait: \d*\.\d*  InnoDB_queue_wait: \d*\.\d*$
+[log_grep.inc] lines:   0
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^#   InnoDB_pages_distinct: \d+$
+[log_grep.inc] lines:   0
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^# No InnoDB statistics available for this query$
+[log_grep.inc] lines:   0
+[log_start.inc] percona.slow_extended.log_slow_verbosity_3
+INSERT INTO t1 VALUE(2);
+[log_stop.inc] percona.slow_extended.log_slow_verbosity_3
+log_slow_verbosity='query_plan':
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^# Thread_id: \d+  Schema: .+  Last_errno: \d+  Killed: \d+$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^#.*Rows_affected: \d+  Rows_read: \d+$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^# Bytes_sent: \d+.*$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^# InnoDB_trx_id: \w+$
+[log_grep.inc] lines:   0
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^# Bytes_sent: \d+  Tmp_tables: \d+  Tmp_disk_tables: \d+  Tmp_table_sizes: \d+$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^# QC_Hit: (Yes|No)  Full_scan: (Yes|No)  Full_join: (Yes|No)  Tmp_table: (Yes|No)  Tmp_table_on_disk: (Yes|No)$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^# Filesort: (Yes|No)  Filesort_on_disk: (Yes|No)  Merge_passes: \d+$
+[log_grep.inc] lines:   2
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^#   InnoDB_IO_r_ops: \d+  InnoDB_IO_r_bytes: \d+  InnoDB_IO_r_wait: \d*\.\d*$
+[log_grep.inc] lines:   0
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^#   InnoDB_rec_lock_wait: \d*\.\d*  InnoDB_queue_wait: \d*\.\d*$
+[log_grep.inc] lines:   0
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^#   InnoDB_pages_distinct: \d+$
+[log_grep.inc] lines:   0
+[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^# No InnoDB statistics available for this query$
+[log_grep.inc] lines:   0

=== modified file 'Percona-Server/mysql-test/r/percona_long_query_time.result'
--- Percona-Server/mysql-test/r/percona_long_query_time.result	2011-11-24 01:59:42 +0000
+++ Percona-Server/mysql-test/r/percona_long_query_time.result	2013-01-21 06:26:24 +0000
@@ -1,3 +1,4 @@
+SET SESSION min_examined_row_limit=0;
 SET long_query_time=2;
 [log_start.inc] percona.slow_extended.long_query_time
 SET SESSION query_exec_time=1.1;
@@ -29,5 +30,6 @@
 SET long_query_time=2;
 [log_stop.inc] percona.slow_extended.long_query_time
 SET long_query_time=default;
+SET SESSION min_examined_row_limit=default;
 [log_grep.inc] file: percona.slow_extended.long_query_time pattern: Query_time
 [log_grep.inc] lines:   3

=== modified file 'Percona-Server/mysql-test/r/percona_mysqldumpslow.result'
--- Percona-Server/mysql-test/r/percona_mysqldumpslow.result	2011-12-28 11:19:35 +0000
+++ Percona-Server/mysql-test/r/percona_mysqldumpslow.result	2013-01-21 06:26:24 +0000
@@ -4,9102 +4,8108 @@
 SET @old_log_slow_sp_statements=@@log_slow_sp_statements;
 SET @old_slow_query_log_microseconds_timestamp=@@slow_query_log_microseconds_timestamp;
 SET @old_log_slow_admin_statements=@@log_slow_admin_statements;
-SET GLOBAL long_query_time=1;
-SET SESSION query_exec_time=0.5;
-[log_start.inc] percona.mysqldumpslow
-SET GLOBAL log_slow_verbosity='innodb,query_plan,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,query_plan,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,query_plan,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,query_plan,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,query_plan,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,query_plan,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,query_plan,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,query_plan,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='query_plan,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='query_plan,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='query_plan,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='query_plan,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='query_plan,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='query_plan,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='query_plan,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='query_plan,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='microtime';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,query_plan';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,query_plan';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,query_plan';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,query_plan';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,query_plan';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,query_plan';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,query_plan';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb,query_plan';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='query_plan';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='query_plan';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='query_plan';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='query_plan';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='query_plan';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='query_plan';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='query_plan';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='query_plan';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='innodb';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=0;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=1;
-SET GLOBAL log_slow_admin_statements=0;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.99;
-SET SESSION slow_query_log_query_time=1.99;
-SET SESSION slow_query_log_lock_time=0.9;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=2.1;
-SET SESSION slow_query_log_query_time=2.1;
-SET SESSION slow_query_log_lock_time=1.0;
-SELECT COUNT(*) FROM t1;
-COUNT(*)
-12
-SET SESSION query_exec_time=2.21;
-SET SESSION slow_query_log_query_time=2.21;
-SET SESSION slow_query_log_lock_time=1.1;
-SELECT COUNT(*) FROM t2;
-COUNT(*)
-24
-SET SESSION query_exec_time=2.32;
-SET SESSION slow_query_log_query_time=2.32;
-SET SESSION slow_query_log_lock_time=1.2;
-DROP TABLE t1;
-SET SESSION query_exec_time=2.43;
-SET SESSION slow_query_log_query_time=2.43;
-SET SESSION slow_query_log_lock_time=1.3;
-DROP TABLE t2;
-SET SESSION query_exec_time=2.54;
-SET SESSION slow_query_log_query_time=2.54;
-SET SESSION slow_query_log_lock_time=1.4;
-SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
-SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
-SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
-SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
-SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
-SET GLOBAL log_slow_verbosity='';
-SET GLOBAL log_slow_timestamp_every=1;
-SET GLOBAL log_slow_sp_statements=1;
-SET GLOBAL slow_query_log_microseconds_timestamp=0;
-SET GLOBAL log_slow_admin_statements=1;
-DROP TABLE IF EXISTS t1;
-DROP TABLE IF EXISTS t2;
-SET SESSION query_exec_time=1.11;
-SET SESSION slow_query_log_query_time=1.11;
-SET SESSION slow_query_log_lock_time=0.1;
-CREATE TABLE t1(id INT) ENGINE=InnoDB;
-SET SESSION query_exec_time=1.22;
-SET SESSION slow_query_log_query_time=1.22;
-SET SESSION slow_query_log_lock_time=0.2;
-CREATE TABLE t2(id INT) ENGINE=MyISAM;
-SET SESSION query_exec_time=1.33;
-SET SESSION slow_query_log_query_time=1.33;
-SET SESSION slow_query_log_lock_time=0.3;
-INSERT INTO t1 VALUES(0);
-SET SESSION query_exec_time=1.44;
-SET SESSION slow_query_log_query_time=1.44;
-SET SESSION slow_query_log_lock_time=0.4;
-INSERT INTO t1 VALUES(1);
-SET SESSION query_exec_time=1.55;
-SET SESSION slow_query_log_query_time=1.55;
-SET SESSION slow_query_log_lock_time=0.5;
-INSERT INTO t1 VALUES(2);
-SET SESSION query_exec_time=1.66;
-SET SESSION slow_query_log_query_time=1.66;
-SET SESSION slow_query_log_lock_time=0.6;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
-SET SESSION query_exec_time=1.77;
-SET SESSION slow_query_log_query_time=1.77;
-SET SESSION slow_query_log_lock_time=0.7;
-INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
-SET SESSION query_exec_time=1.88;
-SET SESSION slow_query_log_query_time=1.88;
-SET SESSION slow_query_log_lock_time=0.8;
-INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;