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

Filed under:
|
|

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

Related posts about mysql

Related posts about router