Closed (fixed)
Project:
fastpath_fscache
Version:
6.x-1.x-dev
Component:
Miscellaneous
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
17 Apr 2009 at 15:11 UTC
Updated:
6 May 2009 at 13:30 UTC
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
Comment #1
kenorb commentedIncrease 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.
Comment #2
netbear commentedThanks 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?
Comment #3
kenorb commentedYou 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.
Comment #4
netbear commentedThanks one more time, kenorb I'll give it a try.