1select @@global.binlog_space_limit; 2@@global.binlog_space_limit 31024 4FLUSH LOGS; 5FLUSH LOGS; 6FLUSH LOGS; 7FLUSH LOGS; 8show binary logs; 9Log_name File_size 10binary.000001 # 11binary.000002 # 12binary.000003 # 13binary.000004 # 14binary.000005 # 15FLUSH LOGS; 16show binary logs; 17Log_name File_size 18binary.000002 # 19binary.000003 # 20binary.000004 # 21binary.000005 # 22binary.000006 # 23CREATE TABLE `t1` ( 24`v1` int(11) DEFAULT NULL, 25`v2` int(11) DEFAULT NULL, 26KEY `v1` (`v1`) 27); 28INSERT INTO t1 VALUES (0,0); 29show binary logs; 30Log_name File_size 31binary.000005 # 32binary.000006 # 33INSERT INTO t1 VALUES (1,1); 34show binary logs; 35Log_name File_size 36binary.000006 # 37FLUSH LOGS; 38show binary logs; 39Log_name File_size 40binary.000007 # 41FLUSH LOGS; 42FLUSH LOGS; 43FLUSH LOGS; 44FLUSH LOGS; 45show binary logs; 46Log_name File_size 47binary.000007 # 48binary.000008 # 49binary.000009 # 50binary.000010 # 51binary.000011 # 52PURGE BINARY LOGS TO 'binary.000008'; 53FLUSH LOGS; 54show binary logs; 55Log_name File_size 56binary.000008 # 57binary.000009 # 58binary.000010 # 59binary.000011 # 60binary.000012 # 61INSERT INTO t1 VALUES (2,2); 62show binary logs; 63Log_name File_size 64binary.000009 # 65binary.000010 # 66binary.000011 # 67binary.000012 # 68INSERT INTO t1 VALUES (3,3); 69show binary logs; 70Log_name File_size 71binary.000011 # 72binary.000012 # 73RESET MASTER; 74show binary logs; 75Log_name File_size 76binary.000001 # 77INSERT INTO t1 VALUES (4,4); 78FLUSH LOGS; 79INSERT INTO t1 VALUES (5,5); 80show binary logs; 81Log_name File_size 82binary.000001 # 83binary.000002 # 84INSERT INTO t1 VALUES (6,6); 85show binary logs; 86Log_name File_size 87binary.000002 # 88FLUSH LOGS; 89FLUSH LOGS; 90show binary logs; 91Log_name File_size 92binary.000003 # 93binary.000004 # 94DROP TABLE IF EXISTS t1; 95