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

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

  1. slow-log-fixes-5.1
  2. Merge into 5.1
Proposed by Laurynas Biveinis
Status: Merged
Approved by: Stewart Smith
Approved revision: no longer in the source branch.
Merged at revision: 529
Proposed branch: lp:~laurynas-biveinis/percona-server/slow-log-fixes-5.1
Merge into: lp:percona-server/5.1
Diff against target: 20056 lines (+9597/-9871)
52 files modified
Percona-Server/mysql-test/include/log_cleanup.inc (+1/-0)
Percona-Server/mysql-test/include/log_start.inc (+3/-8)
Percona-Server/mysql-test/include/log_stop.inc (+2/-2)
Percona-Server/mysql-test/include/percona_slow_extended_error_on_quit.inc (+0/-50)
Percona-Server/mysql-test/include/percona_slow_log_verbosity_grep.inc (+26/-0)
Percona-Server/mysql-test/r/percona_bug643149.result (+2/-2)
Percona-Server/mysql-test/r/percona_log_slow_admin_statements.result (+15/-6)
Percona-Server/mysql-test/r/percona_log_slow_filter.result (+0/-15)
Percona-Server/mysql-test/r/percona_log_slow_innodb.result (+42/-0)
Percona-Server/mysql-test/r/percona_log_slow_query_plan.result (+202/-0)
Percona-Server/mysql-test/r/percona_log_slow_query_plan_qc.result (+35/-0)
Percona-Server/mysql-test/r/percona_log_slow_slave_statements-innodb.result (+6/-1)
Percona-Server/mysql-test/r/percona_log_slow_slave_statements.result (+16/-36)
Percona-Server/mysql-test/r/percona_log_slow_sp_statements.result (+20/-19)
Percona-Server/mysql-test/r/percona_log_slow_timestamp_every.result (+13/-39)
Percona-Server/mysql-test/r/percona_log_slow_verbosity.result (+111/-16)
Percona-Server/mysql-test/r/percona_long_query_time.result (+2/-0)
Percona-Server/mysql-test/r/percona_mysqldumpslow.result (+8100/-9094)
Percona-Server/mysql-test/r/percona_slow_extended_error_on_quit.result (+20/-168)
Percona-Server/mysql-test/r/percona_slow_extended_log_error.result (+14/-0)
Percona-Server/mysql-test/r/percona_slow_query_log_microseconds_timestamp.result (+17/-17)
Percona-Server/mysql-test/r/percona_use_global_log_slow_control.result (+2/-0)
Percona-Server/mysql-test/r/percona_use_global_long_query_time.result (+2/-0)
Percona-Server/mysql-test/t/disabled.def (+1/-0)
Percona-Server/mysql-test/t/percona_log_slow_admin_statements.test (+41/-2)
Percona-Server/mysql-test/t/percona_log_slow_filter.test (+0/-26)
Percona-Server/mysql-test/t/percona_log_slow_innodb.test (+82/-0)
Percona-Server/mysql-test/t/percona_log_slow_query_plan.test (+302/-0)
Percona-Server/mysql-test/t/percona_log_slow_query_plan_qc.test (+71/-0)
Percona-Server/mysql-test/t/percona_log_slow_slave_statements-innodb-slave.opt (+0/-1)
Percona-Server/mysql-test/t/percona_log_slow_slave_statements-innodb.test (+16/-16)
Percona-Server/mysql-test/t/percona_log_slow_slave_statements-slave.opt (+0/-1)
Percona-Server/mysql-test/t/percona_log_slow_slave_statements.test (+50/-101)
Percona-Server/mysql-test/t/percona_log_slow_sp_statements.test (+34/-20)
Percona-Server/mysql-test/t/percona_log_slow_timestamp_every.test (+17/-29)
Percona-Server/mysql-test/t/percona_log_slow_verbosity.test (+75/-19)
Percona-Server/mysql-test/t/percona_long_query_time.test (+4/-0)
Percona-Server/mysql-test/t/percona_min_examined_row_limit.test (+1/-0)
Percona-Server/mysql-test/t/percona_mysqldumpslow.test (+59/-24)
Percona-Server/mysql-test/t/percona_slow_extended_error_on_quit.test (+58/-74)
Percona-Server/mysql-test/t/percona_slow_extended_log_error.test (+31/-0)
Percona-Server/mysql-test/t/percona_slow_query_log_microseconds_timestamp.test (+36/-24)
Percona-Server/mysql-test/t/percona_use_global_log_slow_control.test (+4/-1)
Percona-Server/mysql-test/t/percona_use_global_long_query_time.test (+5/-0)
Percona-Server/scripts/mysqldumpslow.sh (+3/-3)
Percona-Server/sql/event_scheduler.cc (+0/-1)
Percona-Server/sql/log.cc (+48/-22)
Percona-Server/sql/log_event.cc (+5/-9)
Percona-Server/sql/slave.cc (+1/-2)
Percona-Server/sql/sql_class.h (+0/-13)
Percona-Server/sql/sql_connect.cc (+0/-9)
Percona-Server/sql/sql_parse.cc (+2/-1)
To merge this branch: bzr merge lp:~laurynas-biveinis/percona-server/slow-log-fixes-5.1
Reviewer Review Type Date Requested Status
Stewart Smith (community) Approve
Review via email: mp+144057@code.launchpad.net

Description of the change

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/

To post a comment you must log in.
Revision history for this message
Stewart Smith (stewart) :
review: Approve
Revision history for this message
Stewart Smith (stewart) wrote :

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
Revision history for this message
Stewart Smith (stewart) wrote :

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

review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== 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 @@
1--remove_files_wildcard $MYSQLTEST_VARDIR *.slog
02
=== 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 @@
1--let slow_query_log_file_old=`SELECT Variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE Variable_name = 'slow_query_log_file';`1--let slow_query_log_file_old=`SELECT Variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE Variable_name = 'slow_query_log_file';`
2--let slow_query_log_old=`SELECT Variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE Variable_name = 'slow_query_log';`2--let slow_query_log_old=`SELECT Variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE Variable_name = 'slow_query_log';`
3--let log_output_old=`SELECT Variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE Variable_name = 'log_output';`
3--disable_query_log4--disable_query_log
4--let log_file_full_path = $MYSQLTEST_VARDIR/$log_file5--let log_file_full_path = $MYSQLTEST_VARDIR/$log_file.slog
5SET GLOBAL slow_query_log=0;6SET GLOBAL slow_query_log=0;
6perl;7SET GLOBAL log_output=FILE;
7 $log_file_full_path= $ENV{'log_file_full_path'};
8 unlink $log_file_full_path;
9 open(FILE, '>', $log_file_full_path)
10 or die "Cannot create log file $log_file_full_path, reason: $!";
11 close(FILE);
12EOF
13--echo [log_start.inc] $log_file8--echo [log_start.inc] $log_file
14EVAL SET GLOBAL slow_query_log_file="$log_file_full_path";9EVAL SET GLOBAL slow_query_log_file="$log_file_full_path";
15SET GLOBAL slow_query_log=1;10SET GLOBAL slow_query_log=1;
1611
=== 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 @@
1--disable_query_log1--disable_query_log
2FLUSH LOGS;
3SET GLOBAL slow_query_log=0;2SET GLOBAL slow_query_log=0;
4--echo [log_stop.inc] $log_file3--echo [log_stop.inc] $log_file
4EVAL SET GLOBAL log_output= $log_output_old;
5EVAL SET GLOBAL slow_query_log_file= "$slow_query_log_file_old";5EVAL SET GLOBAL slow_query_log_file= "$slow_query_log_file_old";
6EVAL SET GLOBAL slow_query_log= $slow_query_log_old ;6EVAL SET GLOBAL slow_query_log= $slow_query_log_old;
7--enable_query_log7--enable_query_log
88
=== 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 @@
1--echo ################################################################################
2--let grep_pattern=CREATE
3--source include/log_grep.inc
4--let grep_pattern=INSERT
5--source include/log_grep.inc
6--let grep_pattern=SELECT
7--source include/log_grep.inc
8--let grep_pattern=Quit
9--source include/log_grep.inc
10--let grep_pattern=Last_errno: [^0]+
11--source include/log_grep.inc
12--let grep_pattern=Last_errno: 0
13--source include/log_grep.inc
14--let grep_pattern=Rows_sent: [^0]+
15--source include/log_grep.inc
16--let grep_pattern=Rows_sent: 0
17--source include/log_grep.inc
18--let grep_pattern=Rows_examined: [^0]+
19--source include/log_grep.inc
20--let grep_pattern=Rows_examined: 0
21--source include/log_grep.inc
22--let grep_pattern=Rows_affected: [^0]+
23--source include/log_grep.inc
24--let grep_pattern=Rows_affected: 0
25--source include/log_grep.inc
26--let grep_pattern=Rows_read: [^0]+
27--source include/log_grep.inc
28--let grep_pattern=Rows_read: 0
29--source include/log_grep.inc
30--let grep_pattern=Bytes_sent: [^0]+
31--source include/log_grep.inc
32--let grep_pattern=Bytes_sent: 0
33--source include/log_grep.inc
34--let grep_pattern=Tmp_tables: [^0]+
35--source include/log_grep.inc
36--let grep_pattern=Tmp_tables: 0
37--source include/log_grep.inc
38--let grep_pattern=Tmp_disk_tables: [^0]+
39--source include/log_grep.inc
40--let grep_pattern=Tmp_disk_tables: 0
41--source include/log_grep.inc
42--let grep_pattern=Tmp_table_sizes: [^0]+
43--source include/log_grep.inc
44--let grep_pattern=Tmp_table_sizes: 0
45--source include/log_grep.inc
46--let grep_pattern=# No InnoDB statistics available for this query
47--source include/log_grep.inc
48--let grep_pattern=# InnoDB_trx_id:
49--source include/log_grep.inc
50--echo ################################################################################
510
=== 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 @@
1# Common extensions to the slow query log
2--let grep_pattern = ^# Thread_id: \d+ Schema: .+ Last_errno: \d+ Killed: \d+\$
3--source include/log_grep.inc
4--let grep_pattern = ^#.*Rows_affected: \d+ Rows_read: \d+\$
5--source include/log_grep.inc
6--let grep_pattern = ^# Bytes_sent: \d+.*\$
7--source include/log_grep.inc
8# InnoDB
9--let grep_pattern = ^# InnoDB_trx_id: \w+\$
10--source include/log_grep.inc
11# Query plan
12--let grep_pattern = ^# Bytes_sent: \d+ Tmp_tables: \d+ Tmp_disk_tables: \d+ Tmp_table_sizes: \d+\$
13--source include/log_grep.inc
14--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)\$
15--source include/log_grep.inc
16--let grep_pattern = ^# Filesort: (Yes|No) Filesort_on_disk: (Yes|No) Merge_passes: \d+\$
17--source include/log_grep.inc
18# InnoDB
19--let grep_pattern = ^# InnoDB_IO_r_ops: \d+ InnoDB_IO_r_bytes: \d+ InnoDB_IO_r_wait: \d*\.\d*\$
20--source include/log_grep.inc
21--let grep_pattern = ^# InnoDB_rec_lock_wait: \d*\.\d* InnoDB_queue_wait: \d*\.\d*\$
22--source include/log_grep.inc
23--let grep_pattern = ^# InnoDB_pages_distinct: \d+\$
24--source include/log_grep.inc
25--let grep_pattern = ^# No InnoDB statistics available for this query\$
26--source include/log_grep.inc
027
=== 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 @@
9# User@Host: root[root] @ localhost []9# User@Host: root[root] @ localhost []
10# Thread_id: X Schema: test Last_errno: X Killed: X10# Thread_id: X Schema: test Last_errno: X Killed: X
11# Query_time: X.X Lock_time: X.X Rows_sent: X Rows_examined: X Rows_affected: X Rows_read: X11# Query_time: X.X Lock_time: X.X Rows_sent: X Rows_examined: X Rows_affected: X Rows_read: X
12# Bytes_sent: X Tmp_tables: X Tmp_disk_tables: X Tmp_table_sizes: X12# Bytes_sent: X
13# 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 13# 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
14# Profile_total: X.X Profile_total_cpu: X.X 14# Profile_total: X.X Profile_total_cpu: X.X
15# User@Host: root[root] @ localhost []15# User@Host: root[root] @ localhost []
16# Thread_id: X Schema: test Last_errno: X Killed: X16# Thread_id: X Schema: test Last_errno: X Killed: X
17# Query_time: X.X Lock_time: X.X Rows_sent: X Rows_examined: X Rows_affected: X Rows_read: X17# Query_time: X.X Lock_time: X.X Rows_sent: X Rows_examined: X Rows_affected: X Rows_read: X
18# Bytes_sent: X Tmp_tables: X Tmp_disk_tables: X Tmp_table_sizes: X18# Bytes_sent: X
19# 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 19# 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
20# Profile_total: X.X Profile_total_cpu: X.X 20# Profile_total: X.X Profile_total_cpu: X.X
21SET GLOBAL slow_query_log_file=@old_slow_query_log_file;21SET GLOBAL slow_query_log_file=@old_slow_query_log_file;
2222
=== 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 @@
1SHOW GLOBAL VARIABLES like 'log_slow_admin_statements';1DROP TABLE IF EXISTS t1;
2Variable_name Value2CREATE TABLE t1 (a INT);
3log_slow_admin_statements OFF3SET SESSION min_examined_row_limit=0;
4SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='log_slow_admin_statements';4SET SESSION long_query_time=0;
5VARIABLE_NAME VARIABLE_VALUE5SET GLOBAL log_slow_admin_statements=ON;
6LOG_SLOW_ADMIN_STATEMENTS OFF6[log_start.inc] percona_log_slow_admin_stmt_1
7ALTER TABLE t1 ADD INDEX a(a);
8[log_stop.inc] percona_log_slow_admin_stmt_1
9[log_grep.inc] file: percona_log_slow_admin_stmt_1 pattern: ALTER TABLE t1 ADD INDEX a\(a\);
10[log_grep.inc] lines: 1
11[log_start.inc] percona_log_slow_admin_stmt_2
12ALTER TABLE t1 DROP INDEX a;
13[log_stop.inc] percona_log_slow_admin_stmt_2
14[log_grep.inc] file: percona_log_slow_admin_stmt_2 pattern: ALTER TABLE t1 DROP INDEX a;
15[log_grep.inc] lines: 0
716
=== 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 @@
1CREATE TABLE t(id INT PRIMARY KEY);
2INSERT INTO t VALUES(1);
3INSERT INTO t VALUES(2);
4INSERT INTO t VALUES(3);
5SET long_query_time=1;
6SET log_slow_filter=full_join;
7[log_start.inc] percona.slow_extended.log_slow_filter
8SET query_exec_time = 1.1;
9SELECT * FROM t AS t1, t AS t2;
10SET query_exec_time = default;
11[log_stop.inc] percona.slow_extended.log_slow_filter
12SET log_slow_filter=default;
13SET long_query_time=default;
14[log_grep.inc] file: percona.slow_extended.log_slow_filter pattern: Query_time
15[log_grep.inc] lines: 1
160
=== 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 @@
1DROP TABLE IF EXISTS t1, t2;
2CREATE TABLE t1(a INT) ENGINE=InnoDB;
3INSERT INTO t1 VALUE(1);
4CREATE TABLE t2(a INT) ENGINE=InnoDB;
5INSERT INTO t2 VALUE(1);
6SET SESSION min_examined_row_limit=0;
7SET SESSION long_query_time=0;
8SET @old_log_slow_verbosity := @@log_slow_verbosity;
9SET SESSION log_slow_verbosity='microtime,innodb';
10[log_start.inc] percona.slow_extended.innodb_0
11INSERT INTO t1 VALUES(2);
12INSERT INTO t2 VALUES(2);
13INSERT INTO t1 VALUES(3);
14SELECT 5;
155
165
17[log_stop.inc] percona.slow_extended.innodb_0
18LOCK TABLE t1 WRITE;
19[log_start.inc] percona.slow_extended.innodb_3
20LOCK TABLE t1 WRITE;
21SELECT SLEEP(5);
22SLEEP(5)
230
24UNLOCK TABLES;
25[log_stop.inc] percona.slow_extended.innodb_3
26UNLOCK TABLES;
27BEGIN;
28SELECT * FROM t2 FOR UPDATE;
29a
301
312
32[log_start.inc] percona.slow_extended.innodb_4
33DELETE FROM t2 WHERE a=2;
34SELECT SLEEP(5);
35SLEEP(5)
360
37COMMIT;
38[log_stop.inc] percona.slow_extended.innodb_4
39SET SESSION min_examined_row_limit=default;
40SET SESSION long_query_time=default;
41SET SESSION log_slow_verbosity=@old_log_slow_verbosity;
42DROP TABLE t1, t2;
043
=== 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 @@
1FLUSH STATUS;
2DROP TABLE IF EXISTS t1;
3CREATE TABLE t1(
4a INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
5b INT) ENGINE=InnoDB;
6INSERT INTO t1 VALUES(NULL, 10), (NULL, 5);
7SET SESSION long_query_time=0;
8SET SESSION min_examined_row_limit=0;
9SET SESSION log_slow_verbosity='microtime,query_plan';
10EXPLAIN SELECT * FROM t1;
11id select_type table type possible_keys key key_len ref rows Extra
121 SIMPLE t1 ALL NULL NULL NULL NULL 2
13[log_start.inc] percona_slow_query_log.query_plan_0
14SELECT * FROM t1;
15a b
161 10
172 5
18[log_stop.inc] percona_slow_query_log.query_plan_0
19[log_grep.inc] file: percona_slow_query_log.query_plan_0 pattern: ^# Filesort: No Filesort_on_disk: No Merge_passes: 0$
20[log_grep.inc] lines: 2
21id select_type table type possible_keys key key_len ref rows Extra
221 SIMPLE t1 ALL NULL NULL NULL NULL 2 Using filesort
23[log_start.inc] percona_slow_query_log.query_plan_1
24SELECT * FROM t1 ORDER BY b;
25a b
262 5
271 10
28[log_stop.inc] percona_slow_query_log.query_plan_1
29[log_grep.inc] file: percona_slow_query_log.query_plan_1 pattern: ^# Filesort: Yes Filesort_on_disk: No Merge_passes: 0$
30[log_grep.inc] lines: 1
31[log_start.inc] percona_slow_query_log.query_plan_1a
32SELECT * FROM t1 ORDER BY b;
33a b
342 5
351 10
36[log_stop.inc] percona_slow_query_log.query_plan_1a
37[log_grep.inc] file: percona_slow_query_log.query_plan_1a pattern: ^# Filesort: Yes Filesort_on_disk: No Merge_passes: 0$
38[log_grep.inc] lines: 0
39Variable_name Value
40Sort_merge_passes 0
41id select_type table type possible_keys key key_len ref rows Extra
421 SIMPLE t2 ALL NULL NULL NULL NULL ROWS Using filesort
43[log_start.inc] percona_slow_query_log.query_plan_2
44SELECT * FROM t2 ORDER BY a;
45[log_stop.inc] percona_slow_query_log.query_plan_2
46[log_grep.inc] file: percona_slow_query_log.query_plan_2 pattern: ^# Filesort: Yes Filesort_on_disk: Yes Merge_passes: 1$
47[log_grep.inc] lines: 1
48Variable_name Value
49Sort_merge_passes 1
50[log_start.inc] percona_slow_query_log.query_plan_2a
51SELECT * FROM t2 ORDER BY a;
52[log_stop.inc] percona_slow_query_log.query_plan_2a
53[log_grep.inc] file: percona_slow_query_log.query_plan_2a pattern: ^# Filesort: Yes Filesort_on_disk: Yes Merge_passes: 1$
54[log_grep.inc] lines: 0
55Variable_name Value
56Sort_merge_passes 2
57[log_start.inc] percona_slow_query_log.query_plan_3
58SELECT * FROM t2 ORDER BY a;
59[log_stop.inc] percona_slow_query_log.query_plan_3
60[log_grep.inc] file: percona_slow_query_log.query_plan_3 pattern: ^# Filesort: Yes Filesort_on_disk: Yes Merge_passes: 4$
61[log_grep.inc] lines: 1
62Variable_name Value
63Sort_merge_passes 6
64Variable_name Value
65Select_scan 37
66[log_start.inc] percona_slow_query_log.query_plan_4
67SELECT * FROM t1 WHERE a=1;
68a b
691 10
70[log_stop.inc] percona_slow_query_log.query_plan_4
71[log_grep.inc] file: percona_slow_query_log.query_plan_4 pattern: ^#.*Full_scan: No.*$
72[log_grep.inc] lines: 2
73Variable_name Value
74Select_scan 40
75[log_start.inc] percona_slow_query_log.query_plan_5
76SELECT COUNT(*) FROM t1;
77COUNT(*)
782
79[log_stop.inc] percona_slow_query_log.query_plan_5
80[log_grep.inc] file: percona_slow_query_log.query_plan_5 pattern: ^#.*Full_scan: Yes.*$
81[log_grep.inc] lines: 1
82Variable_name Value
83Select_scan 44
84[log_start.inc] percona_slow_query_log.query_plan_5a
85SELECT COUNT(*) FROM t1;
86COUNT(*)
872
88[log_stop.inc] percona_slow_query_log.query_plan_5a
89[log_grep.inc] file: percona_slow_query_log.query_plan_5a pattern: ^#.*Full_scan: Yes.*$
90[log_grep.inc] lines: 0
91Variable_name Value
92Select_scan 48
93Variable_name Value
94Select_full_join 0
95[log_start.inc] percona_slow_query_log.query_plan_6
96SELECT COUNT(*) FROM t1, t3 WHERE t1.a = t3.a;
97COUNT(*)
982
99[log_stop.inc] percona_slow_query_log.query_plan_6
100[log_grep.inc] file: percona_slow_query_log.query_plan_6 pattern: ^#.*Full_join: No.*$
101[log_grep.inc] lines: 2
102Variable_name Value
103Select_full_join 0
104[log_start.inc] percona_slow_query_log.query_plan_7
105SELECT COUNT(*) FROM t1, t2 WHERE t1.b = t2.a;
106COUNT(*)
1078192
108[log_stop.inc] percona_slow_query_log.query_plan_7
109[log_grep.inc] file: percona_slow_query_log.query_plan_7 pattern: ^#.*Full_join: Yes.*$
110[log_grep.inc] lines: 1
111Variable_name Value
112Select_full_join 1
113[log_start.inc] percona_slow_query_log.query_plan_7a
114SELECT COUNT(*) FROM t1, t2 WHERE t1.b = t2.a;
115COUNT(*)
1168192
117[log_stop.inc] percona_slow_query_log.query_plan_7a
118[log_grep.inc] file: percona_slow_query_log.query_plan_7a pattern: ^#.*Full_join: Yes.*$
119[log_grep.inc] lines: 0
120Variable_name Value
121Select_full_join 2
122Variable_name Value
123Created_tmp_tables 49
124Variable_name Value
125Created_tmp_disk_tables 0
126id select_type table type possible_keys key key_len ref rows Extra
1271 SIMPLE t1 index NULL PRIMARY 4 NULL 2 Using index
128[log_start.inc] percona_slow_query_log.query_plan_8
129SELECT COUNT(*) FROM t1;
130COUNT(*)
1312
132[log_stop.inc] percona_slow_query_log.query_plan_8
133[log_grep.inc] file: percona_slow_query_log.query_plan_8 pattern: ^#.*Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0$
134[log_grep.inc] lines: 2
135[log_grep.inc] file: percona_slow_query_log.query_plan_8 pattern: ^#.*Tmp_table: No Tmp_table_on_disk: No$
136[log_grep.inc] lines: 2
137Variable_name Value
138Created_tmp_tables 52
139Variable_name Value
140Created_tmp_disk_tables 0
141id select_type table type possible_keys key key_len ref rows Extra
1421 SIMPLE t1 index PRIMARY PRIMARY 4 NULL 2 Using index; Using temporary; Using filesort
1431 SIMPLE t3 eq_ref PRIMARY PRIMARY 4 test.t1.a 1 Using index
144[log_start.inc] percona_slow_query_log.query_plan_9
145SELECT COUNT(*) FROM t1, t3 WHERE t1.a = t3.a GROUP BY t3.a;
146COUNT(*)
1471
1481
149[log_stop.inc] percona_slow_query_log.query_plan_9
150[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]*$
151[log_grep.inc] lines: 1
152[log_grep.inc] file: percona_slow_query_log.query_plan_9 pattern: ^#.*Tmp_table: Yes Tmp_table_on_disk: No$
153[log_grep.inc] lines: 1
154Variable_name Value
155Created_tmp_tables 56
156Variable_name Value
157Created_tmp_disk_tables 0
158[log_start.inc] percona_slow_query_log.query_plan_9a
159SELECT COUNT(*) FROM t1, t3 WHERE t1.a = t3.a GROUP BY t3.a;
160COUNT(*)
1611
1621
163[log_stop.inc] percona_slow_query_log.query_plan_9a
164[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]*$
165[log_grep.inc] lines: 0
166[log_grep.inc] file: percona_slow_query_log.query_plan_9a pattern: ^#.*Tmp_table: Yes Tmp_table_on_disk: No$
167[log_grep.inc] lines: 0
168Variable_name Value
169Created_tmp_tables 60
170Variable_name Value
171Created_tmp_disk_tables 0
172id select_type table type possible_keys key key_len ref rows Extra
1731 SIMPLE t1 index PRIMARY PRIMARY 4 NULL 2 Using index; Using temporary; Using filesort
1741 SIMPLE t4 eq_ref PRIMARY PRIMARY 4 test.t1.a 1 Using index
175[log_start.inc] percona_slow_query_log.query_plan_10
176SELECT COUNT(*) FROM t1, t4 WHERE t1.a = t4.a GROUP BY t4.b;
177COUNT(*)
1781
1791
180[log_stop.inc] percona_slow_query_log.query_plan_10
181[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]*$
182[log_grep.inc] lines: 1
183[log_grep.inc] file: percona_slow_query_log.query_plan_10 pattern: ^#.*Tmp_table: Yes Tmp_table_on_disk: Yes$
184[log_grep.inc] lines: 1
185Variable_name Value
186Created_tmp_tables 64
187Variable_name Value
188Created_tmp_disk_tables 1
189[log_start.inc] percona_slow_query_log.query_plan_10a
190SELECT COUNT(*) FROM t1, t4 WHERE t1.a = t4.a GROUP BY t4.b;
191COUNT(*)
1921
1931
194[log_stop.inc] percona_slow_query_log.query_plan_10a
195[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]*$
196[log_grep.inc] lines: 0
197[log_grep.inc] file: percona_slow_query_log.query_plan_10a pattern: ^#.*Tmp_table: Yes Tmp_table_on_disk: Yes$
198[log_grep.inc] lines: 0
199Variable_name Value
200Created_tmp_tables 68
201Variable_name Value
202Created_tmp_disk_tables 2
0203
=== 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 @@
1FLUSH STATUS;
2SET SESSION min_examined_row_limit=0;
3DROP TABLE IF EXISTS t1;
4CREATE TABLE t1 (a INT) ENGINE=InnoDB;
5INSERT INTO t1 VALUE(5);
6SET SESSION query_cache_type=1;
7SET GLOBAL query_cache_size=1355776;
8SET SESSION long_query_time=0;
9SET SESSION log_slow_verbosity='microtime,query_plan';
10[log_start.inc] percona_slow_query_log.query_plan_qc_1
11SELECT * FROM t1;
12a
135
14[log_stop.inc] percona_slow_query_log.query_plan_qc_1
15[log_grep.inc] file: percona_slow_query_log.query_plan_qc_1 pattern: ^# QC_Hit: No.*$
16[log_grep.inc] lines: 2
17Variable_name Value
18Qcache_hits 0
19[log_start.inc] percona_slow_query_log.query_plan_qc_2
20SELECT * FROM t1;
21a
225
23[log_stop.inc] percona_slow_query_log.query_plan_qc_2
24[log_grep.inc] file: percona_slow_query_log.query_plan_qc_2 pattern: ^# QC_Hit: Yes.*$
25[log_grep.inc] lines: 1
26Variable_name Value
27Qcache_hits 1
28[log_start.inc] percona_slow_query_log.query_plan_qc_3
29SELECT * FROM t1 WHERE a > 5;
30a
31[log_stop.inc] percona_slow_query_log.query_plan_qc_3
32[log_grep.inc] file: percona_slow_query_log.query_plan_qc_3 pattern: ^# QC_Hit: No.*$
33[log_grep.inc] lines: 0
34Variable_name Value
35Qcache_hits 1
036
=== 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 @@
1include/master-slave.inc1include/master-slave.inc
2[connection master]2[connection master]
3SET SESSION min_examined_row_limit=0;
3DROP TABLE IF EXISTS t;4DROP TABLE IF EXISTS t;
4CREATE TABLE t(id INT,data CHAR(30)) ENGINE=InnoDB;5CREATE TABLE t(id INT,data CHAR(30)) ENGINE=InnoDB;
5INSERT INTO t VALUES6INSERT INTO t VALUES
@@ -10,8 +11,12 @@
10(5,"aaaaabbbbbcccccdddddeeeeefffff");11(5,"aaaaabbbbbcccccdddddeeeeefffff");
11INSERT INTO t SELECT t2.id,t2.data from t as t1, t as t2;12INSERT INTO t SELECT t2.id,t2.data from t as t1, t as t2;
12INSERT INTO t SELECT t2.id,t2.data from t as t1, t as t2;13INSERT INTO t SELECT t2.id,t2.data from t as t1, t as t2;
13include/rpl_restart_server.inc [server_number=1]14SET GLOBAL long_query_time=0;
15SET GLOBAL log_slow_slave_statements=TRUE;
16SET GLOBAL log_slow_verbosity='innodb';
17include/restart_slave.inc
14[log_start.inc] percona.slow_extended.log_slow_slave_statements-innodb18[log_start.inc] percona.slow_extended.log_slow_slave_statements-innodb
19INSERT INTO t SELECT t.id,t.data from t;
15[log_stop.inc] percona.slow_extended.log_slow_slave_statements-innodb20[log_stop.inc] percona.slow_extended.log_slow_slave_statements-innodb
16[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements-innodb pattern: InnoDB_IO_r_ops21[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements-innodb pattern: InnoDB_IO_r_ops
17[log_grep.inc] lines: 122[log_grep.inc] lines: 1
1823
=== 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 @@
1include/master-slave.inc1include/master-slave.inc
2[connection master]2[connection master]
3DROP TABLE IF EXISTS t;3DROP TABLE IF EXISTS t;
4CREATE TABLE t(id INT);4CREATE TABLE t(id INT) ENGINE=InnoDB;
5SET GLOBAL min_examined_row_limit=0;
6SET GLOBAL long_query_time=0;
7SET GLOBAL log_slow_slave_statements=OFF;
8include/restart_slave.inc
5[log_start.inc] percona.slow_extended.log_slow_slave_statements9[log_start.inc] percona.slow_extended.log_slow_slave_statements
6LINE 110INSERT INTO t VALUES (1);
7LOG_SLOW_SLAVE_STATAMENTS is OFF11SET GLOBAL log_slow_slave_statements=ON;
8LOG_SLOW_SLAVE_STATEMENTS=112BEGIN;
9LOG_SLOW_SLAVE_STATAMENTS is ON13INSERT INTO t VALUES (2);
10LINE 214COMMIT;
11include/restart_slave.inc15SET GLOBAL log_slow_slave_statements=OFF;
12LOG_SLOW_SLAVE_STATAMENTS is ON16INSERT INTO t VALUES (3);
13LINE 3
14LOG_SLOW_SLAVE_STATAMENTS is ON
15LOG_SLOW_SLAVE_STATEMENTS=0
16LOG_SLOW_SLAVE_STATAMENTS is OFF
17LINE 4
18include/restart_slave.inc
19LOG_SLOW_SLAVE_STATAMENTS is OFF
20LINE 5
21LOG_SLOW_SLAVE_STATAMENTS is OFF
22LOG_SLOW_SLAVE_STATEMENTS=1
23LOG_SLOW_SLAVE_STATAMENTS is ON
24LINE 6
25include/restart_slave.inc
26LOG_SLOW_SLAVE_STATAMENTS is ON
27LINE 7
28[log_stop.inc] percona.slow_extended.log_slow_slave_statements17[log_stop.inc] percona.slow_extended.log_slow_slave_statements
29SET GLOBAL log_slow_slave_statements=default;
30[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(1\)18[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(1\)
31[log_grep.inc] lines: 019[log_grep.inc] lines: 0
32[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(2\)20[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(2\)
33[log_grep.inc] lines: 021[log_grep.inc] lines: 1
34[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(3\)22[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(3\)
35[log_grep.inc] lines: 123[log_grep.inc] lines: 0
36[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(4\)24[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: ^# User@Host: \[SQL_SLAVE\] @ \[\]
37[log_grep.inc] lines: 025[log_grep.inc] lines: 2
38[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(5\)
39[log_grep.inc] lines: 0
40[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(6\)
41[log_grep.inc] lines: 0
42[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(7\)
43[log_grep.inc] lines: 1
44[log_grep.inc] file: percona.slow_extended.log_slow_slave_statements pattern: INSERT INTO t VALUES \(8\)
45[log_grep.inc] lines: 0
46include/rpl_end.inc26include/rpl_end.inc
4727
=== 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 @@
1SET long_query_time=1;1DROP PROCEDURE IF EXISTS test_f;
2SET GLOBAL log_slow_sp_statements=1;2SET SESSION min_examined_row_limit=0;
3[log_start.inc] percona.slow_extended.log_slow_sp_statements3SET SESSION long_query_time=0;
4SET SESSION query_cache_type=0;
4CREATE PROCEDURE test_f()5CREATE PROCEDURE test_f()
5BEGIN6BEGIN
6SET SESSION query_exec_time=1.1; SELECT 1;7SELECT 1;
7SET SESSION query_exec_time=2.1; SELECT 1;
8SET SESSION query_exec_time=3.1; SELECT 1;
9SET SESSION query_exec_time=default;
10END^8END^
11CALL test_f();9SET GLOBAL log_slow_sp_statements=ON;
12110[log_start.inc] percona.slow_extended.sp1
13111CALL test_f();
141121
151131
16114[log_stop.inc] percona.slow_extended.sp1
17115[log_grep.inc] file: percona.slow_extended.sp1 pattern: SELECT 1;
18[log_stop.inc] percona.slow_extended.log_slow_sp_statements16[log_grep.inc] lines: 1
19SET GLOBAL log_slow_sp_statements=default;17[log_start.inc] percona.slow_extended.sp2
20SET long_query_time=default;18CALL test_f();
21[log_grep.inc] file: percona.slow_extended.log_slow_sp_statements pattern: Query_time191
22[log_grep.inc] lines: 3201
21[log_stop.inc] percona.slow_extended.sp2
22[log_grep.inc] file: percona.slow_extended.sp2 pattern: SELECT 1;
23[log_grep.inc] lines: 0
2324
=== 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 @@
1SET long_query_time=2;1SET SESSION min_examined_row_limit=0;
2SET GLOBAL log_slow_timestamp_every=1;2SET SESSION long_query_time=0;
3[log_start.inc] percona.slow_extended.log_slow_timestamp_every3SET GLOBAL log_slow_timestamp_every=TRUE;
4SET SESSION query_exec_time=2.1;4[log_start.inc] percona_slow_extended_query_log_1
5SELECT 1;5SELECT 1;
6161
7171
8SELECT 2;8SELECT 2;
9292
102102
11SELECT 3;11[log_stop.inc] percona_slow_extended_query_log_1
12312[log_grep.inc] file: percona_slow_extended_query_log_1 pattern: ^# Time: \d{6} (\d| )\d:\d\d:\d\d$
13313[log_grep.inc] lines: 3
14SET GLOBAL log_slow_timestamp_every=0;
15SELECT 1;
161
171
18SELECT 2;
192
202
21SELECT 3;
223
233
24SET GLOBAL log_slow_timestamp_every=1;
25SELECT 1;
261
271
28SELECT 2;
292
302
31SELECT 3;
323
333
34SET SESSION query_exec_time = default;
35[log_stop.inc] percona.slow_extended.log_slow_timestamp_every
36SET GLOBAL log_slow_timestamp_every=default;
37SET long_query_time=default;
38[log_grep.inc] file: percona.slow_extended.log_slow_timestamp_every pattern: # Time: [0-9]+[ ]+[0-9]+:[0-9]+:[0-9]+
39[log_grep.inc] lines: 6
4014
=== 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 @@
1SET SESSION long_query_time=1;1DROP TABLE IF EXISTS t1;
2[log_start.inc] percona.slow_extended.log_slow_verbosity2CREATE TABLE t1(a INT) ENGINE=InnoDB;
3SET SESSION query_exec_time=2.1;3SET SESSION min_examined_row_limit=0;
4SELECT 1;4SET SESSION long_query_time=0;
515SET SESSION log_slow_verbosity='microtime,innodb,query_plan';
616[log_start.inc] percona.slow_extended.log_slow_verbosity_0
7SET SESSION log_slow_verbosity=innodb;7INSERT INTO t1 VALUE(0);
8SELECT 1;8[log_stop.inc] percona.slow_extended.log_slow_verbosity_0
919log_slow_verbosity='microtime,innodb,query_plan':
10110[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^# Thread_id: \d+ Schema: .+ Last_errno: \d+ Killed: \d+$
11SET SESSION query_exec_time=default;11[log_grep.inc] lines: 2
12[log_stop.inc] percona.slow_extended.log_slow_verbosity12[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^#.*Rows_affected: \d+ Rows_read: \d+$
13SET log_slow_verbosity='';13[log_grep.inc] lines: 2
14SET long_query_time=default;14[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^# Bytes_sent: \d+.*$
15[log_grep.inc] file: percona.slow_extended.log_slow_verbosity pattern: No InnoDB statistics available for this query15[log_grep.inc] lines: 2
16[log_grep.inc] lines: 116[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^# InnoDB_trx_id: \w+$
17[log_grep.inc] lines: 1
18[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+$
19[log_grep.inc] lines: 2
20[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)$
21[log_grep.inc] lines: 2
22[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^# Filesort: (Yes|No) Filesort_on_disk: (Yes|No) Merge_passes: \d+$
23[log_grep.inc] lines: 2
24[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*$
25[log_grep.inc] lines: 1
26[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^# InnoDB_rec_lock_wait: \d*\.\d* InnoDB_queue_wait: \d*\.\d*$
27[log_grep.inc] lines: 1
28[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^# InnoDB_pages_distinct: \d+$
29[log_grep.inc] lines: 1
30[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_0 pattern: ^# No InnoDB statistics available for this query$
31[log_grep.inc] lines: 1
32[log_start.inc] percona.slow_extended.log_slow_verbosity_1
33SELECT 1;
341
351
36[log_stop.inc] percona.slow_extended.log_slow_verbosity_1
37log_slow_verbosity='microtime,innodb,query_plan':
38[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# Thread_id: \d+ Schema: .+ Last_errno: \d+ Killed: \d+$
39[log_grep.inc] lines: 2
40[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^#.*Rows_affected: \d+ Rows_read: \d+$
41[log_grep.inc] lines: 2
42[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# Bytes_sent: \d+.*$
43[log_grep.inc] lines: 2
44[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# InnoDB_trx_id: \w+$
45[log_grep.inc] lines: 0
46[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+$
47[log_grep.inc] lines: 2
48[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)$
49[log_grep.inc] lines: 2
50[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# Filesort: (Yes|No) Filesort_on_disk: (Yes|No) Merge_passes: \d+$
51[log_grep.inc] lines: 2
52[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*$
53[log_grep.inc] lines: 0
54[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# InnoDB_rec_lock_wait: \d*\.\d* InnoDB_queue_wait: \d*\.\d*$
55[log_grep.inc] lines: 0
56[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# InnoDB_pages_distinct: \d+$
57[log_grep.inc] lines: 0
58[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_1 pattern: ^# No InnoDB statistics available for this query$
59[log_grep.inc] lines: 2
60[log_start.inc] percona.slow_extended.log_slow_verbosity_2
61INSERT INTO t1 VALUE(1);
62[log_stop.inc] percona.slow_extended.log_slow_verbosity_2
63log_slow_verbosity='microtime':
64[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^# Thread_id: \d+ Schema: .+ Last_errno: \d+ Killed: \d+$
65[log_grep.inc] lines: 2
66[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^#.*Rows_affected: \d+ Rows_read: \d+$
67[log_grep.inc] lines: 2
68[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^# Bytes_sent: \d+.*$
69[log_grep.inc] lines: 2
70[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^# InnoDB_trx_id: \w+$
71[log_grep.inc] lines: 0
72[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+$
73[log_grep.inc] lines: 0
74[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)$
75[log_grep.inc] lines: 0
76[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^# Filesort: (Yes|No) Filesort_on_disk: (Yes|No) Merge_passes: \d+$
77[log_grep.inc] lines: 0
78[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*$
79[log_grep.inc] lines: 0
80[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^# InnoDB_rec_lock_wait: \d*\.\d* InnoDB_queue_wait: \d*\.\d*$
81[log_grep.inc] lines: 0
82[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^# InnoDB_pages_distinct: \d+$
83[log_grep.inc] lines: 0
84[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_2 pattern: ^# No InnoDB statistics available for this query$
85[log_grep.inc] lines: 0
86[log_start.inc] percona.slow_extended.log_slow_verbosity_3
87INSERT INTO t1 VALUE(2);
88[log_stop.inc] percona.slow_extended.log_slow_verbosity_3
89log_slow_verbosity='query_plan':
90[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^# Thread_id: \d+ Schema: .+ Last_errno: \d+ Killed: \d+$
91[log_grep.inc] lines: 2
92[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^#.*Rows_affected: \d+ Rows_read: \d+$
93[log_grep.inc] lines: 2
94[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^# Bytes_sent: \d+.*$
95[log_grep.inc] lines: 2
96[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^# InnoDB_trx_id: \w+$
97[log_grep.inc] lines: 0
98[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+$
99[log_grep.inc] lines: 2
100[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)$
101[log_grep.inc] lines: 2
102[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^# Filesort: (Yes|No) Filesort_on_disk: (Yes|No) Merge_passes: \d+$
103[log_grep.inc] lines: 2
104[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*$
105[log_grep.inc] lines: 0
106[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^# InnoDB_rec_lock_wait: \d*\.\d* InnoDB_queue_wait: \d*\.\d*$
107[log_grep.inc] lines: 0
108[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^# InnoDB_pages_distinct: \d+$
109[log_grep.inc] lines: 0
110[log_grep.inc] file: percona.slow_extended.log_slow_verbosity_3 pattern: ^# No InnoDB statistics available for this query$
111[log_grep.inc] lines: 0
17112
=== 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 @@
1SET SESSION min_examined_row_limit=0;
1SET long_query_time=2;2SET long_query_time=2;
2[log_start.inc] percona.slow_extended.long_query_time3[log_start.inc] percona.slow_extended.long_query_time
3SET SESSION query_exec_time=1.1;4SET SESSION query_exec_time=1.1;
@@ -29,5 +30,6 @@
29SET long_query_time=2;30SET long_query_time=2;
30[log_stop.inc] percona.slow_extended.long_query_time31[log_stop.inc] percona.slow_extended.long_query_time
31SET long_query_time=default;32SET long_query_time=default;
33SET SESSION min_examined_row_limit=default;
32[log_grep.inc] file: percona.slow_extended.long_query_time pattern: Query_time34[log_grep.inc] file: percona.slow_extended.long_query_time pattern: Query_time
33[log_grep.inc] lines: 335[log_grep.inc] lines: 3
3436
=== 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 @@
4SET @old_log_slow_sp_statements=@@log_slow_sp_statements;4SET @old_log_slow_sp_statements=@@log_slow_sp_statements;
5SET @old_slow_query_log_microseconds_timestamp=@@slow_query_log_microseconds_timestamp;5SET @old_slow_query_log_microseconds_timestamp=@@slow_query_log_microseconds_timestamp;
6SET @old_log_slow_admin_statements=@@log_slow_admin_statements;6SET @old_log_slow_admin_statements=@@log_slow_admin_statements;
7SET GLOBAL long_query_time=1;
8SET SESSION query_exec_time=0.5;
9[log_start.inc] percona.mysqldumpslow
10SET GLOBAL log_slow_verbosity='innodb,query_plan,microtime';
11SET GLOBAL log_slow_timestamp_every=1;
12SET GLOBAL log_slow_sp_statements=1;
13SET GLOBAL slow_query_log_microseconds_timestamp=1;
14SET GLOBAL log_slow_admin_statements=1;
15DROP TABLE IF EXISTS t1;
16DROP TABLE IF EXISTS t2;
17SET SESSION query_exec_time=1.11;
18SET SESSION slow_query_log_query_time=1.11;
19SET SESSION slow_query_log_lock_time=0.1;
20CREATE TABLE t1(id INT) ENGINE=InnoDB;
21SET SESSION query_exec_time=1.22;
22SET SESSION slow_query_log_query_time=1.22;
23SET SESSION slow_query_log_lock_time=0.2;
24CREATE TABLE t2(id INT) ENGINE=MyISAM;
25SET SESSION query_exec_time=1.33;
26SET SESSION slow_query_log_query_time=1.33;
27SET SESSION slow_query_log_lock_time=0.3;
28INSERT INTO t1 VALUES(0);
29SET SESSION query_exec_time=1.44;
30SET SESSION slow_query_log_query_time=1.44;
31SET SESSION slow_query_log_lock_time=0.4;
32INSERT INTO t1 VALUES(1);
33SET SESSION query_exec_time=1.55;
34SET SESSION slow_query_log_query_time=1.55;
35SET SESSION slow_query_log_lock_time=0.5;
36INSERT INTO t1 VALUES(2);
37SET SESSION query_exec_time=1.66;
38SET SESSION slow_query_log_query_time=1.66;
39SET SESSION slow_query_log_lock_time=0.6;
40INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
41SET SESSION query_exec_time=1.77;
42SET SESSION slow_query_log_query_time=1.77;
43SET SESSION slow_query_log_lock_time=0.7;
44INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
45SET SESSION query_exec_time=1.88;
46SET SESSION slow_query_log_query_time=1.88;
47SET SESSION slow_query_log_lock_time=0.8;
48INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
49SET SESSION query_exec_time=1.99;
50SET SESSION slow_query_log_query_time=1.99;
51SET SESSION slow_query_log_lock_time=0.9;
52INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
53SET SESSION query_exec_time=2.1;
54SET SESSION slow_query_log_query_time=2.1;
55SET SESSION slow_query_log_lock_time=1.0;
56SELECT COUNT(*) FROM t1;
57COUNT(*)
5812
59SET SESSION query_exec_time=2.21;
60SET SESSION slow_query_log_query_time=2.21;
61SET SESSION slow_query_log_lock_time=1.1;
62SELECT COUNT(*) FROM t2;
63COUNT(*)
6424
65SET SESSION query_exec_time=2.32;
66SET SESSION slow_query_log_query_time=2.32;
67SET SESSION slow_query_log_lock_time=1.2;
68DROP TABLE t1;
69SET SESSION query_exec_time=2.43;
70SET SESSION slow_query_log_query_time=2.43;
71SET SESSION slow_query_log_lock_time=1.3;
72DROP TABLE t2;
73SET SESSION query_exec_time=2.54;
74SET SESSION slow_query_log_query_time=2.54;
75SET SESSION slow_query_log_lock_time=1.4;
76SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
77SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
78SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
79SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
80SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
81SET GLOBAL log_slow_verbosity='innodb,query_plan,microtime';
82SET GLOBAL log_slow_timestamp_every=1;
83SET GLOBAL log_slow_sp_statements=1;
84SET GLOBAL slow_query_log_microseconds_timestamp=1;
85SET GLOBAL log_slow_admin_statements=0;
86DROP TABLE IF EXISTS t1;
87DROP TABLE IF EXISTS t2;
88SET SESSION query_exec_time=1.11;
89SET SESSION slow_query_log_query_time=1.11;
90SET SESSION slow_query_log_lock_time=0.1;
91CREATE TABLE t1(id INT) ENGINE=InnoDB;
92SET SESSION query_exec_time=1.22;
93SET SESSION slow_query_log_query_time=1.22;
94SET SESSION slow_query_log_lock_time=0.2;
95CREATE TABLE t2(id INT) ENGINE=MyISAM;
96SET SESSION query_exec_time=1.33;
97SET SESSION slow_query_log_query_time=1.33;
98SET SESSION slow_query_log_lock_time=0.3;
99INSERT INTO t1 VALUES(0);
100SET SESSION query_exec_time=1.44;
101SET SESSION slow_query_log_query_time=1.44;
102SET SESSION slow_query_log_lock_time=0.4;
103INSERT INTO t1 VALUES(1);
104SET SESSION query_exec_time=1.55;
105SET SESSION slow_query_log_query_time=1.55;
106SET SESSION slow_query_log_lock_time=0.5;
107INSERT INTO t1 VALUES(2);
108SET SESSION query_exec_time=1.66;
109SET SESSION slow_query_log_query_time=1.66;
110SET SESSION slow_query_log_lock_time=0.6;
111INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
112SET SESSION query_exec_time=1.77;
113SET SESSION slow_query_log_query_time=1.77;
114SET SESSION slow_query_log_lock_time=0.7;
115INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
116SET SESSION query_exec_time=1.88;
117SET SESSION slow_query_log_query_time=1.88;
118SET SESSION slow_query_log_lock_time=0.8;
119INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
120SET SESSION query_exec_time=1.99;
121SET SESSION slow_query_log_query_time=1.99;
122SET SESSION slow_query_log_lock_time=0.9;
123INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
124SET SESSION query_exec_time=2.1;
125SET SESSION slow_query_log_query_time=2.1;
126SET SESSION slow_query_log_lock_time=1.0;
127SELECT COUNT(*) FROM t1;
128COUNT(*)
12912
130SET SESSION query_exec_time=2.21;
131SET SESSION slow_query_log_query_time=2.21;
132SET SESSION slow_query_log_lock_time=1.1;
133SELECT COUNT(*) FROM t2;
134COUNT(*)
13524
136SET SESSION query_exec_time=2.32;
137SET SESSION slow_query_log_query_time=2.32;
138SET SESSION slow_query_log_lock_time=1.2;
139DROP TABLE t1;
140SET SESSION query_exec_time=2.43;
141SET SESSION slow_query_log_query_time=2.43;
142SET SESSION slow_query_log_lock_time=1.3;
143DROP TABLE t2;
144SET SESSION query_exec_time=2.54;
145SET SESSION slow_query_log_query_time=2.54;
146SET SESSION slow_query_log_lock_time=1.4;
147SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
148SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
149SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
150SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
151SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
152SET GLOBAL log_slow_verbosity='innodb,query_plan,microtime';
153SET GLOBAL log_slow_timestamp_every=1;
154SET GLOBAL log_slow_sp_statements=1;
155SET GLOBAL slow_query_log_microseconds_timestamp=0;
156SET GLOBAL log_slow_admin_statements=1;
157DROP TABLE IF EXISTS t1;
158DROP TABLE IF EXISTS t2;
159SET SESSION query_exec_time=1.11;
160SET SESSION slow_query_log_query_time=1.11;
161SET SESSION slow_query_log_lock_time=0.1;
162CREATE TABLE t1(id INT) ENGINE=InnoDB;
163SET SESSION query_exec_time=1.22;
164SET SESSION slow_query_log_query_time=1.22;
165SET SESSION slow_query_log_lock_time=0.2;
166CREATE TABLE t2(id INT) ENGINE=MyISAM;
167SET SESSION query_exec_time=1.33;
168SET SESSION slow_query_log_query_time=1.33;
169SET SESSION slow_query_log_lock_time=0.3;
170INSERT INTO t1 VALUES(0);
171SET SESSION query_exec_time=1.44;
172SET SESSION slow_query_log_query_time=1.44;
173SET SESSION slow_query_log_lock_time=0.4;
174INSERT INTO t1 VALUES(1);
175SET SESSION query_exec_time=1.55;
176SET SESSION slow_query_log_query_time=1.55;
177SET SESSION slow_query_log_lock_time=0.5;
178INSERT INTO t1 VALUES(2);
179SET SESSION query_exec_time=1.66;
180SET SESSION slow_query_log_query_time=1.66;
181SET SESSION slow_query_log_lock_time=0.6;
182INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
183SET SESSION query_exec_time=1.77;
184SET SESSION slow_query_log_query_time=1.77;
185SET SESSION slow_query_log_lock_time=0.7;
186INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
187SET SESSION query_exec_time=1.88;
188SET SESSION slow_query_log_query_time=1.88;
189SET SESSION slow_query_log_lock_time=0.8;
190INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
191SET SESSION query_exec_time=1.99;
192SET SESSION slow_query_log_query_time=1.99;
193SET SESSION slow_query_log_lock_time=0.9;
194INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
195SET SESSION query_exec_time=2.1;
196SET SESSION slow_query_log_query_time=2.1;
197SET SESSION slow_query_log_lock_time=1.0;
198SELECT COUNT(*) FROM t1;
199COUNT(*)
20012
201SET SESSION query_exec_time=2.21;
202SET SESSION slow_query_log_query_time=2.21;
203SET SESSION slow_query_log_lock_time=1.1;
204SELECT COUNT(*) FROM t2;
205COUNT(*)
20624
207SET SESSION query_exec_time=2.32;
208SET SESSION slow_query_log_query_time=2.32;
209SET SESSION slow_query_log_lock_time=1.2;
210DROP TABLE t1;
211SET SESSION query_exec_time=2.43;
212SET SESSION slow_query_log_query_time=2.43;
213SET SESSION slow_query_log_lock_time=1.3;
214DROP TABLE t2;
215SET SESSION query_exec_time=2.54;
216SET SESSION slow_query_log_query_time=2.54;
217SET SESSION slow_query_log_lock_time=1.4;
218SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
219SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
220SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
221SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
222SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
223SET GLOBAL log_slow_verbosity='innodb,query_plan,microtime';
224SET GLOBAL log_slow_timestamp_every=1;
225SET GLOBAL log_slow_sp_statements=1;
226SET GLOBAL slow_query_log_microseconds_timestamp=0;
227SET GLOBAL log_slow_admin_statements=0;
228DROP TABLE IF EXISTS t1;
229DROP TABLE IF EXISTS t2;
230SET SESSION query_exec_time=1.11;
231SET SESSION slow_query_log_query_time=1.11;
232SET SESSION slow_query_log_lock_time=0.1;
233CREATE TABLE t1(id INT) ENGINE=InnoDB;
234SET SESSION query_exec_time=1.22;
235SET SESSION slow_query_log_query_time=1.22;
236SET SESSION slow_query_log_lock_time=0.2;
237CREATE TABLE t2(id INT) ENGINE=MyISAM;
238SET SESSION query_exec_time=1.33;
239SET SESSION slow_query_log_query_time=1.33;
240SET SESSION slow_query_log_lock_time=0.3;
241INSERT INTO t1 VALUES(0);
242SET SESSION query_exec_time=1.44;
243SET SESSION slow_query_log_query_time=1.44;
244SET SESSION slow_query_log_lock_time=0.4;
245INSERT INTO t1 VALUES(1);
246SET SESSION query_exec_time=1.55;
247SET SESSION slow_query_log_query_time=1.55;
248SET SESSION slow_query_log_lock_time=0.5;
249INSERT INTO t1 VALUES(2);
250SET SESSION query_exec_time=1.66;
251SET SESSION slow_query_log_query_time=1.66;
252SET SESSION slow_query_log_lock_time=0.6;
253INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
254SET SESSION query_exec_time=1.77;
255SET SESSION slow_query_log_query_time=1.77;
256SET SESSION slow_query_log_lock_time=0.7;
257INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
258SET SESSION query_exec_time=1.88;
259SET SESSION slow_query_log_query_time=1.88;
260SET SESSION slow_query_log_lock_time=0.8;
261INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
262SET SESSION query_exec_time=1.99;
263SET SESSION slow_query_log_query_time=1.99;
264SET SESSION slow_query_log_lock_time=0.9;
265INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
266SET SESSION query_exec_time=2.1;
267SET SESSION slow_query_log_query_time=2.1;
268SET SESSION slow_query_log_lock_time=1.0;
269SELECT COUNT(*) FROM t1;
270COUNT(*)
27112
272SET SESSION query_exec_time=2.21;
273SET SESSION slow_query_log_query_time=2.21;
274SET SESSION slow_query_log_lock_time=1.1;
275SELECT COUNT(*) FROM t2;
276COUNT(*)
27724
278SET SESSION query_exec_time=2.32;
279SET SESSION slow_query_log_query_time=2.32;
280SET SESSION slow_query_log_lock_time=1.2;
281DROP TABLE t1;
282SET SESSION query_exec_time=2.43;
283SET SESSION slow_query_log_query_time=2.43;
284SET SESSION slow_query_log_lock_time=1.3;
285DROP TABLE t2;
286SET SESSION query_exec_time=2.54;
287SET SESSION slow_query_log_query_time=2.54;
288SET SESSION slow_query_log_lock_time=1.4;
289SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
290SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
291SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
292SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
293SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
294SET GLOBAL log_slow_verbosity='innodb,query_plan,microtime';
295SET GLOBAL log_slow_timestamp_every=1;
296SET GLOBAL log_slow_sp_statements=0;
297SET GLOBAL slow_query_log_microseconds_timestamp=1;
298SET GLOBAL log_slow_admin_statements=1;
299DROP TABLE IF EXISTS t1;
300DROP TABLE IF EXISTS t2;
301SET SESSION query_exec_time=1.11;
302SET SESSION slow_query_log_query_time=1.11;
303SET SESSION slow_query_log_lock_time=0.1;
304CREATE TABLE t1(id INT) ENGINE=InnoDB;
305SET SESSION query_exec_time=1.22;
306SET SESSION slow_query_log_query_time=1.22;
307SET SESSION slow_query_log_lock_time=0.2;
308CREATE TABLE t2(id INT) ENGINE=MyISAM;
309SET SESSION query_exec_time=1.33;
310SET SESSION slow_query_log_query_time=1.33;
311SET SESSION slow_query_log_lock_time=0.3;
312INSERT INTO t1 VALUES(0);
313SET SESSION query_exec_time=1.44;
314SET SESSION slow_query_log_query_time=1.44;
315SET SESSION slow_query_log_lock_time=0.4;
316INSERT INTO t1 VALUES(1);
317SET SESSION query_exec_time=1.55;
318SET SESSION slow_query_log_query_time=1.55;
319SET SESSION slow_query_log_lock_time=0.5;
320INSERT INTO t1 VALUES(2);
321SET SESSION query_exec_time=1.66;
322SET SESSION slow_query_log_query_time=1.66;
323SET SESSION slow_query_log_lock_time=0.6;
324INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
325SET SESSION query_exec_time=1.77;
326SET SESSION slow_query_log_query_time=1.77;
327SET SESSION slow_query_log_lock_time=0.7;
328INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
329SET SESSION query_exec_time=1.88;
330SET SESSION slow_query_log_query_time=1.88;
331SET SESSION slow_query_log_lock_time=0.8;
332INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
333SET SESSION query_exec_time=1.99;
334SET SESSION slow_query_log_query_time=1.99;
335SET SESSION slow_query_log_lock_time=0.9;
336INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
337SET SESSION query_exec_time=2.1;
338SET SESSION slow_query_log_query_time=2.1;
339SET SESSION slow_query_log_lock_time=1.0;
340SELECT COUNT(*) FROM t1;
341COUNT(*)
34212
343SET SESSION query_exec_time=2.21;
344SET SESSION slow_query_log_query_time=2.21;
345SET SESSION slow_query_log_lock_time=1.1;
346SELECT COUNT(*) FROM t2;
347COUNT(*)
34824
349SET SESSION query_exec_time=2.32;
350SET SESSION slow_query_log_query_time=2.32;
351SET SESSION slow_query_log_lock_time=1.2;
352DROP TABLE t1;
353SET SESSION query_exec_time=2.43;
354SET SESSION slow_query_log_query_time=2.43;
355SET SESSION slow_query_log_lock_time=1.3;
356DROP TABLE t2;
357SET SESSION query_exec_time=2.54;
358SET SESSION slow_query_log_query_time=2.54;
359SET SESSION slow_query_log_lock_time=1.4;
360SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
361SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
362SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
363SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
364SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
365SET GLOBAL log_slow_verbosity='innodb,query_plan,microtime';
366SET GLOBAL log_slow_timestamp_every=1;
367SET GLOBAL log_slow_sp_statements=0;
368SET GLOBAL slow_query_log_microseconds_timestamp=1;
369SET GLOBAL log_slow_admin_statements=0;
370DROP TABLE IF EXISTS t1;
371DROP TABLE IF EXISTS t2;
372SET SESSION query_exec_time=1.11;
373SET SESSION slow_query_log_query_time=1.11;
374SET SESSION slow_query_log_lock_time=0.1;
375CREATE TABLE t1(id INT) ENGINE=InnoDB;
376SET SESSION query_exec_time=1.22;
377SET SESSION slow_query_log_query_time=1.22;
378SET SESSION slow_query_log_lock_time=0.2;
379CREATE TABLE t2(id INT) ENGINE=MyISAM;
380SET SESSION query_exec_time=1.33;
381SET SESSION slow_query_log_query_time=1.33;
382SET SESSION slow_query_log_lock_time=0.3;
383INSERT INTO t1 VALUES(0);
384SET SESSION query_exec_time=1.44;
385SET SESSION slow_query_log_query_time=1.44;
386SET SESSION slow_query_log_lock_time=0.4;
387INSERT INTO t1 VALUES(1);
388SET SESSION query_exec_time=1.55;
389SET SESSION slow_query_log_query_time=1.55;
390SET SESSION slow_query_log_lock_time=0.5;
391INSERT INTO t1 VALUES(2);
392SET SESSION query_exec_time=1.66;
393SET SESSION slow_query_log_query_time=1.66;
394SET SESSION slow_query_log_lock_time=0.6;
395INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
396SET SESSION query_exec_time=1.77;
397SET SESSION slow_query_log_query_time=1.77;
398SET SESSION slow_query_log_lock_time=0.7;
399INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
400SET SESSION query_exec_time=1.88;
401SET SESSION slow_query_log_query_time=1.88;
402SET SESSION slow_query_log_lock_time=0.8;
403INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
404SET SESSION query_exec_time=1.99;
405SET SESSION slow_query_log_query_time=1.99;
406SET SESSION slow_query_log_lock_time=0.9;
407INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
408SET SESSION query_exec_time=2.1;
409SET SESSION slow_query_log_query_time=2.1;
410SET SESSION slow_query_log_lock_time=1.0;
411SELECT COUNT(*) FROM t1;
412COUNT(*)
41312
414SET SESSION query_exec_time=2.21;
415SET SESSION slow_query_log_query_time=2.21;
416SET SESSION slow_query_log_lock_time=1.1;
417SELECT COUNT(*) FROM t2;
418COUNT(*)
41924
420SET SESSION query_exec_time=2.32;
421SET SESSION slow_query_log_query_time=2.32;
422SET SESSION slow_query_log_lock_time=1.2;
423DROP TABLE t1;
424SET SESSION query_exec_time=2.43;
425SET SESSION slow_query_log_query_time=2.43;
426SET SESSION slow_query_log_lock_time=1.3;
427DROP TABLE t2;
428SET SESSION query_exec_time=2.54;
429SET SESSION slow_query_log_query_time=2.54;
430SET SESSION slow_query_log_lock_time=1.4;
431SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
432SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
433SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
434SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
435SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
436SET GLOBAL log_slow_verbosity='innodb,query_plan,microtime';
437SET GLOBAL log_slow_timestamp_every=1;
438SET GLOBAL log_slow_sp_statements=0;
439SET GLOBAL slow_query_log_microseconds_timestamp=0;
440SET GLOBAL log_slow_admin_statements=1;
441DROP TABLE IF EXISTS t1;
442DROP TABLE IF EXISTS t2;
443SET SESSION query_exec_time=1.11;
444SET SESSION slow_query_log_query_time=1.11;
445SET SESSION slow_query_log_lock_time=0.1;
446CREATE TABLE t1(id INT) ENGINE=InnoDB;
447SET SESSION query_exec_time=1.22;
448SET SESSION slow_query_log_query_time=1.22;
449SET SESSION slow_query_log_lock_time=0.2;
450CREATE TABLE t2(id INT) ENGINE=MyISAM;
451SET SESSION query_exec_time=1.33;
452SET SESSION slow_query_log_query_time=1.33;
453SET SESSION slow_query_log_lock_time=0.3;
454INSERT INTO t1 VALUES(0);
455SET SESSION query_exec_time=1.44;
456SET SESSION slow_query_log_query_time=1.44;
457SET SESSION slow_query_log_lock_time=0.4;
458INSERT INTO t1 VALUES(1);
459SET SESSION query_exec_time=1.55;
460SET SESSION slow_query_log_query_time=1.55;
461SET SESSION slow_query_log_lock_time=0.5;
462INSERT INTO t1 VALUES(2);
463SET SESSION query_exec_time=1.66;
464SET SESSION slow_query_log_query_time=1.66;
465SET SESSION slow_query_log_lock_time=0.6;
466INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
467SET SESSION query_exec_time=1.77;
468SET SESSION slow_query_log_query_time=1.77;
469SET SESSION slow_query_log_lock_time=0.7;
470INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
471SET SESSION query_exec_time=1.88;
472SET SESSION slow_query_log_query_time=1.88;
473SET SESSION slow_query_log_lock_time=0.8;
474INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
475SET SESSION query_exec_time=1.99;
476SET SESSION slow_query_log_query_time=1.99;
477SET SESSION slow_query_log_lock_time=0.9;
478INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
479SET SESSION query_exec_time=2.1;
480SET SESSION slow_query_log_query_time=2.1;
481SET SESSION slow_query_log_lock_time=1.0;
482SELECT COUNT(*) FROM t1;
483COUNT(*)
48412
485SET SESSION query_exec_time=2.21;
486SET SESSION slow_query_log_query_time=2.21;
487SET SESSION slow_query_log_lock_time=1.1;
488SELECT COUNT(*) FROM t2;
489COUNT(*)
49024
491SET SESSION query_exec_time=2.32;
492SET SESSION slow_query_log_query_time=2.32;
493SET SESSION slow_query_log_lock_time=1.2;
494DROP TABLE t1;
495SET SESSION query_exec_time=2.43;
496SET SESSION slow_query_log_query_time=2.43;
497SET SESSION slow_query_log_lock_time=1.3;
498DROP TABLE t2;
499SET SESSION query_exec_time=2.54;
500SET SESSION slow_query_log_query_time=2.54;
501SET SESSION slow_query_log_lock_time=1.4;
502SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
503SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
504SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
505SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
506SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
507SET GLOBAL log_slow_verbosity='innodb,query_plan,microtime';
508SET GLOBAL log_slow_timestamp_every=1;
509SET GLOBAL log_slow_sp_statements=0;
510SET GLOBAL slow_query_log_microseconds_timestamp=0;
511SET GLOBAL log_slow_admin_statements=0;
512DROP TABLE IF EXISTS t1;
513DROP TABLE IF EXISTS t2;
514SET SESSION query_exec_time=1.11;
515SET SESSION slow_query_log_query_time=1.11;
516SET SESSION slow_query_log_lock_time=0.1;
517CREATE TABLE t1(id INT) ENGINE=InnoDB;
518SET SESSION query_exec_time=1.22;
519SET SESSION slow_query_log_query_time=1.22;
520SET SESSION slow_query_log_lock_time=0.2;
521CREATE TABLE t2(id INT) ENGINE=MyISAM;
522SET SESSION query_exec_time=1.33;
523SET SESSION slow_query_log_query_time=1.33;
524SET SESSION slow_query_log_lock_time=0.3;
525INSERT INTO t1 VALUES(0);
526SET SESSION query_exec_time=1.44;
527SET SESSION slow_query_log_query_time=1.44;
528SET SESSION slow_query_log_lock_time=0.4;
529INSERT INTO t1 VALUES(1);
530SET SESSION query_exec_time=1.55;
531SET SESSION slow_query_log_query_time=1.55;
532SET SESSION slow_query_log_lock_time=0.5;
533INSERT INTO t1 VALUES(2);
534SET SESSION query_exec_time=1.66;
535SET SESSION slow_query_log_query_time=1.66;
536SET SESSION slow_query_log_lock_time=0.6;
537INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
538SET SESSION query_exec_time=1.77;
539SET SESSION slow_query_log_query_time=1.77;
540SET SESSION slow_query_log_lock_time=0.7;
541INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
542SET SESSION query_exec_time=1.88;
543SET SESSION slow_query_log_query_time=1.88;
544SET SESSION slow_query_log_lock_time=0.8;
545INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
546SET SESSION query_exec_time=1.99;
547SET SESSION slow_query_log_query_time=1.99;
548SET SESSION slow_query_log_lock_time=0.9;
549INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
550SET SESSION query_exec_time=2.1;
551SET SESSION slow_query_log_query_time=2.1;
552SET SESSION slow_query_log_lock_time=1.0;
553SELECT COUNT(*) FROM t1;
554COUNT(*)
55512
556SET SESSION query_exec_time=2.21;
557SET SESSION slow_query_log_query_time=2.21;
558SET SESSION slow_query_log_lock_time=1.1;
559SELECT COUNT(*) FROM t2;
560COUNT(*)
56124
562SET SESSION query_exec_time=2.32;
563SET SESSION slow_query_log_query_time=2.32;
564SET SESSION slow_query_log_lock_time=1.2;
565DROP TABLE t1;
566SET SESSION query_exec_time=2.43;
567SET SESSION slow_query_log_query_time=2.43;
568SET SESSION slow_query_log_lock_time=1.3;
569DROP TABLE t2;
570SET SESSION query_exec_time=2.54;
571SET SESSION slow_query_log_query_time=2.54;
572SET SESSION slow_query_log_lock_time=1.4;
573SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
574SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
575SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
576SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
577SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
578SET GLOBAL log_slow_verbosity='query_plan,microtime';
579SET GLOBAL log_slow_timestamp_every=1;
580SET GLOBAL log_slow_sp_statements=1;
581SET GLOBAL slow_query_log_microseconds_timestamp=1;
582SET GLOBAL log_slow_admin_statements=1;
583DROP TABLE IF EXISTS t1;
584DROP TABLE IF EXISTS t2;
585SET SESSION query_exec_time=1.11;
586SET SESSION slow_query_log_query_time=1.11;
587SET SESSION slow_query_log_lock_time=0.1;
588CREATE TABLE t1(id INT) ENGINE=InnoDB;
589SET SESSION query_exec_time=1.22;
590SET SESSION slow_query_log_query_time=1.22;
591SET SESSION slow_query_log_lock_time=0.2;
592CREATE TABLE t2(id INT) ENGINE=MyISAM;
593SET SESSION query_exec_time=1.33;
594SET SESSION slow_query_log_query_time=1.33;
595SET SESSION slow_query_log_lock_time=0.3;
596INSERT INTO t1 VALUES(0);
597SET SESSION query_exec_time=1.44;
598SET SESSION slow_query_log_query_time=1.44;
599SET SESSION slow_query_log_lock_time=0.4;
600INSERT INTO t1 VALUES(1);
601SET SESSION query_exec_time=1.55;
602SET SESSION slow_query_log_query_time=1.55;
603SET SESSION slow_query_log_lock_time=0.5;
604INSERT INTO t1 VALUES(2);
605SET SESSION query_exec_time=1.66;
606SET SESSION slow_query_log_query_time=1.66;
607SET SESSION slow_query_log_lock_time=0.6;
608INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
609SET SESSION query_exec_time=1.77;
610SET SESSION slow_query_log_query_time=1.77;
611SET SESSION slow_query_log_lock_time=0.7;
612INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
613SET SESSION query_exec_time=1.88;
614SET SESSION slow_query_log_query_time=1.88;
615SET SESSION slow_query_log_lock_time=0.8;
616INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
617SET SESSION query_exec_time=1.99;
618SET SESSION slow_query_log_query_time=1.99;
619SET SESSION slow_query_log_lock_time=0.9;
620INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
621SET SESSION query_exec_time=2.1;
622SET SESSION slow_query_log_query_time=2.1;
623SET SESSION slow_query_log_lock_time=1.0;
624SELECT COUNT(*) FROM t1;
625COUNT(*)
62612
627SET SESSION query_exec_time=2.21;
628SET SESSION slow_query_log_query_time=2.21;
629SET SESSION slow_query_log_lock_time=1.1;
630SELECT COUNT(*) FROM t2;
631COUNT(*)
63224
633SET SESSION query_exec_time=2.32;
634SET SESSION slow_query_log_query_time=2.32;
635SET SESSION slow_query_log_lock_time=1.2;
636DROP TABLE t1;
637SET SESSION query_exec_time=2.43;
638SET SESSION slow_query_log_query_time=2.43;
639SET SESSION slow_query_log_lock_time=1.3;
640DROP TABLE t2;
641SET SESSION query_exec_time=2.54;
642SET SESSION slow_query_log_query_time=2.54;
643SET SESSION slow_query_log_lock_time=1.4;
644SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
645SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
646SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
647SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
648SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
649SET GLOBAL log_slow_verbosity='query_plan,microtime';
650SET GLOBAL log_slow_timestamp_every=1;
651SET GLOBAL log_slow_sp_statements=1;
652SET GLOBAL slow_query_log_microseconds_timestamp=1;
653SET GLOBAL log_slow_admin_statements=0;
654DROP TABLE IF EXISTS t1;
655DROP TABLE IF EXISTS t2;
656SET SESSION query_exec_time=1.11;
657SET SESSION slow_query_log_query_time=1.11;
658SET SESSION slow_query_log_lock_time=0.1;
659CREATE TABLE t1(id INT) ENGINE=InnoDB;
660SET SESSION query_exec_time=1.22;
661SET SESSION slow_query_log_query_time=1.22;
662SET SESSION slow_query_log_lock_time=0.2;
663CREATE TABLE t2(id INT) ENGINE=MyISAM;
664SET SESSION query_exec_time=1.33;
665SET SESSION slow_query_log_query_time=1.33;
666SET SESSION slow_query_log_lock_time=0.3;
667INSERT INTO t1 VALUES(0);
668SET SESSION query_exec_time=1.44;
669SET SESSION slow_query_log_query_time=1.44;
670SET SESSION slow_query_log_lock_time=0.4;
671INSERT INTO t1 VALUES(1);
672SET SESSION query_exec_time=1.55;
673SET SESSION slow_query_log_query_time=1.55;
674SET SESSION slow_query_log_lock_time=0.5;
675INSERT INTO t1 VALUES(2);
676SET SESSION query_exec_time=1.66;
677SET SESSION slow_query_log_query_time=1.66;
678SET SESSION slow_query_log_lock_time=0.6;
679INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
680SET SESSION query_exec_time=1.77;
681SET SESSION slow_query_log_query_time=1.77;
682SET SESSION slow_query_log_lock_time=0.7;
683INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
684SET SESSION query_exec_time=1.88;
685SET SESSION slow_query_log_query_time=1.88;
686SET SESSION slow_query_log_lock_time=0.8;
687INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
688SET SESSION query_exec_time=1.99;
689SET SESSION slow_query_log_query_time=1.99;
690SET SESSION slow_query_log_lock_time=0.9;
691INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
692SET SESSION query_exec_time=2.1;
693SET SESSION slow_query_log_query_time=2.1;
694SET SESSION slow_query_log_lock_time=1.0;
695SELECT COUNT(*) FROM t1;
696COUNT(*)
69712
698SET SESSION query_exec_time=2.21;
699SET SESSION slow_query_log_query_time=2.21;
700SET SESSION slow_query_log_lock_time=1.1;
701SELECT COUNT(*) FROM t2;
702COUNT(*)
70324
704SET SESSION query_exec_time=2.32;
705SET SESSION slow_query_log_query_time=2.32;
706SET SESSION slow_query_log_lock_time=1.2;
707DROP TABLE t1;
708SET SESSION query_exec_time=2.43;
709SET SESSION slow_query_log_query_time=2.43;
710SET SESSION slow_query_log_lock_time=1.3;
711DROP TABLE t2;
712SET SESSION query_exec_time=2.54;
713SET SESSION slow_query_log_query_time=2.54;
714SET SESSION slow_query_log_lock_time=1.4;
715SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
716SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
717SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
718SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
719SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
720SET GLOBAL log_slow_verbosity='query_plan,microtime';
721SET GLOBAL log_slow_timestamp_every=1;
722SET GLOBAL log_slow_sp_statements=1;
723SET GLOBAL slow_query_log_microseconds_timestamp=0;
724SET GLOBAL log_slow_admin_statements=1;
725DROP TABLE IF EXISTS t1;
726DROP TABLE IF EXISTS t2;
727SET SESSION query_exec_time=1.11;
728SET SESSION slow_query_log_query_time=1.11;
729SET SESSION slow_query_log_lock_time=0.1;
730CREATE TABLE t1(id INT) ENGINE=InnoDB;
731SET SESSION query_exec_time=1.22;
732SET SESSION slow_query_log_query_time=1.22;
733SET SESSION slow_query_log_lock_time=0.2;
734CREATE TABLE t2(id INT) ENGINE=MyISAM;
735SET SESSION query_exec_time=1.33;
736SET SESSION slow_query_log_query_time=1.33;
737SET SESSION slow_query_log_lock_time=0.3;
738INSERT INTO t1 VALUES(0);
739SET SESSION query_exec_time=1.44;
740SET SESSION slow_query_log_query_time=1.44;
741SET SESSION slow_query_log_lock_time=0.4;
742INSERT INTO t1 VALUES(1);
743SET SESSION query_exec_time=1.55;
744SET SESSION slow_query_log_query_time=1.55;
745SET SESSION slow_query_log_lock_time=0.5;
746INSERT INTO t1 VALUES(2);
747SET SESSION query_exec_time=1.66;
748SET SESSION slow_query_log_query_time=1.66;
749SET SESSION slow_query_log_lock_time=0.6;
750INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
751SET SESSION query_exec_time=1.77;
752SET SESSION slow_query_log_query_time=1.77;
753SET SESSION slow_query_log_lock_time=0.7;
754INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
755SET SESSION query_exec_time=1.88;
756SET SESSION slow_query_log_query_time=1.88;
757SET SESSION slow_query_log_lock_time=0.8;
758INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
759SET SESSION query_exec_time=1.99;
760SET SESSION slow_query_log_query_time=1.99;
761SET SESSION slow_query_log_lock_time=0.9;
762INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
763SET SESSION query_exec_time=2.1;
764SET SESSION slow_query_log_query_time=2.1;
765SET SESSION slow_query_log_lock_time=1.0;
766SELECT COUNT(*) FROM t1;
767COUNT(*)
76812
769SET SESSION query_exec_time=2.21;
770SET SESSION slow_query_log_query_time=2.21;
771SET SESSION slow_query_log_lock_time=1.1;
772SELECT COUNT(*) FROM t2;
773COUNT(*)
77424
775SET SESSION query_exec_time=2.32;
776SET SESSION slow_query_log_query_time=2.32;
777SET SESSION slow_query_log_lock_time=1.2;
778DROP TABLE t1;
779SET SESSION query_exec_time=2.43;
780SET SESSION slow_query_log_query_time=2.43;
781SET SESSION slow_query_log_lock_time=1.3;
782DROP TABLE t2;
783SET SESSION query_exec_time=2.54;
784SET SESSION slow_query_log_query_time=2.54;
785SET SESSION slow_query_log_lock_time=1.4;
786SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
787SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
788SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
789SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
790SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
791SET GLOBAL log_slow_verbosity='query_plan,microtime';
792SET GLOBAL log_slow_timestamp_every=1;
793SET GLOBAL log_slow_sp_statements=1;
794SET GLOBAL slow_query_log_microseconds_timestamp=0;
795SET GLOBAL log_slow_admin_statements=0;
796DROP TABLE IF EXISTS t1;
797DROP TABLE IF EXISTS t2;
798SET SESSION query_exec_time=1.11;
799SET SESSION slow_query_log_query_time=1.11;
800SET SESSION slow_query_log_lock_time=0.1;
801CREATE TABLE t1(id INT) ENGINE=InnoDB;
802SET SESSION query_exec_time=1.22;
803SET SESSION slow_query_log_query_time=1.22;
804SET SESSION slow_query_log_lock_time=0.2;
805CREATE TABLE t2(id INT) ENGINE=MyISAM;
806SET SESSION query_exec_time=1.33;
807SET SESSION slow_query_log_query_time=1.33;
808SET SESSION slow_query_log_lock_time=0.3;
809INSERT INTO t1 VALUES(0);
810SET SESSION query_exec_time=1.44;
811SET SESSION slow_query_log_query_time=1.44;
812SET SESSION slow_query_log_lock_time=0.4;
813INSERT INTO t1 VALUES(1);
814SET SESSION query_exec_time=1.55;
815SET SESSION slow_query_log_query_time=1.55;
816SET SESSION slow_query_log_lock_time=0.5;
817INSERT INTO t1 VALUES(2);
818SET SESSION query_exec_time=1.66;
819SET SESSION slow_query_log_query_time=1.66;
820SET SESSION slow_query_log_lock_time=0.6;
821INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
822SET SESSION query_exec_time=1.77;
823SET SESSION slow_query_log_query_time=1.77;
824SET SESSION slow_query_log_lock_time=0.7;
825INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
826SET SESSION query_exec_time=1.88;
827SET SESSION slow_query_log_query_time=1.88;
828SET SESSION slow_query_log_lock_time=0.8;
829INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
830SET SESSION query_exec_time=1.99;
831SET SESSION slow_query_log_query_time=1.99;
832SET SESSION slow_query_log_lock_time=0.9;
833INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
834SET SESSION query_exec_time=2.1;
835SET SESSION slow_query_log_query_time=2.1;
836SET SESSION slow_query_log_lock_time=1.0;
837SELECT COUNT(*) FROM t1;
838COUNT(*)
83912
840SET SESSION query_exec_time=2.21;
841SET SESSION slow_query_log_query_time=2.21;
842SET SESSION slow_query_log_lock_time=1.1;
843SELECT COUNT(*) FROM t2;
844COUNT(*)
84524
846SET SESSION query_exec_time=2.32;
847SET SESSION slow_query_log_query_time=2.32;
848SET SESSION slow_query_log_lock_time=1.2;
849DROP TABLE t1;
850SET SESSION query_exec_time=2.43;
851SET SESSION slow_query_log_query_time=2.43;
852SET SESSION slow_query_log_lock_time=1.3;
853DROP TABLE t2;
854SET SESSION query_exec_time=2.54;
855SET SESSION slow_query_log_query_time=2.54;
856SET SESSION slow_query_log_lock_time=1.4;
857SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
858SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
859SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
860SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
861SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
862SET GLOBAL log_slow_verbosity='query_plan,microtime';
863SET GLOBAL log_slow_timestamp_every=1;
864SET GLOBAL log_slow_sp_statements=0;
865SET GLOBAL slow_query_log_microseconds_timestamp=1;
866SET GLOBAL log_slow_admin_statements=1;
867DROP TABLE IF EXISTS t1;
868DROP TABLE IF EXISTS t2;
869SET SESSION query_exec_time=1.11;
870SET SESSION slow_query_log_query_time=1.11;
871SET SESSION slow_query_log_lock_time=0.1;
872CREATE TABLE t1(id INT) ENGINE=InnoDB;
873SET SESSION query_exec_time=1.22;
874SET SESSION slow_query_log_query_time=1.22;
875SET SESSION slow_query_log_lock_time=0.2;
876CREATE TABLE t2(id INT) ENGINE=MyISAM;
877SET SESSION query_exec_time=1.33;
878SET SESSION slow_query_log_query_time=1.33;
879SET SESSION slow_query_log_lock_time=0.3;
880INSERT INTO t1 VALUES(0);
881SET SESSION query_exec_time=1.44;
882SET SESSION slow_query_log_query_time=1.44;
883SET SESSION slow_query_log_lock_time=0.4;
884INSERT INTO t1 VALUES(1);
885SET SESSION query_exec_time=1.55;
886SET SESSION slow_query_log_query_time=1.55;
887SET SESSION slow_query_log_lock_time=0.5;
888INSERT INTO t1 VALUES(2);
889SET SESSION query_exec_time=1.66;
890SET SESSION slow_query_log_query_time=1.66;
891SET SESSION slow_query_log_lock_time=0.6;
892INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
893SET SESSION query_exec_time=1.77;
894SET SESSION slow_query_log_query_time=1.77;
895SET SESSION slow_query_log_lock_time=0.7;
896INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
897SET SESSION query_exec_time=1.88;
898SET SESSION slow_query_log_query_time=1.88;
899SET SESSION slow_query_log_lock_time=0.8;
900INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
901SET SESSION query_exec_time=1.99;
902SET SESSION slow_query_log_query_time=1.99;
903SET SESSION slow_query_log_lock_time=0.9;
904INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
905SET SESSION query_exec_time=2.1;
906SET SESSION slow_query_log_query_time=2.1;
907SET SESSION slow_query_log_lock_time=1.0;
908SELECT COUNT(*) FROM t1;
909COUNT(*)
91012
911SET SESSION query_exec_time=2.21;
912SET SESSION slow_query_log_query_time=2.21;
913SET SESSION slow_query_log_lock_time=1.1;
914SELECT COUNT(*) FROM t2;
915COUNT(*)
91624
917SET SESSION query_exec_time=2.32;
918SET SESSION slow_query_log_query_time=2.32;
919SET SESSION slow_query_log_lock_time=1.2;
920DROP TABLE t1;
921SET SESSION query_exec_time=2.43;
922SET SESSION slow_query_log_query_time=2.43;
923SET SESSION slow_query_log_lock_time=1.3;
924DROP TABLE t2;
925SET SESSION query_exec_time=2.54;
926SET SESSION slow_query_log_query_time=2.54;
927SET SESSION slow_query_log_lock_time=1.4;
928SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
929SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
930SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
931SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
932SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
933SET GLOBAL log_slow_verbosity='query_plan,microtime';
934SET GLOBAL log_slow_timestamp_every=1;
935SET GLOBAL log_slow_sp_statements=0;
936SET GLOBAL slow_query_log_microseconds_timestamp=1;
937SET GLOBAL log_slow_admin_statements=0;
938DROP TABLE IF EXISTS t1;
939DROP TABLE IF EXISTS t2;
940SET SESSION query_exec_time=1.11;
941SET SESSION slow_query_log_query_time=1.11;
942SET SESSION slow_query_log_lock_time=0.1;
943CREATE TABLE t1(id INT) ENGINE=InnoDB;
944SET SESSION query_exec_time=1.22;
945SET SESSION slow_query_log_query_time=1.22;
946SET SESSION slow_query_log_lock_time=0.2;
947CREATE TABLE t2(id INT) ENGINE=MyISAM;
948SET SESSION query_exec_time=1.33;
949SET SESSION slow_query_log_query_time=1.33;
950SET SESSION slow_query_log_lock_time=0.3;
951INSERT INTO t1 VALUES(0);
952SET SESSION query_exec_time=1.44;
953SET SESSION slow_query_log_query_time=1.44;
954SET SESSION slow_query_log_lock_time=0.4;
955INSERT INTO t1 VALUES(1);
956SET SESSION query_exec_time=1.55;
957SET SESSION slow_query_log_query_time=1.55;
958SET SESSION slow_query_log_lock_time=0.5;
959INSERT INTO t1 VALUES(2);
960SET SESSION query_exec_time=1.66;
961SET SESSION slow_query_log_query_time=1.66;
962SET SESSION slow_query_log_lock_time=0.6;
963INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
964SET SESSION query_exec_time=1.77;
965SET SESSION slow_query_log_query_time=1.77;
966SET SESSION slow_query_log_lock_time=0.7;
967INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
968SET SESSION query_exec_time=1.88;
969SET SESSION slow_query_log_query_time=1.88;
970SET SESSION slow_query_log_lock_time=0.8;
971INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
972SET SESSION query_exec_time=1.99;
973SET SESSION slow_query_log_query_time=1.99;
974SET SESSION slow_query_log_lock_time=0.9;
975INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
976SET SESSION query_exec_time=2.1;
977SET SESSION slow_query_log_query_time=2.1;
978SET SESSION slow_query_log_lock_time=1.0;
979SELECT COUNT(*) FROM t1;
980COUNT(*)
98112
982SET SESSION query_exec_time=2.21;
983SET SESSION slow_query_log_query_time=2.21;
984SET SESSION slow_query_log_lock_time=1.1;
985SELECT COUNT(*) FROM t2;
986COUNT(*)
98724
988SET SESSION query_exec_time=2.32;
989SET SESSION slow_query_log_query_time=2.32;
990SET SESSION slow_query_log_lock_time=1.2;
991DROP TABLE t1;
992SET SESSION query_exec_time=2.43;
993SET SESSION slow_query_log_query_time=2.43;
994SET SESSION slow_query_log_lock_time=1.3;
995DROP TABLE t2;
996SET SESSION query_exec_time=2.54;
997SET SESSION slow_query_log_query_time=2.54;
998SET SESSION slow_query_log_lock_time=1.4;
999SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
1000SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
1001SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
1002SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
1003SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
1004SET GLOBAL log_slow_verbosity='query_plan,microtime';
1005SET GLOBAL log_slow_timestamp_every=1;
1006SET GLOBAL log_slow_sp_statements=0;
1007SET GLOBAL slow_query_log_microseconds_timestamp=0;
1008SET GLOBAL log_slow_admin_statements=1;
1009DROP TABLE IF EXISTS t1;
1010DROP TABLE IF EXISTS t2;
1011SET SESSION query_exec_time=1.11;
1012SET SESSION slow_query_log_query_time=1.11;
1013SET SESSION slow_query_log_lock_time=0.1;
1014CREATE TABLE t1(id INT) ENGINE=InnoDB;
1015SET SESSION query_exec_time=1.22;
1016SET SESSION slow_query_log_query_time=1.22;
1017SET SESSION slow_query_log_lock_time=0.2;
1018CREATE TABLE t2(id INT) ENGINE=MyISAM;
1019SET SESSION query_exec_time=1.33;
1020SET SESSION slow_query_log_query_time=1.33;
1021SET SESSION slow_query_log_lock_time=0.3;
1022INSERT INTO t1 VALUES(0);
1023SET SESSION query_exec_time=1.44;
1024SET SESSION slow_query_log_query_time=1.44;
1025SET SESSION slow_query_log_lock_time=0.4;
1026INSERT INTO t1 VALUES(1);
1027SET SESSION query_exec_time=1.55;
1028SET SESSION slow_query_log_query_time=1.55;
1029SET SESSION slow_query_log_lock_time=0.5;
1030INSERT INTO t1 VALUES(2);
1031SET SESSION query_exec_time=1.66;
1032SET SESSION slow_query_log_query_time=1.66;
1033SET SESSION slow_query_log_lock_time=0.6;
1034INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
1035SET SESSION query_exec_time=1.77;
1036SET SESSION slow_query_log_query_time=1.77;
1037SET SESSION slow_query_log_lock_time=0.7;
1038INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
1039SET SESSION query_exec_time=1.88;
1040SET SESSION slow_query_log_query_time=1.88;
1041SET SESSION slow_query_log_lock_time=0.8;
1042INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
1043SET SESSION query_exec_time=1.99;
1044SET SESSION slow_query_log_query_time=1.99;
1045SET SESSION slow_query_log_lock_time=0.9;
1046INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
1047SET SESSION query_exec_time=2.1;
1048SET SESSION slow_query_log_query_time=2.1;
1049SET SESSION slow_query_log_lock_time=1.0;
1050SELECT COUNT(*) FROM t1;
1051COUNT(*)
105212
1053SET SESSION query_exec_time=2.21;
1054SET SESSION slow_query_log_query_time=2.21;
1055SET SESSION slow_query_log_lock_time=1.1;
1056SELECT COUNT(*) FROM t2;
1057COUNT(*)
105824
1059SET SESSION query_exec_time=2.32;
1060SET SESSION slow_query_log_query_time=2.32;
1061SET SESSION slow_query_log_lock_time=1.2;
1062DROP TABLE t1;
1063SET SESSION query_exec_time=2.43;
1064SET SESSION slow_query_log_query_time=2.43;
1065SET SESSION slow_query_log_lock_time=1.3;
1066DROP TABLE t2;
1067SET SESSION query_exec_time=2.54;
1068SET SESSION slow_query_log_query_time=2.54;
1069SET SESSION slow_query_log_lock_time=1.4;
1070SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
1071SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
1072SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
1073SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
1074SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
1075SET GLOBAL log_slow_verbosity='query_plan,microtime';
1076SET GLOBAL log_slow_timestamp_every=1;
1077SET GLOBAL log_slow_sp_statements=0;
1078SET GLOBAL slow_query_log_microseconds_timestamp=0;
1079SET GLOBAL log_slow_admin_statements=0;
1080DROP TABLE IF EXISTS t1;
1081DROP TABLE IF EXISTS t2;
1082SET SESSION query_exec_time=1.11;
1083SET SESSION slow_query_log_query_time=1.11;
1084SET SESSION slow_query_log_lock_time=0.1;
1085CREATE TABLE t1(id INT) ENGINE=InnoDB;
1086SET SESSION query_exec_time=1.22;
1087SET SESSION slow_query_log_query_time=1.22;
1088SET SESSION slow_query_log_lock_time=0.2;
1089CREATE TABLE t2(id INT) ENGINE=MyISAM;
1090SET SESSION query_exec_time=1.33;
1091SET SESSION slow_query_log_query_time=1.33;
1092SET SESSION slow_query_log_lock_time=0.3;
1093INSERT INTO t1 VALUES(0);
1094SET SESSION query_exec_time=1.44;
1095SET SESSION slow_query_log_query_time=1.44;
1096SET SESSION slow_query_log_lock_time=0.4;
1097INSERT INTO t1 VALUES(1);
1098SET SESSION query_exec_time=1.55;
1099SET SESSION slow_query_log_query_time=1.55;
1100SET SESSION slow_query_log_lock_time=0.5;
1101INSERT INTO t1 VALUES(2);
1102SET SESSION query_exec_time=1.66;
1103SET SESSION slow_query_log_query_time=1.66;
1104SET SESSION slow_query_log_lock_time=0.6;
1105INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
1106SET SESSION query_exec_time=1.77;
1107SET SESSION slow_query_log_query_time=1.77;
1108SET SESSION slow_query_log_lock_time=0.7;
1109INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
1110SET SESSION query_exec_time=1.88;
1111SET SESSION slow_query_log_query_time=1.88;
1112SET SESSION slow_query_log_lock_time=0.8;
1113INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
1114SET SESSION query_exec_time=1.99;
1115SET SESSION slow_query_log_query_time=1.99;
1116SET SESSION slow_query_log_lock_time=0.9;
1117INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
1118SET SESSION query_exec_time=2.1;
1119SET SESSION slow_query_log_query_time=2.1;
1120SET SESSION slow_query_log_lock_time=1.0;
1121SELECT COUNT(*) FROM t1;
1122COUNT(*)
112312
1124SET SESSION query_exec_time=2.21;
1125SET SESSION slow_query_log_query_time=2.21;
1126SET SESSION slow_query_log_lock_time=1.1;
1127SELECT COUNT(*) FROM t2;
1128COUNT(*)
112924
1130SET SESSION query_exec_time=2.32;
1131SET SESSION slow_query_log_query_time=2.32;
1132SET SESSION slow_query_log_lock_time=1.2;
1133DROP TABLE t1;
1134SET SESSION query_exec_time=2.43;
1135SET SESSION slow_query_log_query_time=2.43;
1136SET SESSION slow_query_log_lock_time=1.3;
1137DROP TABLE t2;
1138SET SESSION query_exec_time=2.54;
1139SET SESSION slow_query_log_query_time=2.54;
1140SET SESSION slow_query_log_lock_time=1.4;
1141SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
1142SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
1143SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
1144SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
1145SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
1146SET GLOBAL log_slow_verbosity='innodb,microtime';
1147SET GLOBAL log_slow_timestamp_every=1;
1148SET GLOBAL log_slow_sp_statements=1;
1149SET GLOBAL slow_query_log_microseconds_timestamp=1;
1150SET GLOBAL log_slow_admin_statements=1;
1151DROP TABLE IF EXISTS t1;
1152DROP TABLE IF EXISTS t2;
1153SET SESSION query_exec_time=1.11;
1154SET SESSION slow_query_log_query_time=1.11;
1155SET SESSION slow_query_log_lock_time=0.1;
1156CREATE TABLE t1(id INT) ENGINE=InnoDB;
1157SET SESSION query_exec_time=1.22;
1158SET SESSION slow_query_log_query_time=1.22;
1159SET SESSION slow_query_log_lock_time=0.2;
1160CREATE TABLE t2(id INT) ENGINE=MyISAM;
1161SET SESSION query_exec_time=1.33;
1162SET SESSION slow_query_log_query_time=1.33;
1163SET SESSION slow_query_log_lock_time=0.3;
1164INSERT INTO t1 VALUES(0);
1165SET SESSION query_exec_time=1.44;
1166SET SESSION slow_query_log_query_time=1.44;
1167SET SESSION slow_query_log_lock_time=0.4;
1168INSERT INTO t1 VALUES(1);
1169SET SESSION query_exec_time=1.55;
1170SET SESSION slow_query_log_query_time=1.55;
1171SET SESSION slow_query_log_lock_time=0.5;
1172INSERT INTO t1 VALUES(2);
1173SET SESSION query_exec_time=1.66;
1174SET SESSION slow_query_log_query_time=1.66;
1175SET SESSION slow_query_log_lock_time=0.6;
1176INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
1177SET SESSION query_exec_time=1.77;
1178SET SESSION slow_query_log_query_time=1.77;
1179SET SESSION slow_query_log_lock_time=0.7;
1180INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
1181SET SESSION query_exec_time=1.88;
1182SET SESSION slow_query_log_query_time=1.88;
1183SET SESSION slow_query_log_lock_time=0.8;
1184INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
1185SET SESSION query_exec_time=1.99;
1186SET SESSION slow_query_log_query_time=1.99;
1187SET SESSION slow_query_log_lock_time=0.9;
1188INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
1189SET SESSION query_exec_time=2.1;
1190SET SESSION slow_query_log_query_time=2.1;
1191SET SESSION slow_query_log_lock_time=1.0;
1192SELECT COUNT(*) FROM t1;
1193COUNT(*)
119412
1195SET SESSION query_exec_time=2.21;
1196SET SESSION slow_query_log_query_time=2.21;
1197SET SESSION slow_query_log_lock_time=1.1;
1198SELECT COUNT(*) FROM t2;
1199COUNT(*)
120024
1201SET SESSION query_exec_time=2.32;
1202SET SESSION slow_query_log_query_time=2.32;
1203SET SESSION slow_query_log_lock_time=1.2;
1204DROP TABLE t1;
1205SET SESSION query_exec_time=2.43;
1206SET SESSION slow_query_log_query_time=2.43;
1207SET SESSION slow_query_log_lock_time=1.3;
1208DROP TABLE t2;
1209SET SESSION query_exec_time=2.54;
1210SET SESSION slow_query_log_query_time=2.54;
1211SET SESSION slow_query_log_lock_time=1.4;
1212SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
1213SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
1214SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
1215SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
1216SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
1217SET GLOBAL log_slow_verbosity='innodb,microtime';
1218SET GLOBAL log_slow_timestamp_every=1;
1219SET GLOBAL log_slow_sp_statements=1;
1220SET GLOBAL slow_query_log_microseconds_timestamp=1;
1221SET GLOBAL log_slow_admin_statements=0;
1222DROP TABLE IF EXISTS t1;
1223DROP TABLE IF EXISTS t2;
1224SET SESSION query_exec_time=1.11;
1225SET SESSION slow_query_log_query_time=1.11;
1226SET SESSION slow_query_log_lock_time=0.1;
1227CREATE TABLE t1(id INT) ENGINE=InnoDB;
1228SET SESSION query_exec_time=1.22;
1229SET SESSION slow_query_log_query_time=1.22;
1230SET SESSION slow_query_log_lock_time=0.2;
1231CREATE TABLE t2(id INT) ENGINE=MyISAM;
1232SET SESSION query_exec_time=1.33;
1233SET SESSION slow_query_log_query_time=1.33;
1234SET SESSION slow_query_log_lock_time=0.3;
1235INSERT INTO t1 VALUES(0);
1236SET SESSION query_exec_time=1.44;
1237SET SESSION slow_query_log_query_time=1.44;
1238SET SESSION slow_query_log_lock_time=0.4;
1239INSERT INTO t1 VALUES(1);
1240SET SESSION query_exec_time=1.55;
1241SET SESSION slow_query_log_query_time=1.55;
1242SET SESSION slow_query_log_lock_time=0.5;
1243INSERT INTO t1 VALUES(2);
1244SET SESSION query_exec_time=1.66;
1245SET SESSION slow_query_log_query_time=1.66;
1246SET SESSION slow_query_log_lock_time=0.6;
1247INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
1248SET SESSION query_exec_time=1.77;
1249SET SESSION slow_query_log_query_time=1.77;
1250SET SESSION slow_query_log_lock_time=0.7;
1251INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
1252SET SESSION query_exec_time=1.88;
1253SET SESSION slow_query_log_query_time=1.88;
1254SET SESSION slow_query_log_lock_time=0.8;
1255INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
1256SET SESSION query_exec_time=1.99;
1257SET SESSION slow_query_log_query_time=1.99;
1258SET SESSION slow_query_log_lock_time=0.9;
1259INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
1260SET SESSION query_exec_time=2.1;
1261SET SESSION slow_query_log_query_time=2.1;
1262SET SESSION slow_query_log_lock_time=1.0;
1263SELECT COUNT(*) FROM t1;
1264COUNT(*)
126512
1266SET SESSION query_exec_time=2.21;
1267SET SESSION slow_query_log_query_time=2.21;
1268SET SESSION slow_query_log_lock_time=1.1;
1269SELECT COUNT(*) FROM t2;
1270COUNT(*)
127124
1272SET SESSION query_exec_time=2.32;
1273SET SESSION slow_query_log_query_time=2.32;
1274SET SESSION slow_query_log_lock_time=1.2;
1275DROP TABLE t1;
1276SET SESSION query_exec_time=2.43;
1277SET SESSION slow_query_log_query_time=2.43;
1278SET SESSION slow_query_log_lock_time=1.3;
1279DROP TABLE t2;
1280SET SESSION query_exec_time=2.54;
1281SET SESSION slow_query_log_query_time=2.54;
1282SET SESSION slow_query_log_lock_time=1.4;
1283SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
1284SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
1285SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
1286SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
1287SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
1288SET GLOBAL log_slow_verbosity='innodb,microtime';
1289SET GLOBAL log_slow_timestamp_every=1;
1290SET GLOBAL log_slow_sp_statements=1;
1291SET GLOBAL slow_query_log_microseconds_timestamp=0;
1292SET GLOBAL log_slow_admin_statements=1;
1293DROP TABLE IF EXISTS t1;
1294DROP TABLE IF EXISTS t2;
1295SET SESSION query_exec_time=1.11;
1296SET SESSION slow_query_log_query_time=1.11;
1297SET SESSION slow_query_log_lock_time=0.1;
1298CREATE TABLE t1(id INT) ENGINE=InnoDB;
1299SET SESSION query_exec_time=1.22;
1300SET SESSION slow_query_log_query_time=1.22;
1301SET SESSION slow_query_log_lock_time=0.2;
1302CREATE TABLE t2(id INT) ENGINE=MyISAM;
1303SET SESSION query_exec_time=1.33;
1304SET SESSION slow_query_log_query_time=1.33;
1305SET SESSION slow_query_log_lock_time=0.3;
1306INSERT INTO t1 VALUES(0);
1307SET SESSION query_exec_time=1.44;
1308SET SESSION slow_query_log_query_time=1.44;
1309SET SESSION slow_query_log_lock_time=0.4;
1310INSERT INTO t1 VALUES(1);
1311SET SESSION query_exec_time=1.55;
1312SET SESSION slow_query_log_query_time=1.55;
1313SET SESSION slow_query_log_lock_time=0.5;
1314INSERT INTO t1 VALUES(2);
1315SET SESSION query_exec_time=1.66;
1316SET SESSION slow_query_log_query_time=1.66;
1317SET SESSION slow_query_log_lock_time=0.6;
1318INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
1319SET SESSION query_exec_time=1.77;
1320SET SESSION slow_query_log_query_time=1.77;
1321SET SESSION slow_query_log_lock_time=0.7;
1322INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
1323SET SESSION query_exec_time=1.88;
1324SET SESSION slow_query_log_query_time=1.88;
1325SET SESSION slow_query_log_lock_time=0.8;
1326INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
1327SET SESSION query_exec_time=1.99;
1328SET SESSION slow_query_log_query_time=1.99;
1329SET SESSION slow_query_log_lock_time=0.9;
1330INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
1331SET SESSION query_exec_time=2.1;
1332SET SESSION slow_query_log_query_time=2.1;
1333SET SESSION slow_query_log_lock_time=1.0;
1334SELECT COUNT(*) FROM t1;
1335COUNT(*)
133612
1337SET SESSION query_exec_time=2.21;
1338SET SESSION slow_query_log_query_time=2.21;
1339SET SESSION slow_query_log_lock_time=1.1;
1340SELECT COUNT(*) FROM t2;
1341COUNT(*)
134224
1343SET SESSION query_exec_time=2.32;
1344SET SESSION slow_query_log_query_time=2.32;
1345SET SESSION slow_query_log_lock_time=1.2;
1346DROP TABLE t1;
1347SET SESSION query_exec_time=2.43;
1348SET SESSION slow_query_log_query_time=2.43;
1349SET SESSION slow_query_log_lock_time=1.3;
1350DROP TABLE t2;
1351SET SESSION query_exec_time=2.54;
1352SET SESSION slow_query_log_query_time=2.54;
1353SET SESSION slow_query_log_lock_time=1.4;
1354SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
1355SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
1356SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
1357SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
1358SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
1359SET GLOBAL log_slow_verbosity='innodb,microtime';
1360SET GLOBAL log_slow_timestamp_every=1;
1361SET GLOBAL log_slow_sp_statements=1;
1362SET GLOBAL slow_query_log_microseconds_timestamp=0;
1363SET GLOBAL log_slow_admin_statements=0;
1364DROP TABLE IF EXISTS t1;
1365DROP TABLE IF EXISTS t2;
1366SET SESSION query_exec_time=1.11;
1367SET SESSION slow_query_log_query_time=1.11;
1368SET SESSION slow_query_log_lock_time=0.1;
1369CREATE TABLE t1(id INT) ENGINE=InnoDB;
1370SET SESSION query_exec_time=1.22;
1371SET SESSION slow_query_log_query_time=1.22;
1372SET SESSION slow_query_log_lock_time=0.2;
1373CREATE TABLE t2(id INT) ENGINE=MyISAM;
1374SET SESSION query_exec_time=1.33;
1375SET SESSION slow_query_log_query_time=1.33;
1376SET SESSION slow_query_log_lock_time=0.3;
1377INSERT INTO t1 VALUES(0);
1378SET SESSION query_exec_time=1.44;
1379SET SESSION slow_query_log_query_time=1.44;
1380SET SESSION slow_query_log_lock_time=0.4;
1381INSERT INTO t1 VALUES(1);
1382SET SESSION query_exec_time=1.55;
1383SET SESSION slow_query_log_query_time=1.55;
1384SET SESSION slow_query_log_lock_time=0.5;
1385INSERT INTO t1 VALUES(2);
1386SET SESSION query_exec_time=1.66;
1387SET SESSION slow_query_log_query_time=1.66;
1388SET SESSION slow_query_log_lock_time=0.6;
1389INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
1390SET SESSION query_exec_time=1.77;
1391SET SESSION slow_query_log_query_time=1.77;
1392SET SESSION slow_query_log_lock_time=0.7;
1393INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
1394SET SESSION query_exec_time=1.88;
1395SET SESSION slow_query_log_query_time=1.88;
1396SET SESSION slow_query_log_lock_time=0.8;
1397INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
1398SET SESSION query_exec_time=1.99;
1399SET SESSION slow_query_log_query_time=1.99;
1400SET SESSION slow_query_log_lock_time=0.9;
1401INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
1402SET SESSION query_exec_time=2.1;
1403SET SESSION slow_query_log_query_time=2.1;
1404SET SESSION slow_query_log_lock_time=1.0;
1405SELECT COUNT(*) FROM t1;
1406COUNT(*)
140712
1408SET SESSION query_exec_time=2.21;
1409SET SESSION slow_query_log_query_time=2.21;
1410SET SESSION slow_query_log_lock_time=1.1;
1411SELECT COUNT(*) FROM t2;
1412COUNT(*)
141324
1414SET SESSION query_exec_time=2.32;
1415SET SESSION slow_query_log_query_time=2.32;
1416SET SESSION slow_query_log_lock_time=1.2;
1417DROP TABLE t1;
1418SET SESSION query_exec_time=2.43;
1419SET SESSION slow_query_log_query_time=2.43;
1420SET SESSION slow_query_log_lock_time=1.3;
1421DROP TABLE t2;
1422SET SESSION query_exec_time=2.54;
1423SET SESSION slow_query_log_query_time=2.54;
1424SET SESSION slow_query_log_lock_time=1.4;
1425SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
1426SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
1427SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
1428SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
1429SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
1430SET GLOBAL log_slow_verbosity='innodb,microtime';
1431SET GLOBAL log_slow_timestamp_every=1;
1432SET GLOBAL log_slow_sp_statements=0;
1433SET GLOBAL slow_query_log_microseconds_timestamp=1;
1434SET GLOBAL log_slow_admin_statements=1;
1435DROP TABLE IF EXISTS t1;
1436DROP TABLE IF EXISTS t2;
1437SET SESSION query_exec_time=1.11;
1438SET SESSION slow_query_log_query_time=1.11;
1439SET SESSION slow_query_log_lock_time=0.1;
1440CREATE TABLE t1(id INT) ENGINE=InnoDB;
1441SET SESSION query_exec_time=1.22;
1442SET SESSION slow_query_log_query_time=1.22;
1443SET SESSION slow_query_log_lock_time=0.2;
1444CREATE TABLE t2(id INT) ENGINE=MyISAM;
1445SET SESSION query_exec_time=1.33;
1446SET SESSION slow_query_log_query_time=1.33;
1447SET SESSION slow_query_log_lock_time=0.3;
1448INSERT INTO t1 VALUES(0);
1449SET SESSION query_exec_time=1.44;
1450SET SESSION slow_query_log_query_time=1.44;
1451SET SESSION slow_query_log_lock_time=0.4;
1452INSERT INTO t1 VALUES(1);
1453SET SESSION query_exec_time=1.55;
1454SET SESSION slow_query_log_query_time=1.55;
1455SET SESSION slow_query_log_lock_time=0.5;
1456INSERT INTO t1 VALUES(2);
1457SET SESSION query_exec_time=1.66;
1458SET SESSION slow_query_log_query_time=1.66;
1459SET SESSION slow_query_log_lock_time=0.6;
1460INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
1461SET SESSION query_exec_time=1.77;
1462SET SESSION slow_query_log_query_time=1.77;
1463SET SESSION slow_query_log_lock_time=0.7;
1464INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
1465SET SESSION query_exec_time=1.88;
1466SET SESSION slow_query_log_query_time=1.88;
1467SET SESSION slow_query_log_lock_time=0.8;
1468INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
1469SET SESSION query_exec_time=1.99;
1470SET SESSION slow_query_log_query_time=1.99;
1471SET SESSION slow_query_log_lock_time=0.9;
1472INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
1473SET SESSION query_exec_time=2.1;
1474SET SESSION slow_query_log_query_time=2.1;
1475SET SESSION slow_query_log_lock_time=1.0;
1476SELECT COUNT(*) FROM t1;
1477COUNT(*)
147812
1479SET SESSION query_exec_time=2.21;
1480SET SESSION slow_query_log_query_time=2.21;
1481SET SESSION slow_query_log_lock_time=1.1;
1482SELECT COUNT(*) FROM t2;
1483COUNT(*)
148424
1485SET SESSION query_exec_time=2.32;
1486SET SESSION slow_query_log_query_time=2.32;
1487SET SESSION slow_query_log_lock_time=1.2;
1488DROP TABLE t1;
1489SET SESSION query_exec_time=2.43;
1490SET SESSION slow_query_log_query_time=2.43;
1491SET SESSION slow_query_log_lock_time=1.3;
1492DROP TABLE t2;
1493SET SESSION query_exec_time=2.54;
1494SET SESSION slow_query_log_query_time=2.54;
1495SET SESSION slow_query_log_lock_time=1.4;
1496SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
1497SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
1498SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
1499SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
1500SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
1501SET GLOBAL log_slow_verbosity='innodb,microtime';
1502SET GLOBAL log_slow_timestamp_every=1;
1503SET GLOBAL log_slow_sp_statements=0;
1504SET GLOBAL slow_query_log_microseconds_timestamp=1;
1505SET GLOBAL log_slow_admin_statements=0;
1506DROP TABLE IF EXISTS t1;
1507DROP TABLE IF EXISTS t2;
1508SET SESSION query_exec_time=1.11;
1509SET SESSION slow_query_log_query_time=1.11;
1510SET SESSION slow_query_log_lock_time=0.1;
1511CREATE TABLE t1(id INT) ENGINE=InnoDB;
1512SET SESSION query_exec_time=1.22;
1513SET SESSION slow_query_log_query_time=1.22;
1514SET SESSION slow_query_log_lock_time=0.2;
1515CREATE TABLE t2(id INT) ENGINE=MyISAM;
1516SET SESSION query_exec_time=1.33;
1517SET SESSION slow_query_log_query_time=1.33;
1518SET SESSION slow_query_log_lock_time=0.3;
1519INSERT INTO t1 VALUES(0);
1520SET SESSION query_exec_time=1.44;
1521SET SESSION slow_query_log_query_time=1.44;
1522SET SESSION slow_query_log_lock_time=0.4;
1523INSERT INTO t1 VALUES(1);
1524SET SESSION query_exec_time=1.55;
1525SET SESSION slow_query_log_query_time=1.55;
1526SET SESSION slow_query_log_lock_time=0.5;
1527INSERT INTO t1 VALUES(2);
1528SET SESSION query_exec_time=1.66;
1529SET SESSION slow_query_log_query_time=1.66;
1530SET SESSION slow_query_log_lock_time=0.6;
1531INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
1532SET SESSION query_exec_time=1.77;
1533SET SESSION slow_query_log_query_time=1.77;
1534SET SESSION slow_query_log_lock_time=0.7;
1535INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
1536SET SESSION query_exec_time=1.88;
1537SET SESSION slow_query_log_query_time=1.88;
1538SET SESSION slow_query_log_lock_time=0.8;
1539INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
1540SET SESSION query_exec_time=1.99;
1541SET SESSION slow_query_log_query_time=1.99;
1542SET SESSION slow_query_log_lock_time=0.9;
1543INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
1544SET SESSION query_exec_time=2.1;
1545SET SESSION slow_query_log_query_time=2.1;
1546SET SESSION slow_query_log_lock_time=1.0;
1547SELECT COUNT(*) FROM t1;
1548COUNT(*)
154912
1550SET SESSION query_exec_time=2.21;
1551SET SESSION slow_query_log_query_time=2.21;
1552SET SESSION slow_query_log_lock_time=1.1;
1553SELECT COUNT(*) FROM t2;
1554COUNT(*)
155524
1556SET SESSION query_exec_time=2.32;
1557SET SESSION slow_query_log_query_time=2.32;
1558SET SESSION slow_query_log_lock_time=1.2;
1559DROP TABLE t1;
1560SET SESSION query_exec_time=2.43;
1561SET SESSION slow_query_log_query_time=2.43;
1562SET SESSION slow_query_log_lock_time=1.3;
1563DROP TABLE t2;
1564SET SESSION query_exec_time=2.54;
1565SET SESSION slow_query_log_query_time=2.54;
1566SET SESSION slow_query_log_lock_time=1.4;
1567SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
1568SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
1569SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
1570SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
1571SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
1572SET GLOBAL log_slow_verbosity='innodb,microtime';
1573SET GLOBAL log_slow_timestamp_every=1;
1574SET GLOBAL log_slow_sp_statements=0;
1575SET GLOBAL slow_query_log_microseconds_timestamp=0;
1576SET GLOBAL log_slow_admin_statements=1;
1577DROP TABLE IF EXISTS t1;
1578DROP TABLE IF EXISTS t2;
1579SET SESSION query_exec_time=1.11;
1580SET SESSION slow_query_log_query_time=1.11;
1581SET SESSION slow_query_log_lock_time=0.1;
1582CREATE TABLE t1(id INT) ENGINE=InnoDB;
1583SET SESSION query_exec_time=1.22;
1584SET SESSION slow_query_log_query_time=1.22;
1585SET SESSION slow_query_log_lock_time=0.2;
1586CREATE TABLE t2(id INT) ENGINE=MyISAM;
1587SET SESSION query_exec_time=1.33;
1588SET SESSION slow_query_log_query_time=1.33;
1589SET SESSION slow_query_log_lock_time=0.3;
1590INSERT INTO t1 VALUES(0);
1591SET SESSION query_exec_time=1.44;
1592SET SESSION slow_query_log_query_time=1.44;
1593SET SESSION slow_query_log_lock_time=0.4;
1594INSERT INTO t1 VALUES(1);
1595SET SESSION query_exec_time=1.55;
1596SET SESSION slow_query_log_query_time=1.55;
1597SET SESSION slow_query_log_lock_time=0.5;
1598INSERT INTO t1 VALUES(2);
1599SET SESSION query_exec_time=1.66;
1600SET SESSION slow_query_log_query_time=1.66;
1601SET SESSION slow_query_log_lock_time=0.6;
1602INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
1603SET SESSION query_exec_time=1.77;
1604SET SESSION slow_query_log_query_time=1.77;
1605SET SESSION slow_query_log_lock_time=0.7;
1606INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
1607SET SESSION query_exec_time=1.88;
1608SET SESSION slow_query_log_query_time=1.88;
1609SET SESSION slow_query_log_lock_time=0.8;
1610INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
1611SET SESSION query_exec_time=1.99;
1612SET SESSION slow_query_log_query_time=1.99;
1613SET SESSION slow_query_log_lock_time=0.9;
1614INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
1615SET SESSION query_exec_time=2.1;
1616SET SESSION slow_query_log_query_time=2.1;
1617SET SESSION slow_query_log_lock_time=1.0;
1618SELECT COUNT(*) FROM t1;
1619COUNT(*)
162012
1621SET SESSION query_exec_time=2.21;
1622SET SESSION slow_query_log_query_time=2.21;
1623SET SESSION slow_query_log_lock_time=1.1;
1624SELECT COUNT(*) FROM t2;
1625COUNT(*)
162624
1627SET SESSION query_exec_time=2.32;
1628SET SESSION slow_query_log_query_time=2.32;
1629SET SESSION slow_query_log_lock_time=1.2;
1630DROP TABLE t1;
1631SET SESSION query_exec_time=2.43;
1632SET SESSION slow_query_log_query_time=2.43;
1633SET SESSION slow_query_log_lock_time=1.3;
1634DROP TABLE t2;
1635SET SESSION query_exec_time=2.54;
1636SET SESSION slow_query_log_query_time=2.54;
1637SET SESSION slow_query_log_lock_time=1.4;
1638SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
1639SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
1640SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
1641SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
1642SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
1643SET GLOBAL log_slow_verbosity='innodb,microtime';
1644SET GLOBAL log_slow_timestamp_every=1;
1645SET GLOBAL log_slow_sp_statements=0;
1646SET GLOBAL slow_query_log_microseconds_timestamp=0;
1647SET GLOBAL log_slow_admin_statements=0;
1648DROP TABLE IF EXISTS t1;
1649DROP TABLE IF EXISTS t2;
1650SET SESSION query_exec_time=1.11;
1651SET SESSION slow_query_log_query_time=1.11;
1652SET SESSION slow_query_log_lock_time=0.1;
1653CREATE TABLE t1(id INT) ENGINE=InnoDB;
1654SET SESSION query_exec_time=1.22;
1655SET SESSION slow_query_log_query_time=1.22;
1656SET SESSION slow_query_log_lock_time=0.2;
1657CREATE TABLE t2(id INT) ENGINE=MyISAM;
1658SET SESSION query_exec_time=1.33;
1659SET SESSION slow_query_log_query_time=1.33;
1660SET SESSION slow_query_log_lock_time=0.3;
1661INSERT INTO t1 VALUES(0);
1662SET SESSION query_exec_time=1.44;
1663SET SESSION slow_query_log_query_time=1.44;
1664SET SESSION slow_query_log_lock_time=0.4;
1665INSERT INTO t1 VALUES(1);
1666SET SESSION query_exec_time=1.55;
1667SET SESSION slow_query_log_query_time=1.55;
1668SET SESSION slow_query_log_lock_time=0.5;
1669INSERT INTO t1 VALUES(2);
1670SET SESSION query_exec_time=1.66;
1671SET SESSION slow_query_log_query_time=1.66;
1672SET SESSION slow_query_log_lock_time=0.6;
1673INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
1674SET SESSION query_exec_time=1.77;
1675SET SESSION slow_query_log_query_time=1.77;
1676SET SESSION slow_query_log_lock_time=0.7;
1677INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
1678SET SESSION query_exec_time=1.88;
1679SET SESSION slow_query_log_query_time=1.88;
1680SET SESSION slow_query_log_lock_time=0.8;
1681INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
1682SET SESSION query_exec_time=1.99;
1683SET SESSION slow_query_log_query_time=1.99;
1684SET SESSION slow_query_log_lock_time=0.9;
1685INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
1686SET SESSION query_exec_time=2.1;
1687SET SESSION slow_query_log_query_time=2.1;
1688SET SESSION slow_query_log_lock_time=1.0;
1689SELECT COUNT(*) FROM t1;
1690COUNT(*)
169112
1692SET SESSION query_exec_time=2.21;
1693SET SESSION slow_query_log_query_time=2.21;
1694SET SESSION slow_query_log_lock_time=1.1;
1695SELECT COUNT(*) FROM t2;
1696COUNT(*)
169724
1698SET SESSION query_exec_time=2.32;
1699SET SESSION slow_query_log_query_time=2.32;
1700SET SESSION slow_query_log_lock_time=1.2;
1701DROP TABLE t1;
1702SET SESSION query_exec_time=2.43;
1703SET SESSION slow_query_log_query_time=2.43;
1704SET SESSION slow_query_log_lock_time=1.3;
1705DROP TABLE t2;
1706SET SESSION query_exec_time=2.54;
1707SET SESSION slow_query_log_query_time=2.54;
1708SET SESSION slow_query_log_lock_time=1.4;
1709SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
1710SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
1711SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
1712SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
1713SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
1714SET GLOBAL log_slow_verbosity='microtime';
1715SET GLOBAL log_slow_timestamp_every=1;
1716SET GLOBAL log_slow_sp_statements=1;
1717SET GLOBAL slow_query_log_microseconds_timestamp=1;
1718SET GLOBAL log_slow_admin_statements=1;
1719DROP TABLE IF EXISTS t1;
1720DROP TABLE IF EXISTS t2;
1721SET SESSION query_exec_time=1.11;
1722SET SESSION slow_query_log_query_time=1.11;
1723SET SESSION slow_query_log_lock_time=0.1;
1724CREATE TABLE t1(id INT) ENGINE=InnoDB;
1725SET SESSION query_exec_time=1.22;
1726SET SESSION slow_query_log_query_time=1.22;
1727SET SESSION slow_query_log_lock_time=0.2;
1728CREATE TABLE t2(id INT) ENGINE=MyISAM;
1729SET SESSION query_exec_time=1.33;
1730SET SESSION slow_query_log_query_time=1.33;
1731SET SESSION slow_query_log_lock_time=0.3;
1732INSERT INTO t1 VALUES(0);
1733SET SESSION query_exec_time=1.44;
1734SET SESSION slow_query_log_query_time=1.44;
1735SET SESSION slow_query_log_lock_time=0.4;
1736INSERT INTO t1 VALUES(1);
1737SET SESSION query_exec_time=1.55;
1738SET SESSION slow_query_log_query_time=1.55;
1739SET SESSION slow_query_log_lock_time=0.5;
1740INSERT INTO t1 VALUES(2);
1741SET SESSION query_exec_time=1.66;
1742SET SESSION slow_query_log_query_time=1.66;
1743SET SESSION slow_query_log_lock_time=0.6;
1744INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
1745SET SESSION query_exec_time=1.77;
1746SET SESSION slow_query_log_query_time=1.77;
1747SET SESSION slow_query_log_lock_time=0.7;
1748INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
1749SET SESSION query_exec_time=1.88;
1750SET SESSION slow_query_log_query_time=1.88;
1751SET SESSION slow_query_log_lock_time=0.8;
1752INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
1753SET SESSION query_exec_time=1.99;
1754SET SESSION slow_query_log_query_time=1.99;
1755SET SESSION slow_query_log_lock_time=0.9;
1756INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
1757SET SESSION query_exec_time=2.1;
1758SET SESSION slow_query_log_query_time=2.1;
1759SET SESSION slow_query_log_lock_time=1.0;
1760SELECT COUNT(*) FROM t1;
1761COUNT(*)
176212
1763SET SESSION query_exec_time=2.21;
1764SET SESSION slow_query_log_query_time=2.21;
1765SET SESSION slow_query_log_lock_time=1.1;
1766SELECT COUNT(*) FROM t2;
1767COUNT(*)
176824
1769SET SESSION query_exec_time=2.32;
1770SET SESSION slow_query_log_query_time=2.32;
1771SET SESSION slow_query_log_lock_time=1.2;
1772DROP TABLE t1;
1773SET SESSION query_exec_time=2.43;
1774SET SESSION slow_query_log_query_time=2.43;
1775SET SESSION slow_query_log_lock_time=1.3;
1776DROP TABLE t2;
1777SET SESSION query_exec_time=2.54;
1778SET SESSION slow_query_log_query_time=2.54;
1779SET SESSION slow_query_log_lock_time=1.4;
1780SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
1781SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
1782SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
1783SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
1784SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
1785SET GLOBAL log_slow_verbosity='microtime';
1786SET GLOBAL log_slow_timestamp_every=1;
1787SET GLOBAL log_slow_sp_statements=1;
1788SET GLOBAL slow_query_log_microseconds_timestamp=1;
1789SET GLOBAL log_slow_admin_statements=0;
1790DROP TABLE IF EXISTS t1;
1791DROP TABLE IF EXISTS t2;
1792SET SESSION query_exec_time=1.11;
1793SET SESSION slow_query_log_query_time=1.11;
1794SET SESSION slow_query_log_lock_time=0.1;
1795CREATE TABLE t1(id INT) ENGINE=InnoDB;
1796SET SESSION query_exec_time=1.22;
1797SET SESSION slow_query_log_query_time=1.22;
1798SET SESSION slow_query_log_lock_time=0.2;
1799CREATE TABLE t2(id INT) ENGINE=MyISAM;
1800SET SESSION query_exec_time=1.33;
1801SET SESSION slow_query_log_query_time=1.33;
1802SET SESSION slow_query_log_lock_time=0.3;
1803INSERT INTO t1 VALUES(0);
1804SET SESSION query_exec_time=1.44;
1805SET SESSION slow_query_log_query_time=1.44;
1806SET SESSION slow_query_log_lock_time=0.4;
1807INSERT INTO t1 VALUES(1);
1808SET SESSION query_exec_time=1.55;
1809SET SESSION slow_query_log_query_time=1.55;
1810SET SESSION slow_query_log_lock_time=0.5;
1811INSERT INTO t1 VALUES(2);
1812SET SESSION query_exec_time=1.66;
1813SET SESSION slow_query_log_query_time=1.66;
1814SET SESSION slow_query_log_lock_time=0.6;
1815INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
1816SET SESSION query_exec_time=1.77;
1817SET SESSION slow_query_log_query_time=1.77;
1818SET SESSION slow_query_log_lock_time=0.7;
1819INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
1820SET SESSION query_exec_time=1.88;
1821SET SESSION slow_query_log_query_time=1.88;
1822SET SESSION slow_query_log_lock_time=0.8;
1823INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
1824SET SESSION query_exec_time=1.99;
1825SET SESSION slow_query_log_query_time=1.99;
1826SET SESSION slow_query_log_lock_time=0.9;
1827INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
1828SET SESSION query_exec_time=2.1;
1829SET SESSION slow_query_log_query_time=2.1;
1830SET SESSION slow_query_log_lock_time=1.0;
1831SELECT COUNT(*) FROM t1;
1832COUNT(*)
183312
1834SET SESSION query_exec_time=2.21;
1835SET SESSION slow_query_log_query_time=2.21;
1836SET SESSION slow_query_log_lock_time=1.1;
1837SELECT COUNT(*) FROM t2;
1838COUNT(*)
183924
1840SET SESSION query_exec_time=2.32;
1841SET SESSION slow_query_log_query_time=2.32;
1842SET SESSION slow_query_log_lock_time=1.2;
1843DROP TABLE t1;
1844SET SESSION query_exec_time=2.43;
1845SET SESSION slow_query_log_query_time=2.43;
1846SET SESSION slow_query_log_lock_time=1.3;
1847DROP TABLE t2;
1848SET SESSION query_exec_time=2.54;
1849SET SESSION slow_query_log_query_time=2.54;
1850SET SESSION slow_query_log_lock_time=1.4;
1851SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
1852SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
1853SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
1854SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
1855SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
1856SET GLOBAL log_slow_verbosity='microtime';
1857SET GLOBAL log_slow_timestamp_every=1;
1858SET GLOBAL log_slow_sp_statements=1;
1859SET GLOBAL slow_query_log_microseconds_timestamp=0;
1860SET GLOBAL log_slow_admin_statements=1;
1861DROP TABLE IF EXISTS t1;
1862DROP TABLE IF EXISTS t2;
1863SET SESSION query_exec_time=1.11;
1864SET SESSION slow_query_log_query_time=1.11;
1865SET SESSION slow_query_log_lock_time=0.1;
1866CREATE TABLE t1(id INT) ENGINE=InnoDB;
1867SET SESSION query_exec_time=1.22;
1868SET SESSION slow_query_log_query_time=1.22;
1869SET SESSION slow_query_log_lock_time=0.2;
1870CREATE TABLE t2(id INT) ENGINE=MyISAM;
1871SET SESSION query_exec_time=1.33;
1872SET SESSION slow_query_log_query_time=1.33;
1873SET SESSION slow_query_log_lock_time=0.3;
1874INSERT INTO t1 VALUES(0);
1875SET SESSION query_exec_time=1.44;
1876SET SESSION slow_query_log_query_time=1.44;
1877SET SESSION slow_query_log_lock_time=0.4;
1878INSERT INTO t1 VALUES(1);
1879SET SESSION query_exec_time=1.55;
1880SET SESSION slow_query_log_query_time=1.55;
1881SET SESSION slow_query_log_lock_time=0.5;
1882INSERT INTO t1 VALUES(2);
1883SET SESSION query_exec_time=1.66;
1884SET SESSION slow_query_log_query_time=1.66;
1885SET SESSION slow_query_log_lock_time=0.6;
1886INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
1887SET SESSION query_exec_time=1.77;
1888SET SESSION slow_query_log_query_time=1.77;
1889SET SESSION slow_query_log_lock_time=0.7;
1890INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
1891SET SESSION query_exec_time=1.88;
1892SET SESSION slow_query_log_query_time=1.88;
1893SET SESSION slow_query_log_lock_time=0.8;
1894INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
1895SET SESSION query_exec_time=1.99;
1896SET SESSION slow_query_log_query_time=1.99;
1897SET SESSION slow_query_log_lock_time=0.9;
1898INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
1899SET SESSION query_exec_time=2.1;
1900SET SESSION slow_query_log_query_time=2.1;
1901SET SESSION slow_query_log_lock_time=1.0;
1902SELECT COUNT(*) FROM t1;
1903COUNT(*)
190412
1905SET SESSION query_exec_time=2.21;
1906SET SESSION slow_query_log_query_time=2.21;
1907SET SESSION slow_query_log_lock_time=1.1;
1908SELECT COUNT(*) FROM t2;
1909COUNT(*)
191024
1911SET SESSION query_exec_time=2.32;
1912SET SESSION slow_query_log_query_time=2.32;
1913SET SESSION slow_query_log_lock_time=1.2;
1914DROP TABLE t1;
1915SET SESSION query_exec_time=2.43;
1916SET SESSION slow_query_log_query_time=2.43;
1917SET SESSION slow_query_log_lock_time=1.3;
1918DROP TABLE t2;
1919SET SESSION query_exec_time=2.54;
1920SET SESSION slow_query_log_query_time=2.54;
1921SET SESSION slow_query_log_lock_time=1.4;
1922SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
1923SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
1924SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
1925SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
1926SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
1927SET GLOBAL log_slow_verbosity='microtime';
1928SET GLOBAL log_slow_timestamp_every=1;
1929SET GLOBAL log_slow_sp_statements=1;
1930SET GLOBAL slow_query_log_microseconds_timestamp=0;
1931SET GLOBAL log_slow_admin_statements=0;
1932DROP TABLE IF EXISTS t1;
1933DROP TABLE IF EXISTS t2;
1934SET SESSION query_exec_time=1.11;
1935SET SESSION slow_query_log_query_time=1.11;
1936SET SESSION slow_query_log_lock_time=0.1;
1937CREATE TABLE t1(id INT) ENGINE=InnoDB;
1938SET SESSION query_exec_time=1.22;
1939SET SESSION slow_query_log_query_time=1.22;
1940SET SESSION slow_query_log_lock_time=0.2;
1941CREATE TABLE t2(id INT) ENGINE=MyISAM;
1942SET SESSION query_exec_time=1.33;
1943SET SESSION slow_query_log_query_time=1.33;
1944SET SESSION slow_query_log_lock_time=0.3;
1945INSERT INTO t1 VALUES(0);
1946SET SESSION query_exec_time=1.44;
1947SET SESSION slow_query_log_query_time=1.44;
1948SET SESSION slow_query_log_lock_time=0.4;
1949INSERT INTO t1 VALUES(1);
1950SET SESSION query_exec_time=1.55;
1951SET SESSION slow_query_log_query_time=1.55;
1952SET SESSION slow_query_log_lock_time=0.5;
1953INSERT INTO t1 VALUES(2);
1954SET SESSION query_exec_time=1.66;
1955SET SESSION slow_query_log_query_time=1.66;
1956SET SESSION slow_query_log_lock_time=0.6;
1957INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
1958SET SESSION query_exec_time=1.77;
1959SET SESSION slow_query_log_query_time=1.77;
1960SET SESSION slow_query_log_lock_time=0.7;
1961INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
1962SET SESSION query_exec_time=1.88;
1963SET SESSION slow_query_log_query_time=1.88;
1964SET SESSION slow_query_log_lock_time=0.8;
1965INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
1966SET SESSION query_exec_time=1.99;
1967SET SESSION slow_query_log_query_time=1.99;
1968SET SESSION slow_query_log_lock_time=0.9;
1969INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
1970SET SESSION query_exec_time=2.1;
1971SET SESSION slow_query_log_query_time=2.1;
1972SET SESSION slow_query_log_lock_time=1.0;
1973SELECT COUNT(*) FROM t1;
1974COUNT(*)
197512
1976SET SESSION query_exec_time=2.21;
1977SET SESSION slow_query_log_query_time=2.21;
1978SET SESSION slow_query_log_lock_time=1.1;
1979SELECT COUNT(*) FROM t2;
1980COUNT(*)
198124
1982SET SESSION query_exec_time=2.32;
1983SET SESSION slow_query_log_query_time=2.32;
1984SET SESSION slow_query_log_lock_time=1.2;
1985DROP TABLE t1;
1986SET SESSION query_exec_time=2.43;
1987SET SESSION slow_query_log_query_time=2.43;
1988SET SESSION slow_query_log_lock_time=1.3;
1989DROP TABLE t2;
1990SET SESSION query_exec_time=2.54;
1991SET SESSION slow_query_log_query_time=2.54;
1992SET SESSION slow_query_log_lock_time=1.4;
1993SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
1994SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
1995SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
1996SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
1997SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
1998SET GLOBAL log_slow_verbosity='microtime';
1999SET GLOBAL log_slow_timestamp_every=1;
2000SET GLOBAL log_slow_sp_statements=0;
2001SET GLOBAL slow_query_log_microseconds_timestamp=1;
2002SET GLOBAL log_slow_admin_statements=1;
2003DROP TABLE IF EXISTS t1;
2004DROP TABLE IF EXISTS t2;
2005SET SESSION query_exec_time=1.11;
2006SET SESSION slow_query_log_query_time=1.11;
2007SET SESSION slow_query_log_lock_time=0.1;
2008CREATE TABLE t1(id INT) ENGINE=InnoDB;
2009SET SESSION query_exec_time=1.22;
2010SET SESSION slow_query_log_query_time=1.22;
2011SET SESSION slow_query_log_lock_time=0.2;
2012CREATE TABLE t2(id INT) ENGINE=MyISAM;
2013SET SESSION query_exec_time=1.33;
2014SET SESSION slow_query_log_query_time=1.33;
2015SET SESSION slow_query_log_lock_time=0.3;
2016INSERT INTO t1 VALUES(0);
2017SET SESSION query_exec_time=1.44;
2018SET SESSION slow_query_log_query_time=1.44;
2019SET SESSION slow_query_log_lock_time=0.4;
2020INSERT INTO t1 VALUES(1);
2021SET SESSION query_exec_time=1.55;
2022SET SESSION slow_query_log_query_time=1.55;
2023SET SESSION slow_query_log_lock_time=0.5;
2024INSERT INTO t1 VALUES(2);
2025SET SESSION query_exec_time=1.66;
2026SET SESSION slow_query_log_query_time=1.66;
2027SET SESSION slow_query_log_lock_time=0.6;
2028INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
2029SET SESSION query_exec_time=1.77;
2030SET SESSION slow_query_log_query_time=1.77;
2031SET SESSION slow_query_log_lock_time=0.7;
2032INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
2033SET SESSION query_exec_time=1.88;
2034SET SESSION slow_query_log_query_time=1.88;
2035SET SESSION slow_query_log_lock_time=0.8;
2036INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
2037SET SESSION query_exec_time=1.99;
2038SET SESSION slow_query_log_query_time=1.99;
2039SET SESSION slow_query_log_lock_time=0.9;
2040INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
2041SET SESSION query_exec_time=2.1;
2042SET SESSION slow_query_log_query_time=2.1;
2043SET SESSION slow_query_log_lock_time=1.0;
2044SELECT COUNT(*) FROM t1;
2045COUNT(*)
204612
2047SET SESSION query_exec_time=2.21;
2048SET SESSION slow_query_log_query_time=2.21;
2049SET SESSION slow_query_log_lock_time=1.1;
2050SELECT COUNT(*) FROM t2;
2051COUNT(*)
205224
2053SET SESSION query_exec_time=2.32;
2054SET SESSION slow_query_log_query_time=2.32;
2055SET SESSION slow_query_log_lock_time=1.2;
2056DROP TABLE t1;
2057SET SESSION query_exec_time=2.43;
2058SET SESSION slow_query_log_query_time=2.43;
2059SET SESSION slow_query_log_lock_time=1.3;
2060DROP TABLE t2;
2061SET SESSION query_exec_time=2.54;
2062SET SESSION slow_query_log_query_time=2.54;
2063SET SESSION slow_query_log_lock_time=1.4;
2064SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
2065SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
2066SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
2067SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
2068SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
2069SET GLOBAL log_slow_verbosity='microtime';
2070SET GLOBAL log_slow_timestamp_every=1;
2071SET GLOBAL log_slow_sp_statements=0;
2072SET GLOBAL slow_query_log_microseconds_timestamp=1;
2073SET GLOBAL log_slow_admin_statements=0;
2074DROP TABLE IF EXISTS t1;
2075DROP TABLE IF EXISTS t2;
2076SET SESSION query_exec_time=1.11;
2077SET SESSION slow_query_log_query_time=1.11;
2078SET SESSION slow_query_log_lock_time=0.1;
2079CREATE TABLE t1(id INT) ENGINE=InnoDB;
2080SET SESSION query_exec_time=1.22;
2081SET SESSION slow_query_log_query_time=1.22;
2082SET SESSION slow_query_log_lock_time=0.2;
2083CREATE TABLE t2(id INT) ENGINE=MyISAM;
2084SET SESSION query_exec_time=1.33;
2085SET SESSION slow_query_log_query_time=1.33;
2086SET SESSION slow_query_log_lock_time=0.3;
2087INSERT INTO t1 VALUES(0);
2088SET SESSION query_exec_time=1.44;
2089SET SESSION slow_query_log_query_time=1.44;
2090SET SESSION slow_query_log_lock_time=0.4;
2091INSERT INTO t1 VALUES(1);
2092SET SESSION query_exec_time=1.55;
2093SET SESSION slow_query_log_query_time=1.55;
2094SET SESSION slow_query_log_lock_time=0.5;
2095INSERT INTO t1 VALUES(2);
2096SET SESSION query_exec_time=1.66;
2097SET SESSION slow_query_log_query_time=1.66;
2098SET SESSION slow_query_log_lock_time=0.6;
2099INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
2100SET SESSION query_exec_time=1.77;
2101SET SESSION slow_query_log_query_time=1.77;
2102SET SESSION slow_query_log_lock_time=0.7;
2103INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
2104SET SESSION query_exec_time=1.88;
2105SET SESSION slow_query_log_query_time=1.88;
2106SET SESSION slow_query_log_lock_time=0.8;
2107INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
2108SET SESSION query_exec_time=1.99;
2109SET SESSION slow_query_log_query_time=1.99;
2110SET SESSION slow_query_log_lock_time=0.9;
2111INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
2112SET SESSION query_exec_time=2.1;
2113SET SESSION slow_query_log_query_time=2.1;
2114SET SESSION slow_query_log_lock_time=1.0;
2115SELECT COUNT(*) FROM t1;
2116COUNT(*)
211712
2118SET SESSION query_exec_time=2.21;
2119SET SESSION slow_query_log_query_time=2.21;
2120SET SESSION slow_query_log_lock_time=1.1;
2121SELECT COUNT(*) FROM t2;
2122COUNT(*)
212324
2124SET SESSION query_exec_time=2.32;
2125SET SESSION slow_query_log_query_time=2.32;
2126SET SESSION slow_query_log_lock_time=1.2;
2127DROP TABLE t1;
2128SET SESSION query_exec_time=2.43;
2129SET SESSION slow_query_log_query_time=2.43;
2130SET SESSION slow_query_log_lock_time=1.3;
2131DROP TABLE t2;
2132SET SESSION query_exec_time=2.54;
2133SET SESSION slow_query_log_query_time=2.54;
2134SET SESSION slow_query_log_lock_time=1.4;
2135SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
2136SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
2137SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
2138SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
2139SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
2140SET GLOBAL log_slow_verbosity='microtime';
2141SET GLOBAL log_slow_timestamp_every=1;
2142SET GLOBAL log_slow_sp_statements=0;
2143SET GLOBAL slow_query_log_microseconds_timestamp=0;
2144SET GLOBAL log_slow_admin_statements=1;
2145DROP TABLE IF EXISTS t1;
2146DROP TABLE IF EXISTS t2;
2147SET SESSION query_exec_time=1.11;
2148SET SESSION slow_query_log_query_time=1.11;
2149SET SESSION slow_query_log_lock_time=0.1;
2150CREATE TABLE t1(id INT) ENGINE=InnoDB;
2151SET SESSION query_exec_time=1.22;
2152SET SESSION slow_query_log_query_time=1.22;
2153SET SESSION slow_query_log_lock_time=0.2;
2154CREATE TABLE t2(id INT) ENGINE=MyISAM;
2155SET SESSION query_exec_time=1.33;
2156SET SESSION slow_query_log_query_time=1.33;
2157SET SESSION slow_query_log_lock_time=0.3;
2158INSERT INTO t1 VALUES(0);
2159SET SESSION query_exec_time=1.44;
2160SET SESSION slow_query_log_query_time=1.44;
2161SET SESSION slow_query_log_lock_time=0.4;
2162INSERT INTO t1 VALUES(1);
2163SET SESSION query_exec_time=1.55;
2164SET SESSION slow_query_log_query_time=1.55;
2165SET SESSION slow_query_log_lock_time=0.5;
2166INSERT INTO t1 VALUES(2);
2167SET SESSION query_exec_time=1.66;
2168SET SESSION slow_query_log_query_time=1.66;
2169SET SESSION slow_query_log_lock_time=0.6;
2170INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
2171SET SESSION query_exec_time=1.77;
2172SET SESSION slow_query_log_query_time=1.77;
2173SET SESSION slow_query_log_lock_time=0.7;
2174INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
2175SET SESSION query_exec_time=1.88;
2176SET SESSION slow_query_log_query_time=1.88;
2177SET SESSION slow_query_log_lock_time=0.8;
2178INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
2179SET SESSION query_exec_time=1.99;
2180SET SESSION slow_query_log_query_time=1.99;
2181SET SESSION slow_query_log_lock_time=0.9;
2182INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
2183SET SESSION query_exec_time=2.1;
2184SET SESSION slow_query_log_query_time=2.1;
2185SET SESSION slow_query_log_lock_time=1.0;
2186SELECT COUNT(*) FROM t1;
2187COUNT(*)
218812
2189SET SESSION query_exec_time=2.21;
2190SET SESSION slow_query_log_query_time=2.21;
2191SET SESSION slow_query_log_lock_time=1.1;
2192SELECT COUNT(*) FROM t2;
2193COUNT(*)
219424
2195SET SESSION query_exec_time=2.32;
2196SET SESSION slow_query_log_query_time=2.32;
2197SET SESSION slow_query_log_lock_time=1.2;
2198DROP TABLE t1;
2199SET SESSION query_exec_time=2.43;
2200SET SESSION slow_query_log_query_time=2.43;
2201SET SESSION slow_query_log_lock_time=1.3;
2202DROP TABLE t2;
2203SET SESSION query_exec_time=2.54;
2204SET SESSION slow_query_log_query_time=2.54;
2205SET SESSION slow_query_log_lock_time=1.4;
2206SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
2207SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
2208SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
2209SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
2210SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
2211SET GLOBAL log_slow_verbosity='microtime';
2212SET GLOBAL log_slow_timestamp_every=1;
2213SET GLOBAL log_slow_sp_statements=0;
2214SET GLOBAL slow_query_log_microseconds_timestamp=0;
2215SET GLOBAL log_slow_admin_statements=0;
2216DROP TABLE IF EXISTS t1;
2217DROP TABLE IF EXISTS t2;
2218SET SESSION query_exec_time=1.11;
2219SET SESSION slow_query_log_query_time=1.11;
2220SET SESSION slow_query_log_lock_time=0.1;
2221CREATE TABLE t1(id INT) ENGINE=InnoDB;
2222SET SESSION query_exec_time=1.22;
2223SET SESSION slow_query_log_query_time=1.22;
2224SET SESSION slow_query_log_lock_time=0.2;
2225CREATE TABLE t2(id INT) ENGINE=MyISAM;
2226SET SESSION query_exec_time=1.33;
2227SET SESSION slow_query_log_query_time=1.33;
2228SET SESSION slow_query_log_lock_time=0.3;
2229INSERT INTO t1 VALUES(0);
2230SET SESSION query_exec_time=1.44;
2231SET SESSION slow_query_log_query_time=1.44;
2232SET SESSION slow_query_log_lock_time=0.4;
2233INSERT INTO t1 VALUES(1);
2234SET SESSION query_exec_time=1.55;
2235SET SESSION slow_query_log_query_time=1.55;
2236SET SESSION slow_query_log_lock_time=0.5;
2237INSERT INTO t1 VALUES(2);
2238SET SESSION query_exec_time=1.66;
2239SET SESSION slow_query_log_query_time=1.66;
2240SET SESSION slow_query_log_lock_time=0.6;
2241INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
2242SET SESSION query_exec_time=1.77;
2243SET SESSION slow_query_log_query_time=1.77;
2244SET SESSION slow_query_log_lock_time=0.7;
2245INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
2246SET SESSION query_exec_time=1.88;
2247SET SESSION slow_query_log_query_time=1.88;
2248SET SESSION slow_query_log_lock_time=0.8;
2249INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
2250SET SESSION query_exec_time=1.99;
2251SET SESSION slow_query_log_query_time=1.99;
2252SET SESSION slow_query_log_lock_time=0.9;
2253INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
2254SET SESSION query_exec_time=2.1;
2255SET SESSION slow_query_log_query_time=2.1;
2256SET SESSION slow_query_log_lock_time=1.0;
2257SELECT COUNT(*) FROM t1;
2258COUNT(*)
225912
2260SET SESSION query_exec_time=2.21;
2261SET SESSION slow_query_log_query_time=2.21;
2262SET SESSION slow_query_log_lock_time=1.1;
2263SELECT COUNT(*) FROM t2;
2264COUNT(*)
226524
2266SET SESSION query_exec_time=2.32;
2267SET SESSION slow_query_log_query_time=2.32;
2268SET SESSION slow_query_log_lock_time=1.2;
2269DROP TABLE t1;
2270SET SESSION query_exec_time=2.43;
2271SET SESSION slow_query_log_query_time=2.43;
2272SET SESSION slow_query_log_lock_time=1.3;
2273DROP TABLE t2;
2274SET SESSION query_exec_time=2.54;
2275SET SESSION slow_query_log_query_time=2.54;
2276SET SESSION slow_query_log_lock_time=1.4;
2277SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
2278SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
2279SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
2280SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
2281SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
2282SET GLOBAL log_slow_verbosity='innodb,query_plan';
2283SET GLOBAL log_slow_timestamp_every=1;
2284SET GLOBAL log_slow_sp_statements=1;
2285SET GLOBAL slow_query_log_microseconds_timestamp=1;
2286SET GLOBAL log_slow_admin_statements=1;
2287DROP TABLE IF EXISTS t1;
2288DROP TABLE IF EXISTS t2;
2289SET SESSION query_exec_time=1.11;
2290SET SESSION slow_query_log_query_time=1.11;
2291SET SESSION slow_query_log_lock_time=0.1;
2292CREATE TABLE t1(id INT) ENGINE=InnoDB;
2293SET SESSION query_exec_time=1.22;
2294SET SESSION slow_query_log_query_time=1.22;
2295SET SESSION slow_query_log_lock_time=0.2;
2296CREATE TABLE t2(id INT) ENGINE=MyISAM;
2297SET SESSION query_exec_time=1.33;
2298SET SESSION slow_query_log_query_time=1.33;
2299SET SESSION slow_query_log_lock_time=0.3;
2300INSERT INTO t1 VALUES(0);
2301SET SESSION query_exec_time=1.44;
2302SET SESSION slow_query_log_query_time=1.44;
2303SET SESSION slow_query_log_lock_time=0.4;
2304INSERT INTO t1 VALUES(1);
2305SET SESSION query_exec_time=1.55;
2306SET SESSION slow_query_log_query_time=1.55;
2307SET SESSION slow_query_log_lock_time=0.5;
2308INSERT INTO t1 VALUES(2);
2309SET SESSION query_exec_time=1.66;
2310SET SESSION slow_query_log_query_time=1.66;
2311SET SESSION slow_query_log_lock_time=0.6;
2312INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
2313SET SESSION query_exec_time=1.77;
2314SET SESSION slow_query_log_query_time=1.77;
2315SET SESSION slow_query_log_lock_time=0.7;
2316INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
2317SET SESSION query_exec_time=1.88;
2318SET SESSION slow_query_log_query_time=1.88;
2319SET SESSION slow_query_log_lock_time=0.8;
2320INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
2321SET SESSION query_exec_time=1.99;
2322SET SESSION slow_query_log_query_time=1.99;
2323SET SESSION slow_query_log_lock_time=0.9;
2324INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
2325SET SESSION query_exec_time=2.1;
2326SET SESSION slow_query_log_query_time=2.1;
2327SET SESSION slow_query_log_lock_time=1.0;
2328SELECT COUNT(*) FROM t1;
2329COUNT(*)
233012
2331SET SESSION query_exec_time=2.21;
2332SET SESSION slow_query_log_query_time=2.21;
2333SET SESSION slow_query_log_lock_time=1.1;
2334SELECT COUNT(*) FROM t2;
2335COUNT(*)
233624
2337SET SESSION query_exec_time=2.32;
2338SET SESSION slow_query_log_query_time=2.32;
2339SET SESSION slow_query_log_lock_time=1.2;
2340DROP TABLE t1;
2341SET SESSION query_exec_time=2.43;
2342SET SESSION slow_query_log_query_time=2.43;
2343SET SESSION slow_query_log_lock_time=1.3;
2344DROP TABLE t2;
2345SET SESSION query_exec_time=2.54;
2346SET SESSION slow_query_log_query_time=2.54;
2347SET SESSION slow_query_log_lock_time=1.4;
2348SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
2349SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
2350SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
2351SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
2352SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
2353SET GLOBAL log_slow_verbosity='innodb,query_plan';
2354SET GLOBAL log_slow_timestamp_every=1;
2355SET GLOBAL log_slow_sp_statements=1;
2356SET GLOBAL slow_query_log_microseconds_timestamp=1;
2357SET GLOBAL log_slow_admin_statements=0;
2358DROP TABLE IF EXISTS t1;
2359DROP TABLE IF EXISTS t2;
2360SET SESSION query_exec_time=1.11;
2361SET SESSION slow_query_log_query_time=1.11;
2362SET SESSION slow_query_log_lock_time=0.1;
2363CREATE TABLE t1(id INT) ENGINE=InnoDB;
2364SET SESSION query_exec_time=1.22;
2365SET SESSION slow_query_log_query_time=1.22;
2366SET SESSION slow_query_log_lock_time=0.2;
2367CREATE TABLE t2(id INT) ENGINE=MyISAM;
2368SET SESSION query_exec_time=1.33;
2369SET SESSION slow_query_log_query_time=1.33;
2370SET SESSION slow_query_log_lock_time=0.3;
2371INSERT INTO t1 VALUES(0);
2372SET SESSION query_exec_time=1.44;
2373SET SESSION slow_query_log_query_time=1.44;
2374SET SESSION slow_query_log_lock_time=0.4;
2375INSERT INTO t1 VALUES(1);
2376SET SESSION query_exec_time=1.55;
2377SET SESSION slow_query_log_query_time=1.55;
2378SET SESSION slow_query_log_lock_time=0.5;
2379INSERT INTO t1 VALUES(2);
2380SET SESSION query_exec_time=1.66;
2381SET SESSION slow_query_log_query_time=1.66;
2382SET SESSION slow_query_log_lock_time=0.6;
2383INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
2384SET SESSION query_exec_time=1.77;
2385SET SESSION slow_query_log_query_time=1.77;
2386SET SESSION slow_query_log_lock_time=0.7;
2387INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
2388SET SESSION query_exec_time=1.88;
2389SET SESSION slow_query_log_query_time=1.88;
2390SET SESSION slow_query_log_lock_time=0.8;
2391INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
2392SET SESSION query_exec_time=1.99;
2393SET SESSION slow_query_log_query_time=1.99;
2394SET SESSION slow_query_log_lock_time=0.9;
2395INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
2396SET SESSION query_exec_time=2.1;
2397SET SESSION slow_query_log_query_time=2.1;
2398SET SESSION slow_query_log_lock_time=1.0;
2399SELECT COUNT(*) FROM t1;
2400COUNT(*)
240112
2402SET SESSION query_exec_time=2.21;
2403SET SESSION slow_query_log_query_time=2.21;
2404SET SESSION slow_query_log_lock_time=1.1;
2405SELECT COUNT(*) FROM t2;
2406COUNT(*)
240724
2408SET SESSION query_exec_time=2.32;
2409SET SESSION slow_query_log_query_time=2.32;
2410SET SESSION slow_query_log_lock_time=1.2;
2411DROP TABLE t1;
2412SET SESSION query_exec_time=2.43;
2413SET SESSION slow_query_log_query_time=2.43;
2414SET SESSION slow_query_log_lock_time=1.3;
2415DROP TABLE t2;
2416SET SESSION query_exec_time=2.54;
2417SET SESSION slow_query_log_query_time=2.54;
2418SET SESSION slow_query_log_lock_time=1.4;
2419SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
2420SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
2421SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
2422SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
2423SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
2424SET GLOBAL log_slow_verbosity='innodb,query_plan';
2425SET GLOBAL log_slow_timestamp_every=1;
2426SET GLOBAL log_slow_sp_statements=1;
2427SET GLOBAL slow_query_log_microseconds_timestamp=0;
2428SET GLOBAL log_slow_admin_statements=1;
2429DROP TABLE IF EXISTS t1;
2430DROP TABLE IF EXISTS t2;
2431SET SESSION query_exec_time=1.11;
2432SET SESSION slow_query_log_query_time=1.11;
2433SET SESSION slow_query_log_lock_time=0.1;
2434CREATE TABLE t1(id INT) ENGINE=InnoDB;
2435SET SESSION query_exec_time=1.22;
2436SET SESSION slow_query_log_query_time=1.22;
2437SET SESSION slow_query_log_lock_time=0.2;
2438CREATE TABLE t2(id INT) ENGINE=MyISAM;
2439SET SESSION query_exec_time=1.33;
2440SET SESSION slow_query_log_query_time=1.33;
2441SET SESSION slow_query_log_lock_time=0.3;
2442INSERT INTO t1 VALUES(0);
2443SET SESSION query_exec_time=1.44;
2444SET SESSION slow_query_log_query_time=1.44;
2445SET SESSION slow_query_log_lock_time=0.4;
2446INSERT INTO t1 VALUES(1);
2447SET SESSION query_exec_time=1.55;
2448SET SESSION slow_query_log_query_time=1.55;
2449SET SESSION slow_query_log_lock_time=0.5;
2450INSERT INTO t1 VALUES(2);
2451SET SESSION query_exec_time=1.66;
2452SET SESSION slow_query_log_query_time=1.66;
2453SET SESSION slow_query_log_lock_time=0.6;
2454INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
2455SET SESSION query_exec_time=1.77;
2456SET SESSION slow_query_log_query_time=1.77;
2457SET SESSION slow_query_log_lock_time=0.7;
2458INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
2459SET SESSION query_exec_time=1.88;
2460SET SESSION slow_query_log_query_time=1.88;
2461SET SESSION slow_query_log_lock_time=0.8;
2462INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
2463SET SESSION query_exec_time=1.99;
2464SET SESSION slow_query_log_query_time=1.99;
2465SET SESSION slow_query_log_lock_time=0.9;
2466INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
2467SET SESSION query_exec_time=2.1;
2468SET SESSION slow_query_log_query_time=2.1;
2469SET SESSION slow_query_log_lock_time=1.0;
2470SELECT COUNT(*) FROM t1;
2471COUNT(*)
247212
2473SET SESSION query_exec_time=2.21;
2474SET SESSION slow_query_log_query_time=2.21;
2475SET SESSION slow_query_log_lock_time=1.1;
2476SELECT COUNT(*) FROM t2;
2477COUNT(*)
247824
2479SET SESSION query_exec_time=2.32;
2480SET SESSION slow_query_log_query_time=2.32;
2481SET SESSION slow_query_log_lock_time=1.2;
2482DROP TABLE t1;
2483SET SESSION query_exec_time=2.43;
2484SET SESSION slow_query_log_query_time=2.43;
2485SET SESSION slow_query_log_lock_time=1.3;
2486DROP TABLE t2;
2487SET SESSION query_exec_time=2.54;
2488SET SESSION slow_query_log_query_time=2.54;
2489SET SESSION slow_query_log_lock_time=1.4;
2490SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
2491SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
2492SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
2493SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
2494SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
2495SET GLOBAL log_slow_verbosity='innodb,query_plan';
2496SET GLOBAL log_slow_timestamp_every=1;
2497SET GLOBAL log_slow_sp_statements=1;
2498SET GLOBAL slow_query_log_microseconds_timestamp=0;
2499SET GLOBAL log_slow_admin_statements=0;
2500DROP TABLE IF EXISTS t1;
2501DROP TABLE IF EXISTS t2;
2502SET SESSION query_exec_time=1.11;
2503SET SESSION slow_query_log_query_time=1.11;
2504SET SESSION slow_query_log_lock_time=0.1;
2505CREATE TABLE t1(id INT) ENGINE=InnoDB;
2506SET SESSION query_exec_time=1.22;
2507SET SESSION slow_query_log_query_time=1.22;
2508SET SESSION slow_query_log_lock_time=0.2;
2509CREATE TABLE t2(id INT) ENGINE=MyISAM;
2510SET SESSION query_exec_time=1.33;
2511SET SESSION slow_query_log_query_time=1.33;
2512SET SESSION slow_query_log_lock_time=0.3;
2513INSERT INTO t1 VALUES(0);
2514SET SESSION query_exec_time=1.44;
2515SET SESSION slow_query_log_query_time=1.44;
2516SET SESSION slow_query_log_lock_time=0.4;
2517INSERT INTO t1 VALUES(1);
2518SET SESSION query_exec_time=1.55;
2519SET SESSION slow_query_log_query_time=1.55;
2520SET SESSION slow_query_log_lock_time=0.5;
2521INSERT INTO t1 VALUES(2);
2522SET SESSION query_exec_time=1.66;
2523SET SESSION slow_query_log_query_time=1.66;
2524SET SESSION slow_query_log_lock_time=0.6;
2525INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
2526SET SESSION query_exec_time=1.77;
2527SET SESSION slow_query_log_query_time=1.77;
2528SET SESSION slow_query_log_lock_time=0.7;
2529INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
2530SET SESSION query_exec_time=1.88;
2531SET SESSION slow_query_log_query_time=1.88;
2532SET SESSION slow_query_log_lock_time=0.8;
2533INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
2534SET SESSION query_exec_time=1.99;
2535SET SESSION slow_query_log_query_time=1.99;
2536SET SESSION slow_query_log_lock_time=0.9;
2537INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
2538SET SESSION query_exec_time=2.1;
2539SET SESSION slow_query_log_query_time=2.1;
2540SET SESSION slow_query_log_lock_time=1.0;
2541SELECT COUNT(*) FROM t1;
2542COUNT(*)
254312
2544SET SESSION query_exec_time=2.21;
2545SET SESSION slow_query_log_query_time=2.21;
2546SET SESSION slow_query_log_lock_time=1.1;
2547SELECT COUNT(*) FROM t2;
2548COUNT(*)
254924
2550SET SESSION query_exec_time=2.32;
2551SET SESSION slow_query_log_query_time=2.32;
2552SET SESSION slow_query_log_lock_time=1.2;
2553DROP TABLE t1;
2554SET SESSION query_exec_time=2.43;
2555SET SESSION slow_query_log_query_time=2.43;
2556SET SESSION slow_query_log_lock_time=1.3;
2557DROP TABLE t2;
2558SET SESSION query_exec_time=2.54;
2559SET SESSION slow_query_log_query_time=2.54;
2560SET SESSION slow_query_log_lock_time=1.4;
2561SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
2562SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
2563SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
2564SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
2565SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
2566SET GLOBAL log_slow_verbosity='innodb,query_plan';
2567SET GLOBAL log_slow_timestamp_every=1;
2568SET GLOBAL log_slow_sp_statements=0;
2569SET GLOBAL slow_query_log_microseconds_timestamp=1;
2570SET GLOBAL log_slow_admin_statements=1;
2571DROP TABLE IF EXISTS t1;
2572DROP TABLE IF EXISTS t2;
2573SET SESSION query_exec_time=1.11;
2574SET SESSION slow_query_log_query_time=1.11;
2575SET SESSION slow_query_log_lock_time=0.1;
2576CREATE TABLE t1(id INT) ENGINE=InnoDB;
2577SET SESSION query_exec_time=1.22;
2578SET SESSION slow_query_log_query_time=1.22;
2579SET SESSION slow_query_log_lock_time=0.2;
2580CREATE TABLE t2(id INT) ENGINE=MyISAM;
2581SET SESSION query_exec_time=1.33;
2582SET SESSION slow_query_log_query_time=1.33;
2583SET SESSION slow_query_log_lock_time=0.3;
2584INSERT INTO t1 VALUES(0);
2585SET SESSION query_exec_time=1.44;
2586SET SESSION slow_query_log_query_time=1.44;
2587SET SESSION slow_query_log_lock_time=0.4;
2588INSERT INTO t1 VALUES(1);
2589SET SESSION query_exec_time=1.55;
2590SET SESSION slow_query_log_query_time=1.55;
2591SET SESSION slow_query_log_lock_time=0.5;
2592INSERT INTO t1 VALUES(2);
2593SET SESSION query_exec_time=1.66;
2594SET SESSION slow_query_log_query_time=1.66;
2595SET SESSION slow_query_log_lock_time=0.6;
2596INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
2597SET SESSION query_exec_time=1.77;
2598SET SESSION slow_query_log_query_time=1.77;
2599SET SESSION slow_query_log_lock_time=0.7;
2600INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
2601SET SESSION query_exec_time=1.88;
2602SET SESSION slow_query_log_query_time=1.88;
2603SET SESSION slow_query_log_lock_time=0.8;
2604INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
2605SET SESSION query_exec_time=1.99;
2606SET SESSION slow_query_log_query_time=1.99;
2607SET SESSION slow_query_log_lock_time=0.9;
2608INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
2609SET SESSION query_exec_time=2.1;
2610SET SESSION slow_query_log_query_time=2.1;
2611SET SESSION slow_query_log_lock_time=1.0;
2612SELECT COUNT(*) FROM t1;
2613COUNT(*)
261412
2615SET SESSION query_exec_time=2.21;
2616SET SESSION slow_query_log_query_time=2.21;
2617SET SESSION slow_query_log_lock_time=1.1;
2618SELECT COUNT(*) FROM t2;
2619COUNT(*)
262024
2621SET SESSION query_exec_time=2.32;
2622SET SESSION slow_query_log_query_time=2.32;
2623SET SESSION slow_query_log_lock_time=1.2;
2624DROP TABLE t1;
2625SET SESSION query_exec_time=2.43;
2626SET SESSION slow_query_log_query_time=2.43;
2627SET SESSION slow_query_log_lock_time=1.3;
2628DROP TABLE t2;
2629SET SESSION query_exec_time=2.54;
2630SET SESSION slow_query_log_query_time=2.54;
2631SET SESSION slow_query_log_lock_time=1.4;
2632SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
2633SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
2634SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
2635SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
2636SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
2637SET GLOBAL log_slow_verbosity='innodb,query_plan';
2638SET GLOBAL log_slow_timestamp_every=1;
2639SET GLOBAL log_slow_sp_statements=0;
2640SET GLOBAL slow_query_log_microseconds_timestamp=1;
2641SET GLOBAL log_slow_admin_statements=0;
2642DROP TABLE IF EXISTS t1;
2643DROP TABLE IF EXISTS t2;
2644SET SESSION query_exec_time=1.11;
2645SET SESSION slow_query_log_query_time=1.11;
2646SET SESSION slow_query_log_lock_time=0.1;
2647CREATE TABLE t1(id INT) ENGINE=InnoDB;
2648SET SESSION query_exec_time=1.22;
2649SET SESSION slow_query_log_query_time=1.22;
2650SET SESSION slow_query_log_lock_time=0.2;
2651CREATE TABLE t2(id INT) ENGINE=MyISAM;
2652SET SESSION query_exec_time=1.33;
2653SET SESSION slow_query_log_query_time=1.33;
2654SET SESSION slow_query_log_lock_time=0.3;
2655INSERT INTO t1 VALUES(0);
2656SET SESSION query_exec_time=1.44;
2657SET SESSION slow_query_log_query_time=1.44;
2658SET SESSION slow_query_log_lock_time=0.4;
2659INSERT INTO t1 VALUES(1);
2660SET SESSION query_exec_time=1.55;
2661SET SESSION slow_query_log_query_time=1.55;
2662SET SESSION slow_query_log_lock_time=0.5;
2663INSERT INTO t1 VALUES(2);
2664SET SESSION query_exec_time=1.66;
2665SET SESSION slow_query_log_query_time=1.66;
2666SET SESSION slow_query_log_lock_time=0.6;
2667INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
2668SET SESSION query_exec_time=1.77;
2669SET SESSION slow_query_log_query_time=1.77;
2670SET SESSION slow_query_log_lock_time=0.7;
2671INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
2672SET SESSION query_exec_time=1.88;
2673SET SESSION slow_query_log_query_time=1.88;
2674SET SESSION slow_query_log_lock_time=0.8;
2675INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
2676SET SESSION query_exec_time=1.99;
2677SET SESSION slow_query_log_query_time=1.99;
2678SET SESSION slow_query_log_lock_time=0.9;
2679INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
2680SET SESSION query_exec_time=2.1;
2681SET SESSION slow_query_log_query_time=2.1;
2682SET SESSION slow_query_log_lock_time=1.0;
2683SELECT COUNT(*) FROM t1;
2684COUNT(*)
268512
2686SET SESSION query_exec_time=2.21;
2687SET SESSION slow_query_log_query_time=2.21;
2688SET SESSION slow_query_log_lock_time=1.1;
2689SELECT COUNT(*) FROM t2;
2690COUNT(*)
269124
2692SET SESSION query_exec_time=2.32;
2693SET SESSION slow_query_log_query_time=2.32;
2694SET SESSION slow_query_log_lock_time=1.2;
2695DROP TABLE t1;
2696SET SESSION query_exec_time=2.43;
2697SET SESSION slow_query_log_query_time=2.43;
2698SET SESSION slow_query_log_lock_time=1.3;
2699DROP TABLE t2;
2700SET SESSION query_exec_time=2.54;
2701SET SESSION slow_query_log_query_time=2.54;
2702SET SESSION slow_query_log_lock_time=1.4;
2703SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
2704SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
2705SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
2706SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
2707SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
2708SET GLOBAL log_slow_verbosity='innodb,query_plan';
2709SET GLOBAL log_slow_timestamp_every=1;
2710SET GLOBAL log_slow_sp_statements=0;
2711SET GLOBAL slow_query_log_microseconds_timestamp=0;
2712SET GLOBAL log_slow_admin_statements=1;
2713DROP TABLE IF EXISTS t1;
2714DROP TABLE IF EXISTS t2;
2715SET SESSION query_exec_time=1.11;
2716SET SESSION slow_query_log_query_time=1.11;
2717SET SESSION slow_query_log_lock_time=0.1;
2718CREATE TABLE t1(id INT) ENGINE=InnoDB;
2719SET SESSION query_exec_time=1.22;
2720SET SESSION slow_query_log_query_time=1.22;
2721SET SESSION slow_query_log_lock_time=0.2;
2722CREATE TABLE t2(id INT) ENGINE=MyISAM;
2723SET SESSION query_exec_time=1.33;
2724SET SESSION slow_query_log_query_time=1.33;
2725SET SESSION slow_query_log_lock_time=0.3;
2726INSERT INTO t1 VALUES(0);
2727SET SESSION query_exec_time=1.44;
2728SET SESSION slow_query_log_query_time=1.44;
2729SET SESSION slow_query_log_lock_time=0.4;
2730INSERT INTO t1 VALUES(1);
2731SET SESSION query_exec_time=1.55;
2732SET SESSION slow_query_log_query_time=1.55;
2733SET SESSION slow_query_log_lock_time=0.5;
2734INSERT INTO t1 VALUES(2);
2735SET SESSION query_exec_time=1.66;
2736SET SESSION slow_query_log_query_time=1.66;
2737SET SESSION slow_query_log_lock_time=0.6;
2738INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
2739SET SESSION query_exec_time=1.77;
2740SET SESSION slow_query_log_query_time=1.77;
2741SET SESSION slow_query_log_lock_time=0.7;
2742INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
2743SET SESSION query_exec_time=1.88;
2744SET SESSION slow_query_log_query_time=1.88;
2745SET SESSION slow_query_log_lock_time=0.8;
2746INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
2747SET SESSION query_exec_time=1.99;
2748SET SESSION slow_query_log_query_time=1.99;
2749SET SESSION slow_query_log_lock_time=0.9;
2750INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
2751SET SESSION query_exec_time=2.1;
2752SET SESSION slow_query_log_query_time=2.1;
2753SET SESSION slow_query_log_lock_time=1.0;
2754SELECT COUNT(*) FROM t1;
2755COUNT(*)
275612
2757SET SESSION query_exec_time=2.21;
2758SET SESSION slow_query_log_query_time=2.21;
2759SET SESSION slow_query_log_lock_time=1.1;
2760SELECT COUNT(*) FROM t2;
2761COUNT(*)
276224
2763SET SESSION query_exec_time=2.32;
2764SET SESSION slow_query_log_query_time=2.32;
2765SET SESSION slow_query_log_lock_time=1.2;
2766DROP TABLE t1;
2767SET SESSION query_exec_time=2.43;
2768SET SESSION slow_query_log_query_time=2.43;
2769SET SESSION slow_query_log_lock_time=1.3;
2770DROP TABLE t2;
2771SET SESSION query_exec_time=2.54;
2772SET SESSION slow_query_log_query_time=2.54;
2773SET SESSION slow_query_log_lock_time=1.4;
2774SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
2775SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
2776SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
2777SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
2778SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
2779SET GLOBAL log_slow_verbosity='innodb,query_plan';
2780SET GLOBAL log_slow_timestamp_every=1;
2781SET GLOBAL log_slow_sp_statements=0;
2782SET GLOBAL slow_query_log_microseconds_timestamp=0;
2783SET GLOBAL log_slow_admin_statements=0;
2784DROP TABLE IF EXISTS t1;
2785DROP TABLE IF EXISTS t2;
2786SET SESSION query_exec_time=1.11;
2787SET SESSION slow_query_log_query_time=1.11;
2788SET SESSION slow_query_log_lock_time=0.1;
2789CREATE TABLE t1(id INT) ENGINE=InnoDB;
2790SET SESSION query_exec_time=1.22;
2791SET SESSION slow_query_log_query_time=1.22;
2792SET SESSION slow_query_log_lock_time=0.2;
2793CREATE TABLE t2(id INT) ENGINE=MyISAM;
2794SET SESSION query_exec_time=1.33;
2795SET SESSION slow_query_log_query_time=1.33;
2796SET SESSION slow_query_log_lock_time=0.3;
2797INSERT INTO t1 VALUES(0);
2798SET SESSION query_exec_time=1.44;
2799SET SESSION slow_query_log_query_time=1.44;
2800SET SESSION slow_query_log_lock_time=0.4;
2801INSERT INTO t1 VALUES(1);
2802SET SESSION query_exec_time=1.55;
2803SET SESSION slow_query_log_query_time=1.55;
2804SET SESSION slow_query_log_lock_time=0.5;
2805INSERT INTO t1 VALUES(2);
2806SET SESSION query_exec_time=1.66;
2807SET SESSION slow_query_log_query_time=1.66;
2808SET SESSION slow_query_log_lock_time=0.6;
2809INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
2810SET SESSION query_exec_time=1.77;
2811SET SESSION slow_query_log_query_time=1.77;
2812SET SESSION slow_query_log_lock_time=0.7;
2813INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
2814SET SESSION query_exec_time=1.88;
2815SET SESSION slow_query_log_query_time=1.88;
2816SET SESSION slow_query_log_lock_time=0.8;
2817INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
2818SET SESSION query_exec_time=1.99;
2819SET SESSION slow_query_log_query_time=1.99;
2820SET SESSION slow_query_log_lock_time=0.9;
2821INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
2822SET SESSION query_exec_time=2.1;
2823SET SESSION slow_query_log_query_time=2.1;
2824SET SESSION slow_query_log_lock_time=1.0;
2825SELECT COUNT(*) FROM t1;
2826COUNT(*)
282712
2828SET SESSION query_exec_time=2.21;
2829SET SESSION slow_query_log_query_time=2.21;
2830SET SESSION slow_query_log_lock_time=1.1;
2831SELECT COUNT(*) FROM t2;
2832COUNT(*)
283324
2834SET SESSION query_exec_time=2.32;
2835SET SESSION slow_query_log_query_time=2.32;
2836SET SESSION slow_query_log_lock_time=1.2;
2837DROP TABLE t1;
2838SET SESSION query_exec_time=2.43;
2839SET SESSION slow_query_log_query_time=2.43;
2840SET SESSION slow_query_log_lock_time=1.3;
2841DROP TABLE t2;
2842SET SESSION query_exec_time=2.54;
2843SET SESSION slow_query_log_query_time=2.54;
2844SET SESSION slow_query_log_lock_time=1.4;
2845SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
2846SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
2847SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
2848SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
2849SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
2850SET GLOBAL log_slow_verbosity='query_plan';
2851SET GLOBAL log_slow_timestamp_every=1;
2852SET GLOBAL log_slow_sp_statements=1;
2853SET GLOBAL slow_query_log_microseconds_timestamp=1;
2854SET GLOBAL log_slow_admin_statements=1;
2855DROP TABLE IF EXISTS t1;
2856DROP TABLE IF EXISTS t2;
2857SET SESSION query_exec_time=1.11;
2858SET SESSION slow_query_log_query_time=1.11;
2859SET SESSION slow_query_log_lock_time=0.1;
2860CREATE TABLE t1(id INT) ENGINE=InnoDB;
2861SET SESSION query_exec_time=1.22;
2862SET SESSION slow_query_log_query_time=1.22;
2863SET SESSION slow_query_log_lock_time=0.2;
2864CREATE TABLE t2(id INT) ENGINE=MyISAM;
2865SET SESSION query_exec_time=1.33;
2866SET SESSION slow_query_log_query_time=1.33;
2867SET SESSION slow_query_log_lock_time=0.3;
2868INSERT INTO t1 VALUES(0);
2869SET SESSION query_exec_time=1.44;
2870SET SESSION slow_query_log_query_time=1.44;
2871SET SESSION slow_query_log_lock_time=0.4;
2872INSERT INTO t1 VALUES(1);
2873SET SESSION query_exec_time=1.55;
2874SET SESSION slow_query_log_query_time=1.55;
2875SET SESSION slow_query_log_lock_time=0.5;
2876INSERT INTO t1 VALUES(2);
2877SET SESSION query_exec_time=1.66;
2878SET SESSION slow_query_log_query_time=1.66;
2879SET SESSION slow_query_log_lock_time=0.6;
2880INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
2881SET SESSION query_exec_time=1.77;
2882SET SESSION slow_query_log_query_time=1.77;
2883SET SESSION slow_query_log_lock_time=0.7;
2884INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
2885SET SESSION query_exec_time=1.88;
2886SET SESSION slow_query_log_query_time=1.88;
2887SET SESSION slow_query_log_lock_time=0.8;
2888INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
2889SET SESSION query_exec_time=1.99;
2890SET SESSION slow_query_log_query_time=1.99;
2891SET SESSION slow_query_log_lock_time=0.9;
2892INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
2893SET SESSION query_exec_time=2.1;
2894SET SESSION slow_query_log_query_time=2.1;
2895SET SESSION slow_query_log_lock_time=1.0;
2896SELECT COUNT(*) FROM t1;
2897COUNT(*)
289812
2899SET SESSION query_exec_time=2.21;
2900SET SESSION slow_query_log_query_time=2.21;
2901SET SESSION slow_query_log_lock_time=1.1;
2902SELECT COUNT(*) FROM t2;
2903COUNT(*)
290424
2905SET SESSION query_exec_time=2.32;
2906SET SESSION slow_query_log_query_time=2.32;
2907SET SESSION slow_query_log_lock_time=1.2;
2908DROP TABLE t1;
2909SET SESSION query_exec_time=2.43;
2910SET SESSION slow_query_log_query_time=2.43;
2911SET SESSION slow_query_log_lock_time=1.3;
2912DROP TABLE t2;
2913SET SESSION query_exec_time=2.54;
2914SET SESSION slow_query_log_query_time=2.54;
2915SET SESSION slow_query_log_lock_time=1.4;
2916SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
2917SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
2918SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
2919SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
2920SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
2921SET GLOBAL log_slow_verbosity='query_plan';
2922SET GLOBAL log_slow_timestamp_every=1;
2923SET GLOBAL log_slow_sp_statements=1;
2924SET GLOBAL slow_query_log_microseconds_timestamp=1;
2925SET GLOBAL log_slow_admin_statements=0;
2926DROP TABLE IF EXISTS t1;
2927DROP TABLE IF EXISTS t2;
2928SET SESSION query_exec_time=1.11;
2929SET SESSION slow_query_log_query_time=1.11;
2930SET SESSION slow_query_log_lock_time=0.1;
2931CREATE TABLE t1(id INT) ENGINE=InnoDB;
2932SET SESSION query_exec_time=1.22;
2933SET SESSION slow_query_log_query_time=1.22;
2934SET SESSION slow_query_log_lock_time=0.2;
2935CREATE TABLE t2(id INT) ENGINE=MyISAM;
2936SET SESSION query_exec_time=1.33;
2937SET SESSION slow_query_log_query_time=1.33;
2938SET SESSION slow_query_log_lock_time=0.3;
2939INSERT INTO t1 VALUES(0);
2940SET SESSION query_exec_time=1.44;
2941SET SESSION slow_query_log_query_time=1.44;
2942SET SESSION slow_query_log_lock_time=0.4;
2943INSERT INTO t1 VALUES(1);
2944SET SESSION query_exec_time=1.55;
2945SET SESSION slow_query_log_query_time=1.55;
2946SET SESSION slow_query_log_lock_time=0.5;
2947INSERT INTO t1 VALUES(2);
2948SET SESSION query_exec_time=1.66;
2949SET SESSION slow_query_log_query_time=1.66;
2950SET SESSION slow_query_log_lock_time=0.6;
2951INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
2952SET SESSION query_exec_time=1.77;
2953SET SESSION slow_query_log_query_time=1.77;
2954SET SESSION slow_query_log_lock_time=0.7;
2955INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
2956SET SESSION query_exec_time=1.88;
2957SET SESSION slow_query_log_query_time=1.88;
2958SET SESSION slow_query_log_lock_time=0.8;
2959INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
2960SET SESSION query_exec_time=1.99;
2961SET SESSION slow_query_log_query_time=1.99;
2962SET SESSION slow_query_log_lock_time=0.9;
2963INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
2964SET SESSION query_exec_time=2.1;
2965SET SESSION slow_query_log_query_time=2.1;
2966SET SESSION slow_query_log_lock_time=1.0;
2967SELECT COUNT(*) FROM t1;
2968COUNT(*)
296912
2970SET SESSION query_exec_time=2.21;
2971SET SESSION slow_query_log_query_time=2.21;
2972SET SESSION slow_query_log_lock_time=1.1;
2973SELECT COUNT(*) FROM t2;
2974COUNT(*)
297524
2976SET SESSION query_exec_time=2.32;
2977SET SESSION slow_query_log_query_time=2.32;
2978SET SESSION slow_query_log_lock_time=1.2;
2979DROP TABLE t1;
2980SET SESSION query_exec_time=2.43;
2981SET SESSION slow_query_log_query_time=2.43;
2982SET SESSION slow_query_log_lock_time=1.3;
2983DROP TABLE t2;
2984SET SESSION query_exec_time=2.54;
2985SET SESSION slow_query_log_query_time=2.54;
2986SET SESSION slow_query_log_lock_time=1.4;
2987SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
2988SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
2989SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
2990SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
2991SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
2992SET GLOBAL log_slow_verbosity='query_plan';
2993SET GLOBAL log_slow_timestamp_every=1;
2994SET GLOBAL log_slow_sp_statements=1;
2995SET GLOBAL slow_query_log_microseconds_timestamp=0;
2996SET GLOBAL log_slow_admin_statements=1;
2997DROP TABLE IF EXISTS t1;
2998DROP TABLE IF EXISTS t2;
2999SET SESSION query_exec_time=1.11;
3000SET SESSION slow_query_log_query_time=1.11;
3001SET SESSION slow_query_log_lock_time=0.1;
3002CREATE TABLE t1(id INT) ENGINE=InnoDB;
3003SET SESSION query_exec_time=1.22;
3004SET SESSION slow_query_log_query_time=1.22;
3005SET SESSION slow_query_log_lock_time=0.2;
3006CREATE TABLE t2(id INT) ENGINE=MyISAM;
3007SET SESSION query_exec_time=1.33;
3008SET SESSION slow_query_log_query_time=1.33;
3009SET SESSION slow_query_log_lock_time=0.3;
3010INSERT INTO t1 VALUES(0);
3011SET SESSION query_exec_time=1.44;
3012SET SESSION slow_query_log_query_time=1.44;
3013SET SESSION slow_query_log_lock_time=0.4;
3014INSERT INTO t1 VALUES(1);
3015SET SESSION query_exec_time=1.55;
3016SET SESSION slow_query_log_query_time=1.55;
3017SET SESSION slow_query_log_lock_time=0.5;
3018INSERT INTO t1 VALUES(2);
3019SET SESSION query_exec_time=1.66;
3020SET SESSION slow_query_log_query_time=1.66;
3021SET SESSION slow_query_log_lock_time=0.6;
3022INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
3023SET SESSION query_exec_time=1.77;
3024SET SESSION slow_query_log_query_time=1.77;
3025SET SESSION slow_query_log_lock_time=0.7;
3026INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
3027SET SESSION query_exec_time=1.88;
3028SET SESSION slow_query_log_query_time=1.88;
3029SET SESSION slow_query_log_lock_time=0.8;
3030INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
3031SET SESSION query_exec_time=1.99;
3032SET SESSION slow_query_log_query_time=1.99;
3033SET SESSION slow_query_log_lock_time=0.9;
3034INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
3035SET SESSION query_exec_time=2.1;
3036SET SESSION slow_query_log_query_time=2.1;
3037SET SESSION slow_query_log_lock_time=1.0;
3038SELECT COUNT(*) FROM t1;
3039COUNT(*)
304012
3041SET SESSION query_exec_time=2.21;
3042SET SESSION slow_query_log_query_time=2.21;
3043SET SESSION slow_query_log_lock_time=1.1;
3044SELECT COUNT(*) FROM t2;
3045COUNT(*)
304624
3047SET SESSION query_exec_time=2.32;
3048SET SESSION slow_query_log_query_time=2.32;
3049SET SESSION slow_query_log_lock_time=1.2;
3050DROP TABLE t1;
3051SET SESSION query_exec_time=2.43;
3052SET SESSION slow_query_log_query_time=2.43;
3053SET SESSION slow_query_log_lock_time=1.3;
3054DROP TABLE t2;
3055SET SESSION query_exec_time=2.54;
3056SET SESSION slow_query_log_query_time=2.54;
3057SET SESSION slow_query_log_lock_time=1.4;
3058SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
3059SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
3060SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
3061SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
3062SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
3063SET GLOBAL log_slow_verbosity='query_plan';
3064SET GLOBAL log_slow_timestamp_every=1;
3065SET GLOBAL log_slow_sp_statements=1;
3066SET GLOBAL slow_query_log_microseconds_timestamp=0;
3067SET GLOBAL log_slow_admin_statements=0;
3068DROP TABLE IF EXISTS t1;
3069DROP TABLE IF EXISTS t2;
3070SET SESSION query_exec_time=1.11;
3071SET SESSION slow_query_log_query_time=1.11;
3072SET SESSION slow_query_log_lock_time=0.1;
3073CREATE TABLE t1(id INT) ENGINE=InnoDB;
3074SET SESSION query_exec_time=1.22;
3075SET SESSION slow_query_log_query_time=1.22;
3076SET SESSION slow_query_log_lock_time=0.2;
3077CREATE TABLE t2(id INT) ENGINE=MyISAM;
3078SET SESSION query_exec_time=1.33;
3079SET SESSION slow_query_log_query_time=1.33;
3080SET SESSION slow_query_log_lock_time=0.3;
3081INSERT INTO t1 VALUES(0);
3082SET SESSION query_exec_time=1.44;
3083SET SESSION slow_query_log_query_time=1.44;
3084SET SESSION slow_query_log_lock_time=0.4;
3085INSERT INTO t1 VALUES(1);
3086SET SESSION query_exec_time=1.55;
3087SET SESSION slow_query_log_query_time=1.55;
3088SET SESSION slow_query_log_lock_time=0.5;
3089INSERT INTO t1 VALUES(2);
3090SET SESSION query_exec_time=1.66;
3091SET SESSION slow_query_log_query_time=1.66;
3092SET SESSION slow_query_log_lock_time=0.6;
3093INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
3094SET SESSION query_exec_time=1.77;
3095SET SESSION slow_query_log_query_time=1.77;
3096SET SESSION slow_query_log_lock_time=0.7;
3097INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
3098SET SESSION query_exec_time=1.88;
3099SET SESSION slow_query_log_query_time=1.88;
3100SET SESSION slow_query_log_lock_time=0.8;
3101INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
3102SET SESSION query_exec_time=1.99;
3103SET SESSION slow_query_log_query_time=1.99;
3104SET SESSION slow_query_log_lock_time=0.9;
3105INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
3106SET SESSION query_exec_time=2.1;
3107SET SESSION slow_query_log_query_time=2.1;
3108SET SESSION slow_query_log_lock_time=1.0;
3109SELECT COUNT(*) FROM t1;
3110COUNT(*)
311112
3112SET SESSION query_exec_time=2.21;
3113SET SESSION slow_query_log_query_time=2.21;
3114SET SESSION slow_query_log_lock_time=1.1;
3115SELECT COUNT(*) FROM t2;
3116COUNT(*)
311724
3118SET SESSION query_exec_time=2.32;
3119SET SESSION slow_query_log_query_time=2.32;
3120SET SESSION slow_query_log_lock_time=1.2;
3121DROP TABLE t1;
3122SET SESSION query_exec_time=2.43;
3123SET SESSION slow_query_log_query_time=2.43;
3124SET SESSION slow_query_log_lock_time=1.3;
3125DROP TABLE t2;
3126SET SESSION query_exec_time=2.54;
3127SET SESSION slow_query_log_query_time=2.54;
3128SET SESSION slow_query_log_lock_time=1.4;
3129SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
3130SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
3131SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
3132SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
3133SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
3134SET GLOBAL log_slow_verbosity='query_plan';
3135SET GLOBAL log_slow_timestamp_every=1;
3136SET GLOBAL log_slow_sp_statements=0;
3137SET GLOBAL slow_query_log_microseconds_timestamp=1;
3138SET GLOBAL log_slow_admin_statements=1;
3139DROP TABLE IF EXISTS t1;
3140DROP TABLE IF EXISTS t2;
3141SET SESSION query_exec_time=1.11;
3142SET SESSION slow_query_log_query_time=1.11;
3143SET SESSION slow_query_log_lock_time=0.1;
3144CREATE TABLE t1(id INT) ENGINE=InnoDB;
3145SET SESSION query_exec_time=1.22;
3146SET SESSION slow_query_log_query_time=1.22;
3147SET SESSION slow_query_log_lock_time=0.2;
3148CREATE TABLE t2(id INT) ENGINE=MyISAM;
3149SET SESSION query_exec_time=1.33;
3150SET SESSION slow_query_log_query_time=1.33;
3151SET SESSION slow_query_log_lock_time=0.3;
3152INSERT INTO t1 VALUES(0);
3153SET SESSION query_exec_time=1.44;
3154SET SESSION slow_query_log_query_time=1.44;
3155SET SESSION slow_query_log_lock_time=0.4;
3156INSERT INTO t1 VALUES(1);
3157SET SESSION query_exec_time=1.55;
3158SET SESSION slow_query_log_query_time=1.55;
3159SET SESSION slow_query_log_lock_time=0.5;
3160INSERT INTO t1 VALUES(2);
3161SET SESSION query_exec_time=1.66;
3162SET SESSION slow_query_log_query_time=1.66;
3163SET SESSION slow_query_log_lock_time=0.6;
3164INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
3165SET SESSION query_exec_time=1.77;
3166SET SESSION slow_query_log_query_time=1.77;
3167SET SESSION slow_query_log_lock_time=0.7;
3168INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
3169SET SESSION query_exec_time=1.88;
3170SET SESSION slow_query_log_query_time=1.88;
3171SET SESSION slow_query_log_lock_time=0.8;
3172INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
3173SET SESSION query_exec_time=1.99;
3174SET SESSION slow_query_log_query_time=1.99;
3175SET SESSION slow_query_log_lock_time=0.9;
3176INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
3177SET SESSION query_exec_time=2.1;
3178SET SESSION slow_query_log_query_time=2.1;
3179SET SESSION slow_query_log_lock_time=1.0;
3180SELECT COUNT(*) FROM t1;
3181COUNT(*)
318212
3183SET SESSION query_exec_time=2.21;
3184SET SESSION slow_query_log_query_time=2.21;
3185SET SESSION slow_query_log_lock_time=1.1;
3186SELECT COUNT(*) FROM t2;
3187COUNT(*)
318824
3189SET SESSION query_exec_time=2.32;
3190SET SESSION slow_query_log_query_time=2.32;
3191SET SESSION slow_query_log_lock_time=1.2;
3192DROP TABLE t1;
3193SET SESSION query_exec_time=2.43;
3194SET SESSION slow_query_log_query_time=2.43;
3195SET SESSION slow_query_log_lock_time=1.3;
3196DROP TABLE t2;
3197SET SESSION query_exec_time=2.54;
3198SET SESSION slow_query_log_query_time=2.54;
3199SET SESSION slow_query_log_lock_time=1.4;
3200SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
3201SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
3202SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
3203SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
3204SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
3205SET GLOBAL log_slow_verbosity='query_plan';
3206SET GLOBAL log_slow_timestamp_every=1;
3207SET GLOBAL log_slow_sp_statements=0;
3208SET GLOBAL slow_query_log_microseconds_timestamp=1;
3209SET GLOBAL log_slow_admin_statements=0;
3210DROP TABLE IF EXISTS t1;
3211DROP TABLE IF EXISTS t2;
3212SET SESSION query_exec_time=1.11;
3213SET SESSION slow_query_log_query_time=1.11;
3214SET SESSION slow_query_log_lock_time=0.1;
3215CREATE TABLE t1(id INT) ENGINE=InnoDB;
3216SET SESSION query_exec_time=1.22;
3217SET SESSION slow_query_log_query_time=1.22;
3218SET SESSION slow_query_log_lock_time=0.2;
3219CREATE TABLE t2(id INT) ENGINE=MyISAM;
3220SET SESSION query_exec_time=1.33;
3221SET SESSION slow_query_log_query_time=1.33;
3222SET SESSION slow_query_log_lock_time=0.3;
3223INSERT INTO t1 VALUES(0);
3224SET SESSION query_exec_time=1.44;
3225SET SESSION slow_query_log_query_time=1.44;
3226SET SESSION slow_query_log_lock_time=0.4;
3227INSERT INTO t1 VALUES(1);
3228SET SESSION query_exec_time=1.55;
3229SET SESSION slow_query_log_query_time=1.55;
3230SET SESSION slow_query_log_lock_time=0.5;
3231INSERT INTO t1 VALUES(2);
3232SET SESSION query_exec_time=1.66;
3233SET SESSION slow_query_log_query_time=1.66;
3234SET SESSION slow_query_log_lock_time=0.6;
3235INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
3236SET SESSION query_exec_time=1.77;
3237SET SESSION slow_query_log_query_time=1.77;
3238SET SESSION slow_query_log_lock_time=0.7;
3239INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
3240SET SESSION query_exec_time=1.88;
3241SET SESSION slow_query_log_query_time=1.88;
3242SET SESSION slow_query_log_lock_time=0.8;
3243INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
3244SET SESSION query_exec_time=1.99;
3245SET SESSION slow_query_log_query_time=1.99;
3246SET SESSION slow_query_log_lock_time=0.9;
3247INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
3248SET SESSION query_exec_time=2.1;
3249SET SESSION slow_query_log_query_time=2.1;
3250SET SESSION slow_query_log_lock_time=1.0;
3251SELECT COUNT(*) FROM t1;
3252COUNT(*)
325312
3254SET SESSION query_exec_time=2.21;
3255SET SESSION slow_query_log_query_time=2.21;
3256SET SESSION slow_query_log_lock_time=1.1;
3257SELECT COUNT(*) FROM t2;
3258COUNT(*)
325924
3260SET SESSION query_exec_time=2.32;
3261SET SESSION slow_query_log_query_time=2.32;
3262SET SESSION slow_query_log_lock_time=1.2;
3263DROP TABLE t1;
3264SET SESSION query_exec_time=2.43;
3265SET SESSION slow_query_log_query_time=2.43;
3266SET SESSION slow_query_log_lock_time=1.3;
3267DROP TABLE t2;
3268SET SESSION query_exec_time=2.54;
3269SET SESSION slow_query_log_query_time=2.54;
3270SET SESSION slow_query_log_lock_time=1.4;
3271SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
3272SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
3273SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
3274SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
3275SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
3276SET GLOBAL log_slow_verbosity='query_plan';
3277SET GLOBAL log_slow_timestamp_every=1;
3278SET GLOBAL log_slow_sp_statements=0;
3279SET GLOBAL slow_query_log_microseconds_timestamp=0;
3280SET GLOBAL log_slow_admin_statements=1;
3281DROP TABLE IF EXISTS t1;
3282DROP TABLE IF EXISTS t2;
3283SET SESSION query_exec_time=1.11;
3284SET SESSION slow_query_log_query_time=1.11;
3285SET SESSION slow_query_log_lock_time=0.1;
3286CREATE TABLE t1(id INT) ENGINE=InnoDB;
3287SET SESSION query_exec_time=1.22;
3288SET SESSION slow_query_log_query_time=1.22;
3289SET SESSION slow_query_log_lock_time=0.2;
3290CREATE TABLE t2(id INT) ENGINE=MyISAM;
3291SET SESSION query_exec_time=1.33;
3292SET SESSION slow_query_log_query_time=1.33;
3293SET SESSION slow_query_log_lock_time=0.3;
3294INSERT INTO t1 VALUES(0);
3295SET SESSION query_exec_time=1.44;
3296SET SESSION slow_query_log_query_time=1.44;
3297SET SESSION slow_query_log_lock_time=0.4;
3298INSERT INTO t1 VALUES(1);
3299SET SESSION query_exec_time=1.55;
3300SET SESSION slow_query_log_query_time=1.55;
3301SET SESSION slow_query_log_lock_time=0.5;
3302INSERT INTO t1 VALUES(2);
3303SET SESSION query_exec_time=1.66;
3304SET SESSION slow_query_log_query_time=1.66;
3305SET SESSION slow_query_log_lock_time=0.6;
3306INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
3307SET SESSION query_exec_time=1.77;
3308SET SESSION slow_query_log_query_time=1.77;
3309SET SESSION slow_query_log_lock_time=0.7;
3310INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
3311SET SESSION query_exec_time=1.88;
3312SET SESSION slow_query_log_query_time=1.88;
3313SET SESSION slow_query_log_lock_time=0.8;
3314INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
3315SET SESSION query_exec_time=1.99;
3316SET SESSION slow_query_log_query_time=1.99;
3317SET SESSION slow_query_log_lock_time=0.9;
3318INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
3319SET SESSION query_exec_time=2.1;
3320SET SESSION slow_query_log_query_time=2.1;
3321SET SESSION slow_query_log_lock_time=1.0;
3322SELECT COUNT(*) FROM t1;
3323COUNT(*)
332412
3325SET SESSION query_exec_time=2.21;
3326SET SESSION slow_query_log_query_time=2.21;
3327SET SESSION slow_query_log_lock_time=1.1;
3328SELECT COUNT(*) FROM t2;
3329COUNT(*)
333024
3331SET SESSION query_exec_time=2.32;
3332SET SESSION slow_query_log_query_time=2.32;
3333SET SESSION slow_query_log_lock_time=1.2;
3334DROP TABLE t1;
3335SET SESSION query_exec_time=2.43;
3336SET SESSION slow_query_log_query_time=2.43;
3337SET SESSION slow_query_log_lock_time=1.3;
3338DROP TABLE t2;
3339SET SESSION query_exec_time=2.54;
3340SET SESSION slow_query_log_query_time=2.54;
3341SET SESSION slow_query_log_lock_time=1.4;
3342SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
3343SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
3344SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
3345SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
3346SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
3347SET GLOBAL log_slow_verbosity='query_plan';
3348SET GLOBAL log_slow_timestamp_every=1;
3349SET GLOBAL log_slow_sp_statements=0;
3350SET GLOBAL slow_query_log_microseconds_timestamp=0;
3351SET GLOBAL log_slow_admin_statements=0;
3352DROP TABLE IF EXISTS t1;
3353DROP TABLE IF EXISTS t2;
3354SET SESSION query_exec_time=1.11;
3355SET SESSION slow_query_log_query_time=1.11;
3356SET SESSION slow_query_log_lock_time=0.1;
3357CREATE TABLE t1(id INT) ENGINE=InnoDB;
3358SET SESSION query_exec_time=1.22;
3359SET SESSION slow_query_log_query_time=1.22;
3360SET SESSION slow_query_log_lock_time=0.2;
3361CREATE TABLE t2(id INT) ENGINE=MyISAM;
3362SET SESSION query_exec_time=1.33;
3363SET SESSION slow_query_log_query_time=1.33;
3364SET SESSION slow_query_log_lock_time=0.3;
3365INSERT INTO t1 VALUES(0);
3366SET SESSION query_exec_time=1.44;
3367SET SESSION slow_query_log_query_time=1.44;
3368SET SESSION slow_query_log_lock_time=0.4;
3369INSERT INTO t1 VALUES(1);
3370SET SESSION query_exec_time=1.55;
3371SET SESSION slow_query_log_query_time=1.55;
3372SET SESSION slow_query_log_lock_time=0.5;
3373INSERT INTO t1 VALUES(2);
3374SET SESSION query_exec_time=1.66;
3375SET SESSION slow_query_log_query_time=1.66;
3376SET SESSION slow_query_log_lock_time=0.6;
3377INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
3378SET SESSION query_exec_time=1.77;
3379SET SESSION slow_query_log_query_time=1.77;
3380SET SESSION slow_query_log_lock_time=0.7;
3381INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
3382SET SESSION query_exec_time=1.88;
3383SET SESSION slow_query_log_query_time=1.88;
3384SET SESSION slow_query_log_lock_time=0.8;
3385INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
3386SET SESSION query_exec_time=1.99;
3387SET SESSION slow_query_log_query_time=1.99;
3388SET SESSION slow_query_log_lock_time=0.9;
3389INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
3390SET SESSION query_exec_time=2.1;
3391SET SESSION slow_query_log_query_time=2.1;
3392SET SESSION slow_query_log_lock_time=1.0;
3393SELECT COUNT(*) FROM t1;
3394COUNT(*)
339512
3396SET SESSION query_exec_time=2.21;
3397SET SESSION slow_query_log_query_time=2.21;
3398SET SESSION slow_query_log_lock_time=1.1;
3399SELECT COUNT(*) FROM t2;
3400COUNT(*)
340124
3402SET SESSION query_exec_time=2.32;
3403SET SESSION slow_query_log_query_time=2.32;
3404SET SESSION slow_query_log_lock_time=1.2;
3405DROP TABLE t1;
3406SET SESSION query_exec_time=2.43;
3407SET SESSION slow_query_log_query_time=2.43;
3408SET SESSION slow_query_log_lock_time=1.3;
3409DROP TABLE t2;
3410SET SESSION query_exec_time=2.54;
3411SET SESSION slow_query_log_query_time=2.54;
3412SET SESSION slow_query_log_lock_time=1.4;
3413SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
3414SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
3415SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
3416SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
3417SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
3418SET GLOBAL log_slow_verbosity='innodb';
3419SET GLOBAL log_slow_timestamp_every=1;
3420SET GLOBAL log_slow_sp_statements=1;
3421SET GLOBAL slow_query_log_microseconds_timestamp=1;
3422SET GLOBAL log_slow_admin_statements=1;
3423DROP TABLE IF EXISTS t1;
3424DROP TABLE IF EXISTS t2;
3425SET SESSION query_exec_time=1.11;
3426SET SESSION slow_query_log_query_time=1.11;
3427SET SESSION slow_query_log_lock_time=0.1;
3428CREATE TABLE t1(id INT) ENGINE=InnoDB;
3429SET SESSION query_exec_time=1.22;
3430SET SESSION slow_query_log_query_time=1.22;
3431SET SESSION slow_query_log_lock_time=0.2;
3432CREATE TABLE t2(id INT) ENGINE=MyISAM;
3433SET SESSION query_exec_time=1.33;
3434SET SESSION slow_query_log_query_time=1.33;
3435SET SESSION slow_query_log_lock_time=0.3;
3436INSERT INTO t1 VALUES(0);
3437SET SESSION query_exec_time=1.44;
3438SET SESSION slow_query_log_query_time=1.44;
3439SET SESSION slow_query_log_lock_time=0.4;
3440INSERT INTO t1 VALUES(1);
3441SET SESSION query_exec_time=1.55;
3442SET SESSION slow_query_log_query_time=1.55;
3443SET SESSION slow_query_log_lock_time=0.5;
3444INSERT INTO t1 VALUES(2);
3445SET SESSION query_exec_time=1.66;
3446SET SESSION slow_query_log_query_time=1.66;
3447SET SESSION slow_query_log_lock_time=0.6;
3448INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
3449SET SESSION query_exec_time=1.77;
3450SET SESSION slow_query_log_query_time=1.77;
3451SET SESSION slow_query_log_lock_time=0.7;
3452INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
3453SET SESSION query_exec_time=1.88;
3454SET SESSION slow_query_log_query_time=1.88;
3455SET SESSION slow_query_log_lock_time=0.8;
3456INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
3457SET SESSION query_exec_time=1.99;
3458SET SESSION slow_query_log_query_time=1.99;
3459SET SESSION slow_query_log_lock_time=0.9;
3460INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
3461SET SESSION query_exec_time=2.1;
3462SET SESSION slow_query_log_query_time=2.1;
3463SET SESSION slow_query_log_lock_time=1.0;
3464SELECT COUNT(*) FROM t1;
3465COUNT(*)
346612
3467SET SESSION query_exec_time=2.21;
3468SET SESSION slow_query_log_query_time=2.21;
3469SET SESSION slow_query_log_lock_time=1.1;
3470SELECT COUNT(*) FROM t2;
3471COUNT(*)
347224
3473SET SESSION query_exec_time=2.32;
3474SET SESSION slow_query_log_query_time=2.32;
3475SET SESSION slow_query_log_lock_time=1.2;
3476DROP TABLE t1;
3477SET SESSION query_exec_time=2.43;
3478SET SESSION slow_query_log_query_time=2.43;
3479SET SESSION slow_query_log_lock_time=1.3;
3480DROP TABLE t2;
3481SET SESSION query_exec_time=2.54;
3482SET SESSION slow_query_log_query_time=2.54;
3483SET SESSION slow_query_log_lock_time=1.4;
3484SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
3485SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
3486SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
3487SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
3488SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
3489SET GLOBAL log_slow_verbosity='innodb';
3490SET GLOBAL log_slow_timestamp_every=1;
3491SET GLOBAL log_slow_sp_statements=1;
3492SET GLOBAL slow_query_log_microseconds_timestamp=1;
3493SET GLOBAL log_slow_admin_statements=0;
3494DROP TABLE IF EXISTS t1;
3495DROP TABLE IF EXISTS t2;
3496SET SESSION query_exec_time=1.11;
3497SET SESSION slow_query_log_query_time=1.11;
3498SET SESSION slow_query_log_lock_time=0.1;
3499CREATE TABLE t1(id INT) ENGINE=InnoDB;
3500SET SESSION query_exec_time=1.22;
3501SET SESSION slow_query_log_query_time=1.22;
3502SET SESSION slow_query_log_lock_time=0.2;
3503CREATE TABLE t2(id INT) ENGINE=MyISAM;
3504SET SESSION query_exec_time=1.33;
3505SET SESSION slow_query_log_query_time=1.33;
3506SET SESSION slow_query_log_lock_time=0.3;
3507INSERT INTO t1 VALUES(0);
3508SET SESSION query_exec_time=1.44;
3509SET SESSION slow_query_log_query_time=1.44;
3510SET SESSION slow_query_log_lock_time=0.4;
3511INSERT INTO t1 VALUES(1);
3512SET SESSION query_exec_time=1.55;
3513SET SESSION slow_query_log_query_time=1.55;
3514SET SESSION slow_query_log_lock_time=0.5;
3515INSERT INTO t1 VALUES(2);
3516SET SESSION query_exec_time=1.66;
3517SET SESSION slow_query_log_query_time=1.66;
3518SET SESSION slow_query_log_lock_time=0.6;
3519INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
3520SET SESSION query_exec_time=1.77;
3521SET SESSION slow_query_log_query_time=1.77;
3522SET SESSION slow_query_log_lock_time=0.7;
3523INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
3524SET SESSION query_exec_time=1.88;
3525SET SESSION slow_query_log_query_time=1.88;
3526SET SESSION slow_query_log_lock_time=0.8;
3527INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
3528SET SESSION query_exec_time=1.99;
3529SET SESSION slow_query_log_query_time=1.99;
3530SET SESSION slow_query_log_lock_time=0.9;
3531INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
3532SET SESSION query_exec_time=2.1;
3533SET SESSION slow_query_log_query_time=2.1;
3534SET SESSION slow_query_log_lock_time=1.0;
3535SELECT COUNT(*) FROM t1;
3536COUNT(*)
353712
3538SET SESSION query_exec_time=2.21;
3539SET SESSION slow_query_log_query_time=2.21;
3540SET SESSION slow_query_log_lock_time=1.1;
3541SELECT COUNT(*) FROM t2;
3542COUNT(*)
354324
3544SET SESSION query_exec_time=2.32;
3545SET SESSION slow_query_log_query_time=2.32;
3546SET SESSION slow_query_log_lock_time=1.2;
3547DROP TABLE t1;
3548SET SESSION query_exec_time=2.43;
3549SET SESSION slow_query_log_query_time=2.43;
3550SET SESSION slow_query_log_lock_time=1.3;
3551DROP TABLE t2;
3552SET SESSION query_exec_time=2.54;
3553SET SESSION slow_query_log_query_time=2.54;
3554SET SESSION slow_query_log_lock_time=1.4;
3555SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
3556SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
3557SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
3558SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
3559SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
3560SET GLOBAL log_slow_verbosity='innodb';
3561SET GLOBAL log_slow_timestamp_every=1;
3562SET GLOBAL log_slow_sp_statements=1;
3563SET GLOBAL slow_query_log_microseconds_timestamp=0;
3564SET GLOBAL log_slow_admin_statements=1;
3565DROP TABLE IF EXISTS t1;
3566DROP TABLE IF EXISTS t2;
3567SET SESSION query_exec_time=1.11;
3568SET SESSION slow_query_log_query_time=1.11;
3569SET SESSION slow_query_log_lock_time=0.1;
3570CREATE TABLE t1(id INT) ENGINE=InnoDB;
3571SET SESSION query_exec_time=1.22;
3572SET SESSION slow_query_log_query_time=1.22;
3573SET SESSION slow_query_log_lock_time=0.2;
3574CREATE TABLE t2(id INT) ENGINE=MyISAM;
3575SET SESSION query_exec_time=1.33;
3576SET SESSION slow_query_log_query_time=1.33;
3577SET SESSION slow_query_log_lock_time=0.3;
3578INSERT INTO t1 VALUES(0);
3579SET SESSION query_exec_time=1.44;
3580SET SESSION slow_query_log_query_time=1.44;
3581SET SESSION slow_query_log_lock_time=0.4;
3582INSERT INTO t1 VALUES(1);
3583SET SESSION query_exec_time=1.55;
3584SET SESSION slow_query_log_query_time=1.55;
3585SET SESSION slow_query_log_lock_time=0.5;
3586INSERT INTO t1 VALUES(2);
3587SET SESSION query_exec_time=1.66;
3588SET SESSION slow_query_log_query_time=1.66;
3589SET SESSION slow_query_log_lock_time=0.6;
3590INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
3591SET SESSION query_exec_time=1.77;
3592SET SESSION slow_query_log_query_time=1.77;
3593SET SESSION slow_query_log_lock_time=0.7;
3594INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
3595SET SESSION query_exec_time=1.88;
3596SET SESSION slow_query_log_query_time=1.88;
3597SET SESSION slow_query_log_lock_time=0.8;
3598INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
3599SET SESSION query_exec_time=1.99;
3600SET SESSION slow_query_log_query_time=1.99;
3601SET SESSION slow_query_log_lock_time=0.9;
3602INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
3603SET SESSION query_exec_time=2.1;
3604SET SESSION slow_query_log_query_time=2.1;
3605SET SESSION slow_query_log_lock_time=1.0;
3606SELECT COUNT(*) FROM t1;
3607COUNT(*)
360812
3609SET SESSION query_exec_time=2.21;
3610SET SESSION slow_query_log_query_time=2.21;
3611SET SESSION slow_query_log_lock_time=1.1;
3612SELECT COUNT(*) FROM t2;
3613COUNT(*)
361424
3615SET SESSION query_exec_time=2.32;
3616SET SESSION slow_query_log_query_time=2.32;
3617SET SESSION slow_query_log_lock_time=1.2;
3618DROP TABLE t1;
3619SET SESSION query_exec_time=2.43;
3620SET SESSION slow_query_log_query_time=2.43;
3621SET SESSION slow_query_log_lock_time=1.3;
3622DROP TABLE t2;
3623SET SESSION query_exec_time=2.54;
3624SET SESSION slow_query_log_query_time=2.54;
3625SET SESSION slow_query_log_lock_time=1.4;
3626SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
3627SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
3628SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
3629SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
3630SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
3631SET GLOBAL log_slow_verbosity='innodb';
3632SET GLOBAL log_slow_timestamp_every=1;
3633SET GLOBAL log_slow_sp_statements=1;
3634SET GLOBAL slow_query_log_microseconds_timestamp=0;
3635SET GLOBAL log_slow_admin_statements=0;
3636DROP TABLE IF EXISTS t1;
3637DROP TABLE IF EXISTS t2;
3638SET SESSION query_exec_time=1.11;
3639SET SESSION slow_query_log_query_time=1.11;
3640SET SESSION slow_query_log_lock_time=0.1;
3641CREATE TABLE t1(id INT) ENGINE=InnoDB;
3642SET SESSION query_exec_time=1.22;
3643SET SESSION slow_query_log_query_time=1.22;
3644SET SESSION slow_query_log_lock_time=0.2;
3645CREATE TABLE t2(id INT) ENGINE=MyISAM;
3646SET SESSION query_exec_time=1.33;
3647SET SESSION slow_query_log_query_time=1.33;
3648SET SESSION slow_query_log_lock_time=0.3;
3649INSERT INTO t1 VALUES(0);
3650SET SESSION query_exec_time=1.44;
3651SET SESSION slow_query_log_query_time=1.44;
3652SET SESSION slow_query_log_lock_time=0.4;
3653INSERT INTO t1 VALUES(1);
3654SET SESSION query_exec_time=1.55;
3655SET SESSION slow_query_log_query_time=1.55;
3656SET SESSION slow_query_log_lock_time=0.5;
3657INSERT INTO t1 VALUES(2);
3658SET SESSION query_exec_time=1.66;
3659SET SESSION slow_query_log_query_time=1.66;
3660SET SESSION slow_query_log_lock_time=0.6;
3661INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
3662SET SESSION query_exec_time=1.77;
3663SET SESSION slow_query_log_query_time=1.77;
3664SET SESSION slow_query_log_lock_time=0.7;
3665INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
3666SET SESSION query_exec_time=1.88;
3667SET SESSION slow_query_log_query_time=1.88;
3668SET SESSION slow_query_log_lock_time=0.8;
3669INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
3670SET SESSION query_exec_time=1.99;
3671SET SESSION slow_query_log_query_time=1.99;
3672SET SESSION slow_query_log_lock_time=0.9;
3673INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
3674SET SESSION query_exec_time=2.1;
3675SET SESSION slow_query_log_query_time=2.1;
3676SET SESSION slow_query_log_lock_time=1.0;
3677SELECT COUNT(*) FROM t1;
3678COUNT(*)
367912
3680SET SESSION query_exec_time=2.21;
3681SET SESSION slow_query_log_query_time=2.21;
3682SET SESSION slow_query_log_lock_time=1.1;
3683SELECT COUNT(*) FROM t2;
3684COUNT(*)
368524
3686SET SESSION query_exec_time=2.32;
3687SET SESSION slow_query_log_query_time=2.32;
3688SET SESSION slow_query_log_lock_time=1.2;
3689DROP TABLE t1;
3690SET SESSION query_exec_time=2.43;
3691SET SESSION slow_query_log_query_time=2.43;
3692SET SESSION slow_query_log_lock_time=1.3;
3693DROP TABLE t2;
3694SET SESSION query_exec_time=2.54;
3695SET SESSION slow_query_log_query_time=2.54;
3696SET SESSION slow_query_log_lock_time=1.4;
3697SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
3698SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
3699SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
3700SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
3701SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
3702SET GLOBAL log_slow_verbosity='innodb';
3703SET GLOBAL log_slow_timestamp_every=1;
3704SET GLOBAL log_slow_sp_statements=0;
3705SET GLOBAL slow_query_log_microseconds_timestamp=1;
3706SET GLOBAL log_slow_admin_statements=1;
3707DROP TABLE IF EXISTS t1;
3708DROP TABLE IF EXISTS t2;
3709SET SESSION query_exec_time=1.11;
3710SET SESSION slow_query_log_query_time=1.11;
3711SET SESSION slow_query_log_lock_time=0.1;
3712CREATE TABLE t1(id INT) ENGINE=InnoDB;
3713SET SESSION query_exec_time=1.22;
3714SET SESSION slow_query_log_query_time=1.22;
3715SET SESSION slow_query_log_lock_time=0.2;
3716CREATE TABLE t2(id INT) ENGINE=MyISAM;
3717SET SESSION query_exec_time=1.33;
3718SET SESSION slow_query_log_query_time=1.33;
3719SET SESSION slow_query_log_lock_time=0.3;
3720INSERT INTO t1 VALUES(0);
3721SET SESSION query_exec_time=1.44;
3722SET SESSION slow_query_log_query_time=1.44;
3723SET SESSION slow_query_log_lock_time=0.4;
3724INSERT INTO t1 VALUES(1);
3725SET SESSION query_exec_time=1.55;
3726SET SESSION slow_query_log_query_time=1.55;
3727SET SESSION slow_query_log_lock_time=0.5;
3728INSERT INTO t1 VALUES(2);
3729SET SESSION query_exec_time=1.66;
3730SET SESSION slow_query_log_query_time=1.66;
3731SET SESSION slow_query_log_lock_time=0.6;
3732INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
3733SET SESSION query_exec_time=1.77;
3734SET SESSION slow_query_log_query_time=1.77;
3735SET SESSION slow_query_log_lock_time=0.7;
3736INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
3737SET SESSION query_exec_time=1.88;
3738SET SESSION slow_query_log_query_time=1.88;
3739SET SESSION slow_query_log_lock_time=0.8;
3740INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
3741SET SESSION query_exec_time=1.99;
3742SET SESSION slow_query_log_query_time=1.99;
3743SET SESSION slow_query_log_lock_time=0.9;
3744INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
3745SET SESSION query_exec_time=2.1;
3746SET SESSION slow_query_log_query_time=2.1;
3747SET SESSION slow_query_log_lock_time=1.0;
3748SELECT COUNT(*) FROM t1;
3749COUNT(*)
375012
3751SET SESSION query_exec_time=2.21;
3752SET SESSION slow_query_log_query_time=2.21;
3753SET SESSION slow_query_log_lock_time=1.1;
3754SELECT COUNT(*) FROM t2;
3755COUNT(*)
375624
3757SET SESSION query_exec_time=2.32;
3758SET SESSION slow_query_log_query_time=2.32;
3759SET SESSION slow_query_log_lock_time=1.2;
3760DROP TABLE t1;
3761SET SESSION query_exec_time=2.43;
3762SET SESSION slow_query_log_query_time=2.43;
3763SET SESSION slow_query_log_lock_time=1.3;
3764DROP TABLE t2;
3765SET SESSION query_exec_time=2.54;
3766SET SESSION slow_query_log_query_time=2.54;
3767SET SESSION slow_query_log_lock_time=1.4;
3768SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
3769SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
3770SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
3771SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
3772SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
3773SET GLOBAL log_slow_verbosity='innodb';
3774SET GLOBAL log_slow_timestamp_every=1;
3775SET GLOBAL log_slow_sp_statements=0;
3776SET GLOBAL slow_query_log_microseconds_timestamp=1;
3777SET GLOBAL log_slow_admin_statements=0;
3778DROP TABLE IF EXISTS t1;
3779DROP TABLE IF EXISTS t2;
3780SET SESSION query_exec_time=1.11;
3781SET SESSION slow_query_log_query_time=1.11;
3782SET SESSION slow_query_log_lock_time=0.1;
3783CREATE TABLE t1(id INT) ENGINE=InnoDB;
3784SET SESSION query_exec_time=1.22;
3785SET SESSION slow_query_log_query_time=1.22;
3786SET SESSION slow_query_log_lock_time=0.2;
3787CREATE TABLE t2(id INT) ENGINE=MyISAM;
3788SET SESSION query_exec_time=1.33;
3789SET SESSION slow_query_log_query_time=1.33;
3790SET SESSION slow_query_log_lock_time=0.3;
3791INSERT INTO t1 VALUES(0);
3792SET SESSION query_exec_time=1.44;
3793SET SESSION slow_query_log_query_time=1.44;
3794SET SESSION slow_query_log_lock_time=0.4;
3795INSERT INTO t1 VALUES(1);
3796SET SESSION query_exec_time=1.55;
3797SET SESSION slow_query_log_query_time=1.55;
3798SET SESSION slow_query_log_lock_time=0.5;
3799INSERT INTO t1 VALUES(2);
3800SET SESSION query_exec_time=1.66;
3801SET SESSION slow_query_log_query_time=1.66;
3802SET SESSION slow_query_log_lock_time=0.6;
3803INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
3804SET SESSION query_exec_time=1.77;
3805SET SESSION slow_query_log_query_time=1.77;
3806SET SESSION slow_query_log_lock_time=0.7;
3807INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
3808SET SESSION query_exec_time=1.88;
3809SET SESSION slow_query_log_query_time=1.88;
3810SET SESSION slow_query_log_lock_time=0.8;
3811INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
3812SET SESSION query_exec_time=1.99;
3813SET SESSION slow_query_log_query_time=1.99;
3814SET SESSION slow_query_log_lock_time=0.9;
3815INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
3816SET SESSION query_exec_time=2.1;
3817SET SESSION slow_query_log_query_time=2.1;
3818SET SESSION slow_query_log_lock_time=1.0;
3819SELECT COUNT(*) FROM t1;
3820COUNT(*)
382112
3822SET SESSION query_exec_time=2.21;
3823SET SESSION slow_query_log_query_time=2.21;
3824SET SESSION slow_query_log_lock_time=1.1;
3825SELECT COUNT(*) FROM t2;
3826COUNT(*)
382724
3828SET SESSION query_exec_time=2.32;
3829SET SESSION slow_query_log_query_time=2.32;
3830SET SESSION slow_query_log_lock_time=1.2;
3831DROP TABLE t1;
3832SET SESSION query_exec_time=2.43;
3833SET SESSION slow_query_log_query_time=2.43;
3834SET SESSION slow_query_log_lock_time=1.3;
3835DROP TABLE t2;
3836SET SESSION query_exec_time=2.54;
3837SET SESSION slow_query_log_query_time=2.54;
3838SET SESSION slow_query_log_lock_time=1.4;
3839SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
3840SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
3841SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
3842SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
3843SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
3844SET GLOBAL log_slow_verbosity='innodb';
3845SET GLOBAL log_slow_timestamp_every=1;
3846SET GLOBAL log_slow_sp_statements=0;
3847SET GLOBAL slow_query_log_microseconds_timestamp=0;
3848SET GLOBAL log_slow_admin_statements=1;
3849DROP TABLE IF EXISTS t1;
3850DROP TABLE IF EXISTS t2;
3851SET SESSION query_exec_time=1.11;
3852SET SESSION slow_query_log_query_time=1.11;
3853SET SESSION slow_query_log_lock_time=0.1;
3854CREATE TABLE t1(id INT) ENGINE=InnoDB;
3855SET SESSION query_exec_time=1.22;
3856SET SESSION slow_query_log_query_time=1.22;
3857SET SESSION slow_query_log_lock_time=0.2;
3858CREATE TABLE t2(id INT) ENGINE=MyISAM;
3859SET SESSION query_exec_time=1.33;
3860SET SESSION slow_query_log_query_time=1.33;
3861SET SESSION slow_query_log_lock_time=0.3;
3862INSERT INTO t1 VALUES(0);
3863SET SESSION query_exec_time=1.44;
3864SET SESSION slow_query_log_query_time=1.44;
3865SET SESSION slow_query_log_lock_time=0.4;
3866INSERT INTO t1 VALUES(1);
3867SET SESSION query_exec_time=1.55;
3868SET SESSION slow_query_log_query_time=1.55;
3869SET SESSION slow_query_log_lock_time=0.5;
3870INSERT INTO t1 VALUES(2);
3871SET SESSION query_exec_time=1.66;
3872SET SESSION slow_query_log_query_time=1.66;
3873SET SESSION slow_query_log_lock_time=0.6;
3874INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
3875SET SESSION query_exec_time=1.77;
3876SET SESSION slow_query_log_query_time=1.77;
3877SET SESSION slow_query_log_lock_time=0.7;
3878INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
3879SET SESSION query_exec_time=1.88;
3880SET SESSION slow_query_log_query_time=1.88;
3881SET SESSION slow_query_log_lock_time=0.8;
3882INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
3883SET SESSION query_exec_time=1.99;
3884SET SESSION slow_query_log_query_time=1.99;
3885SET SESSION slow_query_log_lock_time=0.9;
3886INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
3887SET SESSION query_exec_time=2.1;
3888SET SESSION slow_query_log_query_time=2.1;
3889SET SESSION slow_query_log_lock_time=1.0;
3890SELECT COUNT(*) FROM t1;
3891COUNT(*)
389212
3893SET SESSION query_exec_time=2.21;
3894SET SESSION slow_query_log_query_time=2.21;
3895SET SESSION slow_query_log_lock_time=1.1;
3896SELECT COUNT(*) FROM t2;
3897COUNT(*)
389824
3899SET SESSION query_exec_time=2.32;
3900SET SESSION slow_query_log_query_time=2.32;
3901SET SESSION slow_query_log_lock_time=1.2;
3902DROP TABLE t1;
3903SET SESSION query_exec_time=2.43;
3904SET SESSION slow_query_log_query_time=2.43;
3905SET SESSION slow_query_log_lock_time=1.3;
3906DROP TABLE t2;
3907SET SESSION query_exec_time=2.54;
3908SET SESSION slow_query_log_query_time=2.54;
3909SET SESSION slow_query_log_lock_time=1.4;
3910SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
3911SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
3912SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
3913SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
3914SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
3915SET GLOBAL log_slow_verbosity='innodb';
3916SET GLOBAL log_slow_timestamp_every=1;
3917SET GLOBAL log_slow_sp_statements=0;
3918SET GLOBAL slow_query_log_microseconds_timestamp=0;
3919SET GLOBAL log_slow_admin_statements=0;
3920DROP TABLE IF EXISTS t1;
3921DROP TABLE IF EXISTS t2;
3922SET SESSION query_exec_time=1.11;
3923SET SESSION slow_query_log_query_time=1.11;
3924SET SESSION slow_query_log_lock_time=0.1;
3925CREATE TABLE t1(id INT) ENGINE=InnoDB;
3926SET SESSION query_exec_time=1.22;
3927SET SESSION slow_query_log_query_time=1.22;
3928SET SESSION slow_query_log_lock_time=0.2;
3929CREATE TABLE t2(id INT) ENGINE=MyISAM;
3930SET SESSION query_exec_time=1.33;
3931SET SESSION slow_query_log_query_time=1.33;
3932SET SESSION slow_query_log_lock_time=0.3;
3933INSERT INTO t1 VALUES(0);
3934SET SESSION query_exec_time=1.44;
3935SET SESSION slow_query_log_query_time=1.44;
3936SET SESSION slow_query_log_lock_time=0.4;
3937INSERT INTO t1 VALUES(1);
3938SET SESSION query_exec_time=1.55;
3939SET SESSION slow_query_log_query_time=1.55;
3940SET SESSION slow_query_log_lock_time=0.5;
3941INSERT INTO t1 VALUES(2);
3942SET SESSION query_exec_time=1.66;
3943SET SESSION slow_query_log_query_time=1.66;
3944SET SESSION slow_query_log_lock_time=0.6;
3945INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
3946SET SESSION query_exec_time=1.77;
3947SET SESSION slow_query_log_query_time=1.77;
3948SET SESSION slow_query_log_lock_time=0.7;
3949INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
3950SET SESSION query_exec_time=1.88;
3951SET SESSION slow_query_log_query_time=1.88;
3952SET SESSION slow_query_log_lock_time=0.8;
3953INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
3954SET SESSION query_exec_time=1.99;
3955SET SESSION slow_query_log_query_time=1.99;
3956SET SESSION slow_query_log_lock_time=0.9;
3957INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
3958SET SESSION query_exec_time=2.1;
3959SET SESSION slow_query_log_query_time=2.1;
3960SET SESSION slow_query_log_lock_time=1.0;
3961SELECT COUNT(*) FROM t1;
3962COUNT(*)
396312
3964SET SESSION query_exec_time=2.21;
3965SET SESSION slow_query_log_query_time=2.21;
3966SET SESSION slow_query_log_lock_time=1.1;
3967SELECT COUNT(*) FROM t2;
3968COUNT(*)
396924
3970SET SESSION query_exec_time=2.32;
3971SET SESSION slow_query_log_query_time=2.32;
3972SET SESSION slow_query_log_lock_time=1.2;
3973DROP TABLE t1;
3974SET SESSION query_exec_time=2.43;
3975SET SESSION slow_query_log_query_time=2.43;
3976SET SESSION slow_query_log_lock_time=1.3;
3977DROP TABLE t2;
3978SET SESSION query_exec_time=2.54;
3979SET SESSION slow_query_log_query_time=2.54;
3980SET SESSION slow_query_log_lock_time=1.4;
3981SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
3982SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
3983SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
3984SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
3985SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
3986SET GLOBAL log_slow_verbosity='';
3987SET GLOBAL log_slow_timestamp_every=1;
3988SET GLOBAL log_slow_sp_statements=1;
3989SET GLOBAL slow_query_log_microseconds_timestamp=1;
3990SET GLOBAL log_slow_admin_statements=1;
3991DROP TABLE IF EXISTS t1;
3992DROP TABLE IF EXISTS t2;
3993SET SESSION query_exec_time=1.11;
3994SET SESSION slow_query_log_query_time=1.11;
3995SET SESSION slow_query_log_lock_time=0.1;
3996CREATE TABLE t1(id INT) ENGINE=InnoDB;
3997SET SESSION query_exec_time=1.22;
3998SET SESSION slow_query_log_query_time=1.22;
3999SET SESSION slow_query_log_lock_time=0.2;
4000CREATE TABLE t2(id INT) ENGINE=MyISAM;
4001SET SESSION query_exec_time=1.33;
4002SET SESSION slow_query_log_query_time=1.33;
4003SET SESSION slow_query_log_lock_time=0.3;
4004INSERT INTO t1 VALUES(0);
4005SET SESSION query_exec_time=1.44;
4006SET SESSION slow_query_log_query_time=1.44;
4007SET SESSION slow_query_log_lock_time=0.4;
4008INSERT INTO t1 VALUES(1);
4009SET SESSION query_exec_time=1.55;
4010SET SESSION slow_query_log_query_time=1.55;
4011SET SESSION slow_query_log_lock_time=0.5;
4012INSERT INTO t1 VALUES(2);
4013SET SESSION query_exec_time=1.66;
4014SET SESSION slow_query_log_query_time=1.66;
4015SET SESSION slow_query_log_lock_time=0.6;
4016INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
4017SET SESSION query_exec_time=1.77;
4018SET SESSION slow_query_log_query_time=1.77;
4019SET SESSION slow_query_log_lock_time=0.7;
4020INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
4021SET SESSION query_exec_time=1.88;
4022SET SESSION slow_query_log_query_time=1.88;
4023SET SESSION slow_query_log_lock_time=0.8;
4024INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
4025SET SESSION query_exec_time=1.99;
4026SET SESSION slow_query_log_query_time=1.99;
4027SET SESSION slow_query_log_lock_time=0.9;
4028INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
4029SET SESSION query_exec_time=2.1;
4030SET SESSION slow_query_log_query_time=2.1;
4031SET SESSION slow_query_log_lock_time=1.0;
4032SELECT COUNT(*) FROM t1;
4033COUNT(*)
403412
4035SET SESSION query_exec_time=2.21;
4036SET SESSION slow_query_log_query_time=2.21;
4037SET SESSION slow_query_log_lock_time=1.1;
4038SELECT COUNT(*) FROM t2;
4039COUNT(*)
404024
4041SET SESSION query_exec_time=2.32;
4042SET SESSION slow_query_log_query_time=2.32;
4043SET SESSION slow_query_log_lock_time=1.2;
4044DROP TABLE t1;
4045SET SESSION query_exec_time=2.43;
4046SET SESSION slow_query_log_query_time=2.43;
4047SET SESSION slow_query_log_lock_time=1.3;
4048DROP TABLE t2;
4049SET SESSION query_exec_time=2.54;
4050SET SESSION slow_query_log_query_time=2.54;
4051SET SESSION slow_query_log_lock_time=1.4;
4052SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
4053SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
4054SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
4055SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
4056SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
4057SET GLOBAL log_slow_verbosity='';
4058SET GLOBAL log_slow_timestamp_every=1;
4059SET GLOBAL log_slow_sp_statements=1;
4060SET GLOBAL slow_query_log_microseconds_timestamp=1;
4061SET GLOBAL log_slow_admin_statements=0;
4062DROP TABLE IF EXISTS t1;
4063DROP TABLE IF EXISTS t2;
4064SET SESSION query_exec_time=1.11;
4065SET SESSION slow_query_log_query_time=1.11;
4066SET SESSION slow_query_log_lock_time=0.1;
4067CREATE TABLE t1(id INT) ENGINE=InnoDB;
4068SET SESSION query_exec_time=1.22;
4069SET SESSION slow_query_log_query_time=1.22;
4070SET SESSION slow_query_log_lock_time=0.2;
4071CREATE TABLE t2(id INT) ENGINE=MyISAM;
4072SET SESSION query_exec_time=1.33;
4073SET SESSION slow_query_log_query_time=1.33;
4074SET SESSION slow_query_log_lock_time=0.3;
4075INSERT INTO t1 VALUES(0);
4076SET SESSION query_exec_time=1.44;
4077SET SESSION slow_query_log_query_time=1.44;
4078SET SESSION slow_query_log_lock_time=0.4;
4079INSERT INTO t1 VALUES(1);
4080SET SESSION query_exec_time=1.55;
4081SET SESSION slow_query_log_query_time=1.55;
4082SET SESSION slow_query_log_lock_time=0.5;
4083INSERT INTO t1 VALUES(2);
4084SET SESSION query_exec_time=1.66;
4085SET SESSION slow_query_log_query_time=1.66;
4086SET SESSION slow_query_log_lock_time=0.6;
4087INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
4088SET SESSION query_exec_time=1.77;
4089SET SESSION slow_query_log_query_time=1.77;
4090SET SESSION slow_query_log_lock_time=0.7;
4091INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
4092SET SESSION query_exec_time=1.88;
4093SET SESSION slow_query_log_query_time=1.88;
4094SET SESSION slow_query_log_lock_time=0.8;
4095INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
4096SET SESSION query_exec_time=1.99;
4097SET SESSION slow_query_log_query_time=1.99;
4098SET SESSION slow_query_log_lock_time=0.9;
4099INSERT INTO t2 SELECT * FROM t1 ORDER BY id ASC;
4100SET SESSION query_exec_time=2.1;
4101SET SESSION slow_query_log_query_time=2.1;
4102SET SESSION slow_query_log_lock_time=1.0;
4103SELECT COUNT(*) FROM t1;
4104COUNT(*)
410512
4106SET SESSION query_exec_time=2.21;
4107SET SESSION slow_query_log_query_time=2.21;
4108SET SESSION slow_query_log_lock_time=1.1;
4109SELECT COUNT(*) FROM t2;
4110COUNT(*)
411124
4112SET SESSION query_exec_time=2.32;
4113SET SESSION slow_query_log_query_time=2.32;
4114SET SESSION slow_query_log_lock_time=1.2;
4115DROP TABLE t1;
4116SET SESSION query_exec_time=2.43;
4117SET SESSION slow_query_log_query_time=2.43;
4118SET SESSION slow_query_log_lock_time=1.3;
4119DROP TABLE t2;
4120SET SESSION query_exec_time=2.54;
4121SET SESSION slow_query_log_query_time=2.54;
4122SET SESSION slow_query_log_lock_time=1.4;
4123SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity;
4124SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every;
4125SET GLOBAL log_slow_sp_statements=@old_log_slow_sp_statements;
4126SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp;
4127SET GLOBAL log_slow_admin_statements=@old_log_slow_admin_statements;
4128SET GLOBAL log_slow_verbosity='';
4129SET GLOBAL log_slow_timestamp_every=1;
4130SET GLOBAL log_slow_sp_statements=1;
4131SET GLOBAL slow_query_log_microseconds_timestamp=0;
4132SET GLOBAL log_slow_admin_statements=1;
4133DROP TABLE IF EXISTS t1;
4134DROP TABLE IF EXISTS t2;
4135SET SESSION query_exec_time=1.11;
4136SET SESSION slow_query_log_query_time=1.11;
4137SET SESSION slow_query_log_lock_time=0.1;
4138CREATE TABLE t1(id INT) ENGINE=InnoDB;
4139SET SESSION query_exec_time=1.22;
4140SET SESSION slow_query_log_query_time=1.22;
4141SET SESSION slow_query_log_lock_time=0.2;
4142CREATE TABLE t2(id INT) ENGINE=MyISAM;
4143SET SESSION query_exec_time=1.33;
4144SET SESSION slow_query_log_query_time=1.33;
4145SET SESSION slow_query_log_lock_time=0.3;
4146INSERT INTO t1 VALUES(0);
4147SET SESSION query_exec_time=1.44;
4148SET SESSION slow_query_log_query_time=1.44;
4149SET SESSION slow_query_log_lock_time=0.4;
4150INSERT INTO t1 VALUES(1);
4151SET SESSION query_exec_time=1.55;
4152SET SESSION slow_query_log_query_time=1.55;
4153SET SESSION slow_query_log_lock_time=0.5;
4154INSERT INTO t1 VALUES(2);
4155SET SESSION query_exec_time=1.66;
4156SET SESSION slow_query_log_query_time=1.66;
4157SET SESSION slow_query_log_lock_time=0.6;
4158INSERT INTO t1 SELECT * FROM t1 ORDER BY id DESC;
4159SET SESSION query_exec_time=1.77;
4160SET SESSION slow_query_log_query_time=1.77;
4161SET SESSION slow_query_log_lock_time=0.7;
4162INSERT INTO t1 SELECT * FROM t1 ORDER BY id ASC;
4163SET SESSION query_exec_time=1.88;
4164SET SESSION slow_query_log_query_time=1.88;
4165SET SESSION slow_query_log_lock_time=0.8;
4166INSERT INTO t2 SELECT * FROM t1 ORDER BY id DESC;
The diff has been truncated for viewing.

Subscribers

People subscribed via source and target branches