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
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.