mirror of
https://github.com/MariaDB/server.git
synced 2025-08-07 00:04:31 +03:00
16 lines
593 B
Plaintext
16 lines
593 B
Plaintext
set global binlog_alter_two_phase = ON;
|
|
set binlog_alter_two_phase = ON;
|
|
RESET MASTER;
|
|
create table myt (a int) engine=InnoDB;
|
|
alter table myt add column (b int);
|
|
FLUSH LOGS;
|
|
# Exec MYSQL_BINLOG --base64-output=decode-rows -v MYSQLD_DATADIR/BINLOG_FILENAME > MYSQLTEST_VARDIR/tmp/mysqlbinlog_verbose.sql
|
|
Verbose statements from : master-bin.000001
|
|
select replace(txt,'\r', '') as stmt from raw_binlog_rows where txt like '###%';
|
|
stmt
|
|
### alter table myt add column (b int)
|
|
### alter table myt add column (b int)
|
|
drop table raw_binlog_rows;
|
|
drop table myt;
|
|
set global binlog_alter_two_phase=0;
|