I posted some posts about drupal since I started to implement things with drupal.

Here is my own recommendation for Drupal or some heavy PHP/MySQL application.

php.ini

max_execution_time=5000
memory_limit=1024M

my.ini

[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

Info

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.