5

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.

Improve this question
8
  • Do you have views caching enabled on any of your views?
    – 4life
    Jun 3, 2013 at 17:48
  • Yes, I am using time based and contend based (Views content cache) caching.
    – user5950
    Jun 3, 2013 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, 2013 at 21:00
  • 1
    The table has ~8,534,796 entries, something smalls funny here, doesn't it?
    – user5950
    Jun 3, 2013 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, 2013 at 23:06

1 Answer 1

Reset to default
0

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 and acknowledge that you have read and understand our privacy policy and code of conduct.

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