phpMyAdmin Performance Settings

phpMyAdmin Performance Settings

In cPanel & WHM version 68, there is an option to Enable/Disable phpMyAdmin information schema searches settings. If a large number of databases exist on a server, we can disable information schema searches by phpMyAdmin in MySQL.  If you disable this setting, the system disables information schema searches by phpMyAdmin in MySQL. This may improve phpMyAdmin performance. In this documentation, we are going to discuss about how to enable/disable phpMyAdmin information schema searches.

1) Log into your WHM.

2) Select “Server Configuration” from the options.

phpMyadmin performance settings

 

3) Go to “Tweak Settings” option.

phpMyadmin performance settings

 

4) Select the “Software” section from the menu.

phpMyadmin performance settings

 

5) In this page, we can see a new option “Enable phpMyAdmin information schema searches”. By default, it is enabled. But we can disable this option when a large number of databases exist on the server. Select the “Off” button to disable the information schema searches by phpMyAdmin in MySQL.

phpMyadmin performance settings

 

6) Click the “Save” button to save all the changes.

phpMyadmin performance settings

 

If you need any further help please do reach our support department.

 

 

Leave a Reply