Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have few Drupal 6 websites on webhosting, which causes this strange problem:

  • some tables, especially Cache and Watchdog, tend to overhead,
  • when overhead is bigger than some amount of kB, MySQL server is refusing connection to given Drupal database or connection is broken during query execution,
  • Optimizing table (just overheaded rows) in phpMyAdmin is putting all back to normal.

But - until database is optimized, site is showing just MySQL errors, which is ugly... Where is a problem?

Thank you for any hints I could pass back to the hosting admins!

share|improve this question
    
What MySQL errors are you seeing? –  David Schwartz Oct 11 '12 at 9:25
    
Unfortunately usually "The connection to the server was reset while the page was loading." and/or "The connection to MySQL lost during the page loading." *****> E.g. now there were overheads in tables {cache} 52.1kB, {captcha_sessions} 9.4kB, {sessions} 10kB and {variable} 64B. Given error message: "The connection to the server was reset while the page was loading." =====> optimizing table {variables} did the trick (well, I've been optimizing in sequence {cache}, {sessions}, {variable}) to have website back and live. –  Michal Gow Oct 11 '12 at 18:00

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.