Debian Codegraph @

mysql-test/suite/sys_vars/r/slow_query_log_func.result

raw
1 SET @global_slow_query_log = @@global.slow_query_log;
2 SET @global_log_output = @@global.log_output;
3 SET @@session.long_query_time=1;
4 SET @@global.log_output = 'TABLE';
5 '----When global.log_slow_query = OFF----'
6 SET @@global.log_slow_query = OFF;
7 TRUNCATE mysql.slow_log;
8 SELECT sleep(2);
9 sleep(2)
10 0
11 SELECT count(*) FROM mysql.slow_log;
12 count(*)
13 0
14 '----When global.slow_query_log = ON-----'
15 SET @@global.slow_query_log = ON;
16 TRUNCATE mysql.slow_log;
17 SELECT sleep(2);
18 sleep(2)
19 0
20 SELECT count(*) > 0 FROM mysql.slow_log;
21 count(*) > 0
22 1
23 '----When local.log_slow_query = OFF-----'
24 SET @@local.log_slow_query = OFF;
25 TRUNCATE mysql.slow_log;
26 SELECT sleep(2);
27 sleep(2)
28 0
29 SELECT count(*) FROM mysql.slow_log;
30 count(*)
31 0
32 SET @@local.slow_query_log = ON;
33 'Bug#47905 stored procedures not logged correctly to slow query log'
34 TRUNCATE mysql.slow_log;
35 CREATE PROCEDURE p_test()
36 BEGIN
37 select sleep(2);
38 select 1;
39 END//
40 CALL p_test();
41 sleep(2)
42 0
43 1
44 1
45 SELECT count(*) > 0 FROM mysql.slow_log;
46 count(*) > 0
47 1
48 DROP PROCEDURE p_test;
49 Bug53191 Lock_time in slow log is negative when logging stored routines
50 TRUNCATE mysql.slow_log;
51 connect con2,localhost,root,,;
52 connection default;
53 CREATE TABLE t1 (c0 INT PRIMARY KEY AUTO_INCREMENT, c1 TIMESTAMP, c2 TIMESTAMP);
54 CREATE FUNCTION f_slow_now() RETURNS TIMESTAMP
55 BEGIN
56 DO SLEEP(2);
57 RETURN NOW();
58 END//
59 CREATE FUNCTION f_slow_current_time() RETURNS TIME
60 BEGIN
61 DO SLEEP(2);
62 RETURN CURRENT_TIME();
63 END
64 //
65 INSERT INTO t1 (c1,c2) VALUES (now(), f_slow_now())//
66 CREATE TRIGGER tf_before BEFORE INSERT ON t1
67 FOR EACH ROW BEGIN
68 SET new.c2 = f_slow_now();
69 END//
70 CREATE PROCEDURE p1()
71 BEGIN
72 INSERT INTO t1 (c1,c2) values (now(),now());
73 DO SLEEP(2);
74 INSERT INTO t1 (c1,c2) values (now(),now());
75 end//
76 INSERT INTO t1 (c1,c2) VALUES (now(), now());
77 CALL p1();
78 SELECT c1-c2 FROM t1;
79 c1-c2
80 0
81 0
82 0
83 0
84 *** There shouldn't less than 1 s difference between each row
85 SELECT t1.c1-self.c1 > 1 FROM t1, t1 as self WHERE t1.c0=self.c0+1 ORDER BY t1.c0;
86 t1.c1-self.c1 > 1
87 1
88 1
89 1
90 DROP TRIGGER tf_before;
91 DROP FUNCTION f_slow_now;
92 DROP FUNCTION f_slow_current_time;
93 DROP TABLE t1;
94 DROP TABLE IF EXISTS t1;
95 Warnings:
96 Note 1051 Unknown table 'test.t1'
97 CREATE TABLE t1(c1 INT) ENGINE=MyISAM;
98 DROP PROCEDURE IF EXISTS p1;
99 CREATE PROCEDURE p1()
100 BEGIN
101 INSERT INTO t1 VALUES (1);
102 SELECT COUNT(*) FROM t1 WHERE c1= 1;
103 UPDATE t1 SET c1=c1*2;
104 END|
105 connection con2;
106 LOCK TABLE t1 WRITE;
107 connection default;
108 CALL p1();
109 Wait three seconds and unlock the table
110 connection con2;
111 UNLOCK TABLES;
112 connection default;
113 COUNT(*)
114 1
115 Slow log:
116 **** 1 == we have slow log entries
117 SELECT count(*) > 0 FROM mysql.slow_log;
118 count(*) > 0
119 1
120 **** 0 == None of the entries have a lock time greater than 10 s
121 SELECT count(*) FROM mysql.slow_log WHERE lock_time > 10;
122 count(*)
123 0
124 disconnect con2;
125 DROP TABLE t1;
126 DROP PROCEDURE p1;
127 SET @@global.log_output = @global_log_output;
128 SET @global.slow_query_log = @global_slow_query_log;