PDA

View Full Version : MySQL log settings


Yabadoo
19th July 2008, 14:34
I was looking in my /var/log/mysql, and i saw a lot of mysql.bin.#### file's.
Is it safe to disable logging by commenting out the max_binlog_size in /etc/mysql/my.cnf.
Does this increase performance?
What can you do with these log file's?

Thanks in advance.

falko
20th July 2008, 13:39
You need these files for MySQL replication. If you don't use MySQL replication, you can disable the logging in your my.cnf.

Yabadoo
20th July 2008, 16:58
You need these files for MySQL replication. If you don't use MySQL replication, you can disable the logging in your my.cnf.

Thanks for the quick and usefull answer !!