Debian Codegraph @

mysql-test/suite/binlog/r/binlog_rotate_perf.result

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