homepage Welcome to WebmasterWorld Guest from 23.23.57.182
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
How To Determine What Part of Application is Hanging Up MySql Connecti
osoamor

5+ Year Member



 
Msg#: 3316497 posted 5:09 am on Apr 20, 2007 (gmt 0)

I'm running wordpress and smf forums on a site, both upgraded. For some reason, there are connections that aren't closing causing my entire server to grind to a hault. The support team at my colo basically said it's coming from bad code on one of my domains. But that was as far as they would go as they said they can't do anthing on the server. Their basic analysis was that code wasn't properly closing connections to the MYSQL.

When I shell in the command "c mysqld ¦ wc" it reports about 30 when the server is running smooth. The minute it crawls up to 50 +/-, the server basically stops responding. It will continue to climb, all the while not serving pages, but timing out.

How do I determine what is causing the closed connections? How do I go about finding the "bad" code?

I've got about 150k hits a day, and it just recently started.
Server: 512 mb ram, 80 gig, 2.0 gz
LAMP

Thanks
Michael

 

MrManager

5+ Year Member



 
Msg#: 3316497 posted 1:12 pm on Apr 22, 2007 (gmt 0)

Have you taken a look at the process list?

You could try to create different users for your different applications and then check the process list to see who has the most open connections.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved