Debian Codegraph @

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

raw
1 SET @old_log_output= @@global.log_output;
2 SET @old_slow_query_log= @@global.slow_query_log;
3 SET @old_long_query_time= @@session.long_query_time;
4 SET @old_log_slow_admin_statements= @@global.log_slow_admin_statements;
5 USE test;
6 CREATE TABLE log_slow_admin_statements (
7 i INT PRIMARY KEY AUTO_INCREMENT,
8 j VARCHAR(255)
9 ) ENGINE=InnoDB;
10 SET GLOBAL log_output = 'file,table';
11 SET GLOBAL slow_query_log = on;
12 SET SESSION long_query_time = 0;
13 SET GLOBAL log_slow_admin_statements = off;
14 ALTER TABLE log_slow_admin_statements ADD COLUMN k INT DEFAULT 17;
15 CREATE PROCEDURE add_rows()
16 BEGIN
17 DECLARE count INT;
18 SET count = 1;
19 INSERT INTO log_slow_admin_statements(j) values (REPEAT('A', 255));
20 WHILE count <= 15 DO
21 INSERT INTO log_slow_admin_statements(j) SELECT j FROM log_slow_admin_statements;
22 SET count = count + 1;
23 END WHILE;
24 END
25 $
26 CALL add_rows();
27 ANALYZE TABLE log_slow_admin_statements;
28 Table Op Msg_type Msg_text
29 test.log_slow_admin_statements analyze status OK
30 OPTIMIZE TABLE log_slow_admin_statements;
31 Table Op Msg_type Msg_text
32 test.log_slow_admin_statements optimize note Table does not support optimize, doing recreate + analyze instead
33 test.log_slow_admin_statements optimize status OK
34 CHECK TABLE log_slow_admin_statements EXTENDED;
35 Table Op Msg_type Msg_text
36 test.log_slow_admin_statements check status OK
37 Administrative sql statements must not be logged
38 SELECT count(sql_text)= 0 FROM mysql.slow_log
39 WHERE sql_text LIKE '%TABLE log_slow_admin_statements%';
40 count(sql_text)= 0
41 1
42 SET GLOBAL log_slow_admin_statements = on;
43 DROP TABLE log_slow_admin_statements;
44 CREATE TABLE log_slow_admin_statements (
45 i INT PRIMARY KEY AUTO_INCREMENT,
46 j VARCHAR(255)
47 ) ENGINE=InnoDB;
48 CALL add_rows();
49 ANALYZE TABLE log_slow_admin_statements;
50 Table Op Msg_type Msg_text
51 test.log_slow_admin_statements analyze status OK
52 OPTIMIZE TABLE log_slow_admin_statements;
53 Table Op Msg_type Msg_text
54 test.log_slow_admin_statements optimize note Table does not support optimize, doing recreate + analyze instead
55 test.log_slow_admin_statements optimize status OK
56 CHECK TABLE log_slow_admin_statements EXTENDED;
57 Table Op Msg_type Msg_text
58 test.log_slow_admin_statements check status OK
59 At least one administrativ sql statement must be logged in slow query log
60 SELECT count(sql_text)> 0 FROM mysql.slow_log
61 WHERE sql_text LIKE '%TABLE log_slow_admin_statements%';
62 count(sql_text)> 0
63 1
64 SET @@global.log_output= @old_log_output;
65 SET @@global.slow_query_log= @old_slow_query_log;
66 SET @@session.long_query_time= @old_long_query_time;
67 SET @@global.log_slow_admin_statements= @old_log_slow_admin_statements;
68 DROP PROCEDURE add_rows;
69 DROP TABLE log_slow_admin_statements;
70 TRUNCATE TABLE mysql.slow_log;
71 TRUNCATE TABLE mysql.general_log;