MySQL.log

T

Tom Pyles

Well-Known Member
Apr 26, 2002
254
0
316
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?
 
T

taivu

Well-Known Member
Nov 22, 2001
65
0
306
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.
 
T

Tom Pyles

Well-Known Member
Apr 26, 2002
254
0
316
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%
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
S How to store mysql 'slow_query_log' file under '/var/log' directory Databases 1
S How to disable way of interactive password specification when login to mysql database in command line Databases 3
C mysql 5.6 to MariaDB 10.3.29 - sql error logging issues Databases 6
F CPANEL-35991 - Bug in MySQL 5.6 to 5.7 upgrade (error log)? Databases 9
L how can i access on access_log of mysql? Databases 2
Similar threads
How to store mysql 'slow_query_log' file under '/var/log' directory
How to disable way of interactive password specification when login to mysql database in command line
mysql 5.6 to MariaDB 10.3.29 - sql error logging issues
CPANEL-35991 - Bug in MySQL 5.6 to 5.7 upgrade (error log)?
how can i access on access_log of mysql?
Top Bottom