Re: Lots of queries doing "statistics"

2007-08-11 Thread Sean Pringle
On 8/10/07, Stut <[EMAIL PROTECTED]> wrote: > Hi all, > > I'm working on a site at the moment that experiences a strange problem > when the traffic passes a certain point. > > Active connections are usually < 50, but at about 9pm every evening (our > peak time) they suddenly leap up to max_connecti

Re: purge slow query log

2007-08-07 Thread Sean Pringle
On 8/7/07, Boyd Hemphill <[EMAIL PROTECTED]> wrote: > 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. > T