Keep Server Online
If you find the Apache Lounge, the downloads and overall help useful, please express your satisfaction with a donation.
or
A donation makes a contribution towards the costs, the time and effort that's going in this site and building.
Thank You! Steffen
Your donations will help to keep this site alive and well, and continuing building binaries. Apache Lounge is not sponsored.
| |
|
 Topic: MySQL: FLUSH LOGS |
|
| Author |
|
Thog
Joined: 12 Feb 2007
Posts: 75
Location: Montreal
|
 Posted: Thu 15 Nov '07 19:46 Post subject: MySQL: FLUSH LOGS |
 |
|
| When i run the "flush logs" command, only the error.log file is flushed. Is the slow.log file supposed to be flushed also because it never is. Is this a bug or am I interpreting that command poorly? |
|
| Back to top |
|
tdonovan
Moderator
Joined: 17 Dec 2005
Posts: 611
Location: Milford, MA, USA
|
| Posted: Fri 16 Nov '07 4:41 Post subject: |
|
|
It appears to me that the slow log is being flushed correctly using MySQL 5.0.48 on win2k.
Unlike the error log, it is not renamed -old when it is flushed.
Any pending entries are written to disk, the file is closed, then it is re-opened (for append).
Were you expecting a name-slow.log-old file to appear?
FYI -here is what happens for FLUSH LOGS when the slow log is monitored with the Windows FileMon utility: | Quote: | 9:30:17.683 PM mysqld.exe:772 FLUSH C:\Program Files\MySQL\MySQL Server 5.0.48\data\tom4-slow.log SUCCESS
9:30:17.683 PM mysqld.exe:772 CLOSE C:\Program Files\MySQL\MySQL Server 5.0.48\data\tom4-slow.log SUCCESS
9:30:17.683 PM mysqld.exe:772 OPEN C:\Program Files\MySQL\MySQL Server 5.0.48\data\tom4-slow.log SUCCESS Options: OpenIf Access: 00120196
9:30:17.683 PM mysqld.exe:772 QUERY INFORMATION C:\Program Files\MySQL\MySQL Server 5.0.48\data\tom4-slow.log SUCCESS Length: 294
9:30:17.683 PM mysqld.exe:772 WRITE C:\Program Files\MySQL\MySQL Server 5.0.48\data\tom4-slow.log SUCCESS Offset: 294 Length: 147
|
-tom- |
|
| Back to top |
|
|
|
|
|
|
