[SOLVED] huge mysqld.log file

amolmistry · 08-03-2012, 11:06 PM

Hello,

I just found that mysqld.log is consuming more than 200 GB, will this affect to any website if I flush this file.

According to me since this is just log file, it won't affect to any website, correct?

Thanking you,

Ch405 · 08-03-2012, 11:16 PM

It's just a log file, you're okay to flush it. I'd also suggest turning mysql logging off, as it tends to slow down your mysql.

If you want to turn it off, just do this:

Code:

sudo nano /etc/mysql/my.cnf

and comment out the logging directives.

Code:

# general_log_file = /var/log/mysql/mysql.log
# general_log = 1

amolmistry · 08-03-2012, 11:22 PM

Thanks Ch405 for your valuable help.

Ch405 · 08-03-2012, 11:29 PM

You are of course welcome. I generally only use mysql logging when I'm installing new software that uses mysql, so I can catch errors. After that it goes back off.

amolmistry · 08-04-2012, 12:07 AM

one more thing, I've also found almost 66 GB files named updates.0000xx under mysql-logs folder, seems those are only update logs, is it safe to delete those as well, or those are required for further update reference?

amolmistry · 08-04-2012, 12:08 AM

and do we possible to prevent creating such files and is it safe?

Ch405 · 08-04-2012, 12:25 AM

I'm not quite confident in my knowledge of mysql to answer if it's safe to dump those files. You'll have to wait until someone else looks in this thread, sorry.

amolmistry · 08-04-2012, 02:08 AM

no problem Ch405, thanks for valuable help so far

chrism01 · 08-06-2012, 08:33 PM

As no-one has commented for a few days, try asking over at the mysql forums https://forums.mysql.com/