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