Hi all, does anyone know what is the purpose of the following script:
/scripts/enable_sqloptimizer
Thanks in advance!
/scripts/enable_sqloptimizer
Thanks in advance!
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):
You can remove the entries with the following script:
Thanks!
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
Code:
/scripts/disable_sqloptimizer| Thread starter | Similar threads | Forum | Replies | Date |
|---|---|---|---|---|
| S | Purpose of Panopta process | Databases | 10 | |
| J | Cron job killing mysql - /usr/local/cpanel/scripts/update_db_cache | Databases | 3 | |
| M | Use /scripts/installpostgres without losing data | Databases | 4 | |
| J | /usr/bin/test -x /usr/local/cpanel/scripts/update_db_cache | Databases | 5 | |
| I | Problem with /usr/local/cpanel/scripts/update_db_cache | Databases | 21 |