Biblioteca de cunoștințe

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.

Important:

You must run this script as the root user.

To run this script on the command line, use the following format:

/usr/local/cpanel/scripts/auto-adjust-mysql-limits [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`

WHM Scripts
Overview: The cPanel & WHM installation process adds important scripts to your server’s...

The dbmaptool Script
Overview: You can use the /usr/local/cpanel/bin/dbmaptool script to grant ownership of databases...

The servers_queue Script
Overview: This script allows you to manage the task queue system. The task queue system allows...

The autossl_check Script
Overview: The /usr/local/cpanel/bin/autossl_check script allows you to manually check the SSL...

The backup Script
Overview: Use the /usr/local/cpanel/bin/backup script to run a manual backup in WHM via the...