Last active
June 28, 2017 16:24
-
-
Save yashk/3db9126f8af9db05182ed8a546630060 to your computer and use it in GitHub Desktop.
ghost_logs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
2017-06-28 13:04:15 INFO starting gh-ost 1.0.36 | |
2017-06-28 13:04:15 INFO Migrating `ghost`.`ghost_test` | |
2017-06-28 13:04:15 INFO connection validated on localhost:3306 | |
2017-06-28 13:04:15 INFO User has ALL privileges | |
2017-06-28 13:04:15 INFO binary logs validated on localhost:3306 | |
2017-06-28 13:04:15 INFO Restarting replication on localhost:3306 to make sure binlog settings apply to replication thread | |
2017-06-28 13:04:15 DEBUG Replication restarted | |
2017-06-28 13:04:15 INFO Inspector initiated on prod-db-us-58.mashery.com:3306, version 5.5.40-log | |
2017-06-28 13:04:15 INFO Table found. Engine=InnoDB | |
2017-06-28 13:04:15 DEBUG Estimated number of rows via STATUS: 171229248 | |
2017-06-28 13:04:22 DEBUG Validated no foreign keys exist on table | |
2017-06-28 13:04:22 DEBUG Validated no triggers exist on table | |
2017-06-28 13:04:22 INFO Estimated number of rows via EXPLAIN: 171229248 | |
2017-06-28 13:04:22 DEBUG Potential unique keys in ghost_test: [PRIMARY (auto_increment): [id]; has nullable: false varchar_5__varchar_7: [varchar_5 varchar_7]; has nullable: false] | |
2017-06-28 13:04:22 INFO Recursively searching for replication master | |
2017-06-28 13:04:22 DEBUG Looking for master on localhost:3306 | |
2017-06-28 13:04:22 DEBUG Master of localhost:3306 is prod-db-us-56.compute-1.amazonaws.com:3306 | |
2017-06-28 13:04:22 DEBUG Looking for master on prod-db-us-56.compute-1.amazonaws.com:3306 | |
2017-06-28 13:04:22 INFO Master found to be prod-db-us-56.compute-1.amazonaws.com:3306 | |
2017-06-28 13:04:22 INFO log_slave_updates validated on localhost:3306 | |
2017-06-28 13:04:22 INFO connection validated on localhost:3306 | |
2017-06-28 13:04:22 DEBUG Streamer binlog coordinates: mysql-bin.009103:107 | |
2017/06/28 13:04:22 binlogsyncer.go:75: [0;37m[info] create BinlogSyncer with config &{99999 mysql localhost 3306 ghost xxxxxxx false false <nil>}[0m | |
2017-06-28 13:04:22 INFO Connecting binlog streamer at mysql-bin.009103:107 | |
2017/06/28 13:04:22 binlogsyncer.go:241: [0;37m[info] begin to sync binlog from position (mysql-bin.009103, 107)[0m | |
2017/06/28 13:04:22 binlogsyncer.go:134: [0;37m[info] register slave for master server localhost:3306[0m | |
2017-06-28 13:04:22 DEBUG Beginning streaming | |
2017/06/28 13:04:22 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009103, 107)[0m | |
2017-06-28 13:04:22 INFO rotate to next log name: mysql-bin.009103 | |
2017-06-28 13:04:22 INFO connection validated on prod-db-us-56.compute-1.amazonaws.com:3306 | |
2017-06-28 13:04:22 INFO connection validated on prod-db-us-56.compute-1.amazonaws.com:3306 | |
2017-06-28 13:04:22 INFO will use time_zone='SYSTEM' on applier | |
2017-06-28 13:04:22 INFO Examining table structure on applier | |
2017-06-28 13:04:22 INFO Applier initiated on prod-db-us-56.mashery.com:3306, version 5.5.40-log | |
2017-06-28 13:04:22 INFO Droppping table `ghost`.`_ghost_test_gho` | |
2017-06-28 13:04:22 INFO Table dropped | |
2017-06-28 13:04:22 INFO Droppping table `ghost`.`_ghost_test_del` | |
2017-06-28 13:04:22 INFO Table dropped | |
2017-06-28 13:04:22 INFO Droppping table `ghost`.`_ghost_test_ghc` | |
2017-06-28 13:04:22 INFO Table dropped | |
2017-06-28 13:04:22 INFO Creating changelog table `ghost`.`_ghost_test_ghc` | |
2017-06-28 13:04:22 INFO Changelog table created | |
2017-06-28 13:04:22 INFO Creating ghost table `ghost`.`_ghost_test_gho` | |
2017-06-28 13:04:22 INFO Ghost table created | |
2017-06-28 13:04:22 INFO Altering ghost table `ghost`.`_ghost_test_gho` | |
2017-06-28 13:04:22 DEBUG ALTER statement: alter /* gh-ost */ table `ghost`.`_ghost_test_gho` MODIFY COLUMN id BIGINT,MODIFY varchar_16 VARCHAR(1024) | |
2017-06-28 13:04:22 INFO Ghost table altered | |
2017-06-28 13:04:22 INFO Waiting for ghost table to be migrated. Current lag is 0s | |
2017-06-28 13:04:22 INFO Intercepted changelog state GhostTableMigrated | |
2017-06-28 13:04:22 INFO Handled changelog state GhostTableMigrated | |
2017-06-28 13:04:22 DEBUG ghost table migrated | |
2017-06-28 13:04:22 DEBUG Potential unique keys in _ghost_test_gho: [PRIMARY: [id]; has nullable: false varchar_5__varchar_7: [varchar_5 varchar_7]; has nullable: false] | |
2017-06-28 13:04:22 INFO Chosen shared unique key is PRIMARY | |
2017-06-28 13:04:22 INFO Shared columns are id,datetime_2,datetime_3,int_4,varchar_5,varchar_6,varchar_7,tinyint_8,varchar_9,varchar_10,datetime_11,varchar_12,tinyint_13,varchar_14,datetime_15,varchar_16 | |
2017-06-28 13:04:22 INFO Listening on unix socket file: /tmp/gh-ost.ghost.ghost_test.sock | |
2017-06-28 13:04:22 DEBUG Reading migration range according to key: PRIMARY | |
2017-06-28 13:04:22 INFO Migration min values: [1] | |
2017-06-28 13:04:22 DEBUG Reading migration range according to key: PRIMARY | |
2017-06-28 13:04:22 INFO Migration max values: [171229177] | |
2017-06-28 13:04:22 INFO Waiting for first throttle metrics to be collected | |
2017-06-28 13:04:22 INFO First throttle metrics collected | |
2017-06-28 13:04:22 DEBUG Operating until row copy is complete | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.000000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
2017-06-28 13:04:22 DEBUG Getting nothing in the write queue. Sleeping... | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 0/171229248 0.0%; Applied: 0; Backlog: 0/100; Time: 7s(total), 0s(copy); streamer: mysql-bin.009103:2600; State: migrating; ETA: N/A | |
Copy: 0/171229248 0.0%; Applied: 0; Backlog: 0/100; Time: 8s(total), 1s(copy); streamer: mysql-bin.009103:5984; State: migrating; ETA: N/A | |
Copy: 20000/171229248 0.0%; Applied: 0; Backlog: 0/100; Time: 9s(total), 2s(copy); streamer: mysql-bin.009103:2145817; State: migrating; ETA: N/A | |
Copy: 47000/171229248 0.0%; Applied: 0; Backlog: 0/100; Time: 10s(total), 3s(copy); streamer: mysql-bin.009103:6566380; State: migrating; ETA: N/A | |
Copy: 71000/171229248 0.0%; Applied: 0; Backlog: 0/100; Time: 11s(total), 4s(copy); streamer: mysql-bin.009103:9846283; State: migrating; ETA: N/A | |
Copy: 97000/171229248 0.1%; Applied: 0; Backlog: 0/100; Time: 12s(total), 5s(copy); streamer: mysql-bin.009103:13696367; State: migrating; ETA: N/A | |
Copy: 122000/171229248 0.1%; Applied: 0; Backlog: 0/100; Time: 13s(total), 6s(copy); streamer: mysql-bin.009103:16881761; State: migrating; ETA: N/A | |
Copy: 147000/171229248 0.1%; Applied: 0; Backlog: 0/100; Time: 14s(total), 7s(copy); streamer: mysql-bin.009103:20513637; State: migrating; ETA: N/A | |
Copy: 173000/171229248 0.1%; Applied: 0; Backlog: 0/100; Time: 15s(total), 8s(copy); streamer: mysql-bin.009103:24534266; State: migrating; ETA: N/A | |
Copy: 198000/171229248 0.1%; Applied: 0; Backlog: 0/100; Time: 16s(total), 9s(copy); streamer: mysql-bin.009103:27671702; State: migrating; ETA: N/A | |
Copy: 220000/171229248 0.1%; Applied: 0; Backlog: 0/100; Time: 17s(total), 10s(copy); streamer: mysql-bin.009103:31094379; State: migrating; ETA: N/A | |
Copy: 232000/171229248 0.1%; Applied: 0; Backlog: 0/100; Time: 18s(total), 11s(copy); streamer: mysql-bin.009103:32664644; State: migrating; ETA: N/A | |
Copy: 243000/171229248 0.1%; Applied: 0; Backlog: 0/100; Time: 19s(total), 12s(copy); streamer: mysql-bin.009103:33521656; State: throttled, lag=0.515688s; ETA: N/A | |
Copy: 244000/171229248 0.1%; Applied: 0; Backlog: 0/100; Time: 20s(total), 13s(copy); streamer: mysql-bin.009103:34671751; State: migrating; ETA: N/A | |
Copy: 262000/171229248 0.2%; Applied: 0; Backlog: 0/100; Time: 21s(total), 14s(copy); streamer: mysql-bin.009103:35670331; State: throttled, lag=0.715670s; ETA: N/A | |
Copy: 262000/171229248 0.2%; Applied: 0; Backlog: 0/100; Time: 22s(total), 15s(copy); streamer: mysql-bin.009103:36953763; State: throttled, lag=1.215812s; ETA: N/A | |
Copy: 268000/171229248 0.2%; Applied: 0; Backlog: 0/100; Time: 23s(total), 16s(copy); streamer: mysql-bin.009103:38253829; State: migrating; ETA: N/A | |
Copy: 293000/171229248 0.2%; Applied: 0; Backlog: 0/100; Time: 24s(total), 17s(copy); streamer: mysql-bin.009103:41248495; State: migrating; ETA: N/A | |
Copy: 318000/171229248 0.2%; Applied: 0; Backlog: 0/100; Time: 25s(total), 18s(copy); streamer: mysql-bin.009103:44813641; State: migrating; ETA: N/A | |
Copy: 343000/171229248 0.2%; Applied: 0; Backlog: 0/100; Time: 26s(total), 19s(copy); streamer: mysql-bin.009103:48536652; State: migrating; ETA: N/A | |
Copy: 368000/171229248 0.2%; Applied: 0; Backlog: 0/100; Time: 27s(total), 20s(copy); streamer: mysql-bin.009103:52086704; State: migrating; ETA: N/A | |
Copy: 392000/171229248 0.2%; Applied: 0; Backlog: 0/100; Time: 28s(total), 21s(copy); streamer: mysql-bin.009103:55648674; State: migrating; ETA: N/A | |
Copy: 416000/171229248 0.2%; Applied: 0; Backlog: 0/100; Time: 29s(total), 22s(copy); streamer: mysql-bin.009103:58789283; State: migrating; ETA: N/A | |
Copy: 436000/171229248 0.3%; Applied: 0; Backlog: 0/100; Time: 30s(total), 23s(copy); streamer: mysql-bin.009103:62070089; State: migrating; ETA: N/A | |
Copy: 446000/171229248 0.3%; Applied: 0; Backlog: 0/100; Time: 31s(total), 24s(copy); streamer: mysql-bin.009103:63497886; State: migrating; ETA: N/A | |
Copy: 456000/171229248 0.3%; Applied: 0; Backlog: 0/100; Time: 32s(total), 25s(copy); streamer: mysql-bin.009103:64925979; State: migrating; ETA: N/A | |
Copy: 465000/171229248 0.3%; Applied: 0; Backlog: 0/100; Time: 33s(total), 26s(copy); streamer: mysql-bin.009103:66354376; State: migrating; ETA: N/A | |
Copy: 475000/171229248 0.3%; Applied: 0; Backlog: 0/100; Time: 34s(total), 27s(copy); streamer: mysql-bin.009103:67354455; State: migrating; ETA: N/A | |
Copy: 495000/171229248 0.3%; Applied: 0; Backlog: 0/100; Time: 35s(total), 28s(copy); streamer: mysql-bin.009103:68496403; State: migrating; ETA: N/A | |
Copy: 496000/171229248 0.3%; Applied: 0; Backlog: 0/100; Time: 36s(total), 29s(copy); streamer: mysql-bin.009103:69637066; State: throttled, lag=1.115785s; ETA: N/A | |
Copy: 496000/171229248 0.3%; Applied: 0; Backlog: 0/100; Time: 37s(total), 30s(copy); streamer: mysql-bin.009103:70794858; State: throttled, lag=1.815835s; ETA: N/A | |
Copy: 513000/171229248 0.3%; Applied: 0; Backlog: 0/100; Time: 38s(total), 31s(copy); streamer: mysql-bin.009103:71510152; State: migrating; ETA: N/A | |
Copy: 516000/171229248 0.3%; Applied: 0; Backlog: 0/100; Time: 39s(total), 32s(copy); streamer: mysql-bin.009103:72650815; State: throttled, lag=1.115662s; ETA: N/A | |
Copy: 516000/171229248 0.3%; Applied: 0; Backlog: 0/100; Time: 40s(total), 33s(copy); streamer: mysql-bin.009103:73665316; State: throttled, lag=1.715833s; ETA: N/A | |
Copy: 536000/171229248 0.3%; Applied: 0; Backlog: 0/100; Time: 41s(total), 34s(copy); streamer: mysql-bin.009103:74664728; State: throttled, lag=0.515690s; ETA: N/A | |
Copy: 536000/171229248 0.3%; Applied: 0; Backlog: 0/100; Time: 42s(total), 35s(copy); streamer: mysql-bin.009103:76527997; State: throttled, lag=1.015807s; ETA: N/A | |
Copy: 555000/171229248 0.3%; Applied: 0; Backlog: 0/100; Time: 43s(total), 36s(copy); streamer: mysql-bin.009103:78810882; State: migrating; ETA: N/A | |
Copy: 579000/171229248 0.3%; Applied: 0; Backlog: 0/100; Time: 44s(total), 37s(copy); streamer: mysql-bin.009103:82233560; State: migrating; ETA: N/A | |
Copy: 595000/171229248 0.3%; Applied: 0; Backlog: 0/100; Time: 45s(total), 38s(copy); streamer: mysql-bin.009103:84944185; State: migrating; ETA: N/A | |
Copy: 605000/171229248 0.4%; Applied: 0; Backlog: 0/100; Time: 46s(total), 39s(copy); streamer: mysql-bin.009103:86372281; State: migrating; ETA: N/A | |
Copy: 614000/171229248 0.4%; Applied: 0; Backlog: 0/100; Time: 47s(total), 40s(copy); streamer: mysql-bin.009103:87657907; State: migrating; ETA: N/A | |
Copy: 623000/171229248 0.4%; Applied: 0; Backlog: 0/100; Time: 48s(total), 41s(copy); streamer: mysql-bin.009103:88943533; State: migrating; ETA: N/A | |
Copy: 630000/171229248 0.4%; Applied: 0; Backlog: 0/100; Time: 49s(total), 42s(copy); streamer: mysql-bin.009103:89944221; State: migrating; ETA: N/A | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 635000/171229248 0.4%; Applied: 0; Backlog: 0/100; Time: 50s(total), 42s(copy); streamer: mysql-bin.009103:90658464; State: migrating; ETA: N/A | |
Copy: 642000/171229248 0.4%; Applied: 0; Backlog: 0/100; Time: 50s(total), 43s(copy); streamer: mysql-bin.009103:91514874; State: migrating; ETA: N/A | |
Copy: 662000/171229248 0.4%; Applied: 0; Backlog: 0/100; Time: 51s(total), 44s(copy); streamer: mysql-bin.009103:94225201; State: migrating; ETA: N/A | |
Copy: 682000/171229248 0.4%; Applied: 0; Backlog: 0/100; Time: 52s(total), 45s(copy); streamer: mysql-bin.009103:97077996; State: migrating; ETA: N/A | |
Copy: 702000/171229248 0.4%; Applied: 0; Backlog: 0/100; Time: 53s(total), 46s(copy); streamer: mysql-bin.009103:98932297; State: migrating; ETA: N/A | |
Copy: 705000/171229248 0.4%; Applied: 0; Backlog: 0/100; Time: 54s(total), 47s(copy); streamer: mysql-bin.009103:100359188; State: throttled, lag=0.815820s; ETA: N/A | |
Copy: 716000/171229248 0.4%; Applied: 0; Backlog: 0/100; Time: 55s(total), 48s(copy); streamer: mysql-bin.009103:101225641; State: migrating; ETA: N/A | |
Copy: 721000/171229248 0.4%; Applied: 0; Backlog: 0/100; Time: 56s(total), 49s(copy); streamer: mysql-bin.009103:102509761; State: throttled, lag=0.815680s; ETA: N/A | |
Copy: 730000/171229248 0.4%; Applied: 0; Backlog: 0/100; Time: 57s(total), 50s(copy); streamer: mysql-bin.009103:103518983; State: migrating; ETA: N/A | |
Copy: 737000/171229248 0.4%; Applied: 0; Backlog: 0/100; Time: 58s(total), 51s(copy); streamer: mysql-bin.009103:104517866; State: throttled, lag=0.815863s; ETA: N/A | |
Copy: 743000/171229248 0.4%; Applied: 0; Backlog: 0/100; Time: 59s(total), 52s(copy); streamer: mysql-bin.009103:105669856; State: migrating; ETA: N/A | |
Copy: 752000/171229248 0.4%; Applied: 0; Backlog: 0/100; Time: 1m0s(total), 53s(copy); streamer: mysql-bin.009103:106668738; State: throttled, lag=0.715707s; ETA: N/A | |
Copy: 784000/171229248 0.5%; Applied: 0; Backlog: 0/100; Time: 1m5s(total), 58s(copy); streamer: mysql-bin.009103:111822446; State: migrating; ETA: N/A | |
Copy: 858000/171229248 0.5%; Applied: 0; Backlog: 0/100; Time: 1m10s(total), 1m3s(copy); streamer: mysql-bin.009103:122312697; State: migrating; ETA: N/A | |
Copy: 948000/171229248 0.6%; Applied: 0; Backlog: 0/100; Time: 1m15s(total), 1m8s(copy); streamer: mysql-bin.009103:134223928; State: throttled, lag=0.615628s; ETA: N/A | |
Copy: 977000/171229248 0.6%; Applied: 0; Backlog: 0/100; Time: 1m20s(total), 1m13s(copy); streamer: mysql-bin.009103:139377837; State: migrating; ETA: N/A | |
Copy: 1018000/171229248 0.6%; Applied: 0; Backlog: 0/100; Time: 1m25s(total), 1m18s(copy); streamer: mysql-bin.009103:144811948; State: throttled, lag=0.815838s; ETA: N/A | |
Copy: 1078000/171229248 0.6%; Applied: 0; Backlog: 0/100; Time: 1m30s(total), 1m23s(copy); streamer: mysql-bin.009103:153960055; State: migrating; ETA: N/A | |
Copy: 1132000/171229248 0.7%; Applied: 0; Backlog: 0/100; Time: 1m35s(total), 1m28s(copy); streamer: mysql-bin.009103:161668870; State: migrating; ETA: N/A | |
Copy: 1177000/171229248 0.7%; Applied: 0; Backlog: 0/100; Time: 1m40s(total), 1m33s(copy); streamer: mysql-bin.009103:167380691; State: throttled, lag=0.715642s; ETA: N/A | |
Copy: 1211000/171229248 0.7%; Applied: 0; Backlog: 0/100; Time: 1m45s(total), 1m38s(copy); streamer: mysql-bin.009103:172681088; State: throttled, lag=0.915790s; ETA: N/A | |
Copy: 1241000/171229248 0.7%; Applied: 0; Backlog: 0/100; Time: 1m50s(total), 1m43s(copy); streamer: mysql-bin.009103:177132859; State: migrating; ETA: N/A | |
Copy: 1279000/171229248 0.7%; Applied: 0; Backlog: 0/100; Time: 1m55s(total), 1m48s(copy); streamer: mysql-bin.009103:182705226; State: migrating; ETA: N/A | |
Copy: 1358000/171229248 0.8%; Applied: 0; Backlog: 0/100; Time: 2m0s(total), 1m53s(copy); streamer: mysql-bin.009103:193833323; State: migrating; ETA: N/A | |
Copy: 1427000/171229248 0.8%; Applied: 0; Backlog: 0/100; Time: 2m5s(total), 1m58s(copy); streamer: mysql-bin.009103:202544335; State: throttled, lag=0.515750s; ETA: N/A | |
Copy: 1458000/171229248 0.9%; Applied: 0; Backlog: 0/100; Time: 2m10s(total), 2m3s(copy); streamer: mysql-bin.009103:208126099; State: migrating; ETA: N/A | |
Copy: 1498000/171229248 0.9%; Applied: 0; Backlog: 0/100; Time: 2m15s(total), 2m8s(copy); streamer: mysql-bin.009103:213555392; State: migrating; ETA: N/A | |
Copy: 1546000/171229248 0.9%; Applied: 0; Backlog: 0/100; Time: 2m20s(total), 2m13s(copy); streamer: mysql-bin.009103:220708354; State: migrating; ETA: N/A | |
Copy: 1634000/171229248 1.0%; Applied: 0; Backlog: 0/100; Time: 2m25s(total), 2m18s(copy); streamer: mysql-bin.009103:233261147; State: migrating; ETA: N/A | |
Copy: 1678000/171229248 1.0%; Applied: 0; Backlog: 0/100; Time: 2m30s(total), 2m23s(copy); streamer: mysql-bin.009103:239545254; State: migrating; ETA: N/A | |
Copy: 1721000/171229248 1.0%; Applied: 0; Backlog: 0/100; Time: 2m35s(total), 2m28s(copy); streamer: mysql-bin.009103:244829679; State: throttled, lag=0.715955s; ETA: 4h2m57s | |
Copy: 1757000/171229248 1.0%; Applied: 0; Backlog: 0/100; Time: 2m40s(total), 2m33s(copy); streamer: mysql-bin.009103:250842821; State: throttled, lag=0.715885s; ETA: 4h5m58s | |
Copy: 1793000/171229248 1.0%; Applied: 0; Backlog: 0/100; Time: 2m45s(total), 2m38s(copy); streamer: mysql-bin.009103:255859100; State: throttled, lag=0.915719s; ETA: 4h8m51s | |
Copy: 1830000/171229248 1.1%; Applied: 0; Backlog: 0/100; Time: 2m50s(total), 2m43s(copy); streamer: mysql-bin.009103:261441109; State: migrating; ETA: 4h11m29s | |
Copy: 1893000/171229248 1.1%; Applied: 0; Backlog: 0/100; Time: 2m55s(total), 2m48s(copy); streamer: mysql-bin.009103:270289394; State: migrating; ETA: 4h10m28s | |
Copy: 1958000/171229248 1.1%; Applied: 0; Backlog: 0/100; Time: 3m0s(total), 2m53s(copy); streamer: mysql-bin.009103:279573132; State: migrating; ETA: 4h9m16s | |
Copy: 2271000/171229248 1.3%; Applied: 0; Backlog: 0/100; Time: 3m30s(total), 3m23s(copy); streamer: mysql-bin.009103:324285290; State: migrating; ETA: 4h11m43s | |
Copy: 2595000/171229248 1.5%; Applied: 0; Backlog: 0/100; Time: 4m0s(total), 3m53s(copy); streamer: mysql-bin.009103:369851152; State: migrating; ETA: 4h12m21s | |
Copy: 2867000/171229248 1.7%; Applied: 0; Backlog: 0/100; Time: 4m30s(total), 4m23s(copy); streamer: mysql-bin.009103:409594792; State: migrating; ETA: 4h17m24s | |
Copy: 3127000/171229248 1.8%; Applied: 0; Backlog: 0/100; Time: 5m0s(total), 4m53s(copy); streamer: mysql-bin.009103:446623597; State: migrating; ETA: 4h22m31s | |
Copy: 3478000/171229248 2.0%; Applied: 0; Backlog: 0/100; Time: 5m30s(total), 5m23s(copy); streamer: mysql-bin.009103:496890301; State: throttled, lag=1.115688s; ETA: 4h19m39s | |
Copy: 3750000/171229248 2.2%; Applied: 0; Backlog: 0/100; Time: 6m0s(total), 5m53s(copy); streamer: mysql-bin.009103:535629785; State: migrating; ETA: 4h22m45s | |
Copy: 4113000/171229248 2.4%; Applied: 0; Backlog: 0/100; Time: 6m30s(total), 6m23s(copy); streamer: mysql-bin.009103:587585949; State: migrating; ETA: 4h19m21s | |
Copy: 4406000/171229248 2.6%; Applied: 0; Backlog: 0/100; Time: 7m0s(total), 6m53s(copy); streamer: mysql-bin.009103:628877599; State: migrating; ETA: 4h20m37s | |
Copy: 4703000/171229248 2.7%; Applied: 0; Backlog: 0/100; Time: 7m30s(total), 7m23s(copy); streamer: mysql-bin.009103:671882860; State: migrating; ETA: 4h21m26s | |
Copy: 5068000/171229248 3.0%; Applied: 0; Backlog: 0/100; Time: 8m0s(total), 7m53s(copy); streamer: mysql-bin.009103:723841382; State: migrating; ETA: 4h18m28s | |
Copy: 5369000/171229248 3.1%; Applied: 0; Backlog: 0/100; Time: 8m30s(total), 8m23s(copy); streamer: mysql-bin.009103:766701622; State: migrating; ETA: 4h18m58s | |
Copy: 5676000/171229248 3.3%; Applied: 0; Backlog: 0/100; Time: 9m0s(total), 8m53s(copy); streamer: mysql-bin.009103:810697289; State: migrating; ETA: 4h19m6s | |
Copy: 5988000/171229248 3.5%; Applied: 0; Backlog: 0/100; Time: 9m30s(total), 9m23s(copy); streamer: mysql-bin.009103:855406099; State: migrating; ETA: 4h18m56s | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 6283000/171229248 3.7%; Applied: 0; Backlog: 0/100; Time: 10m0s(total), 9m53s(copy); streamer: mysql-bin.009103:897411018; State: migrating; ETA: 4h19m28s | |
Copy: 6595000/171229248 3.9%; Applied: 0; Backlog: 0/100; Time: 10m30s(total), 10m23s(copy); streamer: mysql-bin.009103:942114691; State: migrating; ETA: 4h19m12s | |
Copy: 6914000/171229248 4.0%; Applied: 0; Backlog: 0/100; Time: 11m0s(total), 10m53s(copy); streamer: mysql-bin.009103:986663326; State: migrating; ETA: 4h18m39s | |
Copy: 7263000/171229248 4.2%; Applied: 0; Backlog: 0/100; Time: 11m30s(total), 11m23s(copy); streamer: mysql-bin.009103:1037492794; State: migrating; ETA: 4h16m59s | |
2017/06/28 13:16:09 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009104, 4)[0m | |
2017/06/28 13:16:09 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009104, 4)[0m | |
2017-06-28 13:16:09 INFO rotate to next log name: mysql-bin.009104 | |
2017-06-28 13:16:09 INFO rotate to next log name: mysql-bin.009104 | |
Copy: 7597000/171229248 4.4%; Applied: 0; Backlog: 0/100; Time: 12m0s(total), 11m53s(copy); streamer: mysql-bin.009104:11278758; State: migrating; ETA: 4h15m57s | |
Copy: 7938000/171229248 4.6%; Applied: 0; Backlog: 0/100; Time: 12m30s(total), 12m23s(copy); streamer: mysql-bin.009104:59539967; State: migrating; ETA: 4h14m44s | |
Copy: 8282000/171229248 4.8%; Applied: 0; Backlog: 0/100; Time: 13m0s(total), 12m53s(copy); streamer: mysql-bin.009104:109078833; State: migrating; ETA: 4h13m28s | |
Copy: 8667000/171229248 5.1%; Applied: 0; Backlog: 0/100; Time: 13m30s(total), 13m23s(copy); streamer: mysql-bin.009104:164175594; State: migrating; ETA: 4h11m1s | |
Copy: 9013000/171229248 5.3%; Applied: 0; Backlog: 0/100; Time: 14m0s(total), 13m53s(copy); streamer: mysql-bin.009104:212966645; State: migrating; ETA: 4h9m52s | |
Copy: 9375000/171229248 5.5%; Applied: 0; Backlog: 0/100; Time: 14m30s(total), 14m23s(copy); streamer: mysql-bin.009104:265251958; State: migrating; ETA: 4h8m19s | |
Copy: 9731000/171229248 5.7%; Applied: 0; Backlog: 0/100; Time: 15m0s(total), 14m53s(copy); streamer: mysql-bin.009104:315804785; State: migrating; ETA: 4h7m0s | |
Copy: 10096000/171229248 5.9%; Applied: 0; Backlog: 0/100; Time: 15m30s(total), 15m23s(copy); streamer: mysql-bin.009104:368183542; State: migrating; ETA: 4h5m31s | |
Copy: 10507000/171229248 6.1%; Applied: 0; Backlog: 0/100; Time: 16m0s(total), 15m53s(copy); streamer: mysql-bin.009104:426839163; State: migrating; ETA: 4h2m57s | |
Copy: 10866000/171229248 6.3%; Applied: 0; Backlog: 0/100; Time: 16m30s(total), 16m23s(copy); streamer: mysql-bin.009104:477799816; State: throttled, lag=0.615887s; ETA: 4h1m47s | |
Copy: 11231000/171229248 6.6%; Applied: 0; Backlog: 0/100; Time: 17m0s(total), 16m53s(copy); streamer: mysql-bin.009104:530050760; State: migrating; ETA: 4h0m31s | |
Copy: 11613000/171229248 6.8%; Applied: 0; Backlog: 0/100; Time: 17m30s(total), 17m23s(copy); streamer: mysql-bin.009104:584155538; State: migrating; ETA: 3h58m55s | |
Copy: 11986000/171229248 7.0%; Applied: 0; Backlog: 0/100; Time: 18m0s(total), 17m53s(copy); streamer: mysql-bin.009104:637673008; State: migrating; ETA: 3h57m35s | |
Copy: 12365000/171229248 7.2%; Applied: 0; Backlog: 0/100; Time: 18m30s(total), 18m23s(copy); streamer: mysql-bin.009104:691781460; State: migrating; ETA: 3h56m11s | |
Copy: 12737000/171229248 7.4%; Applied: 0; Backlog: 0/100; Time: 19m0s(total), 18m53s(copy); streamer: mysql-bin.009104:745160296; State: migrating; ETA: 3h54m58s | |
Copy: 13164000/171229248 7.7%; Applied: 0; Backlog: 0/100; Time: 19m30s(total), 19m23s(copy); streamer: mysql-bin.009104:805528056; State: migrating; ETA: 3h52m44s | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 13559000/171229248 7.9%; Applied: 0; Backlog: 0/100; Time: 20m0s(total), 19m53s(copy); streamer: mysql-bin.009104:861526252; State: migrating; ETA: 3h51m12s | |
Copy: 13947000/171229248 8.1%; Applied: 0; Backlog: 0/100; Time: 20m30s(total), 20m23s(copy); streamer: mysql-bin.009104:917567420; State: migrating; ETA: 3h49m51s | |
Copy: 14347000/171229248 8.4%; Applied: 0; Backlog: 0/100; Time: 21m0s(total), 20m53s(copy); streamer: mysql-bin.009104:974940115; State: throttled, lag=0.515826s; ETA: 3h48m21s | |
Copy: 14744000/171229248 8.6%; Applied: 0; Backlog: 0/100; Time: 21m30s(total), 21m23s(copy); streamer: mysql-bin.009104:1031601444; State: migrating; ETA: 3h46m57s | |
2017/06/28 13:26:08 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009105, 4)[0m | |
2017/06/28 13:26:08 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009105, 4)[0m | |
2017-06-28 13:26:08 INFO rotate to next log name: mysql-bin.009105 | |
2017-06-28 13:26:08 INFO rotate to next log name: mysql-bin.009105 | |
Copy: 15153000/171229248 8.8%; Applied: 0; Backlog: 0/100; Time: 22m0s(total), 21m53s(copy); streamer: mysql-bin.009105:16136857; State: throttled, lag=0.615769s; ETA: 3h45m23s | |
Copy: 15561000/171229248 9.1%; Applied: 0; Backlog: 0/100; Time: 22m30s(total), 22m23s(copy); streamer: mysql-bin.009105:74217900; State: migrating; ETA: 3h43m55s | |
Copy: 15966000/171229248 9.3%; Applied: 0; Backlog: 0/100; Time: 23m0s(total), 22m53s(copy); streamer: mysql-bin.009105:132029525; State: migrating; ETA: 3h42m31s | |
Copy: 16381000/171229248 9.6%; Applied: 0; Backlog: 0/100; Time: 23m30s(total), 23m23s(copy); streamer: mysql-bin.009105:191245228; State: migrating; ETA: 3h41m2s | |
Copy: 16824000/171229248 9.8%; Applied: 0; Backlog: 0/100; Time: 24m0s(total), 23m53s(copy); streamer: mysql-bin.009105:254342438; State: migrating; ETA: 3h39m11s | |
Copy: 17232000/171229248 10.1%; Applied: 0; Backlog: 0/100; Time: 24m30s(total), 24m23s(copy); streamer: mysql-bin.009105:312677260; State: migrating; ETA: 3h37m54s | |
Copy: 17704000/171229248 10.3%; Applied: 0; Backlog: 0/100; Time: 25m0s(total), 24m53s(copy); streamer: mysql-bin.009105:380097557; State: migrating; ETA: 3h35m47s | |
Copy: 18122000/171229248 10.6%; Applied: 0; Backlog: 0/100; Time: 25m30s(total), 25m23s(copy); streamer: mysql-bin.009105:439657120; State: migrating; ETA: 3h34m27s | |
Copy: 18558000/171229248 10.8%; Applied: 0; Backlog: 0/100; Time: 26m0s(total), 25m53s(copy); streamer: mysql-bin.009105:501876762; State: migrating; ETA: 3h32m56s | |
Copy: 18963000/171229248 11.1%; Applied: 0; Backlog: 0/100; Time: 26m30s(total), 26m23s(copy); streamer: mysql-bin.009105:559672713; State: migrating; ETA: 3h31m50s | |
Copy: 19403000/171229248 11.3%; Applied: 0; Backlog: 0/100; Time: 27m0s(total), 26m53s(copy); streamer: mysql-bin.009105:622389624; State: migrating; ETA: 3h30m21s | |
Copy: 19828000/171229248 11.6%; Applied: 0; Backlog: 0/100; Time: 27m30s(total), 27m23s(copy); streamer: mysql-bin.009105:682673889; State: migrating; ETA: 3h29m5s | |
Copy: 20271000/171229248 11.8%; Applied: 0; Backlog: 0/100; Time: 28m0s(total), 27m53s(copy); streamer: mysql-bin.009105:746316261; State: migrating; ETA: 3h27m38s | |
Copy: 20707000/171229248 12.1%; Applied: 0; Backlog: 0/100; Time: 28m30s(total), 28m23s(copy); streamer: mysql-bin.009105:808243772; State: migrating; ETA: 3h26m19s | |
Copy: 21141000/171229248 12.3%; Applied: 0; Backlog: 0/100; Time: 29m0s(total), 28m53s(copy); streamer: mysql-bin.009105:870455479; State: migrating; ETA: 3h25m3s | |
Copy: 21584000/171229248 12.6%; Applied: 0; Backlog: 0/100; Time: 29m30s(total), 29m23s(copy); streamer: mysql-bin.009105:933238825; State: migrating; ETA: 3h23m43s | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 22002000/171229248 12.8%; Applied: 0; Backlog: 0/100; Time: 30m0s(total), 29m53s(copy); streamer: mysql-bin.009105:993313771; State: migrating; ETA: 3h22m40s | |
Copy: 22474000/171229248 13.1%; Applied: 0; Backlog: 0/100; Time: 30m30s(total), 30m23s(copy); streamer: mysql-bin.009105:1060797168; State: migrating; ETA: 3h21m6s | |
2017/06/28 13:34:52 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009106, 4)[0m | |
2017/06/28 13:34:52 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009106, 4)[0m | |
2017-06-28 13:34:52 INFO rotate to next log name: mysql-bin.009106 | |
2017-06-28 13:34:52 INFO rotate to next log name: mysql-bin.009106 | |
Copy: 22904000/171229248 13.4%; Applied: 0; Backlog: 0/100; Time: 31m0s(total), 30m53s(copy); streamer: mysql-bin.009106:48134026; State: migrating; ETA: 3h19m59s | |
Copy: 23341000/171229248 13.6%; Applied: 0; Backlog: 0/100; Time: 31m30s(total), 31m23s(copy); streamer: mysql-bin.009106:110723979; State: migrating; ETA: 3h18m50s | |
Copy: 23770000/171229248 13.9%; Applied: 0; Backlog: 0/100; Time: 32m0s(total), 31m53s(copy); streamer: mysql-bin.009106:171505932; State: migrating; ETA: 3h17m47s | |
Copy: 24221000/171229248 14.1%; Applied: 0; Backlog: 0/100; Time: 32m30s(total), 32m23s(copy); streamer: mysql-bin.009106:236142801; State: migrating; ETA: 3h16m32s | |
Copy: 24642000/171229248 14.4%; Applied: 0; Backlog: 0/100; Time: 33m0s(total), 32m53s(copy); streamer: mysql-bin.009106:296232411; State: migrating; ETA: 3h15m36s | |
Copy: 25100000/171229248 14.7%; Applied: 0; Backlog: 0/100; Time: 33m30s(total), 33m23s(copy); streamer: mysql-bin.009106:361561425; State: migrating; ETA: 3h14m21s | |
Copy: 25532000/171229248 14.9%; Applied: 0; Backlog: 0/100; Time: 34m0s(total), 33m53s(copy); streamer: mysql-bin.009106:422913854; State: migrating; ETA: 3h13m21s | |
Copy: 25981000/171229248 15.2%; Applied: 0; Backlog: 0/100; Time: 34m30s(total), 34m23s(copy); streamer: mysql-bin.009106:487408787; State: migrating; ETA: 3h12m13s | |
Copy: 26421000/171229248 15.4%; Applied: 0; Backlog: 0/100; Time: 35m0s(total), 34m53s(copy); streamer: mysql-bin.009106:550031609; State: migrating; ETA: 3h11m11s | |
Copy: 26867000/171229248 15.7%; Applied: 0; Backlog: 0/100; Time: 35m30s(total), 35m23s(copy); streamer: mysql-bin.009106:613680050; State: migrating; ETA: 3h10m7s | |
Copy: 27268000/171229248 15.9%; Applied: 0; Backlog: 0/100; Time: 36m0s(total), 35m53s(copy); streamer: mysql-bin.009106:670776769; State: migrating; ETA: 3h9m26s | |
Copy: 27688000/171229248 16.2%; Applied: 0; Backlog: 0/100; Time: 36m30s(total), 36m23s(copy); streamer: mysql-bin.009106:730879231; State: migrating; ETA: 3h8m37s | |
Copy: 28150000/171229248 16.4%; Applied: 0; Backlog: 0/100; Time: 37m0s(total), 36m53s(copy); streamer: mysql-bin.009106:796770936; State: migrating; ETA: 3h7m28s | |
Copy: 28589000/171229248 16.7%; Applied: 0; Backlog: 0/100; Time: 37m30s(total), 37m23s(copy); streamer: mysql-bin.009106:859548371; State: migrating; ETA: 3h6m31s | |
Copy: 29065000/171229248 17.0%; Applied: 0; Backlog: 0/100; Time: 38m0s(total), 37m53s(copy); streamer: mysql-bin.009106:927170516; State: migrating; ETA: 3h5m17s | |
Copy: 29512000/171229248 17.2%; Applied: 0; Backlog: 0/100; Time: 38m30s(total), 38m23s(copy); streamer: mysql-bin.009106:990945249; State: migrating; ETA: 3h4m19s | |
Copy: 29987000/171229248 17.5%; Applied: 0; Backlog: 0/100; Time: 39m0s(total), 38m53s(copy); streamer: mysql-bin.009106:1058996454; State: migrating; ETA: 3h3m8s | |
2017/06/28 13:43:23 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009107, 4)[0m | |
2017/06/28 13:43:23 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009107, 4)[0m | |
2017-06-28 13:43:23 INFO rotate to next log name: mysql-bin.009107 | |
2017-06-28 13:43:23 INFO rotate to next log name: mysql-bin.009107 | |
Copy: 30429000/171229248 17.8%; Applied: 0; Backlog: 0/100; Time: 39m30s(total), 39m23s(copy); streamer: mysql-bin.009107:47939203; State: migrating; ETA: 3h2m14s | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 30908000/171229248 18.1%; Applied: 0; Backlog: 0/100; Time: 40m0s(total), 39m53s(copy); streamer: mysql-bin.009107:116342413; State: migrating; ETA: 3h1m4s | |
Copy: 31354000/171229248 18.3%; Applied: 0; Backlog: 0/100; Time: 40m30s(total), 40m23s(copy); streamer: mysql-bin.009107:180049274; State: migrating; ETA: 3h0m9s | |
Copy: 31840000/171229248 18.6%; Applied: 0; Backlog: 0/100; Time: 41m0s(total), 40m53s(copy); streamer: mysql-bin.009107:249381375; State: migrating; ETA: 2h58m58s | |
Copy: 32287000/171229248 18.9%; Applied: 0; Backlog: 0/100; Time: 41m30s(total), 41m23s(copy); streamer: mysql-bin.009107:313156101; State: migrating; ETA: 2h58m5s | |
Copy: 32765000/171229248 19.1%; Applied: 0; Backlog: 0/100; Time: 42m0s(total), 41m53s(copy); streamer: mysql-bin.009107:381490158; State: migrating; ETA: 2h56m59s | |
Copy: 33213000/171229248 19.4%; Applied: 0; Backlog: 0/100; Time: 42m30s(total), 42m23s(copy); streamer: mysql-bin.009107:445407028; State: migrating; ETA: 2h56m7s | |
Copy: 33707000/171229248 19.7%; Applied: 0; Backlog: 0/100; Time: 43m0s(total), 42m53s(copy); streamer: mysql-bin.009107:515735074; State: migrating; ETA: 2h54m57s | |
Copy: 34153000/171229248 19.9%; Applied: 0; Backlog: 0/100; Time: 43m30s(total), 43m23s(copy); streamer: mysql-bin.009107:579367335; State: migrating; ETA: 2h54m7s | |
Copy: 34614000/171229248 20.2%; Applied: 0; Backlog: 0/100; Time: 44m0s(total), 43m53s(copy); streamer: mysql-bin.009107:645145915; State: migrating; ETA: 2h53m11s | |
Copy: 35055000/171229248 20.5%; Applied: 0; Backlog: 0/100; Time: 44m30s(total), 44m23s(copy); streamer: mysql-bin.009107:708060701; State: migrating; ETA: 2h52m24s | |
Copy: 35538000/171229248 20.8%; Applied: 0; Backlog: 0/100; Time: 45m0s(total), 44m53s(copy); streamer: mysql-bin.009107:776964317; State: migrating; ETA: 2h51m22s | |
Copy: 35985000/171229248 21.0%; Applied: 0; Backlog: 0/100; Time: 45m30s(total), 45m23s(copy); streamer: mysql-bin.009107:840739045; State: migrating; ETA: 2h50m34s | |
Copy: 36460000/171229248 21.3%; Applied: 0; Backlog: 0/100; Time: 46m0s(total), 45m53s(copy); streamer: mysql-bin.009107:908649809; State: migrating; ETA: 2h49m36s | |
Copy: 36932000/171229248 21.6%; Applied: 0; Backlog: 0/100; Time: 46m30s(total), 46m23s(copy); streamer: mysql-bin.009107:975415799; State: migrating; ETA: 2h48m39s | |
Copy: 37400000/171229248 21.8%; Applied: 0; Backlog: 0/100; Time: 47m0s(total), 46m53s(copy); streamer: mysql-bin.009107:1042752872; State: migrating; ETA: 2h47m45s | |
2017/06/28 13:51:30 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009108, 4)[0m | |
2017/06/28 13:51:30 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009108, 4)[0m | |
2017-06-28 13:51:30 INFO rotate to next log name: mysql-bin.009108 | |
2017-06-28 13:51:30 INFO rotate to next log name: mysql-bin.009108 | |
Copy: 37877000/171229248 22.1%; Applied: 0; Backlog: 0/100; Time: 47m30s(total), 47m23s(copy); streamer: mysql-bin.009108:36661518; State: migrating; ETA: 2h46m49s | |
Copy: 38340000/171229248 22.4%; Applied: 0; Backlog: 0/100; Time: 48m0s(total), 47m53s(copy); streamer: mysql-bin.009108:102858244; State: migrating; ETA: 2h45m58s | |
Copy: 38816000/171229248 22.7%; Applied: 0; Backlog: 0/100; Time: 48m30s(total), 48m23s(copy); streamer: mysql-bin.009108:170768750; State: migrating; ETA: 2h45m3s | |
Copy: 39227000/171229248 22.9%; Applied: 0; Backlog: 0/100; Time: 49m0s(total), 48m53s(copy); streamer: mysql-bin.009108:229574875; State: migrating; ETA: 2h44m29s | |
Copy: 39712000/171229248 23.2%; Applied: 0; Backlog: 0/100; Time: 49m30s(total), 49m23s(copy); streamer: mysql-bin.009108:298479766; State: migrating; ETA: 2h43m32s | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 40171000/171229248 23.5%; Applied: 0; Backlog: 0/100; Time: 50m0s(total), 49m53s(copy); streamer: mysql-bin.009108:364106603; State: migrating; ETA: 2h42m44s | |
Copy: 40654000/171229248 23.7%; Applied: 0; Backlog: 0/100; Time: 50m30s(total), 50m23s(copy); streamer: mysql-bin.009108:432950626; State: migrating; ETA: 2h41m49s | |
Copy: 41111000/171229248 24.0%; Applied: 0; Backlog: 0/100; Time: 51m0s(total), 50m53s(copy); streamer: mysql-bin.009108:498067200; State: migrating; ETA: 2h41m2s | |
Copy: 41609000/171229248 24.3%; Applied: 0; Backlog: 0/100; Time: 51m30s(total), 51m23s(copy); streamer: mysql-bin.009108:569116020; State: migrating; ETA: 2h40m4s | |
Copy: 42060000/171229248 24.6%; Applied: 0; Backlog: 0/100; Time: 52m0s(total), 51m53s(copy); streamer: mysql-bin.009108:633595001; State: migrating; ETA: 2h39m20s | |
Copy: 42554000/171229248 24.9%; Applied: 0; Backlog: 0/100; Time: 52m30s(total), 52m23s(copy); streamer: mysql-bin.009108:704208580; State: migrating; ETA: 2h38m23s | |
Copy: 43017000/171229248 25.1%; Applied: 0; Backlog: 0/100; Time: 53m0s(total), 52m53s(copy); streamer: mysql-bin.009108:770262839; State: migrating; ETA: 2h37m37s | |
Copy: 43514000/171229248 25.4%; Applied: 0; Backlog: 0/100; Time: 53m30s(total), 53m23s(copy); streamer: mysql-bin.009108:840875839; State: migrating; ETA: 2h36m40s | |
Copy: 43953000/171229248 25.7%; Applied: 0; Backlog: 0/100; Time: 54m0s(total), 53m53s(copy); streamer: mysql-bin.009108:903515968; State: migrating; ETA: 2h36m1s | |
Copy: 44412000/171229248 25.9%; Applied: 0; Backlog: 0/100; Time: 54m30s(total), 54m23s(copy); streamer: mysql-bin.009108:969154670; State: migrating; ETA: 2h35m17s | |
Copy: 44880000/171229248 26.2%; Applied: 0; Backlog: 0/100; Time: 55m0s(total), 54m53s(copy); streamer: mysql-bin.009108:1035921574; State: migrating; ETA: 2h34m30s | |
2017/06/28 13:59:31 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009109, 4)[0m | |
2017/06/28 13:59:31 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009109, 4)[0m | |
2017-06-28 13:59:31 INFO rotate to next log name: mysql-bin.009109 | |
2017-06-28 13:59:31 INFO rotate to next log name: mysql-bin.009109 | |
Copy: 45377000/171229248 26.5%; Applied: 0; Backlog: 0/100; Time: 55m30s(total), 55m23s(copy); streamer: mysql-bin.009109:32813030; State: migrating; ETA: 2h33m36s | |
Copy: 45831000/171229248 26.8%; Applied: 0; Backlog: 0/100; Time: 56m0s(total), 55m53s(copy); streamer: mysql-bin.009109:97727510; State: migrating; ETA: 2h32m54s | |
Copy: 46312000/171229248 27.0%; Applied: 0; Backlog: 0/100; Time: 56m30s(total), 56m23s(copy); streamer: mysql-bin.009109:166346231; State: migrating; ETA: 2h32m4s | |
Copy: 46767000/171229248 27.3%; Applied: 0; Backlog: 0/100; Time: 57m0s(total), 56m53s(copy); streamer: mysql-bin.009109:231403484; State: migrating; ETA: 2h31m23s | |
Copy: 47197000/171229248 27.6%; Applied: 0; Backlog: 0/100; Time: 57m30s(total), 57m23s(copy); streamer: mysql-bin.009109:292627371; State: migrating; ETA: 2h30m48s | |
Copy: 47662000/171229248 27.8%; Applied: 0; Backlog: 0/100; Time: 58m0s(total), 57m53s(copy); streamer: mysql-bin.009109:358966570; State: migrating; ETA: 2h30m4s | |
Copy: 48117000/171229248 28.1%; Applied: 0; Backlog: 0/100; Time: 58m30s(total), 58m23s(copy); streamer: mysql-bin.009109:423738575; State: migrating; ETA: 2h29m22s | |
Copy: 48582000/171229248 28.4%; Applied: 0; Backlog: 0/100; Time: 59m0s(total), 58m53s(copy); streamer: mysql-bin.009109:489506993; State: migrating; ETA: 2h28m39s | |
Copy: 48989000/171229248 28.6%; Applied: 0; Backlog: 0/100; Time: 59m30s(total), 59m23s(copy); streamer: mysql-bin.009109:548314777; State: migrating; ETA: 2h28m10s | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 49448000/171229248 28.9%; Applied: 0; Backlog: 0/100; Time: 1h0m0s(total), 59m53s(copy); streamer: mysql-bin.009109:613518042; State: migrating; ETA: 2h27m28s | |
Copy: 49858000/171229248 29.1%; Applied: 0; Backlog: 0/100; Time: 1h0m30s(total), 1h0m23s(copy); streamer: mysql-bin.009109:672327786; State: migrating; ETA: 2h26m59s | |
Copy: 50226000/171229248 29.3%; Applied: 0; Backlog: 0/100; Time: 1h1m0s(total), 1h0m53s(copy); streamer: mysql-bin.009109:724591588; State: migrating; ETA: 2h26m40s | |
Copy: 50661000/171229248 29.6%; Applied: 0; Backlog: 0/100; Time: 1h1m30s(total), 1h1m23s(copy); streamer: mysql-bin.009109:786947085; State: migrating; ETA: 2h26m5s | |
Copy: 51111000/171229248 29.8%; Applied: 0; Backlog: 0/100; Time: 1h2m0s(total), 1h1m53s(copy); streamer: mysql-bin.009109:851297180; State: migrating; ETA: 2h25m26s | |
Copy: 51547000/171229248 30.1%; Applied: 0; Backlog: 0/100; Time: 1h2m30s(total), 1h2m23s(copy); streamer: mysql-bin.009109:913513006; State: migrating; ETA: 2h24m50s | |
Copy: 51955000/171229248 30.3%; Applied: 0; Backlog: 0/100; Time: 1h3m0s(total), 1h2m53s(copy); streamer: mysql-bin.009109:971611344; State: migrating; ETA: 2h24m21s | |
Copy: 52406000/171229248 30.6%; Applied: 0; Backlog: 0/100; Time: 1h3m30s(total), 1h3m23s(copy); streamer: mysql-bin.009109:1035813483; State: migrating; ETA: 2h23m42s | |
2017/06/28 14:08:03 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009110, 4)[0m | |
2017/06/28 14:08:03 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009110, 4)[0m | |
2017-06-28 14:08:03 INFO rotate to next log name: mysql-bin.009110 | |
2017-06-28 14:08:03 INFO rotate to next log name: mysql-bin.009110 | |
Copy: 52853000/171229248 30.9%; Applied: 0; Backlog: 0/100; Time: 1h4m0s(total), 1h3m53s(copy); streamer: mysql-bin.009110:25534428; State: throttled, lag=1.715691s; ETA: 2h23m4s | |
Copy: 53212000/171229248 31.1%; Applied: 0; Backlog: 0/100; Time: 1h4m30s(total), 1h4m23s(copy); streamer: mysql-bin.009110:77388708; State: migrating; ETA: 2h22m47s | |
Copy: 53690000/171229248 31.4%; Applied: 0; Backlog: 0/100; Time: 1h5m0s(total), 1h4m53s(copy); streamer: mysql-bin.009110:145009221; State: migrating; ETA: 2h22m2s | |
Copy: 54093000/171229248 31.6%; Applied: 0; Backlog: 0/100; Time: 1h5m30s(total), 1h5m23s(copy); streamer: mysql-bin.009110:202528524; State: throttled, lag=0.615840s; ETA: 2h21m35s | |
Copy: 54519000/171229248 31.8%; Applied: 0; Backlog: 0/100; Time: 1h6m0s(total), 1h5m53s(copy); streamer: mysql-bin.009110:263761073; State: migrating; ETA: 2h21m2s | |
Copy: 54862000/171229248 32.0%; Applied: 0; Backlog: 0/100; Time: 1h6m30s(total), 1h6m23s(copy); streamer: mysql-bin.009110:312472118; State: migrating; ETA: 2h20m48s | |
Copy: 55340000/171229248 32.3%; Applied: 0; Backlog: 0/100; Time: 1h7m0s(total), 1h6m53s(copy); streamer: mysql-bin.009110:380806196; State: migrating; ETA: 2h20m3s | |
Copy: 55724000/171229248 32.5%; Applied: 0; Backlog: 0/100; Time: 1h7m30s(total), 1h7m23s(copy); streamer: mysql-bin.009110:435909666; State: migrating; ETA: 2h19m40s | |
Copy: 56058000/171229248 32.7%; Applied: 0; Backlog: 0/100; Time: 1h8m0s(total), 1h7m53s(copy); streamer: mysql-bin.009110:483622999; State: migrating; ETA: 2h19m27s | |
Copy: 56464000/171229248 33.0%; Applied: 0; Backlog: 0/100; Time: 1h8m30s(total), 1h8m23s(copy); streamer: mysql-bin.009110:541420420; State: migrating; ETA: 2h18m59s | |
Copy: 56912000/171229248 33.2%; Applied: 0; Backlog: 0/100; Time: 1h9m0s(total), 1h8m53s(copy); streamer: mysql-bin.009110:605200309; State: migrating; ETA: 2h18m21s | |
Copy: 57337000/171229248 33.5%; Applied: 0; Backlog: 0/100; Time: 1h9m30s(total), 1h9m23s(copy); streamer: mysql-bin.009110:666066208; State: migrating; ETA: 2h17m49s | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 57680000/171229248 33.7%; Applied: 0; Backlog: 0/100; Time: 1h10m0s(total), 1h9m53s(copy); streamer: mysql-bin.009110:714557193; State: migrating; ETA: 2h17m34s | |
Copy: 58043000/171229248 33.9%; Applied: 0; Backlog: 0/100; Time: 1h10m30s(total), 1h10m23s(copy); streamer: mysql-bin.009110:765951543; State: throttled, lag=0.515886s; ETA: 2h17m15s | |
Copy: 58483000/171229248 34.2%; Applied: 0; Backlog: 0/100; Time: 1h11m0s(total), 1h10m53s(copy); streamer: mysql-bin.009110:829593900; State: migrating; ETA: 2h16m39s | |
Copy: 58826000/171229248 34.4%; Applied: 0; Backlog: 0/100; Time: 1h11m30s(total), 1h11m23s(copy); streamer: mysql-bin.009110:878439239; State: migrating; ETA: 2h16m23s | |
Copy: 59154000/171229248 34.5%; Applied: 0; Backlog: 0/100; Time: 1h12m0s(total), 1h11m53s(copy); streamer: mysql-bin.009110:925580608; State: migrating; ETA: 2h16m11s | |
Copy: 59503000/171229248 34.8%; Applied: 0; Backlog: 0/100; Time: 1h12m30s(total), 1h12m23s(copy); streamer: mysql-bin.009110:974278654; State: migrating; ETA: 2h15m54s | |
Copy: 59864000/171229248 35.0%; Applied: 0; Backlog: 0/100; Time: 1h13m0s(total), 1h12m53s(copy); streamer: mysql-bin.009110:1026543610; State: migrating; ETA: 2h15m35s | |
2017/06/28 14:17:40 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009111, 4)[0m | |
2017/06/28 14:17:40 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009111, 4)[0m | |
2017-06-28 14:17:40 INFO rotate to next log name: mysql-bin.009111 | |
2017-06-28 14:17:40 INFO rotate to next log name: mysql-bin.009111 | |
Copy: 60282000/171229248 35.2%; Applied: 0; Backlog: 0/100; Time: 1h13m30s(total), 1h13m23s(copy); streamer: mysql-bin.009111:12697000; State: throttled, lag=0.615808s; ETA: 2h15m3s | |
Copy: 60545000/171229248 35.4%; Applied: 0; Backlog: 0/100; Time: 1h14m0s(total), 1h13m53s(copy); streamer: mysql-bin.009111:49898005; State: migrating; ETA: 2h15m4s | |
Copy: 60902000/171229248 35.6%; Applied: 0; Backlog: 0/100; Time: 1h14m30s(total), 1h14m23s(copy); streamer: mysql-bin.009111:101305036; State: migrating; ETA: 2h14m44s | |
Copy: 61298000/171229248 35.8%; Applied: 0; Backlog: 0/100; Time: 1h15m0s(total), 1h14m53s(copy); streamer: mysql-bin.009111:157247402; State: throttled, lag=1.015716s; ETA: 2h14m17s | |
Copy: 61601000/171229248 36.0%; Applied: 0; Backlog: 0/100; Time: 1h15m30s(total), 1h15m23s(copy); streamer: mysql-bin.009111:200844937; State: migrating; ETA: 2h14m9s | |
Copy: 62019000/171229248 36.2%; Applied: 0; Backlog: 0/100; Time: 1h16m0s(total), 1h15m53s(copy); streamer: mysql-bin.009111:260916025; State: migrating; ETA: 2h13m37s | |
Copy: 62336000/171229248 36.4%; Applied: 0; Backlog: 0/100; Time: 1h16m30s(total), 1h16m23s(copy); streamer: mysql-bin.009111:306062462; State: migrating; ETA: 2h13m25s | |
Copy: 62694000/171229248 36.6%; Applied: 0; Backlog: 0/100; Time: 1h17m0s(total), 1h16m53s(copy); streamer: mysql-bin.009111:357166655; State: migrating; ETA: 2h13m5s | |
Copy: 63016000/171229248 36.8%; Applied: 0; Backlog: 0/100; Time: 1h17m30s(total), 1h17m23s(copy); streamer: mysql-bin.009111:403334931; State: migrating; ETA: 2h12m53s | |
Copy: 63333000/171229248 37.0%; Applied: 0; Backlog: 0/100; Time: 1h18m0s(total), 1h17m53s(copy); streamer: mysql-bin.009111:448054981; State: migrating; ETA: 2h12m41s | |
Copy: 63721000/171229248 37.2%; Applied: 0; Backlog: 0/100; Time: 1h18m30s(total), 1h18m23s(copy); streamer: mysql-bin.009111:503153900; State: throttled, lag=1.015817s; ETA: 2h12m14s | |
Copy: 63976000/171229248 37.4%; Applied: 0; Backlog: 0/100; Time: 1h19m0s(total), 1h18m53s(copy); streamer: mysql-bin.009111:539921524; State: throttled, lag=0.715672s; ETA: 2h12m14s | |
Copy: 64406000/171229248 37.6%; Applied: 0; Backlog: 0/100; Time: 1h19m30s(total), 1h19m23s(copy); streamer: mysql-bin.009111:601573439; State: migrating; ETA: 2h11m39s | |
Copy: 64589000/171229248 37.7%; Applied: 0; Backlog: 0/100; Time: 1h19m48s(total), 1h19m40s(copy); streamer: mysql-bin.009111:627861002; State: migrating; ETA: 2h11m33s | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 64718000/171229248 37.8%; Applied: 0; Backlog: 0/100; Time: 1h20m0s(total), 1h19m53s(copy); streamer: mysql-bin.009111:645719091; State: throttled, lag=0.515679s; ETA: 2h11m28s | |
Copy: 65039000/171229248 38.0%; Applied: 0; Backlog: 0/100; Time: 1h20m30s(total), 1h20m23s(copy); streamer: mysql-bin.009111:692161535; State: migrating; ETA: 2h11m14s | |
Copy: 65394000/171229248 38.2%; Applied: 0; Backlog: 0/100; Time: 1h21m0s(total), 1h20m53s(copy); streamer: mysql-bin.009111:742129892; State: throttled, lag=1.115661s; ETA: 2h10m54s | |
Copy: 65720000/171229248 38.4%; Applied: 0; Backlog: 0/100; Time: 1h21m30s(total), 1h21m23s(copy); streamer: mysql-bin.009111:789569136; State: migrating; ETA: 2h10m39s | |
Copy: 66061000/171229248 38.6%; Applied: 0; Backlog: 0/100; Time: 1h22m0s(total), 1h21m53s(copy); streamer: mysql-bin.009111:837975106; State: migrating; ETA: 2h10m21s | |
Copy: 66352000/171229248 38.8%; Applied: 0; Backlog: 0/100; Time: 1h22m30s(total), 1h22m23s(copy); streamer: mysql-bin.009111:879432679; State: migrating; ETA: 2h10m13s | |
Copy: 66662000/171229248 38.9%; Applied: 0; Backlog: 0/100; Time: 1h23m0s(total), 1h22m53s(copy); streamer: mysql-bin.009111:923577781; State: migrating; ETA: 2h10m0s | |
Copy: 66914000/171229248 39.1%; Applied: 0; Backlog: 0/100; Time: 1h23m30s(total), 1h23m23s(copy); streamer: mysql-bin.009111:960058561; State: migrating; ETA: 2h9m59s | |
Copy: 67272000/171229248 39.3%; Applied: 0; Backlog: 0/100; Time: 1h24m0s(total), 1h23m53s(copy); streamer: mysql-bin.009111:1011310086; State: migrating; ETA: 2h9m37s | |
Copy: 67584000/171229248 39.5%; Applied: 0; Backlog: 0/100; Time: 1h24m30s(total), 1h24m23s(copy); streamer: mysql-bin.009111:1055319687; State: throttled, lag=0.715693s; ETA: 2h9m24s | |
2017/06/28 14:29:01 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009112, 4)[0m | |
2017/06/28 14:29:01 binlogsyncer.go:568: [0;37m[info] rotate to (mysql-bin.009112, 4)[0m | |
2017-06-28 14:29:01 INFO rotate to next log name: mysql-bin.009112 | |
2017-06-28 14:29:01 INFO rotate to next log name: mysql-bin.009112 | |
Copy: 67873000/171229248 39.6%; Applied: 0; Backlog: 0/100; Time: 1h25m0s(total), 1h24m53s(copy); streamer: mysql-bin.009112:23129247; State: migrating; ETA: 2h9m15s | |
Copy: 68204000/171229248 39.8%; Applied: 0; Backlog: 0/100; Time: 1h25m30s(total), 1h25m23s(copy); streamer: mysql-bin.009112:70552989; State: migrating; ETA: 2h8m58s | |
Copy: 68559000/171229248 40.0%; Applied: 0; Backlog: 0/100; Time: 1h26m0s(total), 1h25m53s(copy); streamer: mysql-bin.009112:121369662; State: migrating; ETA: 2h8m36s | |
Copy: 68932000/171229248 40.3%; Applied: 0; Backlog: 0/100; Time: 1h26m30s(total), 1h26m23s(copy); streamer: mysql-bin.009112:173759463; State: migrating; ETA: 2h8m11s | |
Copy: 69272000/171229248 40.5%; Applied: 0; Backlog: 0/100; Time: 1h27m0s(total), 1h26m53s(copy); streamer: mysql-bin.009112:223024340; State: migrating; ETA: 2h7m52s | |
Copy: 69633000/171229248 40.7%; Applied: 0; Backlog: 0/100; Time: 1h27m30s(total), 1h27m23s(copy); streamer: mysql-bin.009112:274575037; State: migrating; ETA: 2h7m29s | |
Copy: 69851000/171229248 40.8%; Applied: 0; Backlog: 0/100; Time: 1h28m0s(total), 1h27m53s(copy); streamer: mysql-bin.009112:305938444; State: throttled, lag=2.515825s; ETA: 2h7m32s | |
Copy: 70154000/171229248 41.0%; Applied: 0; Backlog: 0/100; Time: 1h28m30s(total), 1h28m23s(copy); streamer: mysql-bin.009112:349249932; State: migrating; ETA: 2h7m20s | |
Copy: 70539000/171229248 41.2%; Applied: 0; Backlog: 0/100; Time: 1h29m0s(total), 1h28m53s(copy); streamer: mysql-bin.009112:403769417; State: migrating; ETA: 2h6m52s | |
Copy: 70867000/171229248 41.4%; Applied: 0; Backlog: 0/100; Time: 1h29m30s(total), 1h29m23s(copy); streamer: mysql-bin.009112:450621067; State: throttled, lag=0.715668s; ETA: 2h6m35s | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 71245000/171229248 41.6%; Applied: 0; Backlog: 0/100; Time: 1h30m0s(total), 1h29m53s(copy); streamer: mysql-bin.009112:504577946; State: migrating; ETA: 2h6m8s | |
Copy: 71551000/171229248 41.8%; Applied: 0; Backlog: 0/100; Time: 1h30m30s(total), 1h30m23s(copy); streamer: mysql-bin.009112:548686566; State: migrating; ETA: 2h5m54s | |
Copy: 71961000/171229248 42.0%; Applied: 0; Backlog: 0/100; Time: 1h31m0s(total), 1h30m53s(copy); streamer: mysql-bin.009112:607239297; State: migrating; ETA: 2h5m22s | |
Copy: 72329000/171229248 42.2%; Applied: 0; Backlog: 0/100; Time: 1h31m30s(total), 1h31m23s(copy); streamer: mysql-bin.009112:658530411; State: throttled, lag=0.615650s; ETA: 2h4m57s | |
Copy: 72635000/171229248 42.4%; Applied: 0; Backlog: 0/100; Time: 1h32m0s(total), 1h31m53s(copy); streamer: mysql-bin.009112:703216424; State: migrating; ETA: 2h4m43s | |
Copy: 72885000/171229248 42.6%; Applied: 0; Backlog: 0/100; Time: 1h32m30s(total), 1h32m23s(copy); streamer: mysql-bin.009112:738558327; State: throttled, lag=0.715673s; ETA: 2h4m39s | |
Copy: 73188000/171229248 42.7%; Applied: 0; Backlog: 0/100; Time: 1h33m0s(total), 1h32m53s(copy); streamer: mysql-bin.009112:782141445; State: migrating; ETA: 2h4m25s | |
Copy: 73485000/171229248 42.9%; Applied: 0; Backlog: 0/100; Time: 1h33m30s(total), 1h33m23s(copy); streamer: mysql-bin.009112:825003136; State: migrating; ETA: 2h4m12s | |
Copy: 73891000/171229248 43.2%; Applied: 0; Backlog: 0/100; Time: 1h34m0s(total), 1h33m53s(copy); streamer: mysql-bin.009112:882227481; State: migrating; ETA: 2h3m40s | |
Copy: 74242000/171229248 43.4%; Applied: 0; Backlog: 0/100; Time: 1h34m30s(total), 1h34m23s(copy); streamer: mysql-bin.009112:932961613; State: migrating; ETA: 2h3m17s | |
Copy: 74523000/171229248 43.5%; Applied: 0; Backlog: 0/100; Time: 1h35m0s(total), 1h34m53s(copy); streamer: mysql-bin.009112:973070384; State: migrating; ETA: 2h3m7s | |
Copy: 74600000/171229248 43.6%; Applied: 0; Backlog: 0/100; Time: 1h35m30s(total), 1h35m23s(copy); streamer: mysql-bin.009112:984208292; State: throttled, lag=1.915793s; ETA: 2h3m32s | |
[MySQL] 2017/06/28 14:39:52 statement.go:27: Invalid Connection | |
[MySQL] 2017/06/28 14:40:02 packets.go:32: unexpected EOF | |
[MySQL] 2017/06/28 14:40:02 statement.go:27: Invalid Connection | |
2017-06-28 14:40:02 ERROR driver: bad connection | |
2017-06-28 14:40:02 INFO Row copy complete | |
[MySQL] 2017/06/28 14:40:02 packets.go:32: unexpected EOF | |
[MySQL] 2017/06/28 14:40:02 statement.go:27: Invalid Connection | |
[MySQL] 2017/06/28 14:40:02 packets.go:32: unexpected EOF | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h35m47s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986656553; State: migrating; ETA: due | |
2017-06-28 14:40:02 DEBUG checking for cut-over postpone | |
2017-06-28 14:40:02 ERROR dial tcp 10.167.64.18:3306: getsockopt: connection refused | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h35m50s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986656553; State: postponing cut-over; ETA: due | |
2017-06-28 14:40:08 ERROR dial tcp 10.167.64.18:3306: getsockopt: connection refused | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h35m55s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986656553; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h36m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986656553; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h36m5s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986656553; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h36m10s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986656553; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h36m15s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986656553; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h36m20s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986656553; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h36m25s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986656553; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h36m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986656553; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h36m35s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986656553; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h36m40s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986656553; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h36m45s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986656553; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h37m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986656553; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h37m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986656553; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h38m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986656553; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h38m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986656553; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h39m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986811479; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h39m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:986968492; State: postponing cut-over; ETA: due | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h40m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:987125775; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h40m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:987282519; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h41m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:987438489; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h41m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:987595771; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h42m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:987752516; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h42m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:987909007; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h43m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:988066290; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h43m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:988223034; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h44m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:988380317; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h44m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:988537061; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h45m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:988691987; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h45m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:988849000; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h46m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:989005492; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h46m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:989162505; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h47m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:989318475; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h47m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:989475235; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h48m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:989632249; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h48m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:989788993; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h49m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:989945485; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h49m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:990102498; State: postponing cut-over; ETA: due | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h50m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:990259512; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h50m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:990416525; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h51m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:990573539; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h51m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:990730552; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h52m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:990887566; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h52m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:991044749; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h53m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:991201613; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h53m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:991359797; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h54m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:991517440; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h54m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:991675624; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h55m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:991833538; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h55m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:991991180; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h56m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:992148840; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h56m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:992306753; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h57m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:992464396; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h57m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:992622580; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h58m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:992780223; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h58m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:992938136; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h59m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:993096050; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 1h59m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:993254234; State: postponing cut-over; ETA: due | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h0m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:993412148; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h0m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:993569789; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h1m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:993727702; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h1m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:993885614; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h2m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:994043798; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h2m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:994201439; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h3m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:994359352; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h3m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:994517264; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h4m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:994675448; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h4m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:994833089; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h5m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:994991002; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h5m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:995148914; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h6m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:995301848; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h6m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:995459489; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h7m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:995617402; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h7m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:995775314; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h8m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:995933471; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h8m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:996091139; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h9m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:996249052; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h9m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:996406964; State: postponing cut-over; ETA: due | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h10m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:996564623; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h10m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:996722536; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h11m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:996880179; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h11m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:997038092; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h12m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:997196006; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h12m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:997353919; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h13m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:997511833; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h13m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:997669746; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h14m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:997827904; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h14m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:997985573; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h15m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:998142708; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h15m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:998300350; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h16m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:998458264; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h16m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:998616448; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h17m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:998774091; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h17m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:998932004; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h18m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:999089918; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h18m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:999247831; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h19m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:999405745; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h19m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:999563658; State: postponing cut-over; ETA: due | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h20m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:999721572; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h20m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:999879485; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h21m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1000037670; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h21m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1000195584; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h22m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1000352178; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h22m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1000508517; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h23m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1000666178; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h23m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1000824092; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h24m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1000981482; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h24m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1001138871; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h25m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1001296786; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h25m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1001454429; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h26m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1001611294; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h26m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1001768954; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h27m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1001926598; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h27m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1002084783; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h28m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1002241902; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h28m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1002399816; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h29m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1002557731; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h29m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1002715645; State: postponing cut-over; ETA: due | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h30m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1002873560; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h30m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1003031745; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h31m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1003189660; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h31m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1003347303; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h32m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1003505218; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h32m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1003663132; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h33m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1003821047; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h33m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1003978961; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h34m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1004136876; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h34m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1004294790; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h35m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1004452705; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h35m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1004610619; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h36m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1004768534; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h36m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1004926719; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h37m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1005084363; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h37m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1005242277; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h38m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1005400192; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h38m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1005558350; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h39m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1005715496; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h39m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1005873410; State: postponing cut-over; ETA: due | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h40m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1006031325; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h40m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1006189239; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h41m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1006347154; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h41m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1006505068; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h42m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1006662983; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h42m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1006820897; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h43m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1006978812; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h43m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1007136726; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h44m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1007294641; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h44m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1007452030; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h45m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1007609420; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h45m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1007767080; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h46m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1007923674; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h46m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1008081588; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h47m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1008239747; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h47m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1008397417; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h48m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1008555332; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h48m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1008713246; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h49m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1008871161; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h49m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1009029075; State: postponing cut-over; ETA: due | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h50m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1009186990; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h50m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1009344904; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h51m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1009502819; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h51m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1009660733; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h52m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1009818648; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h52m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1009976562; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h53m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1010134477; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h53m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1010292391; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h54m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1010450306; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h54m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1010608220; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h55m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1010766135; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h55m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1010919595; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h56m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1011077239; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h56m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1011235153; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h57m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1011393068; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h57m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1011550982; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h58m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1011708897; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h58m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1011866811; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h59m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1012024726; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 2h59m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1012182640; State: postponing cut-over; ETA: due | |
# Migrating `ghost`.`ghost_test`; Ghost table is `ghost`.`_ghost_test_gho` | |
# Migrating prod-db-us-56.mashery.com:3306; inspecting prod-db-us-58.mashery.com:3306; executing on prod-db-us-58.mashery.com | |
# Migration started at Wed Jun 28 13:04:15 +0000 2017 | |
# chunk-size: 1000; max-lag-millis: 500ms; max-load: ; critical-load: ; nice-ratio: 0.250000 | |
# throttle-additional-flag-file: /tmp/gh-ost.throttle | |
# postpone-cut-over-flag-file: /tmp/ghost-cutover.flag [set] | |
# Serving on unix socket: /tmp/gh-ost.ghost.ghost_test.sock | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h0m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1012340555; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h0m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1012498468; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h1m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1012656382; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h1m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1012814295; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h2m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1012972209; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h2m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1013130122; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h3m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1013288036; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h3m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1013445949; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h4m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1013604134; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h4m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1013762047; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h5m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1013919690; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h5m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1014077603; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h6m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1014235517; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h6m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1014393430; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h7m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1014551615; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h7m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1014709257; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h8m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1014867238; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h8m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1015025084; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h9m0s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1015182998; State: postponing cut-over; ETA: due | |
Copy: 74617000/74617000 100.0%; Applied: 0; Backlog: 0/100; Time: 3h9m30s(total), 1h35m39s(copy); streamer: mysql-bin.009112:1015340911; State: postponing cut-over; ETA: due |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment