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:
    37,064
    Likes Received:
    1,287
    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. kenrbnsn

    SOLVED Updated OpenSSH Incorrectly

    kenrbnsn, Aug 3, 2017, in forum: General Discussion
    Replies:
    6
    Views:
    112
    kenrbnsn
    Aug 5, 2017
  2. caroseuk

    SOLVED Correct DNS settings but AutoSSL Domain Validation failing

    caroseuk, Jul 14, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    3
    Views:
    171
    cPanelMichael
    Jul 17, 2017
  3. Shane Elmer

    SOLVED URL Redirecting Incorrectly in WHMCS to cPanel Connection

    Shane Elmer, Jun 30, 2017, in forum: User Experience
    Replies:
    13
    Views:
    594
    Shane Elmer
    Jun 30, 2017
  4. Mehrdad Tari

    SOLVED Changed Owner of Files Incorrectly

    Mehrdad Tari, Jun 25, 2017, in forum: E-mail Discussions
    Replies:
    8
    Views:
    267
    Mehrdad Tari
    Jul 9, 2017
  5. Carl Beebe

    SOLVED Email Not Setup Correctly

    Carl Beebe, Jun 1, 2017, in forum: E-mail Discussions
    Replies:
    4
    Views:
    140
    cPanelMichael
    Jun 1, 2017

Share This Page