I posted some posts about drupal since I started to implement things with drupal.
- Issue with “Maximum execution time“
- Issue with “MySQL server has gone away“
- And still with memory “The InnoDB memory heap“
Here is my own recommendation for Drupal or some heavy PHP/MySQL application.
[mysqld] max_allowed_packet = 128m sort_buffer_size = 512K ## You can set .._buffer_pool_size up to 50 - 80 % innodb_buffer_pool_size = 512M innodb_additional_mem_pool_size = 2M innodb_use_sys_malloc = 0
I applied above setting with my environment
- XAMPP v3.2.1: PHP 5.5.3, MySQL 5.6.14, Apache 2.4.4
- Windows 7-64bit, Core i5
- RAM 8GB
I am interesting to see if above settings work for you or not in order to be clear that this recommendation is helpful, please drop me a comment.