Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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. inteldigital

    New Thread MySQL desynchronising passwords with WHM/PhpMyAdmin

    inteldigital, Oct 19, 2018 at 6:54 PM, in forum: General Discussion
    Replies:
    1
    Views:
    23
    24x7server
    Oct 20, 2018 at 1:11 AM
  2. BluePlanet

    New Thread Run a MySQL query on database on different cPanel account

    BluePlanet, Oct 19, 2018 at 9:35 AM, in forum: Database Discussion
    Replies:
    0
    Views:
    27
    BluePlanet
    Oct 19, 2018 at 9:35 AM
  3. Nirjonadda

    New Thread MySQL/MariaDB Upgrade

    Nirjonadda, Oct 19, 2018 at 2:55 AM, in forum: Database Discussion
    Replies:
    0
    Views:
    26
    Nirjonadda
    Oct 19, 2018 at 2:55 AM
  4. Aldeahost

    MySQL or MariaDB?

    Aldeahost, Oct 16, 2018 at 3:47 AM, in forum: Database Discussion
    Replies:
    2
    Views:
    85
    cPanelLauren
    Oct 17, 2018 at 6:31 PM
  5. Maning

    MYSQL high cpu usage issue

    Maning, Oct 13, 2018, in forum: Workarounds and Optimization
    Replies:
    1
    Views:
    79
    cPanelLauren
    Oct 19, 2018 at 1:31 PM

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice