MySQL.log

Tom Pyles · Feb 4, 2003

Our /var partition has become almost full. I've cleared out as much as I can, such as old logs (log.1 etc) One log I've found is my mysql.log file is 4 gigs. Will there be any harm in me deleting this log file?

taivu · Feb 5, 2003

I don't have that file on CPanel servers, but I do have one on my development system (/var/log/mysql.log). It is a log of MySQL commands (mainly queries) run on the system.

Run &tail mysql.log& to see what it has in it. If it's indeed a log of MySQL commands and you have no use for them, go ahead and delete the file.

If you want to prevent the log from being created in the first place, open &/etc/my.cnf& in your favourite editor and comment out or remove the line: log = /var/log/mysql.log. Restart MySQL for the changes to take effect.

Tom Pyles · Feb 5, 2003

taivu,
Thanks for the reply...Looking at the file it was mostly from a client running a message board...the client went to a dedicated server this week so I deleted the file. My /var partition went from 96% to roughly 6%

Thread starter	Similar threads	Forum	Replies	Date
A	Is it safe to delete: email_log_system_system.ibd in var/lib/mysql/rewllcxy_email/	General Discussion	3	Jul 11, 2017
G	--log-error/var/lib/mysql/localhost.localdomain.err --open-files-limit10000	General Discussion	6	Dec 27, 2015
B	"Trojan Horses Detected" but only rsyslogd and mysqld. New server, scans shows clean	General Discussion	2	Aug 30, 2011
A	Internal server error with mysqli and no log entry	General Discussion	6	Apr 5, 2011
M	Contents of /var/lib/mysql - Huge log files?	General Discussion	3	Sep 9, 2009

Search

Search

MySQL.log

Tom Pyles

Well-Known Member

taivu

Well-Known Member

Tom Pyles

Well-Known Member