You can find our user documentation at docs.cpanel.net.

Check out our new API beta site!

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

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

There is no content with the specified labels

There is no content with the specified labels

There is no content with the specified labels