Database tweaks
Component ID
464858
Component name
Database tweaks
Component type
module
Maintenance status
Development status
Component security advisory coverage
not-covered
Downloads
2740
Component created
Component changed
Component body
Project merged into Drupal Tweaks module
Please use following module instead:
Drupal Tweaks
-------------------
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
Read more about those variables:
http://dev.mysql.com/doc/refman/5.1/en/server-session-variables.html
And SQL Modes:
http://dev.mysql.com/doc/refman/5.1/en/server-sql-mode.html
Note: It will not work on servers, where your account don't have proper privileges!
You can also follow similar topics:
#361967: Increase MAX_JOIN_SIZE and MAX_ALLOWED_PACKET settings in system.install
You can also read:
http://drupal.org/node/259580 ("Warning: MySQL server has gone away" - Tune MySql to resolve this problem)
http://www.palantir.net/blog/beware-mysql-51-my-son