MySQL data table optimization/repair shows that Table is already up to date

This article mainly introduces solutions to the MySQL table optimization error message "Table is already up to date". Those who need it can refer to it.

When an e-commerce website administrator uses phpMyAdmin to optimize the database in the backend, it displays "Table is already up to date".

Many people may worry about this time, because the default optimization table hint is "status OK" as follows:

Table Op Msg_type Msg_text
commentmeta optimize status OK
comments optimize status OK
term_taxonomy optimize status OK
usermeta optimize status OK
users optimize status OK

In fact, there is no need to doubt or worry.

Literally, "Table is already up to date" means "Data table has been updated"

In other words, the table is already optimized and doesn't need to be optimized.

There are usually several situations that illustrate this:

1. Recently repaired
2. no data
3. long-term use of the table