Yearly Archives: 2011

Amazon RDS: Rotating slow_log and general_log

2 Replies

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.

Amazon AWS Cloud Formation

Leave a reply

Amazon has just announced the new feature, where most of services are consolidate and using templates. Cool.

“Dear Amazon Web Services Customer,

We’re excited to introduce AWS CloudFormation, a new service that gives developers and businesses an easy way to create a collection of AWS resources and provision them in an orderly and predictable fashion. Customers can use AWS CloudFormation sample templates or create their own templates to describe the AWS resources, and any associated dependencies or runtime parameters, required to run their application. CloudFormation takes care of provisioning your resources for you. AWS CloudFormation can be accessed via the AWS Management Console, CloudFormation command line tools or APIs. The service is available at no additional charge and customers pay only for the AWS resources required to run the application. To get started using AWS CloudFormation, visit http://aws.amazon.com/cloudformation/.
“