Skip to content

Instantly share code, notes, and snippets.

@yoku0825
Created December 14, 2018 01:02
Show Gist options
  • Save yoku0825/f09f7c50bf57a1935368639112761310 to your computer and use it in GitHub Desktop.
Save yoku0825/f09f7c50bf57a1935368639112761310 to your computer and use it in GitHub Desktop.
yt-alter-progress
[ 5.76% ( 2943 sec | 180 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 6.19% ( 2880 sec | 190 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 6.48% ( 2885 sec | 200 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 7.53% ( 2704 sec | 220 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 8.09% ( 2615 sec | 230 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 8.24% ( 2673 sec | 240 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 8.69% ( 2627 sec | 250 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 9.42% ( 2499 sec | 260 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 10.09% ( 2496 sec | 280 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 10.44% ( 2488 sec | 290 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 10.67% ( 2512 sec | 300 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 11.25% ( 2445 sec | 310 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 11.76% ( 2402 sec | 320 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 12.46% ( 2390 sec | 340 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 13.29% ( 2284 sec | 350 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 13.44% ( 2319 sec | 360 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 13.73% ( 2325 sec | 370 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 14.42% ( 2255 sec | 380 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 15.18% ( 2234 sec | 400 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 15.28% ( 2274 sec | 410 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 15.39% ( 2310 sec | 420 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 15.74% ( 2303 sec | 430 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 16.15% ( 2285 sec | 440 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 17.21% ( 2214 sec | 460 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 17.65% ( 2193 sec | 470 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 17.91% ( 2201 sec | 480 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 18.37% ( 2177 sec | 490 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 18.51% ( 2201 sec | 500 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 19.26% ( 2181 sec | 520 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 19.78% ( 2149 sec | 530 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 20.55% ( 2087 sec | 540 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 20.75% ( 2101 sec | 550 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 21.01% ( 2106 sec | 560 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 21.80% ( 2081 sec | 580 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 22.07% ( 2083 sec | 590 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 22.46% ( 2071 sec | 600 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 22.81% ( 2065 sec | 610 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 23.36% ( 2034 sec | 620 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 23.91% ( 2037 sec | 640 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 24.44% ( 2009 sec | 650 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 24.70% ( 2013 sec | 660 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 25.17% ( 1992 sec | 670 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 25.51% ( 1985 sec | 680 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 26.25% ( 1967 sec | 700 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 26.66% ( 1953 sec | 710 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 27.28% ( 1919 sec | 720 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 27.47% ( 1927 sec | 730 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 27.68% ( 1933 sec | 740 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 28.53% ( 1904 sec | 760 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 28.91% ( 1894 sec | 770 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 29.23% ( 1888 sec | 780 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 29.92% ( 1851 sec | 790 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 30.21% ( 1848 sec | 800 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 30.92% ( 1832 sec | 820 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 31.27% ( 1824 sec | 830 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 31.63% ( 1816 sec | 840 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 32.23% ( 1787 sec | 850 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 32.62% ( 1777 sec | 860 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 33.46% ( 1750 sec | 880 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 33.78% ( 1745 sec | 890 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 34.46% ( 1712 sec | 900 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 34.63% ( 1717 sec | 910 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 35.27% ( 1688 sec | 920 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 35.94% ( 1675 sec | 940 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 36.33% ( 1665 sec | 950 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 24.44% ( 2009 sec | 650 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 24.70% ( 2013 sec | 660 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 25.17% ( 1992 sec | 670 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 25.51% ( 1985 sec | 680 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 25.95% ( 1969 sec | 690 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 26.25% ( 1967 sec | 700 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 26.66% ( 1953 sec | 710 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 27.28% ( 1919 sec | 720 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 27.47% ( 1927 sec | 730 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 27.68% ( 1933 sec | 740 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 27.88% ( 1940 sec | 750 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 28.53% ( 1904 sec | 760 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 28.91% ( 1894 sec | 770 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 29.23% ( 1888 sec | 780 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 29.92% ( 1851 sec | 790 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 30.21% ( 1848 sec | 800 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 30.56% ( 1840 sec | 810 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 30.92% ( 1832 sec | 820 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 31.27% ( 1824 sec | 830 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 31.63% ( 1816 sec | 840 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 32.23% ( 1787 sec | 850 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 32.62% ( 1777 sec | 860 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 33.27% ( 1745 sec | 870 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 33.46% ( 1750 sec | 880 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 33.78% ( 1745 sec | 890 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 34.46% ( 1712 sec | 900 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 34.63% ( 1717 sec | 910 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 35.27% ( 1688 sec | 920 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 35.81% ( 1667 sec | 930 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 35.94% ( 1675 sec | 940 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 36.33% ( 1665 sec | 950 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 36.64% ( 1660 sec | 960 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 36.91% ( 1658 sec | 970 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 37.53% ( 1631 sec | 980 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 38.31% ( 1610 sec | 1000 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 38.43% ( 1618 sec | 1010 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 38.76% ( 1612 sec | 1020 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 39.11% ( 1604 sec | 1030 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 39.87% ( 1569 sec | 1040 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 40.36% ( 1566 sec | 1060 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 40.64% ( 1563 sec | 1070 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 40.90% ( 1560 sec | 1080 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 41.07% ( 1564 sec | 1090 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 41.55% ( 1548 sec | 1100 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 42.62% ( 1508 sec | 1120 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 42.77% ( 1512 sec | 1130 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 43.40% ( 1487 sec | 1140 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 43.65% ( 1485 sec | 1150 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 43.73% ( 1493 sec | 1160 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 44.50% ( 1472 sec | 1180 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 45.00% ( 1455 sec | 1190 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 45.20% ( 1455 sec | 1200 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 45.58% ( 1445 sec | 1210 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 46.25% ( 1417 sec | 1220 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 46.76% ( 1412 sec | 1240 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 46.90% ( 1415 sec | 1250 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 46.97% ( 1422 sec | 1260 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 47.44% ( 1407 sec | 1270 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 47.73% ( 1402 sec | 1280 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 49.07% ( 1349 sec | 1300 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 49.21% ( 1352 sec | 1310 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 49.39% ( 1352 sec | 1320 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 49.84% ( 1338 sec | 1330 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 50.17% ( 1331 sec | 1340 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 50.51% ( 1332 sec | 1360 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 51.19% ( 1306 sec | 1370 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 51.54% ( 1297 sec | 1380 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 52.00% ( 1283 sec | 1390 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 52.24% ( 1280 sec | 1400 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 52.81% ( 1269 sec | 1420 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 53.33% ( 1251 sec | 1430 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 53.60% ( 1246 sec | 1440 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 53.77% ( 1247 sec | 1450 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 54.24% ( 1231 sec | 1460 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 54.78% ( 1222 sec | 1480 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 55.13% ( 1213 sec | 1490 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 55.63% ( 1196 sec | 1500 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 56.23% ( 1175 sec | 1510 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 56.53% ( 1169 sec | 1520 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 57.19% ( 1153 sec | 1540 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 57.44% ( 1149 sec | 1550 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 57.59% ( 1149 sec | 1560 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 57.76% ( 1148 sec | 1570 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 58.72% ( 1110 sec | 1580 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 59.56% ( 1086 sec | 1600 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 59.91% ( 1077 sec | 1610 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 60.13% ( 1074 sec | 1620 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 60.44% ( 1067 sec | 1630 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 60.71% ( 1061 sec | 1640 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 61.83% ( 1025 sec | 1660 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 62.18% ( 1015 sec | 1670 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 62.67% ( 1000 sec | 1680 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 63.21% ( 984 sec | 1690 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 63.35% ( 983 sec | 1700 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 64.06% ( 965 sec | 1720 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 64.06% ( 970 sec | 1730 sec) ] stage/innodb/alter table (read PK and internal sort) : OPTIMIZE TABLE t1
[ 35.94% ( 3102 sec | 1740 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 36.87% ( 2997 sec | 1750 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 37.95% ( 2879 sec | 1760 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 40.17% ( 2651 sec | 1780 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 41.32% ( 2543 sec | 1790 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 42.48% ( 2438 sec | 1800 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 43.66% ( 2336 sec | 1810 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 44.72% ( 2250 sec | 1820 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 46.22% ( 2141 sec | 1840 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 47.11% ( 2077 sec | 1850 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 48.07% ( 2009 sec | 1860 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 49.27% ( 1926 sec | 1870 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 50.41% ( 1850 sec | 1880 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 52.70% ( 1705 sec | 1900 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 53.29% ( 1674 sec | 1910 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 53.99% ( 1636 sec | 1920 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 54.67% ( 1600 sec | 1930 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 55.34% ( 1566 sec | 1940 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 57.10% ( 1473 sec | 1960 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 58.30% ( 1409 sec | 1970 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 59.52% ( 1347 sec | 1980 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 60.62% ( 1293 sec | 1990 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 61.58% ( 1248 sec | 2000 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 63.83% ( 1145 sec | 2020 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 64.92% ( 1097 sec | 2030 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 66.18% ( 1042 sec | 2040 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 67.58% ( 983 sec | 2050 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 68.94% ( 928 sec | 2060 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 71.58% ( 826 sec | 2080 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 73.15% ( 767 sec | 2090 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 74.66% ( 712 sec | 2100 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 76.17% ( 660 sec | 2110 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 77.62% ( 611 sec | 2120 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 78.68% ( 580 sec | 2140 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 79.07% ( 569 sec | 2150 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 79.54% ( 555 sec | 2160 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 80.00% ( 542 sec | 2170 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 80.44% ( 530 sec | 2180 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 81.41% ( 502 sec | 2200 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 52.70% ( 1705 sec | 1900 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 53.29% ( 1674 sec | 1910 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 53.99% ( 1636 sec | 1920 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 54.67% ( 1600 sec | 1930 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 55.34% ( 1566 sec | 1940 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 56.11% ( 1525 sec | 1950 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 57.10% ( 1473 sec | 1960 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 58.30% ( 1409 sec | 1970 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 59.52% ( 1347 sec | 1980 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 60.62% ( 1293 sec | 1990 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 61.58% ( 1248 sec | 2000 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 62.71% ( 1195 sec | 2010 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 63.83% ( 1145 sec | 2020 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 64.92% ( 1097 sec | 2030 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 66.18% ( 1042 sec | 2040 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 67.58% ( 983 sec | 2050 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 68.94% ( 928 sec | 2060 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 70.05% ( 885 sec | 2070 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 71.58% ( 826 sec | 2080 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 73.15% ( 767 sec | 2090 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 74.66% ( 712 sec | 2100 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 76.17% ( 660 sec | 2110 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 77.62% ( 611 sec | 2120 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 78.38% ( 587 sec | 2130 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 78.68% ( 580 sec | 2140 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 79.07% ( 569 sec | 2150 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 79.54% ( 555 sec | 2160 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 80.00% ( 542 sec | 2170 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 80.44% ( 530 sec | 2180 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 80.88% ( 517 sec | 2190 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 81.41% ( 502 sec | 2200 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 81.84% ( 490 sec | 2210 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 82.51% ( 470 sec | 2220 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 83.51% ( 440 sec | 2230 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 84.51% ( 410 sec | 2240 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 86.29% ( 359 sec | 2260 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 86.83% ( 344 sec | 2270 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 87.65% ( 321 sec | 2280 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 88.47% ( 298 sec | 2290 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 89.29% ( 276 sec | 2300 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 91.37% ( 219 sec | 2320 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 92.50% ( 189 sec | 2330 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 93.60% ( 160 sec | 2340 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 94.57% ( 134 sec | 2350 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 95.64% ( 107 sec | 2360 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 97.84% ( 52 sec | 2380 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 98.91% ( 26 sec | 2390 sec) ] stage/innodb/alter table (merge sort) : OPTIMIZE TABLE t1
[ 100.00% ( 0 sec | 2400 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 100.00% ( 0 sec | 2410 sec) ] stage/innodb/alter table (insert) : OPTIMIZE TABLE t1
[ 100.00% ( 0 sec | 2420 sec) ] stage/innodb/alter table (flush) : OPTIMIZE TABLE t1
[ 100.00% ( 0 sec | 2440 sec) ] stage/innodb/alter table (log apply table) : OPTIMIZE TABLE t1
[ 100.00% ( 0 sec | 2450 sec) ] stage/innodb/alter table (log apply table) : OPTIMIZE TABLE t1
[ 100.00% ( 0 sec | 2460 sec) ] stage/innodb/alter table (log apply table) : OPTIMIZE TABLE t1
[ 100.00% ( 0 sec | 2470 sec) ] stage/innodb/alter table (log apply table) : OPTIMIZE TABLE t1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment