That log rotation script smells like the culprit to me. Exactly what is
it doing?
If it is clipping the file in a way that doesn't let MySQL reset the
file pointer
when you do the flush logs command, you could be max-ing the file out
to its ulimit.
Cheers,
Kent
I am running MySQL 3.22.32 on a sun enterprise server, but I am having
problems with update logging. When update logging is specified in the
/etc/my.cnf file and the MySQl process restarted logging will commence
but will stop after a few hours (the number of hours is variable!).
Connecting to the