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 MySQL server and doing a 'show variables' shows that
update logging is switched on. However no logfile is written even if a
specific flush-logs comand is issued. There is a script regularly
rotating the logfile (every 5 minutes) for replication purposes but no
other log rotation happenening. There is no filespace issue (the logfile
is being written to an 80 GB drive that it only 28% full) nor is there a
permissions problem (after all the logfile is written when the server is
started). Restarting the MySQL process will restart logging but it dies
after a few hours once again.
Has anyone out there had this problem or better yet know how to avoid
it??? Unfortunately upgrading to MySQL 3.23 is NOT an option.
Thanks in advance
Neil
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
