1include/master-slave.inc 2[connection master] 3call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT"); 4call mtr.add_suppression("table or database name 'mysqltest-1'"); 5connection master; 6CREATE DATABASE `mysqltest-1`; 7connection slave; 8connection master; 9connection slave; 10connection master; 11Master position is not changed 12connection slave; 13SET @old_general_log_state = @@global.general_log; 14SET @old_slow_log_state = @@global.slow_query_log; 15SET @old_log_output = @@global.log_output; 16SET GLOBAL general_log = 'ON'; 17SET GLOBAL slow_query_log = 'ON'; 18SET GLOBAL log_output = 'FILE'; 19connection master; 20ALTER TABLE mysql.slow_log DROP COLUMN thread_id, DROP COLUMN rows_affected; 21DROP DATABASE `mysqltest-1`; 22connection slave; 23connection slave; 24SHOW CREATE TABLE mysql.slow_log; 25Table Create Table 26slow_log CREATE TABLE `slow_log` ( 27 `start_time` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6), 28 `user_host` mediumtext NOT NULL, 29 `query_time` time(6) NOT NULL, 30 `lock_time` time(6) NOT NULL, 31 `rows_sent` int(11) NOT NULL, 32 `rows_examined` int(11) NOT NULL, 33 `db` varchar(512) NOT NULL, 34 `last_insert_id` int(11) NOT NULL, 35 `insert_id` int(11) NOT NULL, 36 `server_id` int(10) unsigned NOT NULL, 37 `sql_text` mediumtext NOT NULL 38) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log' 39connection master; 40connection master; 41Master position has been changed 42connection slave; 43connection slave; 44SHOW CREATE TABLE mysql.slow_log; 45Table Create Table 46slow_log CREATE TABLE `slow_log` ( 47 `start_time` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6), 48 `user_host` mediumtext NOT NULL, 49 `query_time` time(6) NOT NULL, 50 `lock_time` time(6) NOT NULL, 51 `rows_sent` int(11) NOT NULL, 52 `rows_examined` int(11) NOT NULL, 53 `db` varchar(512) NOT NULL, 54 `last_insert_id` int(11) NOT NULL, 55 `insert_id` int(11) NOT NULL, 56 `server_id` int(10) unsigned NOT NULL, 57 `sql_text` mediumtext NOT NULL, 58 `thread_id` bigint(21) unsigned NOT NULL, 59 `rows_affected` int(11) NOT NULL 60) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log' 61SET GLOBAL general_log = 'OFF'; 62SET GLOBAL slow_query_log = 'OFF'; 63truncate mysql.slow_log; 64truncate mysql.general_log; 65SET GLOBAL general_log = @old_general_log_state; 66SET GLOBAL slow_query_log = @old_slow_log_state; 67SET GLOBAL log_output = @old_log_output; 68include/rpl_end.inc 69