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.

SOLVED Purpose of /scripts/enable_sqloptimizer?

Discussion in 'Database Discussions' started by Valetia, Dec 30, 2016.

  1. Valetia

    Valetia Well-Known Member

    Joined:
    Jun 20, 2002
    Messages:
    209
    Likes Received:
    1
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    Hi all, does anyone know what is the purpose of the following script:

    /scripts/enable_sqloptimizer

    Thanks in advance!
     
  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 @Valetia,

    This will activate slow query logging for MySQL with the addition of the following entries in the system's /etc/my.cnf file (the entries may look different, depending on the version of MySQL installed on your system):

    Code:
    slow-query-log=1
    long-query-time=1
    You can remove the entries with the following script:

    Code:
    /scripts/disable_sqloptimizer
    Thanks!
     
Loading...

Share This Page