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; 8disconnect default; 9connect default,localhost,root,,test; 10START TRANSACTION; 11CREATE TABLE t2 SELECT * FROM t1; 12ERROR HY000: Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again 13COMMIT; 14SHOW TABLES LIKE 't%'; 15Tables_in_test (t%) 16t1 17DROP TABLE t1; 18disconnect default; 19connect default,localhost,root,,test; 20