Using RDS with slow_log enabled and encountering this error:
mysql> select * from slow_log;
ERROR 1194 (HY000): Table ‘slow_log’ is marked as crashed and should be repaired
Fixed by:
mysql> CALL mysql.rds_rotate_slow_log;
If the same error happens when general_log is enabled, we can use:
mysql> CALL mysql.rds_rotate_general_log;
These two commands are needed to be run periodically (assuming slow_log and general_log are enabled). If the logs are getting bigger, it may affects performance of the RDS instance.
But you still can’t drop the general_log table with the access given by amazon. How does one drop this table?
I have not tried dropping the general_log table.
But other posts executing the command: “CALL mysql.rds_rotate_general_log” , twice to free up disk space.
Instead of dropping general_log table, why not disable general_log, i.e modify the db-parameter and apply it to RDS instance.