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:
    110
    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:
    38,658
    Likes Received:
    1,425
    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. Michael Legg

    SOLVED License IP Incorrect

    Michael Legg, Oct 15, 2017 at 9:25 PM, in forum: General Discussion
    Replies:
    4
    Views:
    48
    cPWilliamL
    Oct 17, 2017 at 8:02 AM
  2. bananaphone

    Email From field being changed incorrectly

    bananaphone, Oct 12, 2017 at 6:05 AM, in forum: E-mail Discussions
    Replies:
    5
    Views:
    62
    Infopro
    Oct 13, 2017 at 4:35 AM
  3. linux4me2

    Files and Folders Uploaded By sFTP Have Incorrect Permissions

    linux4me2, Sep 8, 2017, in forum: EasyApache
    Replies:
    11
    Views:
    201
    cPanelMichael
    Oct 11, 2017
  4. speckados

    Incorrect behavior of the .yaml file editing process for FPM

    speckados, Sep 6, 2017, in forum: EasyApache
    Replies:
    3
    Views:
    94
    cPanelMichael
    Sep 7, 2017
  5. martin MHC

    How to uninstall a RPM correctly (answering a query).

    martin MHC, Aug 26, 2017, in forum: General Discussion
    Replies:
    4
    Views:
    146
    cPanelMichael
    Aug 30, 2017

Share This Page