MySQL not respond when overheaded
- by Michal Gow
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!