phpMyAdmin Performance Settings

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.

  • 0

How to Enable Plaintext Authentication in Dovecot?

How to Enable Plaintext Authentication in Dovecot? Dovecot is an IMAP or POP3 server for...

Install Apache Tomcat using EasyApache4

Install Apache Tomcat using EasyApache4 The Apache Tomcat is an Apache module that provides a...

How to Enable Extended Logging in Exim

How to Enable Extended Logging in Exim The extended Exim logs in cPanel server will help you to...

Maximum number of connections from user+IP exceeded

Maximum number of connections from user+IP exceeded If you are getting an error like ‘ Error –...

How To Set Up Remote Access Key in WHM

How To Set Up Remote Access Key in WHM Remote Access Key is a cPanel feature that allows...