Sample Header Ad - 728x90

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