MARIADB Practical features 3 modify table structure Show progress

In the work need to modify a table structure do not know the progress, hard to wait is also very painful things.

MARIADB Intimate small function, let a person in front of a bright, produced a temporary table, there are progress can be seen,

Good,good.

Direct operation, see results

MariaDB [test]> Select version ();

+-----------------+

| Version () |

+-----------------+

| 10.1.20-mariadb |

+-----------------+

1 row in Set (0.00 sec)

MariaDB [test]> ALTER TABLE t1 modify name varchar (200);

Stage:1 of 2 ' Copy to TMP table ' 54% of the stage done

The DBA wants to tell the development colleague clearly that modifying the table structure will lock the table and lock the table as affecting the business.

The order is simple, but the impact is great. I have deep experience ...

This article is from the "ROIDBA" blog, make sure to keep this source http://roidba.blog.51cto.com/12318731/1888030

MARIADB Practical features 3 modify table structure Show progress