| 1 |
set global binlog_alter_two_phase = ON; |
| 2 |
set binlog_alter_two_phase = ON; |
| 3 |
RESET MASTER; |
| 4 |
create table myt (a int) engine=InnoDB; |
| 5 |
alter table myt add column (b int); |
| 6 |
FLUSH LOGS; |
| 7 |
# Exec MYSQL_BINLOG --base64-output=decode-rows -v MYSQLD_DATADIR/BINLOG_FILENAME > MYSQLTEST_VARDIR/tmp/mysqlbinlog_verbose.sql |
| 8 |
Verbose statements from : master-bin.000001 |
| 9 |
select replace(txt,'\r', '') as stmt from raw_binlog_rows where txt like '###%'; |
| 10 |
stmt |
| 11 |
### alter table myt add column (b int) |
| 12 |
### alter table myt add column (b int) |
| 13 |
drop table raw_binlog_rows; |
| 14 |
drop table myt; |
| 15 |
set global binlog_alter_two_phase=0; |