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