I have one MySQL database that is about 2 gig, 70 tables, 17million rows total.
I've checked my queries and slow query logs and there seems to be no big issues there. I've done explain on many queries and nothing real slow going on.
However, my database seems to take a while to respond at times. The execution times are fine, just takes time to respond. Some times pages on my website will just cause the browser to say "connecting..." for about 4-5 seconds before the page starts loading.
One other things I noticed:
When I just load the database in phpmyadmin, it takes about 3-5 seconds to just list all the tables and the database structure
Any ideas what might be causing this bottleneck? or ways I can try to improve this "listing of tables" in phpmyadmin to see if that's the cause?
It seems like perhaps it is taking a while to make a mysql connection or something?