1SET AUTOCOMMIT=0; 2CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT, b TEXT, PRIMARY KEY(a)) ENGINE=InnoDB; 3SELECT COUNT(*) FROM t1; 4COUNT(*) 51000 6SET GLOBAL binlog_cache_size=4096; 7SET GLOBAL max_binlog_cache_size=4096; 8START TRANSACTION; 9CREATE TABLE t2 SELECT * FROM t1; 10ERROR HY000: Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again 11COMMIT; 12SHOW TABLES LIKE 't%'; 13Tables_in_test (t%) 14t1 15DROP TABLE t1; 16