RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX


Tip: Disabling Binary Logs in MySQL

Sometimes there are just too many logs available to sift through efficiently. Learn how to disable the binary logs in MySQL to cut down on the clutter.


Logs often come in handy for problem resolution. However, there are times when there are too many logs that are not useful from the developer's perspective.

One such log is the binary log in the MySQL database.

First, convert the file my.cnf in location /etc/my.cnf to unix format in case it is not. This will ensure that the file format is correct. You can use the dos2unix command.

Afterwards, comment the following lines in the my.cnf file"


Please note that the above are examples and the values may not necessarily be what you will use.

Do not forget to restart MySQL after this change.


Visit the DevX Tip Bank


Sridhar M S. is a Java developer from Bangalore, India. He holds a master's degree in Computer Science.
Email AuthorEmail Author
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date