homepage Welcome to WebmasterWorld Guest from 54.227.20.250
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
MySql table overhead
Would table overhead kill Apache
Pollos

5+ Year Member



 
Msg#: 4112552 posted 7:34 pm on Apr 8, 2010 (gmt 0)

I normally keep an eye on table overhead in my MySql database. But two days ago my site began to really slow down to a crawl. I have a VPS which normally flies along but I couldn't even log into my Plesk cp at times it was so bad.

After looking at the tables in Phpmyadmin I noticed quite a few had some overhead ranging from only a few bytes to a thousand plus.

After 'optimising' them the server is back up to full speed. Would table overhead cause Apache to slow right down and stall at times?

 

whoisgregg

WebmasterWorld Senior Member whoisgregg us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 4112552 posted 1:28 pm on Apr 20, 2010 (gmt 0)

Would table overhead cause Apache to slow right down and stall at times?

It shouldn't. Was there anything else you might have done around the same time? Perhaps restarting apache or mysql?

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