Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


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

Browse other questions tagged or ask your own question.