I would like to empty the slow query log without restarting MySQL.
If I simply delete lines, the server will no longer write to the file. I have
tried leaving the header, but still no writes unless I restart MySQL.
I am on RHEL4.
The group and owner of the file are correct:
4 -rw-rw---- 1 mysql mysql 157 Aug 7 06:32 slow_query_log
Thanks in advance.
CONFIDENTIALITY NOTICE: This email & attached documents may contain
confidential information. All information is intended only for the use of the
named recipient. If you are not the named recipient, you are not authorized to
read, disclose, copy, distribute or take any action in reliance on the
information and any action other than immediate delivery to the named recipient
is strictly prohibited. If you have received this email in error, do not read
the information and please immediately notify sender by telephone to arrange
for a return of the original documents. If you are the named recipient you are
not authorized to reveal any of this information to any other unauthorized
person. If you did not receive all pages listed or if pages are not legible,
please immediately notify sender by phone.
