Troubleshooting a slow database server with no load
- by user1721724
I'm getting ready to soft launch my website and I've run into some problems with what I think is being caused by my MySQL database running on Fedora.
All websites run fine, just as I'd expect, but any pages that establish a database connection hang until the connection is established, and then bang, the site loads as it should.
Ex. My landing page (http://www.thrusong.com) doesn't make a database connection and loads quickly. User profile pages (http://www.thrusong.com/john) make a database connection and load slowly, even though most of the data comes from memcached and the database currently has no load on it.
This problem just came up yesterday when my router died and I began using my Pace 2Wire modem with built-in router. Before, my old router was set to handle everything. My ISP says the settings in the modem are correct.
Any ideas? Thanks in advance.