1connect conn1,localhost,root,,test;
2reset master;
3create database test_rotate_db;
4use test_rotate_db;
5#currrent engine=myisam
6show binary logs;
7Log_name	File_size
8master-bin.000001	#
9CREATE TABLE t1_myisam (c1 INT) ENGINE=myisam;
10insert into t1_myisam values(0),(1);
11show master status;
12File	Position	Binlog_Do_DB	Binlog_Ignore_DB
13master-bin.000001	#	<Binlog_Do_DB>	<Binlog_Ignore_DB>
14flush logs;
15flush logs;
16flush logs;
17# left times= 99
18flush logs;
19flush logs;
20flush logs;
21# left times= 98
22flush logs;
23flush logs;
24flush logs;
25# left times= 97
26flush logs;
27flush logs;
28flush logs;
29# left times= 96
30flush logs;
31flush logs;
32flush logs;
33# left times= 95
34flush logs;
35flush logs;
36flush logs;
37# left times= 94
38flush logs;
39flush logs;
40flush logs;
41# left times= 93
42flush logs;
43flush logs;
44flush logs;
45# left times= 92
46flush logs;
47flush logs;
48flush logs;
49# left times= 91
50flush logs;
51flush logs;
52flush logs;
53# left times= 90
54flush logs;
55flush logs;
56flush logs;
57# left times= 89
58flush logs;
59flush logs;
60flush logs;
61# left times= 88
62flush logs;
63flush logs;
64flush logs;
65# left times= 87
66flush logs;
67flush logs;
68flush logs;
69# left times= 86
70flush logs;
71flush logs;
72flush logs;
73# left times= 85
74flush logs;
75flush logs;
76flush logs;
77# left times= 84
78flush logs;
79flush logs;
80flush logs;
81# left times= 83
82flush logs;
83flush logs;
84flush logs;
85# left times= 82
86flush logs;
87flush logs;
88flush logs;
89# left times= 81
90flush logs;
91flush logs;
92flush logs;
93# left times= 80
94flush logs;
95flush logs;
96flush logs;
97# left times= 79
98flush logs;
99flush logs;
100flush logs;
101# left times= 78
102flush logs;
103flush logs;
104flush logs;
105# left times= 77
106flush logs;
107flush logs;
108flush logs;
109# left times= 76
110flush logs;
111flush logs;
112flush logs;
113# left times= 75
114flush logs;
115flush logs;
116flush logs;
117# left times= 74
118flush logs;
119flush logs;
120flush logs;
121# left times= 73
122flush logs;
123flush logs;
124flush logs;
125# left times= 72
126flush logs;
127flush logs;
128flush logs;
129# left times= 71
130flush logs;
131flush logs;
132flush logs;
133# left times= 70
134flush logs;
135flush logs;
136flush logs;
137# left times= 69
138flush logs;
139flush logs;
140flush logs;
141# left times= 68
142flush logs;
143flush logs;
144flush logs;
145# left times= 67
146flush logs;
147flush logs;
148flush logs;
149# left times= 66
150flush logs;
151flush logs;
152flush logs;
153# left times= 65
154flush logs;
155flush logs;
156flush logs;
157# left times= 64
158flush logs;
159flush logs;
160flush logs;
161# left times= 63
162flush logs;
163flush logs;
164flush logs;
165# left times= 62
166flush logs;
167flush logs;
168flush logs;
169# left times= 61
170flush logs;
171flush logs;
172flush logs;
173# left times= 60
174flush logs;
175flush logs;
176flush logs;
177# left times= 59
178flush logs;
179flush logs;
180flush logs;
181# left times= 58
182flush logs;
183flush logs;
184flush logs;
185# left times= 57
186flush logs;
187flush logs;
188flush logs;
189# left times= 56
190flush logs;
191flush logs;
192flush logs;
193# left times= 55
194flush logs;
195flush logs;
196flush logs;
197# left times= 54
198flush logs;
199flush logs;
200flush logs;
201# left times= 53
202flush logs;
203flush logs;
204flush logs;
205# left times= 52
206flush logs;
207flush logs;
208flush logs;
209# left times= 51
210flush logs;
211flush logs;
212flush logs;
213# left times= 50
214flush logs;
215flush logs;
216flush logs;
217# left times= 49
218flush logs;
219flush logs;
220flush logs;
221# left times= 48
222flush logs;
223flush logs;
224flush logs;
225# left times= 47
226flush logs;
227flush logs;
228flush logs;
229# left times= 46
230flush logs;
231flush logs;
232flush logs;
233# left times= 45
234flush logs;
235flush logs;
236flush logs;
237# left times= 44
238flush logs;
239flush logs;
240flush logs;
241# left times= 43
242flush logs;
243flush logs;
244flush logs;
245# left times= 42
246flush logs;
247flush logs;
248flush logs;
249# left times= 41
250flush logs;
251flush logs;
252flush logs;
253# left times= 40
254flush logs;
255flush logs;
256flush logs;
257# left times= 39
258flush logs;
259flush logs;
260flush logs;
261# left times= 38
262flush logs;
263flush logs;
264flush logs;
265# left times= 37
266flush logs;
267flush logs;
268flush logs;
269# left times= 36
270flush logs;
271flush logs;
272flush logs;
273# left times= 35
274flush logs;
275flush logs;
276flush logs;
277# left times= 34
278flush logs;
279flush logs;
280flush logs;
281# left times= 33
282flush logs;
283flush logs;
284flush logs;
285# left times= 32
286flush logs;
287flush logs;
288flush logs;
289# left times= 31
290flush logs;
291flush logs;
292flush logs;
293# left times= 30
294flush logs;
295flush logs;
296flush logs;
297# left times= 29
298flush logs;
299flush logs;
300flush logs;
301# left times= 28
302flush logs;
303flush logs;
304flush logs;
305# left times= 27
306flush logs;
307flush logs;
308flush logs;
309# left times= 26
310flush logs;
311flush logs;
312flush logs;
313# left times= 25
314flush logs;
315flush logs;
316flush logs;
317# left times= 24
318flush logs;
319flush logs;
320flush logs;
321# left times= 23
322flush logs;
323flush logs;
324flush logs;
325# left times= 22
326flush logs;
327flush logs;
328flush logs;
329# left times= 21
330flush logs;
331flush logs;
332flush logs;
333# left times= 20
334flush logs;
335flush logs;
336flush logs;
337# left times= 19
338flush logs;
339flush logs;
340flush logs;
341# left times= 18
342flush logs;
343flush logs;
344flush logs;
345# left times= 17
346flush logs;
347flush logs;
348flush logs;
349# left times= 16
350flush logs;
351flush logs;
352flush logs;
353# left times= 15
354flush logs;
355flush logs;
356flush logs;
357# left times= 14
358flush logs;
359flush logs;
360flush logs;
361# left times= 13
362flush logs;
363flush logs;
364flush logs;
365# left times= 12
366flush logs;
367flush logs;
368flush logs;
369# left times= 11
370flush logs;
371flush logs;
372flush logs;
373# left times= 10
374flush logs;
375flush logs;
376flush logs;
377# left times= 9
378flush logs;
379flush logs;
380flush logs;
381# left times= 8
382flush logs;
383flush logs;
384flush logs;
385# left times= 7
386flush logs;
387flush logs;
388flush logs;
389# left times= 6
390flush logs;
391flush logs;
392flush logs;
393# left times= 5
394flush logs;
395flush logs;
396flush logs;
397# left times= 4
398flush logs;
399flush logs;
400show master status;
401File	Position	Binlog_Do_DB	Binlog_Ignore_DB
402master-bin.000291	#	<Binlog_Do_DB>	<Binlog_Ignore_DB>
403show binary logs;
404Log_name	File_size
405master-bin.000001	#
406master-bin.000002	#
407master-bin.000003	#
408master-bin.000004	#
409master-bin.000005	#
410master-bin.000006	#
411master-bin.000007	#
412master-bin.000008	#
413master-bin.000009	#
414master-bin.000010	#
415master-bin.000011	#
416master-bin.000012	#
417master-bin.000013	#
418master-bin.000014	#
419master-bin.000015	#
420master-bin.000016	#
421master-bin.000017	#
422master-bin.000018	#
423master-bin.000019	#
424master-bin.000020	#
425master-bin.000021	#
426master-bin.000022	#
427master-bin.000023	#
428master-bin.000024	#
429master-bin.000025	#
430master-bin.000026	#
431master-bin.000027	#
432master-bin.000028	#
433master-bin.000029	#
434master-bin.000030	#
435master-bin.000031	#
436master-bin.000032	#
437master-bin.000033	#
438master-bin.000034	#
439master-bin.000035	#
440master-bin.000036	#
441master-bin.000037	#
442master-bin.000038	#
443master-bin.000039	#
444master-bin.000040	#
445master-bin.000041	#
446master-bin.000042	#
447master-bin.000043	#
448master-bin.000044	#
449master-bin.000045	#
450master-bin.000046	#
451master-bin.000047	#
452master-bin.000048	#
453master-bin.000049	#
454master-bin.000050	#
455master-bin.000051	#
456master-bin.000052	#
457master-bin.000053	#
458master-bin.000054	#
459master-bin.000055	#
460master-bin.000056	#
461master-bin.000057	#
462master-bin.000058	#
463master-bin.000059	#
464master-bin.000060	#
465master-bin.000061	#
466master-bin.000062	#
467master-bin.000063	#
468master-bin.000064	#
469master-bin.000065	#
470master-bin.000066	#
471master-bin.000067	#
472master-bin.000068	#
473master-bin.000069	#
474master-bin.000070	#
475master-bin.000071	#
476master-bin.000072	#
477master-bin.000073	#
478master-bin.000074	#
479master-bin.000075	#
480master-bin.000076	#
481master-bin.000077	#
482master-bin.000078	#
483master-bin.000079	#
484master-bin.000080	#
485master-bin.000081	#
486master-bin.000082	#
487master-bin.000083	#
488master-bin.000084	#
489master-bin.000085	#
490master-bin.000086	#
491master-bin.000087	#
492master-bin.000088	#
493master-bin.000089	#
494master-bin.000090	#
495master-bin.000091	#
496master-bin.000092	#
497master-bin.000093	#
498master-bin.000094	#
499master-bin.000095	#
500master-bin.000096	#
501master-bin.000097	#
502master-bin.000098	#
503master-bin.000099	#
504master-bin.000100	#
505master-bin.000101	#
506master-bin.000102	#
507master-bin.000103	#
508master-bin.000104	#
509master-bin.000105	#
510master-bin.000106	#
511master-bin.000107	#
512master-bin.000108	#
513master-bin.000109	#
514master-bin.000110	#
515master-bin.000111	#
516master-bin.000112	#
517master-bin.000113	#
518master-bin.000114	#
519master-bin.000115	#
520master-bin.000116	#
521master-bin.000117	#
522master-bin.000118	#
523master-bin.000119	#
524master-bin.000120	#
525master-bin.000121	#
526master-bin.000122	#
527master-bin.000123	#
528master-bin.000124	#
529master-bin.000125	#
530master-bin.000126	#
531master-bin.000127	#
532master-bin.000128	#
533master-bin.000129	#
534master-bin.000130	#
535master-bin.000131	#
536master-bin.000132	#
537master-bin.000133	#
538master-bin.000134	#
539master-bin.000135	#
540master-bin.000136	#
541master-bin.000137	#
542master-bin.000138	#
543master-bin.000139	#
544master-bin.000140	#
545master-bin.000141	#
546master-bin.000142	#
547master-bin.000143	#
548master-bin.000144	#
549master-bin.000145	#
550master-bin.000146	#
551master-bin.000147	#
552master-bin.000148	#
553master-bin.000149	#
554master-bin.000150	#
555master-bin.000151	#
556master-bin.000152	#
557master-bin.000153	#
558master-bin.000154	#
559master-bin.000155	#
560master-bin.000156	#
561master-bin.000157	#
562master-bin.000158	#
563master-bin.000159	#
564master-bin.000160	#
565master-bin.000161	#
566master-bin.000162	#
567master-bin.000163	#
568master-bin.000164	#
569master-bin.000165	#
570master-bin.000166	#
571master-bin.000167	#
572master-bin.000168	#
573master-bin.000169	#
574master-bin.000170	#
575master-bin.000171	#
576master-bin.000172	#
577master-bin.000173	#
578master-bin.000174	#
579master-bin.000175	#
580master-bin.000176	#
581master-bin.000177	#
582master-bin.000178	#
583master-bin.000179	#
584master-bin.000180	#
585master-bin.000181	#
586master-bin.000182	#
587master-bin.000183	#
588master-bin.000184	#
589master-bin.000185	#
590master-bin.000186	#
591master-bin.000187	#
592master-bin.000188	#
593master-bin.000189	#
594master-bin.000190	#
595master-bin.000191	#
596master-bin.000192	#
597master-bin.000193	#
598master-bin.000194	#
599master-bin.000195	#
600master-bin.000196	#
601master-bin.000197	#
602master-bin.000198	#
603master-bin.000199	#
604master-bin.000200	#
605master-bin.000201	#
606master-bin.000202	#
607master-bin.000203	#
608master-bin.000204	#
609master-bin.000205	#
610master-bin.000206	#
611master-bin.000207	#
612master-bin.000208	#
613master-bin.000209	#
614master-bin.000210	#
615master-bin.000211	#
616master-bin.000212	#
617master-bin.000213	#
618master-bin.000214	#
619master-bin.000215	#
620master-bin.000216	#
621master-bin.000217	#
622master-bin.000218	#
623master-bin.000219	#
624master-bin.000220	#
625master-bin.000221	#
626master-bin.000222	#
627master-bin.000223	#
628master-bin.000224	#
629master-bin.000225	#
630master-bin.000226	#
631master-bin.000227	#
632master-bin.000228	#
633master-bin.000229	#
634master-bin.000230	#
635master-bin.000231	#
636master-bin.000232	#
637master-bin.000233	#
638master-bin.000234	#
639master-bin.000235	#
640master-bin.000236	#
641master-bin.000237	#
642master-bin.000238	#
643master-bin.000239	#
644master-bin.000240	#
645master-bin.000241	#
646master-bin.000242	#
647master-bin.000243	#
648master-bin.000244	#
649master-bin.000245	#
650master-bin.000246	#
651master-bin.000247	#
652master-bin.000248	#
653master-bin.000249	#
654master-bin.000250	#
655master-bin.000251	#
656master-bin.000252	#
657master-bin.000253	#
658master-bin.000254	#
659master-bin.000255	#
660master-bin.000256	#
661master-bin.000257	#
662master-bin.000258	#
663master-bin.000259	#
664master-bin.000260	#
665master-bin.000261	#
666master-bin.000262	#
667master-bin.000263	#
668master-bin.000264	#
669master-bin.000265	#
670master-bin.000266	#
671master-bin.000267	#
672master-bin.000268	#
673master-bin.000269	#
674master-bin.000270	#
675master-bin.000271	#
676master-bin.000272	#
677master-bin.000273	#
678master-bin.000274	#
679master-bin.000275	#
680master-bin.000276	#
681master-bin.000277	#
682master-bin.000278	#
683master-bin.000279	#
684master-bin.000280	#
685master-bin.000281	#
686master-bin.000282	#
687master-bin.000283	#
688master-bin.000284	#
689master-bin.000285	#
690master-bin.000286	#
691master-bin.000287	#
692master-bin.000288	#
693master-bin.000289	#
694master-bin.000290	#
695master-bin.000291	#
696reset master;
697# left times= 3
698flush logs;
699flush logs;
700show master status;
701File	Position	Binlog_Do_DB	Binlog_Ignore_DB
702master-bin.000003	#	<Binlog_Do_DB>	<Binlog_Ignore_DB>
703reset master;
704# left times= 2
705flush logs;
706flush logs;
707show master status;
708File	Position	Binlog_Do_DB	Binlog_Ignore_DB
709master-bin.000003	#	<Binlog_Do_DB>	<Binlog_Ignore_DB>
710reset master;
711# left times= 1
712flush logs;
713flush logs;
714show master status;
715File	Position	Binlog_Do_DB	Binlog_Ignore_DB
716master-bin.000003	#	<Binlog_Do_DB>	<Binlog_Ignore_DB>
717reset master;
718# left times= 0
719# [engine=myisam] after first loop_times=0, show master logs results
720show binary logs;
721Log_name	File_size
722master-bin.000001	#
723show master status;
724File	Position	Binlog_Do_DB	Binlog_Ignore_DB
725master-bin.000001	#	<Binlog_Do_DB>	<Binlog_Ignore_DB>
726flush logs;
727flush logs;
728#begin to restart mysqld current loop_times=10
729# restart
730# left restart times= 9
731flush logs;
732flush logs;
733#begin to restart mysqld current loop_times=9
734# restart
735# left restart times= 8
736flush logs;
737flush logs;
738#begin to restart mysqld current loop_times=8
739# restart
740# left restart times= 7
741flush logs;
742flush logs;
743#begin to restart mysqld current loop_times=7
744# restart
745# left restart times= 6
746flush logs;
747flush logs;
748#begin to restart mysqld current loop_times=6
749# restart
750# left restart times= 5
751flush logs;
752flush logs;
753#begin to restart mysqld current loop_times=5
754# restart
755# left restart times= 4
756flush logs;
757flush logs;
758#begin to restart mysqld current loop_times=4
759# restart
760# left restart times= 3
761flush logs;
762flush logs;
763#begin to restart mysqld current loop_times=3
764# restart
765# left restart times= 2
766flush logs;
767flush logs;
768#begin to restart mysqld current loop_times=2
769# restart
770# left restart times= 1
771flush logs;
772flush logs;
773#begin to restart mysqld current loop_times=1
774# restart
775# left restart times= 0
776# [engine=myisam] after second loop_times=0, show master logs results
777show binary logs;
778Log_name	File_size
779master-bin.000001	#
780master-bin.000002	#
781master-bin.000003	#
782master-bin.000004	#
783master-bin.000005	#
784master-bin.000006	#
785master-bin.000007	#
786master-bin.000008	#
787master-bin.000009	#
788master-bin.000010	#
789master-bin.000011	#
790master-bin.000012	#
791master-bin.000013	#
792master-bin.000014	#
793master-bin.000015	#
794master-bin.000016	#
795master-bin.000017	#
796master-bin.000018	#
797master-bin.000019	#
798master-bin.000020	#
799master-bin.000021	#
800master-bin.000022	#
801master-bin.000023	#
802master-bin.000024	#
803master-bin.000025	#
804master-bin.000026	#
805master-bin.000027	#
806master-bin.000028	#
807master-bin.000029	#
808master-bin.000030	#
809master-bin.000031	#
810# ======= now try to change the log-bin config for mysqld =======
811#begin to restart mysqld
812# restart: --log-bin=new_log_bin
813show binary logs;
814Log_name	File_size
815master-bin.000001	#
816master-bin.000002	#
817master-bin.000003	#
818master-bin.000004	#
819master-bin.000005	#
820master-bin.000006	#
821master-bin.000007	#
822master-bin.000008	#
823master-bin.000009	#
824master-bin.000010	#
825master-bin.000011	#
826master-bin.000012	#
827master-bin.000013	#
828master-bin.000014	#
829master-bin.000015	#
830master-bin.000016	#
831master-bin.000017	#
832master-bin.000018	#
833master-bin.000019	#
834master-bin.000020	#
835master-bin.000021	#
836master-bin.000022	#
837master-bin.000023	#
838master-bin.000024	#
839master-bin.000025	#
840master-bin.000026	#
841master-bin.000027	#
842master-bin.000028	#
843master-bin.000029	#
844master-bin.000030	#
845master-bin.000031	#
846new_log_bin.000001	#
847flush logs;
848flush logs;
849flush logs;
850# left times= 9
851flush logs;
852flush logs;
853flush logs;
854# left times= 8
855flush logs;
856flush logs;
857flush logs;
858# left times= 7
859flush logs;
860flush logs;
861flush logs;
862# left times= 6
863flush logs;
864flush logs;
865flush logs;
866# left times= 5
867flush logs;
868flush logs;
869flush logs;
870# left times= 4
871flush logs;
872flush logs;
873show binary logs;
874Log_name	File_size
875master-bin.000001	#
876master-bin.000002	#
877master-bin.000003	#
878master-bin.000004	#
879master-bin.000005	#
880master-bin.000006	#
881master-bin.000007	#
882master-bin.000008	#
883master-bin.000009	#
884master-bin.000010	#
885master-bin.000011	#
886master-bin.000012	#
887master-bin.000013	#
888master-bin.000014	#
889master-bin.000015	#
890master-bin.000016	#
891master-bin.000017	#
892master-bin.000018	#
893master-bin.000019	#
894master-bin.000020	#
895master-bin.000021	#
896master-bin.000022	#
897master-bin.000023	#
898master-bin.000024	#
899master-bin.000025	#
900master-bin.000026	#
901master-bin.000027	#
902master-bin.000028	#
903master-bin.000029	#
904master-bin.000030	#
905master-bin.000031	#
906new_log_bin.000001	#
907new_log_bin.000002	#
908new_log_bin.000003	#
909new_log_bin.000004	#
910new_log_bin.000005	#
911new_log_bin.000006	#
912new_log_bin.000007	#
913new_log_bin.000008	#
914new_log_bin.000009	#
915new_log_bin.000010	#
916new_log_bin.000011	#
917new_log_bin.000012	#
918new_log_bin.000013	#
919new_log_bin.000014	#
920new_log_bin.000015	#
921new_log_bin.000016	#
922new_log_bin.000017	#
923new_log_bin.000018	#
924new_log_bin.000019	#
925new_log_bin.000020	#
926new_log_bin.000021	#
927reset master;
928# left times= 3
929flush logs;
930flush logs;
931reset master;
932# left times= 2
933flush logs;
934flush logs;
935reset master;
936# left times= 1
937flush logs;
938flush logs;
939reset master;
940# left times= 0
941# [engine=myisam] after third loop_times=0, show master logs results
942show binary logs;
943Log_name	File_size
944new_log_bin.000001	#
945drop database test_rotate_db;
946