1SET @old_log_output=                @@global.log_output;
2SET @old_slow_query_log=            @@global.slow_query_log;
3SET @old_long_query_time=           @@session.long_query_time;
4SET @old_log_slow_admin_statements= @@global.log_slow_admin_statements;
5USE test;
6CREATE TABLE log_slow_admin_statements (
7i INT PRIMARY KEY AUTO_INCREMENT,
8j VARCHAR(255)
9) ENGINE=InnoDB;
10SET GLOBAL log_output = 'file,table';
11SET GLOBAL slow_query_log = on;
12SET SESSION long_query_time = 0;
13SET SESSION log_slow_admin_statements = on;
14ALTER TABLE log_slow_admin_statements ADD COLUMN k INT DEFAULT 17;
15CREATE PROCEDURE add_rows()
16BEGIN
17DECLARE count INT;
18SET count = 1;
19INSERT INTO log_slow_admin_statements(j) values (REPEAT('A', 255));
20WHILE count <= 15 DO
21INSERT INTO log_slow_admin_statements(j) SELECT j FROM log_slow_admin_statements;
22SET count = count + 1;
23END WHILE;
24END
25$
26CALL add_rows();
27OPTIMIZE TABLE log_slow_admin_statements;
28Table	Op	Msg_type	Msg_text
29test.log_slow_admin_statements	optimize	note	Table does not support optimize, doing recreate + analyze instead
30test.log_slow_admin_statements	optimize	status	OK
31CHECK TABLE log_slow_admin_statements EXTENDED;
32Table	Op	Msg_type	Msg_text
33test.log_slow_admin_statements	check	status	OK
34DROP TABLE log_slow_admin_statements;
35SELECT sql_text FROM mysql.slow_log WHERE sql_text LIKE '%TABLE log_slow_admin_statements%';
36sql_text
37ALTER TABLE log_slow_admin_statements ADD COLUMN k INT DEFAULT 17
38OPTIMIZE TABLE log_slow_admin_statements
39CHECK TABLE log_slow_admin_statements EXTENDED
40DROP TABLE log_slow_admin_statements
41SET @@global.log_output=                @old_log_output;
42SET @@global.slow_query_log=            @old_slow_query_log;
43SET @@session.long_query_time=          @old_long_query_time;
44SET @@global.log_slow_admin_statements= @old_log_slow_admin_statements;
45DROP PROCEDURE add_rows;
46TRUNCATE TABLE mysql.slow_log;
47SET @save_log_slow_disabled_statements= @@global.log_slow_disabled_statements;
48SET @@SESSION.log_slow_admin_statements= TRUE;
49select @@SESSION.log_slow_disabled_statements;
50@@SESSION.log_slow_disabled_statements
51sp
52SET @@SESSION.log_slow_admin_statements= FALSE;
53select @@SESSION.log_slow_disabled_statements;
54@@SESSION.log_slow_disabled_statements
55admin,sp
56SET @@GLOBAL.log_slow_admin_statements= TRUE;
57select @@GLOBAL.log_slow_disabled_statements;
58@@GLOBAL.log_slow_disabled_statements
59sp
60SET @@GLOBAL.log_slow_admin_statements= FALSE;
61select @@GLOBAL.log_slow_disabled_statements;
62@@GLOBAL.log_slow_disabled_statements
63admin,sp
64SET @@SESSION.log_slow_disabled_statements="";
65select @@SESSION.log_slow_admin_statements;
66@@SESSION.log_slow_admin_statements
671
68SET @@SESSION.log_slow_disabled_statements="admin";
69select @@SESSION.log_slow_admin_statements;
70@@SESSION.log_slow_admin_statements
710
72SET @@GLOBAL.log_slow_disabled_statements="";
73select @@GLOBAL.log_slow_admin_statements;
74@@GLOBAL.log_slow_admin_statements
751
76SET @@GLOBAL.log_slow_disabled_statements="admin";
77select @@GLOBAL.log_slow_admin_statements;
78@@GLOBAL.log_slow_admin_statements
790
80SET @@global.log_slow_disabled_statements= @save_log_slow_disabled_statements;
81