> I just found that mysql 4.0.18 is doing binary logging. How can I > turn this off? <SNIP> > I do not see a nead for this, plus I fear that > it might fill up the file system, plus I think it is reducing performance. >
The binary log is primarily there to let you restore data. Say you backup every night at 04:00 and your database crashes at 15:00 you can restore from your backup but what about all those changes in the 11 hours after the backup was made? Instead you can use mysqlbinlog to run all the changes made in those 11 hours and get your data back to pretty much exactly where it was before the crash. According to the manual, the performance hit is about 1% - that's peanuts in exchange for the ability to recover your data. The other function of the binary log is to store statements that will be replicated on slave servers. That might not be relevant to you at the moment, but will perhaps be something you need later? If you really want to disable it, read the manual page at: http://dev.mysql.com/doc/mysql/en/Binary_log.html Russell. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]