Child pages
  • The auto-adjust-mysql-limits Script
This documentation is for cPanel & WHM version 80 EDGE builds.  The "RELEASE" version of our documentation can be found in the Version 78 Documentation space.


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