This module allow you to enable and change following settings in database:
- SQL_BIG_SELECTS
- MAX_JOIN_SIZE
- MAX_ALLOWED_PACKET
- WAIT_TIMEOUT
and changing SQL_MODES.
This module is very useful in situations like, when the DB is overloaded with too many fields in CCK or very big queries (cache queries) it will throw "mysql gone away" error in drupal. This is actually a common error in these situations. The Fix is we need to increase the Packet size in my.cnf or my.ini file in Mysql folder. But in situations like if in Live sites where we don't have access to these files "my.cnf" if the error comes it will be difficult to handle in those situations you can use this module.
You can find the module at : http://drupal.org/project/db_tweaks
No comments:
Post a Comment