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

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

  1. 18580
  2. Merge into 5.1
Proposed by Oleg Tsarev
Status: Superseded
Proposed branch: lp:~tsarev/percona-server/18580
Merge into: lp:percona-server/5.1
Diff against target: 9659 lines (+9474/-7)
11 files modified
Percona-Server/mysql-test/mysql-test-run.pl (+1/-0)
Percona-Server/mysql-test/r/percona_mysqldumpslow.result (+9135/-0)
Percona-Server/mysql-test/r/percona_server_variables_debug.result (+2/-0)
Percona-Server/mysql-test/t/percona_mysqldumpslow.test (+214/-0)
Percona-Server/scripts/mysqldumpslow.sh (+36/-6)
Percona-Server/sql/log.cc (+25/-0)
Percona-Server/sql/log_event.cc (+31/-1)
Percona-Server/sql/log_event.h (+2/-0)
Percona-Server/sql/mysqld.cc (+20/-0)
Percona-Server/sql/set_var.cc (+6/-0)
Percona-Server/sql/sql_class.h (+2/-0)
To merge this branch: bzr merge lp:~tsarev/percona-server/18580
Reviewer Review Type Date Requested Status
Oleg Tsarev (community) Needs Resubmitting
Laurynas Biveinis (community) Needs Fixing
Review via email: mp+85645@code.launchpad.net

This proposal supersedes a proposal from 2011-12-11.

This proposal has been superseded by a proposal from 2011-12-28.

Description of the change

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

> To Laurynas about test complexivity.
> I test the slow query log in all possible permutations of related to slow query log variables.
> At least this help me found some bugs in my changes in scripts after first-version-fix.
> Better paranoya test, than test with lacks.

Issue #18580 - fix mysqldumpslow script, now works with Percona-Server slow query log format

Related changes:
 1. mysql-test/mysql-test-run.pl now defines enviroment variable MYSQLDUMPSLOW with path to mysqldumpslow script
 2. test mysql-test/t/percona_mysqldumpslow.test (and result)
   * iterate over all combination of slow query log variables:
     * log_slow_timestamp_every
     * log_slow_verbosity
     * log_slow_sp_statements
     * slow_query_log_microseconds_timestamp
     * log_slow_admin_statements
   * check output of mysqldumpslow on result slow query log file
 3. scripts/mysqldumpslow:
   * look ahead two paragraphs for detect of situation with admin statement. Originally script split all input by string ";\n#". Unfortunatelly, percona slow query log has a situation like:
     ...
     SET timestamp=XXX;
     # administator command: Quit;
     # ...
   As result, mysqldumpslow split this paragraph to two separated. Look ahead fixed this.
   * Remove from input additional fields (added by Percona-Server)
   * Without "-a" mode also replace InnoDB Transaction ID by N, "Yes" and "No" by S.
   * Fixed bug with situation, when mysqldumpslow run with "-t X", and slow query log has Y paragraphs: in case when X > Y, mysqldumpslow break with error.
 4. Added debug variables slow_query_log_query_time and slow_query_log_lock_time - way for direct change of value, which will write to slow query log for following queries.

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

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

Revision history for this message
Oleg Tsarev (tsarev) wrote : Posted in a previous version of this proposal

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

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

- Please surround OPT_SLOW_QUERY_LOG_* in enum options_mysqld by #ifndef DBUG_OFF.
- I do not understand the descriptions
  "Replace X by value of variable in the Query_time: X in the slow query log."
  "When 0 (the default) use the actual value X. Used only for debugging."
  and
  "Replace X by value of variable in the Lock_time: X in the slow query log."
  "When 0 (the default) use the actual value X. Used only for debugging.",
  Please ping me on IRC to discuss them.
- Query_log_event::write: double semicolons ";;" at the end of lines.
- The test could have been simpler I think, with just a few representative cases, but this one is OK.

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

Variable descriptions:
"A value that replaces the Query_time values in the slow query log"
"A value that replaces the Lock_time values in the slow query log"
(perhaps could be still improved)

Please merge the three revisions into a single one.

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

should mysqld.cc static double declarations be surrounded by #ifndef DBUG_OFF too like the rest of the debug code?

review: Needs Fixing
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

LGTM, thank you.

review: Approve
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

http://jenkins.percona.com/job/percona-server-5.1-param/219/BUILD_TYPE=debug,Host=centos5-64/testReport/junit/%28root%29/main/percona_mysqldumpslow/ :

--- /home/jenkins/workspace/percona-server-5.1-param/BUILD_TYPE/debug/Host/centos5-64/Percona-Server/mysql-test/r/percona_mysqldumpslow.result 2011-12-20 16:15:27.000000000 +0300
+++ /home/jenkins/workspace/percona-server-5.1-param/BUILD_TYPE/debug/Host/centos5-64/Percona-Server/mysql-test/r/percona_mysqldumpslow.reject 2011-12-28 13:46:36.000000000 +0300
@@ -9132,3 +9132,12 @@
 Count: 128 Time=1.01s (129s) Lock=0.10s (12s) Rows=0.0 (0), root[root]@localhost
   CREATE TABLE t1(id INT) ENGINE=InnoDB

+Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost
+ SET GLOBAL slow_query_log_microseconds_timestamp=@old_slow_query_log_microseconds_timestamp
+
+Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost
+ SET GLOBAL log_slow_timestamp_every=@old_log_slow_timestamp_every
+
+Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost
+ SET GLOBAL log_slow_verbosity=@old_log_slow_verbosity
+

mysqltest: Result length mismatch
------------

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

This is unstable from log_grep.inc. Will fix soon.

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

http://jenkins.percona.com/view/Percona%20Server%205.5/job/percona-server-5.5-param/249/

This queries work more than 10 seconds on slow machine.
I add query-exec-time setup for avoid this.
Now all should be OK.

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

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

Preview Diff

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

Subscribers

People subscribed via source and target branches