Re: MySQL version 4.0.23 uses 99% of processor on FreeBSD 4.11

2006-07-17 Thread Jeremiah Foster
On Fri, 2006-07-14 at 09:47 -0300, Miles Thompson wrote: > At 09:15 AM 7/14/2006, Jeremiah Foster wrote: > >Nearly once or twice a day the mysql daemon on our FreeBSD server has to > >be restarted since it is taking up most of the processor. > > > >That is about 3 hours and a billion rows examined.

Re: MySQL version 4.0.23 uses 99% of processor on FreeBSD 4.11

2006-07-14 Thread Miles Thompson
At 09:15 AM 7/14/2006, Jeremiah Foster wrote: Hello, Nearly once or twice a day the mysql daemon on our FreeBSD server has to be restarted since it is taking up most of the processor. One of the entries in our slow_queries log looks like this; # Query_time: 14074 Lock_time: 0 Rows_sent: 11