List:Internals« Previous MessageNext Message »
From:Baron Schwartz Date:March 21 2012 11:32am
Subject:Re: Slow query log file not getting updated
View as plain text  
The general MySQL list is better for this type of question.

The typical problem is that the server is writing to an open
filehandle that has been deleted from the filesystem, and the file
that you think the server should use is actually not open.  You can
find out like this on a typical Linux system:

$ lsof -p $(pidof mysqld) | grep deleted

On Tue, Mar 20, 2012 at 4:21 PM, Revathi Rangachari <masrrev@stripped> wrote:
> Hi
>
> In one of the replicated slave servers, the slow query log file is not getting
> updated.  The configuration settings in this slave are similar to other slaves.
>
> Is there any other reason, why the slow query log file not getting updated? Updates
> were happening earlier.  The log file was truncated once due to its increasing size.
> Could this be a reason for updates not happening?
>
> Appreciate a line in reply
>
> Thanks
> Revathi R
>
> --
> MySQL Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe:    http://lists.mysql.com/internals
>



-- 
Baron Schwartz
Win free MySQL conference tickets! http://goo.gl/mvZ4W
Thread
MySQL Audit FunctionAruna Karunarathna5 Feb
  • Re: MySQL Audit FunctionAntony T Curtis5 Feb
    • Re: MySQL Audit FunctionPaul DuBois12 Apr
      • Re: MySQL Audit FunctionAntony T Curtis13 Apr
        • Re: MySQL Audit FunctionPaul DuBois13 Apr
          • RE: MySQL Audit FunctionRick James18 Apr
            • Re: MySQL Audit FunctionSergei Golubchik18 Apr
  • re: MySQL Audit FunctionMichael Widenius21 Feb
    • Re: re: MySQL Audit FunctionSergei Golubchik22 Feb
      • memcache vs.query_cacheRevathi Rangachari23 Feb
        • re: memcache vs.query_cacheMichael Widenius24 Feb
          • re: memcache vs.query_cacheRevathi Rangachari25 Feb
          • Re: memcache vs.query_cacheRick James27 Feb
            • query_cache_type and Aborted ClientsRevathi Rangachari1 Mar
              • Re: query_cache_type and Aborted ClientsRick James1 Mar
                • Re: query_cache_type and Aborted ClientsRevathi Rangachari5 Mar
                  • Re: query_cache_type and Aborted ClientsRick James5 Mar
                    • have_query_cache and query_cache_typeRevathi Rangachari6 Mar
                      • Re: have_query_cache and query_cache_typeYves Trudeau7 Mar
                • Slow query log file not getting updatedRevathi Rangachari20 Mar
                  • Re: Slow query log file not getting updatedBaron Schwartz21 Mar