Categories
Drupal

[Drupal] Disable secure connection (https://)

You might sometimes want or face issue that your drupal always redirect to secure connection (https://) protocol. You might want to disable it, especially in local development environment. Note: It’s always a good idea to have the secure connection in production server if it’s available, but normally it costs you extra on that feature on…

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…

Categories
Drupal PHP

Maximum execution time of 60 seconds exceeded [Drupal]

The error: Maximum execution time of 60 seconds exceeded When you execute some PHP script that spends longer time than the configuration of php.ini (which is sometimes is 30 or 60 seconds). With drupal, you might need much in your local development so let’s change in php.ini at: xampp\php\php.ini variable: max_execution_time To value (zero, no…

Categories
MySQL

MySQL server has gone away, Issue & Solution [drupal]

MySQL server has gone away, issue on drupal, drupal ecommerce kickstart gives me alot of headache since I do not first aware that the issue because of there are so many packets execution on mysql with drupal. The full error is (or similar): Additional uncaught exception thrown while handling exception. Original PDOException: SQLSTATE[HY000]: General error:…