The phpMyAdmin on my local dev machine would take around 5-10 seconds to load up the list of databases in the left frame.
The puzzling thing was that the delay would only come up after a relatively long period of inactivity on the part of the database server which means it’s probably some sort of a caching issue.
Upon consulting the Status tab, the Created_tmp_disk_tables variable was coming up red. The advice given was “you may want to increase the tmp_table_size value”.
It so happens, that was exactly what was needed to be fixed.
- Open up the my.ini file in a text editor.
- Look for the tmp_table_size variable.
tmp_table_size=38M // This was mine - Change it to something larger like
tmp_table_size=144M - Restart your MySQL service.
- Enjoy the instant speed bump!
