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: 9646 lines (+9466/-6)
11 files modified
Percona-Server/mysql-test/mysql-test-run.pl (+1/-0)
Percona-Server/mysql-test/r/percona_mysqldumpslow.result (+9134/-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 (+30/-0)
Percona-Server/sql/log_event.h (+2/-0)
Percona-Server/sql/mysqld.cc (+14/-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
Percona developers Pending
Review via email: mp+84252@code.launchpad.net

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

Description of the change

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 :

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 :

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

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

Subscribers

People subscribed via source and target branches