Thursday, November 8, 2012

Speed up your local Drupal development environment

A friend came across an interesting suggestion for speeding up the database interactions on my local development environment on this page: 

http://drupal.org/node/469086

 Basically it's just some changes to mysql's my.ini configuration file:

 innodb_buffer_pool_size = 1G
innodb_flush_log_at_trx_commit = 2
innodb_thread_concurrency=8
transaction-isolation=READ-COMMITTED

Then restart mysql.

The improvement will probably vary.
Posted by at

2 comments:

  1. pauline taylorNovember 22, 2012 at 2:50 AM

    I changed this code in my configuration file but still it's same as before..

    ReplyDelete
  2. Anthony RobertsonNovember 22, 2012 at 9:15 AM

    Remember to restart mysql, and flush your drupal caches too. The improvement might not be staggering but I hope it helps.

    ReplyDelete

Subscribe to: Post Comments (Atom)