Child pages
  • Tweak Settings - SQL
Skip to end of metadata
Go to start of metadata

This document is for a previous release of cPanel & WHM. To view our latest documentation, visit our Home page.

For cPanel & WHM 11.44

( Home >> Server Configuration >> Tweak Settings )

 

Include databases in disk usage calculations

This item allows you to select whether to include databases in disk usage calculations.

This item defaults to On.

 

Use INFORMATION_SCHEMA to acquire MySQL® disk usage

If you enable this setting, your server will use MySQL's INFORMATION_SCHEMA view to include disk usage by all MySQL tables in the disk usage totals.

If you disable this setting, WHM queries the filesystem for disk usage information. Table type usage and local configuration may cause inaccuracy in the disk usage totals.

This item defaults to On.

Note:

If you use a remote MySQL server, you must turn this setting On in order to calculate MySQL disk usage.

Warning:

This setting causes MySQL to become unresponsive until data collection is complete, which may degrade your system's performance.

 

Use pre-4.1-style MySQL ® passwords

This item allows you to select whether you wish to use old pre-MySQL 4.1 passwords with your current version of MySQL. This can be useful if you experience authentication problems with PHP scripts.

This item defaults to Off.

Important:

  • You must restart MySQL to apply this setting. Use WHM's SQL Server (MySQL) interface (Home >> Restart Services >> SQL Server (MySQL)) to restart MySQL.
  • This setting only applies to MySQL 5.5 and earlier. MySQL 5.6 removed support for old style passwords.
  • Your server will not automatically reset old-style passwords when you change this setting to Off. Any users with old-style passwords will be unable to authenticate until you or they reset their passwords. To reset old-style passwords, use cPanel's Change Password interface (Home >> Preferences >> Change Password) or WHM's Password Modification interface (Home >> Account Functions >> Password Modification).
  • To determine whether any users have old-style passwords, run the following query in the MySQL command prompt:

    mysql> SELECT user, Length(Password) FROM mysql.user;

    Users who return a 16-character length use the pre-4.1-style MySQL password.

 

Allow cPanel & WHM to determine the best value for your MySQL open_files_limit configuration

This item allows cPanel & WHM to determine the best value for your MySQL open_files_limit setting in your my.cnf configuration file. The system uses the total number of open tables in your databases to determine this value.

Newer versions of MySQL require additional file descriptors for each open table. A server with a large number of open tables (for example, servers with multiple installations of WordPress®) may require a value of open_files_limit that is greater than the default value of 2048. However, an extremely large open_files_limit setting requires more memory, and may cause performance issues.

This item defaults to On.


 

Allow cPanel & WHM to determine the best value for your MySQL max_allowed_packet configuration

This item allows cPanel to determine the best value for your MySQL max_allowed_packet setting in your my.cnf configuration file.

The max_allowed_packet setting determines the maximum size of a single packet for any generated or intermediate string. If you use very long BLOB columns or long strings, this setting must be large enough to handle them properly. However, an extremely large max_allowed_packet setting may catch unnecessarily large packets, and may cause performance issues.

This item defaults to On.

 

Allow cPanel & WHM to determine the best value for your MySQL innodb_buffer_pool_size configuration

This item allows cPanel to determine the best value for your MySQL innodb_buffer_pool_size setting in your my.cnf configuration file.

The innodb_buffer_pool_size setting determines the size of the memory buffer, in bytes, that the InnoDB storage engine uses to cache data and indexes of its tables. However, an extremely large innodb_buffer_pool_size setting requires more memory, and may cause performance issues.

If you select On for this setting, the system uses the following defaults:

  • For servers with less than 512 Megabytes (MB) of RAM, the system sets the innodb_buffer_pool_size setting to 8 MB.
  • For servers with between 512 MB and 4 Gigabytes (GB) of RAM, the system sets the innodb_buffer_pool_size setting to a proportional value that is between 8 and 128 MB.
  • For servers with more than 4 GB of RAM, the system sets the innodb_buffer_pool_size setting to 128 MB.

This item defaults to On.


Require a username prefix on names of new databases and database users

When you enable Database Prefixing, the system prefixes database names and database usernames with the first eight characters of the system username and an underscore (_). This makes it easier for you to determine which user owns a given database, but it reduces the number of characters that users can use for names of databases and database users.

Note

If you change the system account name, database names and database usernames that the account owns do not change.

This item defaults to On.