Troubleshooting a slow database server with no load
Posted
by
user1721724
on Server Fault
See other posts from Server Fault
or by user1721724
Published on 2013-06-27T14:24:43Z
Indexed on
2013/06/27
16:23 UTC
Read the original article
Hit count: 247
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.
© Server Fault or respective owner