The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL.log

Discussion in 'General Discussion' started by Tom Pyles, Feb 4, 2003.

  1. Tom Pyles

    Tom Pyles Well-Known Member

    Joined:
    Apr 26, 2002
    Messages:
    254
    Likes Received:
    0
    Trophy Points:
    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?
     
    #1 Tom Pyles, Feb 4, 2003
  2. taivu

    taivu Well-Known Member

    Joined:
    Nov 22, 2001
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    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.
     
    #2 taivu, Feb 5, 2003
  3. Tom Pyles

    Tom Pyles Well-Known Member

    Joined:
    Apr 26, 2002
    Messages:
    254
    Likes Received:
    0
    Trophy Points:
    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%
     
    #3 Tom Pyles, Feb 5, 2003
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL
  1. Droidism20011

    MySQL -> MariaDB security questions

    Droidism20011, Jul 20, 2017 at 2:21 PM, in forum: Security
    Replies:
    2
    Views:
    51
    cPanelMichael
    Jul 21, 2017 at 11:24 AM
  2. Ahmed Hany

    Is it safe to delete: email_log_system_system.ibd in var/lib/mysql/rewllcxy_email/

    Ahmed Hany, Jul 11, 2017, in forum: General Discussion
    Replies:
    3
    Views:
    57
    cPanelMichael
    Jul 12, 2017
  3. mark4785

    MySQL DB Download Traces

    mark4785, Jun 30, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    71
    Infopro
    Jun 30, 2017
  4. sparek-3

    MySQL to MariaDB - what to expect?

    sparek-3, Jun 26, 2017, in forum: Database Discussions
    Replies:
    5
    Views:
    222
    DWaters
    Jul 4, 2017
  5. burn1024

    Munin mysql2 plugin isn't working

    burn1024, Jun 23, 2017, in forum: General Discussion
    Replies:
    1
    Views:
    60
    cPanelMichael
    Jun 26, 2017

Share This Page