I have a Drupal 7 site with ~70,000 nodes and ~500,000 terms. During some investigations for the cause of substantial performance problems, I found out that the database table cache_views_data is about 18 GB big. Is this normal?

UPDATE: I am using time based and contend based (Views content cache) caching.

  • Do you have views caching enabled on any of your views? – 4life Jun 3 '13 at 17:48
  • Yes, I am using time based and contend based (Views content cache) caching. – user5950 Jun 3 '13 at 17:55
  • 1
    Yes I have cron running. I think the table is growing, but hard to say, how and when. I mean, I don't know if growing is caused by the growing number of nodes or by something else. – user5950 Jun 3 '13 at 21:00
  • 1
    The table has ~8,534,796 entries, something smalls funny here, doesn't it? – user5950 Jun 3 '13 at 21:43
  • 1
    It seems that the table does not get flushed nieghter when the cron runs nor when I execute drush cc all... – user5950 Jun 3 '13 at 23:06

There is no normal size, it depends on your site, but I think that there's some error because this table grows exponentially.

My site was down because the size of this table. In my case, with a few views & something like 1000 users this table was 29 Gigabits. I deleted it and then everything went back to normal.

I suggest you to keep an eye on the tables of your database, specifically this table.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.