Shulou(Shulou.com)06/01 Report--

In the work need to modify a table structure do not know the progress, waiting is also a very painful thing.

The intimate little function of mariadb makes people shine in front of people's eyes, produces a temporary watch, and the progress can be seen.

Good,good.

Direct operation, see the result

MariaDB [test] > select version ()

+-+

| | version () |

+-+

| | 10.1.20-MariaDB |

+-+

1 row in set (0.00 sec)

MariaDB [test] > alter table T1 modify name varchar

Stage: 1 of 2 'copy to tmp table' 54% of stage done

Dba should clearly tell the developer that changing the table structure will not lock the table, which means that it will affect the business.

The order is simple, but the influence is great. I have a lot of experience.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.