Rick,
Flush slow logs (soon to be log or logs) is in the patch below. There
is a problem in that the slow query log can be flushed but there isn't
any code to rotate it. A flush reopens the file with a new header. In
a separate patch I'm going to update the slow, general, and error logs
so they rotate in numbered files like the binary logs. What do you
think?
-Eric
On Tue, May 13, 2008 at 10:15 AM, Rick James <rjames@stripped> wrote:
> FLUSH SLOW LOG; please
>
>
> MySQL Geeks - Consulting & Review
> Email: rjames@stripped
> Messenger : rjasdf
> http://twiki.corp.yahoo.com/view/Devel/MySQLGeeks
>
>
>
>> -----Original Message-----
>> From: Sergei Golubchik [mailto:serg@stripped]
>> Sent: Tuesday, May 13, 2008 12:16 AM
>> To: Eric Bergen
>> Cc: Internals List
>> Subject: Re: Adding new flush commands
>>
>> Hi!
>>
>> On May 12, Eric Bergen wrote:
>> > Hi,
>> >
>> > I'm trying to split the flush logs command into several different
>> > flush commands. Examples are;
>> > flush binary log;
>> > flush relay log;
>> >
>> > My problem is that when I add the log symbol the new
>> commands work but
>> > the log function is disabled with a parse error:
>> >
>> > mysqltest: At line 495: query 'select log()' failed with wrong errno
>> > 1064: 'You have an error in your SQL syntax; check the manual that
>> > corresponds to your MySQL server version for the right syntax to use
>> > near '()' at line 1', instead of 1582...
>> >
>> > If I change the commands to flush binary logs (as in the
>> patch below)
>> > it works great.
>> >
>> > Is there something special I have to define to prevent my log symbol
>> > from conflicting with the log function?
>>
>> Yes :(
>> You need to remove LOG function from item_create.cc and add
>> an explicit
>> rule for it in sql_yacc.yy. See rules function_call_keyword,
>> function_call_nonkeyword, function_call_generic,
>> function_call_conflict
>> there.
>>
>> Regards / Mit vielen Grüssen,
>> Sergei
>>
>> --
>> __ ___ ___ ____ __
>> / |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
>> / /|_/ / // /\ \/ /_/ / /__ Principal Software
>> Engineer/Server Architect
>> /_/ /_/\_, /___/\___\_\___/ Sun Microsystems GmbH, HRB
>> München 161028
>> <___/ Sonnenallee 1, 85551
>> Kirchheim-Heimstetten
>> Geschäftsführer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
>> Vorsitzender des Aufsichtsrates: Martin Häring
>>
>> --
>> MySQL Internals Mailing List
>> For list archives: http://lists.mysql.com/internals
>> To unsubscribe:
>> http://lists.mysql.com/internals?unsub=1
>>
>>
>
> --
> MySQL Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe: http://lists.mysql.com/internals?unsub=1
>
>
--
high performance mysql consulting.
http://provenscaling.com
