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