MySQL db optimization error on innodb tables
2
votes
2
answers
4277
views
I have a database named 'mysql' which is being used on RHEL 8 server running MySQL 8.0.32.
When trying to optimize the entire database using the mysqlcheck command 'mysqlcheck -o mysql' the below errors are returned. I know that some of this is informational messages, and these can be ignored, however I am wondering how to get more info about these errors.
Is there a way to exclude tables from the mysqlcheck -o optimize (like the ignore option with mysqldump '--ignore-table').
mysql.innodb_index_stats
note : Table does not support optimize, doing recreate + analyze instead
error : The used command is not allowed with this MySQL version
status : Operation failed
mysql.innodb_table_stats
note : Table does not support optimize, doing recreate + analyze instead
error : The used command is not allowed with this MySQL version
status : Operation failed
mysql.gtid_executed
Warning : Please do not modify the gtid_executed table. This is a mysql internal system table to store GTIDs for committed transactions. Modifying it can lead to an inconsistent GTID state.
note : Table does not support optimize, doing recreate + analyze instead
Asked by PirateRagnaros
(21 rep)
Mar 24, 2023, 06:43 AM
Last activity: Feb 24, 2025, 06:03 PM
Last activity: Feb 24, 2025, 06:03 PM