一个DDL导致MySQL主从停止问题及解决

Create table tb(c varchar(1000))engine=innodb; Create table tc as select cast(c as signed integer) from tb; Show create table tc; CREATE TABLE `tc` ( `cast(c as signed integer)` bigint(1000) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=gbk

注：此问题只在Row based的binlog 时存在，多谢 @Mr_Mablevi 提醒

1 楼 nofreezou 2012-09-18 5.1.54 木有这个bug