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

This article mainly introducesMySQLOptimize the table prompt "Table is already up to date" solution, friends who need it can refer to it.

ThisE-commercewebmaster usephpMyAdminWhile optimizing the database in the background, it says "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