Deleting the files from the command line is not considered the 'correct' way: http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
There should be a 'log-bin' line in your my.cnf.... just comment it if you don't want binary logs. Yes, they're mostly just used for master/slave replication, and point-in-time recovery. Instead of disabling it completely, I generally prefer to set expire_logs_days to some value, so MySQL automatically removes them after so many days. As for tuning values, that's not something we can just tell you... it depends entirely on your workload. If there were certain values everyone should set, they'd be the defaults :). Here's some good places to start though: http://www.day32.com/MySQL/ http://hackmysql.com/mysqlreport http://www.mysqlperformanceblog.com/ The tuning script on the first one will guide you through the most common tweaks you might need. mysqlreport is more in-depth, but less hand-holding... good for after the tuning primer one. The blog is just lots of general info... Good luck, Jake On Sat, Oct 25, 2008 at 5:50 AM, Grant Peel <[EMAIL PROTECTED]> wrote: > Hi all, > > I had a server pretty much locked up this morning due to the mysql bin logs > filling up the /var filesystem. > > I had been investigating the my.cnf settings file a white back, got > sidetracked, and never finished it. > > The bin logs are named: > > /var/db/mysql/myserver-bin.000001 > /var/db/mysql/myserver-bin.000002 > /var/db/mysql/myserver-bin.000003 > /var/db/mysql/myserver-bin.000004 > > I assume a new one is created each time the mysql server is started. I had to > shut down all services on the server, delete all these files and restart > everything. > > Anywho, the two questions are: > > 1. Are these files used when 'fixing' tables, or, are they only used for the > master/salve replication? > > 2. Is it safe to, and how do I, turn off the bin logs altogether (there are > no slave servers), > > 3. What my.cnf settings would you all reccomend for: > > Mysql4, running on, FreeBSD 6, 1 GB Memory, var fs is 5 GB, 250 virtual > domains on the server, of which 50 may be using mysql/php (for bulliten > boards etc). > (I am reading through the /usr/local/share/mysql *.cnf files ...) > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
