O'Reilly logo

Drupal 7 Development by Example Beginner's Guide by Kurt Madel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Time for action — — modifying the MySQL my.cnf settings

Mac OS X: MAMP does not use a my.cnf file by default. So you must copy the file at /Applications/MAMP/Library/support-files/my-medium.cnf to /Applications/MAMP/conf/my.cnf (notice the new name of the file).

Windows: For XAMMP, open the my.ini file located at C:\xampp\mysql\bin.

Note

You may want to make a back-up copy of this file before you begin to edit it.

Open the my.cnf/my.ini file in your text editor, and find and edit the following settings to match these values:

# * Fine Tuning
#
key_buffer = 16M
key_buffer_size = 32M
max_allowed_packet = 16M
thread_stack = 512K
thread_cache_size = 8
max_connections = 300

One of the real gotchas for the Drupal MySQL configuration is the max_allowed_packet ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required