2010-11-26, Fri

phpMyAdmin delay when loading database list

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.

  1. Open up the my.ini file in a text editor.
  2. Look for the tmp_table_size variable.
    tmp_table_size=38M // This was mine
  3. Change it to something larger like
  4. Restart your MySQL service.
  5. Enjoy the instant speed bump!
Isaac Su

tags: database delay list mysql phpmyadmin speed