API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 5th, 2017
125
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 30.58 KB | None | 0 0
raw download clone embed print report
  1. Old:
  2.  
  3. Copy: 196000/9500340 2.1%; Applied: 142852; Backlog: 100/100; Time: 7m0s(total), 7m0s(copy); streamer: binlog.000079:670258826; State: migrating; ETA: 5h32m18s
  4. Copy: 196000/9500340 2.1%; Applied: 152459; Backlog: 100/100; Time: 7m30s(total), 7m30s(copy); streamer: binlog.000079:676972069; State: migrating; ETA: 5h56m2s
  5. Copy: 196000/9500340 2.1%; Applied: 162824; Backlog: 100/100; Time: 8m0s(total), 8m0s(copy); streamer: binlog.000079:684179033; State: migrating; ETA: 6h19m46s
  6. Copy: 196000/9500340 2.1%; Applied: 171061; Backlog: 100/100; Time: 8m30s(total), 8m30s(copy); streamer: binlog.000079:690119163; State: migrating; ETA: 6h43m30s
  7. Copy: 196000/9500340 2.1%; Applied: 177955; Backlog: 100/100; Time: 9m0s(total), 9m0s(copy); streamer: binlog.000079:695256290; State: migrating; ETA: 7h7m14s
  8. Copy: 196000/9500340 2.1%; Applied: 188734; Backlog: 100/100; Time: 9m30s(total), 9m30s(copy); streamer: binlog.000079:702951860; State: throttled, lag=0.716483s; ETA: 7h30m58s
  9. # Migrating `sbtest1`.`sbtest1`; Ghost table is `sbtest1`.`_sbtest1_gho`
  10. # Migrating ip-172-30-4-4:3306; inspecting ip-172-30-4-235:3306; executing on ip-172-30-4-235
  11. # Migration started at Thu Jan 05 15:19:54 +0000 2017
  12. # chunk-size: 2000; max-lag-millis: 500ms; max-load: Threads_connected=30; critical-load: ; nice-ratio: 0.000000
  13. # throttle-additional-flag-file: /tmp/gh-ost.throttle
  14. # Serving on unix socket: /tmp/gh-ost.sbtest1.sbtest1.sock
  15. Copy: 196000/9500340 2.1%; Applied: 193272; Backlog: 100/100; Time: 10m0s(total), 10m0s(copy); streamer: binlog.000079:706300741; State: throttled, lag=1.016226s; ETA: 7h54m42s
  16. ^@Copy: 196000/9500340 2.1%; Applied: 203035; Backlog: 100/100; Time: 10m30s(total), 10m30s(copy); streamer: binlog.000079:713679599; State: migrating; ETA: 8h18m27s
  17.  
  18.  
  19.  
  20. New:
  21.  
  22.  
  23. root@ip-172-30-4-235:~# ./gh-ost-352 --host=172.30.4.235 --user=sbtest --password=sbtest --database=sbtest1 --table=sbtest1 --alter="ENGINE=InnoDB" --chunk-size=2000 --max-load=Threads_connected=30 --max-lag-millis=500 --heartbeat-interval-millis=100 --initially-drop-ghost-table --initially-drop-old-table --dml-batch-size=100 --execute
  24. # Migrating `sbtest1`.`sbtest1`; Ghost table is `sbtest1`.`_sbtest1_gho`
  25. # Migrating ip-172-30-4-4:3306; inspecting ip-172-30-4-235:3306; executing on ip-172-30-4-235
  26. # Migration started at Thu Jan 05 15:07:35 +0000 2017
  27. # chunk-size: 2000; max-lag-millis: 500ms; max-load: Threads_connected=30; critical-load: ; nice-ratio: 0.000000
  28. # throttle-additional-flag-file: /tmp/gh-ost.throttle
  29. # Serving on unix socket: /tmp/gh-ost.sbtest1.sbtest1.sock
  30. Copy: 0/9937427 0.0%; Applied: 0; Backlog: 0/100; Time: 1s(total), 0s(copy); streamer: binlog.000077:474635125; State: migrating; ETA: N/A
  31. Copy: 38000/9937427 0.4%; Applied: 271; Backlog: 13/100; Time: 2s(total), 1s(copy); streamer: binlog.000077:480246041; State: migrating; ETA: N/A
  32. Copy: 78000/9937427 0.8%; Applied: 486; Backlog: 27/100; Time: 3s(total), 2s(copy); streamer: binlog.000077:489264859; State: migrating; ETA: N/A
  33. Copy: 128000/9937427 1.3%; Applied: 749; Backlog: 16/100; Time: 4s(total), 3s(copy); streamer: binlog.000077:497500527; State: migrating; ETA: 3m50s
  34. Copy: 172000/9937427 1.7%; Applied: 1017; Backlog: 0/100; Time: 5s(total), 4s(copy); streamer: binlog.000077:505940712; State: migrating; ETA: 3m47s
  35. Copy: 222000/9937427 2.2%; Applied: 1257; Backlog: 0/100; Time: 6s(total), 5s(copy); streamer: binlog.000077:515018515; State: migrating; ETA: 3m39s
  36. Copy: 256000/9937427 2.6%; Applied: 1509; Backlog: 100/100; Time: 7s(total), 6s(copy); streamer: binlog.000077:522993950; State: throttled, lag=0.550868s; ETA: 3m47s
  37. Copy: 256000/9937427 2.6%; Applied: 1711; Backlog: 100/100; Time: 8s(total), 7s(copy); streamer: binlog.000077:525501941; State: migrating; ETA: 4m24s
  38. Copy: 268000/9937427 2.7%; Applied: 2879; Backlog: 0/100; Time: 9s(total), 8s(copy); streamer: binlog.000077:527699409; State: migrating; ETA: 4m48s
  39. Copy: 302000/9937427 3.0%; Applied: 3338; Backlog: 8/100; Time: 10s(total), 9s(copy); streamer: binlog.000077:533434142; State: migrating; ETA: 4m47s
  40. Copy: 334000/9937427 3.4%; Applied: 3915; Backlog: 0/100; Time: 11s(total), 10s(copy); streamer: binlog.000077:539591294; State: migrating; ETA: 4m47s
  41. Copy: 346000/9937427 3.5%; Applied: 4073; Backlog: 100/100; Time: 12s(total), 11s(copy); streamer: binlog.000077:542083792; State: throttled, lag=0.551024s; ETA: 5m5s
  42. Copy: 346000/9937427 3.5%; Applied: 5184; Backlog: 4/100; Time: 13s(total), 12s(copy); streamer: binlog.000077:545102371; State: migrating; ETA: 5m32s
  43. Copy: 384000/9937427 3.9%; Applied: 5676; Backlog: 0/100; Time: 14s(total), 13s(copy); streamer: binlog.000077:550418524; State: migrating; ETA: 5m23s
  44. Copy: 416000/9937427 4.2%; Applied: 6212; Backlog: 10/100; Time: 15s(total), 14s(copy); streamer: binlog.000077:556579229; State: migrating; ETA: 5m20s
  45. Copy: 418000/9937427 4.2%; Applied: 6212; Backlog: 100/100; Time: 16s(total), 15s(copy); streamer: binlog.000077:557412489; State: throttled, lag=0.651142s; ETA: 5m41s
  46. Copy: 426000/9937427 4.3%; Applied: 7162; Backlog: 1/100; Time: 17s(total), 16s(copy); streamer: binlog.000077:560291561; State: migrating; ETA: 5m57s
  47. Copy: 472000/9937427 4.7%; Applied: 7418; Backlog: 0/100; Time: 18s(total), 17s(copy); streamer: binlog.000077:567841575; State: migrating; ETA: 5m41s
  48. Copy: 520000/9937427 5.2%; Applied: 7620; Backlog: 18/100; Time: 19s(total), 18s(copy); streamer: binlog.000077:576516646; State: throttled, lag=0.550810s; ETA: 5m26s
  49. Copy: 520000/9937427 5.2%; Applied: 7721; Backlog: 100/100; Time: 20s(total), 19s(copy); streamer: binlog.000077:580571461; State: migrating; ETA: 5m44s
  50. Copy: 558000/9937427 5.6%; Applied: 8228; Backlog: 0/100; Time: 21s(total), 20s(copy); streamer: binlog.000077:586609411; State: migrating; ETA: 5m36s
  51. Copy: 606000/9937427 6.1%; Applied: 8468; Backlog: 0/100; Time: 22s(total), 21s(copy); streamer: binlog.000077:594920626; State: migrating; ETA: 5m23s
  52. Copy: 638000/9937427 6.4%; Applied: 8585; Backlog: 95/100; Time: 23s(total), 22s(copy); streamer: binlog.000077:602418271; State: throttled, lag=0.550834s; ETA: 5m20s
  53. Copy: 652000/9937427 6.6%; Applied: 9073; Backlog: 0/100; Time: 24s(total), 23s(copy); streamer: binlog.000077:605787818; State: migrating; ETA: 5m27s
  54. Copy: 688000/9937427 6.9%; Applied: 9477; Backlog: 1/100; Time: 25s(total), 24s(copy); streamer: binlog.000077:611860618; State: migrating; ETA: 5m22s
  55. Copy: 704000/9937427 7.1%; Applied: 9742; Backlog: 100/100; Time: 26s(total), 25s(copy); streamer: binlog.000077:615190193; State: throttled, lag=0.550970s; ETA: 5m27s
  56. Copy: 704000/9937427 7.1%; Applied: 10870; Backlog: 0/100; Time: 27s(total), 26s(copy); streamer: binlog.000077:618199158; State: migrating; ETA: 5m41s
  57. Copy: 732000/9937427 7.4%; Applied: 11313; Backlog: 0/100; Time: 28s(total), 27s(copy); streamer: binlog.000077:623522269; State: migrating; ETA: 5m39s
  58. Copy: 764000/9937427 7.7%; Applied: 11837; Backlog: 0/100; Time: 29s(total), 28s(copy); streamer: binlog.000077:628901343; State: migrating; ETA: 5m36s
  59. Copy: 796000/9937427 8.0%; Applied: 12387; Backlog: 0/100; Time: 30s(total), 29s(copy); streamer: binlog.000077:635073199; State: migrating; ETA: 5m33s
  60. Copy: 822000/9937427 8.3%; Applied: 12976; Backlog: 7/100; Time: 31s(total), 30s(copy); streamer: binlog.000077:640482733; State: migrating; ETA: 5m32s
  61. Copy: 840000/9937427 8.5%; Applied: 13248; Backlog: 60/100; Time: 32s(total), 31s(copy); streamer: binlog.000077:643401887; State: throttled, lag=0.851056s; ETA: 5m35s
  62. Copy: 840000/9937427 8.5%; Applied: 13248; Backlog: 100/100; Time: 33s(total), 32s(copy); streamer: binlog.000077:643433937; State: throttled, lag=0.950769s; ETA: 5m46s
  63. Copy: 840000/9937427 8.5%; Applied: 13248; Backlog: 100/100; Time: 34s(total), 33s(copy); streamer: binlog.000077:643433937; State: throttled, lag=1.050849s; ETA: 5m57s
  64. Copy: 840000/9937427 8.5%; Applied: 13248; Backlog: 100/100; Time: 35s(total), 34s(copy); streamer: binlog.000077:643433937; State: throttled, lag=0.650801s; ETA: 6m8s
  65. Copy: 840000/9937427 8.5%; Applied: 13248; Backlog: 100/100; Time: 36s(total), 35s(copy); streamer: binlog.000077:643433937; State: throttled, lag=0.850917s; ETA: 6m19s
  66. Copy: 840000/9937427 8.5%; Applied: 13248; Backlog: 100/100; Time: 37s(total), 36s(copy); streamer: binlog.000077:643433937; State: throttled, lag=0.550999s; ETA: 6m29s
  67. Copy: 840000/9937427 8.5%; Applied: 13248; Backlog: 100/100; Time: 38s(total), 37s(copy); streamer: binlog.000077:643433937; State: throttled, lag=0.850914s; ETA: 6m40s
  68. Copy: 840000/9937427 8.5%; Applied: 13248; Backlog: 100/100; Time: 39s(total), 38s(copy); streamer: binlog.000077:643433937; State: migrating; ETA: 6m51s
  69. Copy: 840000/9937427 8.5%; Applied: 14763; Backlog: 100/100; Time: 40s(total), 39s(copy); streamer: binlog.000077:647068152; State: migrating; ETA: 7m2s
  70. Copy: 840000/9937427 8.5%; Applied: 16480; Backlog: 100/100; Time: 41s(total), 40s(copy); streamer: binlog.000077:648163152; State: migrating; ETA: 7m13s
  71. Copy: 870000/9937427 8.8%; Applied: 17296; Backlog: 2/100; Time: 42s(total), 41s(copy); streamer: binlog.000077:653403887; State: migrating; ETA: 7m7s
  72. Copy: 912000/9937427 9.2%; Applied: 17548; Backlog: 0/100; Time: 43s(total), 42s(copy); streamer: binlog.000077:661707336; State: migrating; ETA: 6m55s
  73. Copy: 960000/9937427 9.7%; Applied: 17782; Backlog: 4/100; Time: 44s(total), 43s(copy); streamer: binlog.000077:670009271; State: migrating; ETA: 6m42s
  74. Copy: 1000000/9937427 10.1%; Applied: 18123; Backlog: 0/100; Time: 45s(total), 44s(copy); streamer: binlog.000077:676809692; State: migrating; ETA: 6m33s
  75. [MySQL] 2017/01/05 15:08:20 statement.go:27: Invalid Connection
  76. Copy: 1004000/9937427 10.1%; Applied: 18123; Backlog: 100/100; Time: 46s(total), 45s(copy); streamer: binlog.000077:678037598; State: throttled, lag=0.550812s; ETA: 6m40s
  77. Copy: 1010000/9937427 10.2%; Applied: 19389; Backlog: 6/100; Time: 47s(total), 46s(copy); streamer: binlog.000077:683075625; State: migrating; ETA: 6m46s
  78. Copy: 1050000/9937427 10.6%; Applied: 19843; Backlog: 0/100; Time: 48s(total), 47s(copy); streamer: binlog.000077:688783358; State: migrating; ETA: 6m37s
  79. Copy: 1080000/9937427 10.9%; Applied: 20381; Backlog: 0/100; Time: 49s(total), 48s(copy); streamer: binlog.000077:694551673; State: migrating; ETA: 6m33s
  80. Copy: 1084000/9937427 10.9%; Applied: 20417; Backlog: 100/100; Time: 50s(total), 49s(copy); streamer: binlog.000077:696187125; State: throttled, lag=0.550865s; ETA: 6m40s
  81. Copy: 1086000/9937427 10.9%; Applied: 21791; Backlog: 20/100; Time: 51s(total), 50s(copy); streamer: binlog.000077:698953636; State: migrating; ETA: 6m47s
  82. Copy: 1108000/9937427 11.1%; Applied: 22069; Backlog: 100/100; Time: 52s(total), 51s(copy); streamer: binlog.000077:700759475; State: throttled, lag=0.650852s; ETA: 6m46s
  83. Copy: 1108000/9937427 11.1%; Applied: 22069; Backlog: 100/100; Time: 53s(total), 52s(copy); streamer: binlog.000077:700759475; State: throttled, lag=0.651114s; ETA: 6m54s
  84. Copy: 1108000/9937427 11.1%; Applied: 22069; Backlog: 100/100; Time: 54s(total), 53s(copy); streamer: binlog.000077:700759475; State: throttled, lag=0.951107s; ETA: 7m2s
  85. Copy: 1108000/9937427 11.1%; Applied: 22069; Backlog: 100/100; Time: 55s(total), 54s(copy); streamer: binlog.000077:700759475; State: throttled, lag=0.550869s; ETA: 7m10s
  86. Copy: 1108000/9937427 11.1%; Applied: 22069; Backlog: 100/100; Time: 56s(total), 55s(copy); streamer: binlog.000077:700759475; State: throttled, lag=0.850975s; ETA: 7m18s
  87. Copy: 1108000/9937427 11.1%; Applied: 22675; Backlog: 100/100; Time: 57s(total), 56s(copy); streamer: binlog.000077:704265702; State: throttled, lag=0.550813s; ETA: 7m26s
  88. Copy: 1108000/9937427 11.1%; Applied: 22776; Backlog: 100/100; Time: 58s(total), 57s(copy); streamer: binlog.000077:704265702; State: throttled, lag=0.550857s; ETA: 7m34s
  89. Copy: 1108000/9937427 11.1%; Applied: 23988; Backlog: 100/100; Time: 59s(total), 58s(copy); streamer: binlog.000077:705016959; State: migrating; ETA: 7m42s
  90. Copy: 1120000/9937427 11.3%; Applied: 25401; Backlog: 4/100; Time: 1m0s(total), 59s(copy); streamer: binlog.000077:707938754; State: migrating; ETA: 7m44s
  91. Copy: 1292000/9937427 13.0%; Applied: 26671; Backlog: 6/100; Time: 1m5s(total), 1m4s(copy); streamer: binlog.000077:739817084; State: migrating; ETA: 7m8s
  92. Copy: 1334000/9937427 13.4%; Applied: 27013; Backlog: 100/100; Time: 1m10s(total), 1m9s(copy); streamer: binlog.000077:748621439; State: throttled, lag=1.450775s; ETA: 7m25s
  93. Copy: 1334000/9937427 13.4%; Applied: 27013; Backlog: 100/100; Time: 1m15s(total), 1m14s(copy); streamer: binlog.000077:748621439; State: throttled, lag=1.051050s; ETA: 7m57s
  94. Copy: 1364000/9937427 13.7%; Applied: 33516; Backlog: 7/100; Time: 1m20s(total), 1m19s(copy); streamer: binlog.000077:759019677; State: migrating; ETA: 8m16s
  95. Copy: 1518000/9937427 15.3%; Applied: 34704; Backlog: 94/100; Time: 1m25s(total), 1m24s(copy); streamer: binlog.000077:790510002; State: throttled, lag=0.550851s; ETA: 7m45s
  96. Copy: 1626000/9937427 16.4%; Applied: 37577; Backlog: 0/100; Time: 1m30s(total), 1m29s(copy); streamer: binlog.000077:812108093; State: migrating; ETA: 7m34s
  97. Copy: 1642000/9937427 16.5%; Applied: 38073; Backlog: 100/100; Time: 1m35s(total), 1m34s(copy); streamer: binlog.000077:817926769; State: migrating; ETA: 7m54s
  98. Copy: 1760000/9937427 17.7%; Applied: 41646; Backlog: 100/100; Time: 1m40s(total), 1m39s(copy); streamer: binlog.000077:842404911; State: throttled, lag=0.550923s; ETA: 7m40s
  99. Copy: 1928000/9937427 19.4%; Applied: 43235; Backlog: 0/100; Time: 1m45s(total), 1m44s(copy); streamer: binlog.000077:874048248; State: migrating; ETA: 7m12s
  100. Copy: 1962000/9937427 19.7%; Applied: 43808; Backlog: 100/100; Time: 1m50s(total), 1m49s(copy); streamer: binlog.000077:883760933; State: throttled, lag=1.450816s; ETA: 7m23s
  101. Copy: 1962000/9937427 19.7%; Applied: 43808; Backlog: 100/100; Time: 1m55s(total), 1m54s(copy); streamer: binlog.000077:883760933; State: throttled, lag=1.451084s; ETA: 7m43s
  102. Copy: 1962000/9937427 19.7%; Applied: 49161; Backlog: 100/100; Time: 2m0s(total), 1m59s(copy); streamer: binlog.000077:886868395; State: migrating; ETA: 8m3s
  103. Copy: 2104000/9937427 21.2%; Applied: 51893; Backlog: 3/100; Time: 2m5s(total), 2m4s(copy); streamer: binlog.000077:916663740; State: migrating; ETA: 7m41s
  104. Copy: 2196000/9937427 22.1%; Applied: 52813; Backlog: 100/100; Time: 2m10s(total), 2m9s(copy); streamer: binlog.000077:933179022; State: throttled, lag=1.251087s; ETA: 7m34s
  105. Copy: 2196000/9937427 22.1%; Applied: 52813; Backlog: 100/100; Time: 2m15s(total), 2m14s(copy); streamer: binlog.000077:933179022; State: throttled, lag=2.850931s; ETA: 7m52s
  106. Copy: 2196000/9937427 22.1%; Applied: 52813; Backlog: 100/100; Time: 2m20s(total), 2m19s(copy); streamer: binlog.000077:933179022; State: throttled, lag=0.750825s; ETA: 8m10s
  107. Copy: 2196000/9937427 22.1%; Applied: 60287; Backlog: 100/100; Time: 2m25s(total), 2m24s(copy); streamer: binlog.000077:939926412; State: migrating; ETA: 8m27s
  108. Copy: 2306000/9937427 23.2%; Applied: 62843; Backlog: 100/100; Time: 2m30s(total), 2m29s(copy); streamer: binlog.000077:961581367; State: throttled, lag=0.750870s; ETA: 8m13s
  109. Copy: 2342000/9937427 23.6%; Applied: 66731; Backlog: 7/100; Time: 2m35s(total), 2m34s(copy); streamer: binlog.000077:971479986; State: migrating; ETA: 8m19s
  110. Copy: 2471999/9937427 24.9%; Applied: 68103; Backlog: 71/100; Time: 2m40s(total), 2m39s(copy); streamer: binlog.000077:996411875; State: throttled, lag=0.750869s; ETA: 8m0s
  111. Copy: 2603997/9937427 26.2%; Applied: 69376; Backlog: 100/100; Time: 2m45s(total), 2m44s(copy); streamer: binlog.000077:1024936289; State: throttled, lag=0.551026s; ETA: 7m41s
  112. Copy: 2655997/9937427 26.7%; Applied: 71477; Backlog: 100/100; Time: 2m50s(total), 2m49s(copy); streamer: binlog.000077:1035609044; State: throttled, lag=0.550883s; ETA: 7m43s
  113. Copy: 2703997/9937427 27.2%; Applied: 75491; Backlog: 55/100; Time: 2m55s(total), 2m54s(copy); streamer: binlog.000077:1048801925; State: migrating; ETA: 7m45s
  114. Copy: 2861988/9937427 28.8%; Applied: 76810; Backlog: 0/100; Time: 3m0s(total), 2m59s(copy); streamer: binlog.000078:3170808; State: migrating; ETA: 7m22s
  115. Copy: 3393872/9937427 34.2%; Applied: 88101; Backlog: 100/100; Time: 3m30s(total), 3m29s(copy); streamer: binlog.000078:116985065; State: throttled, lag=0.650853s; ETA: 6m42s
  116. Copy: 3965362/9937427 39.9%; Applied: 102526; Backlog: 1/100; Time: 4m0s(total), 3m59s(copy); streamer: binlog.000078:237794723; State: migrating; ETA: 5m59s
  117. Copy: 4478277/9937427 45.1%; Applied: 114019; Backlog: 100/100; Time: 4m30s(total), 4m29s(copy); streamer: binlog.000078:343443516; State: throttled, lag=0.750912s; ETA: 5m27s
  118. Copy: 4960793/9937427 49.9%; Applied: 128190; Backlog: 0/100; Time: 5m0s(total), 4m59s(copy); streamer: binlog.000078:448236869; State: migrating; ETA: 4m59s
  119. [MySQL] 2017/01/05 15:12:39 statement.go:27: Invalid Connection
  120. Copy: 5517159/9937427 55.5%; Applied: 140965; Backlog: 47/100; Time: 5m30s(total), 5m29s(copy); streamer: binlog.000078:566921598; State: throttled, lag=0.550872s; ETA: 4m23s
  121. Copy: 6015780/9937427 60.5%; Applied: 153565; Backlog: 0/100; Time: 6m0s(total), 5m59s(copy); streamer: binlog.000078:675841183; State: migrating; ETA: 3m54s
  122. Copy: 6373208/9937427 64.1%; Applied: 166655; Backlog: 5/100; Time: 6m30s(total), 6m29s(copy); streamer: binlog.000078:758920800; State: migrating; ETA: 3m37s
  123. Copy: 6994776/9937427 70.4%; Applied: 178995; Backlog: 100/100; Time: 7m0s(total), 6m59s(copy); streamer: binlog.000078:890283034; State: throttled, lag=0.550805s; ETA: 2m56s
  124. Copy: 7132743/9937427 71.8%; Applied: 180519; Backlog: 20/100; Time: 7m5s(total), 7m4s(copy); streamer: binlog.000078:915760514; State: throttled, lag=0.550907s; ETA: 2m46s
  125. Copy: 7172733/9937427 72.2%; Applied: 181803; Backlog: 100/100; Time: 7m10s(total), 7m9s(copy); streamer: binlog.000078:927079006; State: throttled, lag=1.150887s; ETA: 2m45s
  126. Copy: 7172733/9937427 72.2%; Applied: 182611; Backlog: 100/100; Time: 7m15s(total), 7m14s(copy); streamer: binlog.000078:929592532; State: migrating; ETA: 2m47s
  127. Copy: 7260721/9937427 73.1%; Applied: 186950; Backlog: 100/100; Time: 7m20s(total), 7m19s(copy); streamer: binlog.000078:949905393; State: throttled, lag=0.550852s; ETA: 2m41s
  128. Copy: 7350708/9937427 74.0%; Applied: 188211; Backlog: 100/100; Time: 7m25s(total), 7m24s(copy); streamer: binlog.000078:968584414; State: throttled, lag=0.550890s; ETA: 2m36s
  129. Copy: 7436704/9937427 74.8%; Applied: 191022; Backlog: 4/100; Time: 7m30s(total), 7m29s(copy); streamer: binlog.000078:987816606; State: migrating; ETA: 2m30s
  130. Copy: 7442703/9937427 74.9%; Applied: 191128; Backlog: 100/100; Time: 7m35s(total), 7m34s(copy); streamer: binlog.000078:988784677; State: throttled, lag=0.850924s; ETA: 2m32s
  131. Copy: 7490696/9937427 75.4%; Applied: 195383; Backlog: 0/100; Time: 7m40s(total), 7m39s(copy); streamer: binlog.000078:1002558140; State: migrating; ETA: 2m29s
  132. Copy: 7616692/9937427 76.6%; Applied: 196742; Backlog: 13/100; Time: 7m45s(total), 7m44s(copy); streamer: binlog.000078:1027529967; State: migrating; ETA: 2m21s
  133. Copy: 7674690/9937427 77.2%; Applied: 197055; Backlog: 100/100; Time: 7m50s(total), 7m49s(copy); streamer: binlog.000078:1039534055; State: throttled, lag=1.050860s; ETA: 2m18s
  134. Copy: 7674690/9937427 77.2%; Applied: 197863; Backlog: 100/100; Time: 7m55s(total), 7m54s(copy); streamer: binlog.000078:1041608291; State: migrating; ETA: 2m19s
  135. Copy: 7746690/9937427 78.0%; Applied: 203055; Backlog: 0/100; Time: 8m0s(total), 7m59s(copy); streamer: binlog.000078:1059159406; State: migrating; ETA: 2m15s
  136. Copy: 7862685/9937427 79.1%; Applied: 204437; Backlog: 5/100; Time: 8m5s(total), 8m4s(copy); streamer: binlog.000079:10079600; State: migrating; ETA: 2m7s
  137. Copy: 7930685/9937427 79.8%; Applied: 205984; Backlog: 100/100; Time: 8m10s(total), 8m9s(copy); streamer: binlog.000079:23958198; State: throttled, lag=0.550997s; ETA: 2m3s
  138. Copy: 7930685/9937427 79.8%; Applied: 205984; Backlog: 100/100; Time: 8m15s(total), 8m14s(copy); streamer: binlog.000079:23958198; State: throttled, lag=1.650802s; ETA: 2m5s
  139. Copy: 7930685/9937427 79.8%; Applied: 210327; Backlog: 100/100; Time: 8m20s(total), 8m19s(copy); streamer: binlog.000079:27707764; State: migrating; ETA: 2m6s
  140. Copy: 8080684/9937427 81.3%; Applied: 212727; Backlog: 100/100; Time: 8m25s(total), 8m24s(copy); streamer: binlog.000079:58407549; State: throttled, lag=0.650866s; ETA: 1m55s
  141. Copy: 8120684/9937427 81.7%; Applied: 215942; Backlog: 13/100; Time: 8m30s(total), 8m29s(copy); streamer: binlog.000079:69914157; State: migrating; ETA: 1m53s
  142. Copy: 8198684/9937427 82.5%; Applied: 218459; Backlog: 77/100; Time: 8m35s(total), 8m34s(copy); streamer: binlog.000079:87556539; State: throttled, lag=0.550900s; ETA: 1m49s
  143. Copy: 8332684/9937427 83.9%; Applied: 219914; Backlog: 15/100; Time: 8m40s(total), 8m39s(copy); streamer: binlog.000079:112593601; State: migrating; ETA: 1m39s
  144. Copy: 8488684/9937427 85.4%; Applied: 221221; Backlog: 0/100; Time: 8m45s(total), 8m44s(copy); streamer: binlog.000079:143722392; State: migrating; ETA: 1m29s
  145. Copy: 8490684/9937427 85.4%; Applied: 223241; Backlog: 100/100; Time: 8m50s(total), 8m49s(copy); streamer: binlog.000079:149674240; State: migrating; ETA: 1m30s
  146. Copy: 8540684/9937427 85.9%; Applied: 226985; Backlog: 100/100; Time: 8m55s(total), 8m54s(copy); streamer: binlog.000079:163365718; State: migrating; ETA: 1m27s
  147. Copy: 8676684/9937427 87.3%; Applied: 228747; Backlog: 0/100; Time: 9m0s(total), 8m59s(copy); streamer: binlog.000079:191299262; State: migrating; ETA: 1m18s
  148. Copy: 8834684/9937427 88.9%; Applied: 229994; Backlog: 0/100; Time: 9m5s(total), 9m4s(copy); streamer: binlog.000079:221986626; State: migrating; ETA: 1m7s
  149. Copy: 8904684/9937427 89.6%; Applied: 232368; Backlog: 100/100; Time: 9m10s(total), 9m9s(copy); streamer: binlog.000079:239471058; State: migrating; ETA: 1m3s
  150. Copy: 8970684/9937427 90.3%; Applied: 234227; Backlog: 0/100; Time: 9m13s(total), 9m12s(copy); streamer: binlog.000079:251918475; State: migrating; ETA: 59s
  151. Copy: 8980684/9937427 90.4%; Applied: 234377; Backlog: 100/100; Time: 9m14s(total), 9m13s(copy); streamer: binlog.000079:254145886; State: throttled, lag=0.751182s; ETA: 58s
  152. Copy: 8980684/9937427 90.4%; Applied: 234377; Backlog: 100/100; Time: 9m15s(total), 9m14s(copy); streamer: binlog.000079:254145886; State: throttled, lag=0.750846s; ETA: 59s
  153. Copy: 8980684/9937427 90.4%; Applied: 234377; Backlog: 100/100; Time: 9m16s(total), 9m15s(copy); streamer: binlog.000079:254145886; State: throttled, lag=1.150987s; ETA: 59s
  154. Copy: 8980684/9937427 90.4%; Applied: 234377; Backlog: 100/100; Time: 9m17s(total), 9m16s(copy); streamer: binlog.000079:254145886; State: throttled, lag=0.950825s; ETA: 59s
  155. Copy: 8980684/9937427 90.4%; Applied: 234377; Backlog: 100/100; Time: 9m18s(total), 9m17s(copy); streamer: binlog.000079:254145886; State: throttled, lag=0.950816s; ETA: 59s
  156. Copy: 8980684/9937427 90.4%; Applied: 234377; Backlog: 100/100; Time: 9m19s(total), 9m18s(copy); streamer: binlog.000079:254145886; State: migrating; ETA: 59s
  157. Copy: 8980684/9937427 90.4%; Applied: 235791; Backlog: 100/100; Time: 9m20s(total), 9m19s(copy); streamer: binlog.000079:256993029; State: migrating; ETA: 59s
  158. Copy: 8988684/9937427 90.5%; Applied: 237153; Backlog: 0/100; Time: 9m21s(total), 9m20s(copy); streamer: binlog.000079:259715630; State: migrating; ETA: 59s
  159. Copy: 9026684/9937427 90.8%; Applied: 237378; Backlog: 4/100; Time: 9m22s(total), 9m21s(copy); streamer: binlog.000079:266715602; State: migrating; ETA: 56s
  160. Copy: 9066684/9937427 91.2%; Applied: 237623; Backlog: 1/100; Time: 9m23s(total), 9m22s(copy); streamer: binlog.000079:273544658; State: migrating; ETA: 53s
  161. Copy: 9102684/9937427 91.6%; Applied: 237847; Backlog: 0/100; Time: 9m24s(total), 9m23s(copy); streamer: binlog.000079:280747590; State: migrating; ETA: 51s
  162. Copy: 9142684/9937427 92.0%; Applied: 238071; Backlog: 2/100; Time: 9m25s(total), 9m24s(copy); streamer: binlog.000079:287550548; State: migrating; ETA: 49s
  163. Copy: 9142684/9937427 92.0%; Applied: 238477; Backlog: 5/100; Time: 9m26s(total), 9m25s(copy); streamer: binlog.000079:291353949; State: migrating; ETA: 49s
  164. Copy: 9158684/9937427 92.2%; Applied: 239126; Backlog: 0/100; Time: 9m27s(total), 9m26s(copy); streamer: binlog.000079:292793599; State: migrating; ETA: 48s
  165. Copy: 9166684/9937427 92.2%; Applied: 239321; Backlog: 100/100; Time: 9m28s(total), 9m27s(copy); streamer: binlog.000079:295761149; State: throttled, lag=0.550885s; ETA: 47s
  166. Copy: 9166684/9937427 92.2%; Applied: 240432; Backlog: 31/100; Time: 9m29s(total), 9m28s(copy); streamer: binlog.000079:297885559; State: migrating; ETA: 47s
  167. Copy: 9182684/9937427 92.4%; Applied: 241149; Backlog: 24/100; Time: 9m30s(total), 9m29s(copy); streamer: binlog.000079:300591363; State: migrating; ETA: 46s
  168. Copy: 9208684/9937427 92.7%; Applied: 241720; Backlog: 13/100; Time: 9m31s(total), 9m30s(copy); streamer: binlog.000079:305749063; State: migrating; ETA: 45s
  169. Copy: 9218684/9937427 92.8%; Applied: 242266; Backlog: 13/100; Time: 9m32s(total), 9m31s(copy); streamer: binlog.000079:309780233; State: migrating; ETA: 44s
  170. Copy: 9234684/9937427 92.9%; Applied: 242954; Backlog: 14/100; Time: 9m33s(total), 9m32s(copy); streamer: binlog.000079:311581648; State: migrating; ETA: 43s
  171. Copy: 9238684/9937427 93.0%; Applied: 243005; Backlog: 100/100; Time: 9m34s(total), 9m33s(copy); streamer: binlog.000079:312852745; State: throttled, lag=0.750860s; ETA: 43s
  172. Copy: 9238684/9937427 93.0%; Applied: 243712; Backlog: 100/100; Time: 9m35s(total), 9m34s(copy); streamer: binlog.000079:314932416; State: migrating; ETA: 43s
  173. Copy: 9286684/9937427 93.5%; Applied: 243946; Backlog: 0/100; Time: 9m36s(total), 9m35s(copy); streamer: binlog.000079:324245469; State: migrating; ETA: 40s
  174. Copy: 9340684/9937427 94.0%; Applied: 243946; Backlog: 0/100; Time: 9m37s(total), 9m36s(copy); streamer: binlog.000079:334335152; State: migrating; ETA: 36s
  175. Copy: 9396684/9937427 94.6%; Applied: 243950; Backlog: 0/100; Time: 9m38s(total), 9m37s(copy); streamer: binlog.000079:344794904; State: migrating; ETA: 33s
  176. Copy: 9454684/9937427 95.1%; Applied: 243950; Backlog: 0/100; Time: 9m39s(total), 9m38s(copy); streamer: binlog.000079:356845846; State: migrating; ETA: 29s
  177. Copy: 9514684/9937427 95.7%; Applied: 243950; Backlog: 0/100; Time: 9m40s(total), 9m39s(copy); streamer: binlog.000079:368487148; State: migrating; ETA: 25s
  178. Copy: 9576684/9937427 96.4%; Applied: 243950; Backlog: 0/100; Time: 9m41s(total), 9m40s(copy); streamer: binlog.000079:380128450; State: migrating; ETA: 21s
  179. Copy: 9636684/9937427 97.0%; Applied: 243950; Backlog: 0/100; Time: 9m42s(total), 9m41s(copy); streamer: binlog.000079:391769748; State: migrating; ETA: 18s
  180. Copy: 9694684/9937427 97.6%; Applied: 243950; Backlog: 0/100; Time: 9m43s(total), 9m42s(copy); streamer: binlog.000079:403411048; State: migrating; ETA: 14s
  181. Copy: 9752684/9937427 98.1%; Applied: 243950; Backlog: 0/100; Time: 9m44s(total), 9m43s(copy); streamer: binlog.000079:411948372; State: migrating; ETA: 11s
  182. Copy: 9812684/9937427 98.7%; Applied: 243950; Backlog: 0/100; Time: 9m45s(total), 9m44s(copy); streamer: binlog.000079:424365484; State: migrating; ETA: 7s
  183. Copy: 9850684/9937427 99.1%; Applied: 244233; Backlog: 12/100; Time: 9m46s(total), 9m45s(copy); streamer: binlog.000079:433109674; State: migrating; ETA: 5s
  184. Copy: 9870684/9937427 99.3%; Applied: 244515; Backlog: 100/100; Time: 9m47s(total), 9m46s(copy); streamer: binlog.000079:435767143; State: throttled, lag=0.751152s; ETA: 3s
  185. Copy: 9870684/9937427 99.3%; Applied: 244515; Backlog: 100/100; Time: 9m48s(total), 9m47s(copy); streamer: binlog.000079:435767143; State: throttled, lag=1.050814s; ETA: 3s
  186. Copy: 9870684/9937427 99.3%; Applied: 244515; Backlog: 100/100; Time: 9m49s(total), 9m48s(copy); streamer: binlog.000079:435767143; State: throttled, lag=1.050911s; ETA: 3s
  187. Copy: 9870684/9937427 99.3%; Applied: 244515; Backlog: 100/100; Time: 9m50s(total), 9m49s(copy); streamer: binlog.000079:435767143; State: throttled, lag=1.250969s; ETA: 3s
  188. Copy: 9870684/9937427 99.3%; Applied: 244515; Backlog: 100/100; Time: 9m51s(total), 9m50s(copy); streamer: binlog.000079:435767143; State: throttled, lag=1.450853s; ETA: 3s
  189. Copy: 9870684/9937427 99.3%; Applied: 244515; Backlog: 100/100; Time: 9m52s(total), 9m51s(copy); streamer: binlog.000079:435767143; State: throttled, lag=1.550861s; ETA: 3s
  190. Copy: 9870684/9937427 99.3%; Applied: 244515; Backlog: 100/100; Time: 9m53s(total), 9m52s(copy); streamer: binlog.000079:435767143; State: throttled, lag=1.450835s; ETA: 4s
  191. Copy: 9870684/9937427 99.3%; Applied: 244515; Backlog: 100/100; Time: 9m54s(total), 9m53s(copy); streamer: binlog.000079:435767143; State: throttled, lag=1.350836s; ETA: 4s
  192. Copy: 9870684/9937427 99.3%; Applied: 244515; Backlog: 100/100; Time: 9m55s(total), 9m54s(copy); streamer: binlog.000079:435767143; State: throttled, lag=1.150916s; ETA: 4s
  193. Copy: 9870684/9937427 99.3%; Applied: 244515; Backlog: 100/100; Time: 9m56s(total), 9m55s(copy); streamer: binlog.000079:435767143; State: throttled, lag=0.550842s; ETA: 4s
  194. Copy: 9870684/9937427 99.3%; Applied: 245525; Backlog: 100/100; Time: 9m57s(total), 9m56s(copy); streamer: binlog.000079:439169335; State: migrating; ETA: 4s
  195. Copy: 9870684/9937427 99.3%; Applied: 247242; Backlog: 100/100; Time: 9m58s(total), 9m57s(copy); streamer: binlog.000079:440133821; State: migrating; ETA: 4s
  196. Copy: 9870684/9937427 99.3%; Applied: 248858; Backlog: 100/100; Time: 9m59s(total), 9m58s(copy); streamer: binlog.000079:441041018; State: migrating; ETA: 4s
  197. # Migrating `sbtest1`.`sbtest1`; Ghost table is `sbtest1`.`_sbtest1_gho`
  198. # Migrating ip-172-30-4-4:3306; inspecting ip-172-30-4-235:3306; executing on ip-172-30-4-235
  199. # Migration started at Thu Jan 05 15:07:35 +0000 2017
  200. # chunk-size: 2000; max-lag-millis: 500ms; max-load: Threads_connected=30; critical-load: ; nice-ratio: 0.000000
  201. # throttle-additional-flag-file: /tmp/gh-ost.throttle
  202. # Serving on unix socket: /tmp/gh-ost.sbtest1.sbtest1.sock
  203. Copy: 9870684/9937427 99.3%; Applied: 250474; Backlog: 100/100; Time: 10m0s(total), 9m59s(copy); streamer: binlog.000079:443108243; State: migrating; ETA: 4s
  204. Copy: 9888684/9937427 99.5%; Applied: 251448; Backlog: 0/100; Time: 10m1s(total), 10m0s(copy); streamer: binlog.000079:447818328; State: migrating; ETA: 2s
  205. Copy: 9920684/9937427 99.8%; Applied: 251889; Backlog: 9/100; Time: 10m2s(total), 10m1s(copy); streamer: binlog.000079:454028333; State: migrating; ETA: 1s
  206. Copy: 9970680/9970680 100.0%; Applied: 253661; Backlog: 0/100; Time: 10m4s(total), 10m3s(copy); streamer: binlog.000079:465411317; State: migrating; ETA: due
  207. Copy: 9970680/9970680 100.0%; Applied: 253661; Backlog: 0/100; Time: 10m5s(total), 10m3s(copy); streamer: binlog.000079:465411317; State: migrating; ETA: due
  208. # Migrating `sbtest1`.`sbtest1`; Ghost table is `sbtest1`.`_sbtest1_gho`
  209. # Migrating ip-172-30-4-4:3306; inspecting ip-172-30-4-235:3306; executing on ip-172-30-4-235
  210. # Migration started at Thu Jan 05 15:07:35 +0000 2017
  211. # chunk-size: 2000; max-lag-millis: 500ms; max-load: Threads_connected=30; critical-load: ; nice-ratio: 0.000000
  212. # throttle-additional-flag-file: /tmp/gh-ost.throttle
  213. # Serving on unix socket: /tmp/gh-ost.sbtest1.sbtest1.sock
  214. Copy: 9970680/9970680 100.0%; Applied: 253793; Backlog: 0/100; Time: 10m6s(total), 10m3s(copy); streamer: binlog.000079:466745256; State: migrating; ETA: due
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!