Amazon RDS: Rotating slow_log and general_log

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.

2 thoughts on “Amazon RDS: Rotating slow_log and general_log

  1. jlcooke

    But you still can’t drop the general_log table with the access given by amazon. How does one drop this table?

  2. rodney Post author

    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.

Leave a Reply

Your email address will not be published. Required fields are marked *