@ms100 Could you please try to first optimize and repair the tables from phpMyAdmin and then try to optimize the tables from WP-Optimize and check if it works?
Thread Starter
ms100
(@ms100)
@bornforphp Thanks for the reply.
When I try in phpmyadmin it says: Table does not support optimize
Probably because I have used the plugin function to convert to innodb?
Maybe innodb can not be optimised?
Is there anything I can or should to about the tables colored red?
May I know which table type you are using?
The WP-Optimize can optimise below table types:
- MyISAM
- InnoDB
- ARCHIVE
- Aria (MariaDB)
It looks like the table is corrupted when optimizing it.
If you or your hosting have taker a database backup before optimizing it, please restore that database backup.
The WP-Optimize plugin is used below query to optimise the table:
OPTIMIZE TABLE table_name;
Can you please contact your hosting provide and ask why the duplicated rows were created when running the query by the plugin?
Hope it helps you.
Thread Starter
ms100
(@ms100)
So I use InnoDB. I read that it is a normal warning:
Sometimes when performing optimization on a table utilizing the InnoDB database storage engine, you could receive a warning, which may lead you to believe that this process failed. Do not be alarmed as in essence despite the warning “Table does not support optimize...” phpMyAdmin still performs a similar action leading to an equivalent result. It re-creates the table, exports the SQL code, and re-imports it. If MyISAM is selected, phpMyAdmin executes a standard optimization action, and you receive an “OK” under the “Msg_text” column.
Source
Thanks for helping me out @pmbaldha @bornforphp
