Child pages
  • The auto-adjust-mysql-limits Script
For cPanel & WHM version 76

Skip to end of metadata
Go to start of metadata

Overview

The /usr/local/cpanel/scripts/auto-adjust-mysql-limits script updates MySQL® configuration values for the following cPanel & WHM settings:

  • Allow cPanel & WHM to determine the best value for your MySQL open_files_limit configuration?
  • Allow cPanel & WHM to determine the best value for your MySQL max_allowed_packet configuration?
  • Allow cPanel & WHM to determine the best value for your MySQL innodb_buffer_pool_size configuration?

You can configure these settings in the SQL section of WHM's Tweak Settings interface (WHM >> Home >> Server Configuration >> Tweak Settings).

This script runs when whenever you update the MySQL-related tweak settings and when you transfer or restore an account.

The auto-adjust-mysql-limits script

To use the /usr/local/cpanel/scripts/auto-adjust-mysql-limits script, run the following command as the root user:

/usr/local/cpanel/scripts/auto-adjust-mysql-limits [flags]

Flags

The /usr/local/cpanel/scripts/auto-adjust-mysql-limits  script accepts the following flags:

FlagDescription
--verboseDisplay messages about these limits when the script runs.
--debug

Do not update MySQL.

--helpDisplay a help message.
--no-restartDo not restart MySQL after the script runs.

Additional documentation