Drupal MySQL PHP

My Recommendation Performance Settings [Drupal]

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.




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.

One reply on “My Recommendation Performance Settings [Drupal]”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.