DB Impact

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
navaneeth_r's picture
Posted by navaneeth_r on October 5, 2009 at 1:53pm

Hi,
On analyzing the process list in our heavy traffic site, we found numerous "lock/Unlock {cache} table " sleep queries.
Is it neccessary to lock cache tables whenever we update/insert cache.
In drupal 6 version of cache_set() the db_lock_table()/ db_unlock_table() has been removed.
Can we do this changes in drupal5?.
Will this affect sites default cache mechanism and performance?.

Categories:

Comments

Check out memcache

Posted by failedvagabond on October 5, 2009 at 2:16pm
failedvagabond's picture

We got around this issue on our d5 installation by moving cache out of the database and into memory via the memcache module: http://drupal.org/project/memcache. It gave us a terrific performance boost.

Hi Thanks for your reply. I

Posted by navaneeth_r on October 6, 2009 at 4:49am
navaneeth_r's picture

Hi

Thanks for your reply. I need to know that why drupal6 cache_set has no db_lock_table() and db_unlock_table(). Can you suggest.

Thanks