The solution of optimize table error

This article mainly introduces "the solution to optimize table error". In the daily operation, I believe that many people have doubts about the solution to optimize table error. The editor consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubt about "optimize table error solution"! Next, please follow the editor to study!

The code is as follows:

ALTER TABLE table.name ENGINE='InnoDB'

This will create a copy of the original table, and drop the original table, and replace to the original place.

Although this is safe, but I suggest you do backup and test first before doing this.

I see. It roughly means that innodb's database does not support optimize, so you can use the

ALTER TABLE table.name ENGINE='InnoDB'

This method creates a new table by copying the old table, and then deletes the old table. Although this process is safe, it is better to make a backup first when doing the operation.

There is another way:

You can make OPTIMIZE TABLE work on other storage engines by starting mysqld with the-skip-new or-safe-mode option. In this case, OPTIMIZE TABLE is just mapped toALTER TABLE.

It means that we are required to specify the-- skip-new or-- safe-mode option at startup to support the optimize function.

At this point, the study of "the solution to optimize table error" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!