cache table Mysql index impact on delete

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
navaneeth_r's picture

Hi

cache_clear_all('cache_name1', '');
cache_clear_all('cache_name2', '');
cache_clear_all('cache_name3', '');

Index of the cache table is updated for every cache_clear_all() for the same table. How to solve this? and How to optimize the cache tables?.

Please visit the advantage and disadvantage of index
http://www.mysqlfaqs.net/mysql-faqs/Indexes/What-are-advantages-and-disa...

Regards,
R.Navaneethakrishnan.

High performance

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds:

Hot content this week