MySQL NOW() function producing 0000-00-00 00:00:00

2006-08-25 Thread Jeremiah Foster
Hello all, We are using an NOW() function in our database and occasionally it produces odd results. There are entries where it states: -00-00 00:00:00 instead of the current time. Is this a bug, or are we using the function incorrectly? MySQL version info: mysql Ver 12.22 Distrib 4.0.26, for

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

MySQL version 4.0.23 uses 99% of processor on FreeBSD 4.11

2006-07-14 Thread Jeremiah Foster
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 Rows_examined: 1020472928 SELECT pp.art_num, pp