Re: Slow query log file not getting updated
Baron Schwartz <[email protected]>
| Newsgroups | gmane.comp.db.mysql.devel |
|---|---|
| Message-ID | <CADPxqFZVn=dEFuXC_Wb=LVf5Mcwy6VM4+ZdTaRyq+SeNHLZaXQ@mail.gmail.com> |
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 <[email protected]> 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 -- MySQL Internals Mailing List For list archives: http://lists.mysql.com/internals To unsubscribe: http://lists.mysql.com/internals