Hello, my question is in title of the post. I keep my site on the shared hosting and though it is not high loaded at all (may be 100 users per day) and it periodically is working fine BUT suddenly the server gives "error 500" or "mysql server is gone away" and it keeps giving such errors for HOURS. On the same server I have another site - static and it opens fine in such periods when drupal site is down. So can this module help my site to serve requests when database is totally not accessable? Thanks.

Comments

kenorb’s picture

Status: Active » Fixed

Increase your max_packet_size in your MySQL config.
Check also this: #317775: Caching entire {menu_router} table causes MySQL error/slow rebuilds and slows menu_link_save

Or install this module:
#361967: Increase MAX_JOIN_SIZE and MAX_ALLOWED_PACKET settings in system.install

It should fix your errors.

If your problems are related to cache_ tables, this module can help you to not cache large data into your database.
If you can't increase max_packet_size in your MySQL config, it can help.

netbear’s picture

Thanks for your reply, kenorb, I'll try this, but as I writed before, my situation is different - MySQL does not give error about max_packet_size overhead. It does not responce at all. And server gives error 500 (or sometimes - MySQL server is gone away). So I'd like to my site to serve requests at least for unregistered users without any MySQL connection. Is it possible with fastpath_fscache module or MySQL connection is needed to serve anonimous users even with this module?

kenorb’s picture

You can also check http://drupal.org/project/boost
It's very good if you want to serve for anonymous users static pages without any MySQL query.
Mostly 'MySQL server is gone away' is related to max_packet_size problem. Try to increase it and check if this will help.

netbear’s picture

Thanks one more time, kenorb I'll give it a try.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.