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