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

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

Subscribers

People subscribed via source and target branches