Categories
Drupal MySQL PHP

My Recommendation Performance Settings [Drupal]

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. php.ini max_execution_time=5000 memory_limit=1024M my.ini [mysqld] max_allowed_packet = 128m sort_buffer_size…

Categories
MySQL

MySQL: The InnoDB memory heap is disabled

When you start your MySQL server, check in the log, you might found this warning message: [Note] InnoDB: The InnoDB memory heap is disabled The memory heap is related to performance of the MySQL with engine of InnoDB Solutions The issue would be solved by provide the setting in my.cnf/my.ini as [mysqld] # Comment the…