If you’re ever noticed phpMyAdmin take a long time to load whilst navigating your cPanel server, the fix could be simpler than you think!
First of all, you need to login to WHM (Web Host Manager) and visit Tweak Settings (under Server Configuration). From here, navigate to the SQL tab and check the status of the “Use INFORMATION_SCHEMA to acquire MySQL disk usage” setting. As standard with all cPanel installations, it is enabled.
If we read the description provided cPanel themselves:
Using INFORMATION_SCHEMA ensures that disk usage by MySQL tables is included in totals. However, enabling this option may cause a significant drop in performance as MySQL may become unresponsive until data collection is complete. Disabling this option causes the system to query the filesystem directly, potentially excluding disk space used by some database tables. Note: If you use a remote MySQL server, you must turn this setting On in order to calculate MySQL disk usage.
It’s the bit written above in bold that we’re most interested in, which may be relevant to the slowness you’re seeing.
Before you disable INFORMATION_SCHEMA, make certain that you’re happy with the disadvantage in doing so, in that there may be inaccuracies with the reporting of your MySQL disk space usage.
More information about this setting can be found in the cPanel documentation.