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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Correct Syntax (slow_query_log)

Discussion in 'Workarounds and Optimization' started by fdnven, Sep 3, 2013.

  1. fdnven

    fdnven Well-Known Member

    Joined:
    Feb 14, 2006
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    166
    Hi,

    what is the correct syntax to enable mysql slow query log. MYSQL is set to most current version for WHM 11.38.
    Is the below correct?
    Code:
    slow_query_log
    Thanks
    Frank
     
    #1 fdnven, Sep 3, 2013
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,782
    Likes Received:
    1,712
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    You can utilize the following entries in your /etc/my.cnf file:

    Code:
    slow-query-log=1
slow-query-log-file="/var/log/mysql-slow-queries.log"
    Ensure you create the "/var/log/mysql-slow-queries.log" file and it's owned by the "mysql" user.

    Thank you.
     
    #2 cPanelMichael, Sep 3, 2013
(You must log in or sign up to post here.)
Loading...
Similar Threads - Correct Syntax (slow_query_log)
  1. 01i

    Mail Service Information Incorrect

    01i, Apr 19, 2018 at 9:48 AM, in forum: E-mail Discussions
    Replies:
    1
    Views:
    41
    cPanelMichael
    Apr 19, 2018 at 1:42 PM
  2. darkr00t

    Returning message to sender issue IP not Setup correctly

    darkr00t, Apr 13, 2018, in forum: Bind / DNS / Nameserver Issues
    Replies:
    4
    Views:
    75
    cPanelLauren
    Apr 16, 2018
  3. WPHC

    EasyApache4 modules and packages correct ?

    WPHC, Mar 26, 2018, in forum: EasyApache
    Replies:
    7
    Views:
    106
    cPanelMichael
    Mar 26, 2018
  4. AS_Luis

    Webmail Usuario y contraseña incorrectos using Horde, roundcube y squirremail, solo con una cuenta

    AS_Luis, Mar 21, 2018, in forum: Discusión en Español
    Replies:
    5
    Views:
    128
    cPanelMichael
    Mar 22, 2018
  5. Ramize Attia

    Disk usage not correct

    Ramize Attia, Mar 12, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    88
    cPanelMichael
    Mar 12, 2018

Share This Page