Note: Please go to docs.rightscale.com to access the current RightScale documentation set. Also, feel free to Chat with us!
Home > FAQs > I renamed my MySQL Slow log and now MySQL doesn't log slow queries

I renamed my MySQL Slow log and now MySQL doesn't log slow queries

Table of Contents

Background

Many people with large databases and applications, will find that their mysqlslow.log file will grow extensively and needs to be rotated periodically. If you haven't configured log rotation for the mysqlslow.log and decided to rename/move/delete it manually instead, you'll now find that MySQL hasn't created a new log file as you probably expected and instead, is no longer logging slow queries.

Answer

First and foremost, in order to enable log rotation for your logs on your instances, you should follow the following document:

http://support.rightscale.com/index.php?title=06-FAQs/FAQ_0174_-_How_do_I_configure_log_rotation_on_my_instances%3F

To re-enable your mysqlslow.log file on the instance you're having problems with, you'll need to log in to your database server via it's interactive mysql console and perform the following command:

SET GLOBAL SLOW_QUERY_LOG_FILE=/var/log/mysqlslow.log;

This command will reset the variable for the log file (Even though it's exactly the same as it was previously) and kickstart the logging process within MySQL, without having to restart the MySQL service.

You must to post a comment.
Last modified
21:29, 16 May 2013

Tags

Classifications

This page has no classifications.

Announcements

None


© 2006-2014 RightScale, Inc. All rights reserved.
RightScale is a registered trademark of RightScale, Inc. All other products and services may be trademarks or servicemarks of their respective owners.