Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- root@ip-172-30-4-235:~# ./gh-ost --host=172.30.4.235 --user=sbtest --password=sbtest --database=sbtest1 --table=sbtest1 --alter="ENGINE=InnoDB" --chunk-size=100 --max-load=Threads_connected=20 --max-lag-millis=500 --heartbeat-interval-millis=100 --initially-drop-ghost-table --initially-drop-old-table --execute
- # Migrating `sbtest1`.`sbtest1`; Ghost table is `sbtest1`.`_sbtest1_gho`
- # Migrating ip-172-30-4-4:3306; inspecting ip-172-30-4-235:3306; executing on ip-172-30-4-235
- # Migration started at Fri Dec 30 17:19:10 +0000 2016
- # chunk-size: 100; max-lag-millis: 500ms; max-load: Threads_connected=20; critical-load: ; nice-ratio: 0.000000
- # throttle-additional-flag-file: /tmp/gh-ost.throttle
- # Serving on unix socket: /tmp/gh-ost.sbtest1.sbtest1.sock
- Copy: 0/9112138 0.0%; Applied: 0; Backlog: 1/100; Time: 0s(total), 0s(copy); streamer: binlog.000013:845045940; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 278; Backlog: 60/100; Time: 1s(total), 1s(copy); streamer: binlog.000013:845448687; State: throttled, lag=0.513687s; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 278; Backlog: 100/100; Time: 2s(total), 2s(copy); streamer: binlog.000013:845515511; State: throttled, lag=0.514133s; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 577; Backlog: 100/100; Time: 3s(total), 3s(copy); streamer: binlog.000013:845830975; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 660; Backlog: 100/100; Time: 4s(total), 4s(copy); streamer: binlog.000013:845877513; State: throttled, lag=0.513558s; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 682; Backlog: 100/100; Time: 5s(total), 5s(copy); streamer: binlog.000013:845890718; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 894; Backlog: 100/100; Time: 6s(total), 6s(copy); streamer: binlog.000013:846011635; State: throttled, lag=0.513587s; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 1001; Backlog: 100/100; Time: 7s(total), 7s(copy); streamer: binlog.000013:846074799; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 1428; Backlog: 100/100; Time: 8s(total), 8s(copy); streamer: binlog.000013:846354848; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 1847; Backlog: 100/100; Time: 9s(total), 9s(copy); streamer: binlog.000013:846592756; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 2283; Backlog: 100/100; Time: 10s(total), 10s(copy); streamer: binlog.000013:846860091; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 2711; Backlog: 100/100; Time: 11s(total), 11s(copy); streamer: binlog.000013:847108442; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 3146; Backlog: 100/100; Time: 12s(total), 12s(copy); streamer: binlog.000013:847385418; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 3337; Backlog: 100/100; Time: 13s(total), 13s(copy); streamer: binlog.000013:847514369; State: throttled, lag=0.513391s; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 3648; Backlog: 100/100; Time: 14s(total), 14s(copy); streamer: binlog.000013:847723598; State: throttled, lag=0.513481s; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 3795; Backlog: 100/100; Time: 15s(total), 15s(copy); streamer: binlog.000013:847824759; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 4229; Backlog: 100/100; Time: 16s(total), 16s(copy); streamer: binlog.000013:848117527; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 4451; Backlog: 100/100; Time: 17s(total), 17s(copy); streamer: binlog.000013:848268357; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 4899; Backlog: 100/100; Time: 18s(total), 18s(copy); streamer: binlog.000013:848571134; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 5076; Backlog: 100/100; Time: 19s(total), 19s(copy); streamer: binlog.000013:848691370; State: throttled, lag=0.513633s; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 5120; Backlog: 100/100; Time: 20s(total), 20s(copy); streamer: binlog.000013:848721538; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 5522; Backlog: 100/100; Time: 21s(total), 21s(copy); streamer: binlog.000013:848960497; State: throttled, lag=0.513509s; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 5522; Backlog: 100/100; Time: 22s(total), 22s(copy); streamer: binlog.000013:848960497; State: throttled, lag=0.513527s; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 5907; Backlog: 100/100; Time: 23s(total), 23s(copy); streamer: binlog.000013:849205531; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 6000; Backlog: 100/100; Time: 24s(total), 24s(copy); streamer: binlog.000013:849258813; State: throttled, lag=0.613592s; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 6000; Backlog: 100/100; Time: 25s(total), 25s(copy); streamer: binlog.000013:849258813; State: throttled, lag=0.513457s; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 6222; Backlog: 100/100; Time: 26s(total), 26s(copy); streamer: binlog.000013:849405707; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 6485; Backlog: 100/100; Time: 27s(total), 27s(copy); streamer: binlog.000013:849582157; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 6903; Backlog: 100/100; Time: 28s(total), 28s(copy); streamer: binlog.000013:849844567; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 7334; Backlog: 100/100; Time: 29s(total), 29s(copy); streamer: binlog.000013:850137263; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 7742; Backlog: 100/100; Time: 30s(total), 30s(copy); streamer: binlog.000013:850398097; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 8170; Backlog: 100/100; Time: 31s(total), 31s(copy); streamer: binlog.000013:850642409; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 8579; Backlog: 100/100; Time: 32s(total), 32s(copy); streamer: binlog.000013:850913779; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 9000; Backlog: 100/100; Time: 33s(total), 33s(copy); streamer: binlog.000013:851160136; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 9304; Backlog: 100/100; Time: 34s(total), 34s(copy); streamer: binlog.000013:851349773; State: throttled, lag=0.513518s; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 9417; Backlog: 100/100; Time: 35s(total), 35s(copy); streamer: binlog.000013:851425783; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 9817; Backlog: 100/100; Time: 36s(total), 36s(copy); streamer: binlog.000013:851673469; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 10239; Backlog: 100/100; Time: 37s(total), 37s(copy); streamer: binlog.000013:851915798; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 10647; Backlog: 100/100; Time: 38s(total), 38s(copy); streamer: binlog.000013:852160212; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 11079; Backlog: 100/100; Time: 39s(total), 39s(copy); streamer: binlog.000013:852441193; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 11446; Backlog: 100/100; Time: 40s(total), 40s(copy); streamer: binlog.000013:852690762; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 11863; Backlog: 100/100; Time: 41s(total), 41s(copy); streamer: binlog.000013:852974104; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 11946; Backlog: 100/100; Time: 42s(total), 42s(copy); streamer: binlog.000013:853030130; State: throttled, lag=0.513588s; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 11946; Backlog: 100/100; Time: 43s(total), 43s(copy); streamer: binlog.000013:853030130; State: throttled, lag=0.513650s; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 11946; Backlog: 100/100; Time: 44s(total), 44s(copy); streamer: binlog.000013:853030130; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 12298; Backlog: 100/100; Time: 45s(total), 45s(copy); streamer: binlog.000013:853270903; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 12340; Backlog: 100/100; Time: 46s(total), 46s(copy); streamer: binlog.000013:853298702; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 12427; Backlog: 100/100; Time: 47s(total), 47s(copy); streamer: binlog.000013:853356913; State: throttled, lag=0.513714s; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 12712; Backlog: 100/100; Time: 48s(total), 48s(copy); streamer: binlog.000013:853551935; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 13127; Backlog: 100/100; Time: 49s(total), 49s(copy); streamer: binlog.000013:853829261; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 13531; Backlog: 100/100; Time: 50s(total), 50s(copy); streamer: binlog.000013:854102253; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 13949; Backlog: 100/100; Time: 51s(total), 51s(copy); streamer: binlog.000013:854373181; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 14371; Backlog: 100/100; Time: 52s(total), 52s(copy); streamer: binlog.000013:854633732; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 14759; Backlog: 100/100; Time: 53s(total), 53s(copy); streamer: binlog.000013:854897301; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 14925; Backlog: 100/100; Time: 54s(total), 54s(copy); streamer: binlog.000013:855009100; State: throttled, lag=0.513503s; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 15064; Backlog: 100/100; Time: 55s(total), 55s(copy); streamer: binlog.000013:855104756; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 15466; Backlog: 100/100; Time: 56s(total), 56s(copy); streamer: binlog.000013:855378403; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 15620; Backlog: 100/100; Time: 57s(total), 57s(copy); streamer: binlog.000013:855482195; State: throttled, lag=0.513510s; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 15884; Backlog: 100/100; Time: 58s(total), 58s(copy); streamer: binlog.000013:855661552; State: migrating; ETA: N/A
- Copy: 1900/9112138 0.0%; Applied: 16321; Backlog: 100/100; Time: 59s(total), 59s(copy); streamer: binlog.000013:855963044; State: migrating; ETA: N/A
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement