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
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
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