Tuesday, June 25, 2013

PHP-Mysql tuning for Drupal projects

Hi Guys,

If we installed a lot of number of modules in Drupal project, we see some heavy weight process(CCK field creation, clear performance, saving views , enabling/disabling modules etc.) takes so much time to be executed. Please follow some tips and then enjoy the magic in speed :).

Note: Please take backup of these files before to implement these steps.


" Drupal" settings

  1. Disable the "update" module to check status of installed modules
  2. Disable unused modules

" php.ini" settings

  1. memory_limit = 512M 
  2. max_execution_time = 180s
  3. realpath_cache_size = 2M

" my.ini" settings

  1. innodb_flush_log_at_trx_commit = 0
  2. key_buffer = 160M
  3. max_allowed_packet = 20M
  4. table_cache = 64 
  5. sort_buffer_size = 5120K
  6. net_buffer_length = 80K 
  7. read_buffer_size = 2560K
  8. read_rnd_buffer_size = 5120K 
  9. myisam_sort_buffer_size = 80M

No comments: