The auto-adjust-mysql-limits Script
Valid for versions 82 through the latest version
Version:
82
Last modified: June 21, 2021
Looking for this interface?
Your hosting provider can enable or disable this interface for resellers in WHM's Edit Reseller Nameservers and Privileges interface (WHM >> Home >> Resellers >> Edit Reseller Nameservers and Privileges).
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.
root
user.
Run the script
To run this script on the command line, use the following format:
/usr/local/cpanel/scripts/auto-adjust-mysql-limits [options]
Options
Use the following options with this script:
Options | Description | Example |
---|---|---|
--verbose |
Display messages about these limits when the script runs. | /usr/local/cpanel/scripts/auto-adjust-mysql-limits --verbose |
--debug |
Do not update MySQL. | /usr/local/cpanel/scripts/auto-adjust-mysql-limits --debug |
--help |
Display a help message. | /usr/local/cpanel/scripts/auto-adjust-mysql-limits --help |
--no-restart |
Do not restart MySQL after the script runs. | /usr/local/cpanel/scripts/auto-adjust-mysql-limits --no-restart |