Over many months I see that the table cache_views_data.ibd fills the disk extremly. On my site it has grown to 18 GB where the rest of the raw data is very small.

It looks like views cache is not cleaned up by cron. Is this a known bug?

Comments

hass’s picture

hass commented

Here is the files list, that you get a feeling about the data size:

total 26452328
drwx------ 2 mysql mysql       12288 Dec 21 11:48 .
drwxr-xr-x 7 mysql mysql        4096 Jan  9 12:45 ..
-rw-rw---- 1 mysql mysql        8652 May 26  2010 access.frm
-rw-rw---- 1 mysql mysql       98304 May 26  2010 access.ibd
-rw-rw---- 1 mysql mysql        8814 May 26  2010 accesslog.frm
-rw-rw---- 1 mysql mysql      131072 May 26  2010 accesslog.ibd
-rw-rw---- 1 mysql mysql        8712 May 26  2010 actions.frm
-rw-rw---- 1 mysql mysql       98304 May 26  2010 actions.ibd
-rw-rw---- 1 mysql mysql        8558 May 26  2010 actions_aid.frm
-rw-rw---- 1 mysql mysql       98304 May 26  2010 actions_aid.ibd
-rw-rw---- 1 mysql mysql        8662 May 26  2010 advanced_help_index.frm
-rw-rw---- 1 mysql mysql      114688 Apr 20  2011 advanced_help_index.ibd
-rw-rw---- 1 mysql mysql        8658 May 26  2010 authmap.frm
-rw-rw---- 1 mysql mysql      114688 May 26  2010 authmap.ibd
-rw-rw---- 1 mysql mysql        8662 May 26  2010 batch.frm
-rw-rw---- 1 mysql mysql    10485760 Jun  1  2010 batch.ibd
-rw-rw---- 1 mysql mysql        8968 May 26  2010 blocks.frm
-rw-rw---- 1 mysql mysql      131072 Jul  1  2010 blocks.ibd
-rw-rw---- 1 mysql mysql        8624 May 26  2010 blocks_roles.frm
-rw-rw---- 1 mysql mysql      114688 May 26  2010 blocks_roles.ibd
-rw-rw---- 1 mysql mysql        8652 May 26  2010 boxes.frm
-rw-rw---- 1 mysql mysql      114688 May 26  2010 boxes.ibd
-rw-rw---- 1 mysql mysql        8736 May 26  2010 cache.frm
-rw-rw---- 1 mysql mysql    50331648 Jan  9 12:45 cache.ibd
-rw-rw---- 1 mysql mysql        8736 May 26  2010 cache_block.frm
-rw-rw---- 1 mysql mysql      114688 Aug 25 12:08 cache_block.ibd
-rw-rw---- 1 mysql mysql        8736 Aug 25 12:22 cache_content.frm
-rw-rw---- 1 mysql mysql  2298478592 Jan  9 00:54 cache_content.ibd
-rw-rw---- 1 mysql mysql        8736 May 26  2010 cache_filter.frm
-rw-rw---- 1 mysql mysql   704643072 Jan  9 12:45 cache_filter.ibd
-rw-rw---- 1 mysql mysql        8736 May 26  2010 cache_form.frm
-rw-rw---- 1 mysql mysql    12582912 Aug 16  2010 cache_form.ibd
-rw-rw---- 1 mysql mysql        8736 May 26  2010 cache_menu.frm
-rw-rw---- 1 mysql mysql   792723456 Jan  9 12:44 cache_menu.ibd
-rw-rw---- 1 mysql mysql        8736 May 26  2010 cache_page.frm
-rw-rw---- 1 mysql mysql   364904448 Jan  9 12:45 cache_page.ibd
-rw-rw---- 1 mysql mysql        8736 May 26  2010 cache_update.frm
-rw-rw---- 1 mysql mysql    10485760 Jan  9 12:44 cache_update.ibd
-rw-rw---- 1 mysql mysql        8736 May 26  2010 cache_views.frm
-rw-rw---- 1 mysql mysql      311296 Aug 25 12:14 cache_views.ibd
-rw-rw---- 1 mysql mysql        8736 Aug 25 12:19 cache_views_data.frm
-rw-rw---- 1 mysql mysql 17762877440 Jan  9 12:45 cache_views_data.ibd
-rw-rw---- 1 mysql mysql        8992 May 26  2010 comments.frm
-rw-rw---- 1 mysql mysql      147456 May 26  2010 comments.ibd
-rw-rw---- 1 mysql mysql        8640 May 26  2010 content_field_area.frm
-rw-rw---- 1 mysql mysql    24117248 Oct  1 08:00 content_field_area.ibd
-rw-rw---- 1 mysql mysql        8650 May 26  2010 content_field_area_code.frm
-rw-rw---- 1 mysql mysql    22020096 Oct  1 08:00 content_field_area_code.ibd
-rw-rw---- 1 mysql mysql        8660 May 26  2010 content_field_average_rating.frm
-rw-rw---- 1 mysql mysql    22020096 Oct  1 08:18 content_field_average_rating.ibd
-rw-rw---- 1 mysql mysql        8640 May 26  2010 content_field_city.frm
-rw-rw---- 1 mysql mysql    24117248 Oct  1 08:18 content_field_city.ibd
-rw-rw---- 1 mysql mysql        8646 May 26  2010 content_field_country.frm
-rw-rw---- 1 mysql mysql    24117248 Oct  1 08:01 content_field_country.ibd
-rw-rw---- 1 mysql mysql        8724 May 26  2010 content_field_description.frm
-rw-rw---- 1 mysql mysql   734003200 Oct  1 08:18 content_field_description.ibd
-rw-rw---- 1 mysql mysql        8654 May 26  2010 content_field_housenumber.frm
-rw-rw---- 1 mysql mysql    20971520 Oct  1 08:01 content_field_housenumber.ibd
-rw-rw---- 1 mysql mysql        8636 May 26  2010 content_field_id.frm
-rw-rw---- 1 mysql mysql    26214400 Oct  1 08:01 content_field_id.ibd
-rw-rw---- 1 mysql mysql        8798 May 26  2010 content_field_images.frm
-rw-rw---- 1 mysql mysql   847249408 Oct  1 08:18 content_field_images.ibd
-rw-rw---- 1 mysql mysql        8754 May 26  2010 content_field_link.frm
-rw-rw---- 1 mysql mysql    75497472 Oct  1 08:17 content_field_link.ibd
-rw-rw---- 1 mysql mysql        8670 May 26  2010 content_field_occupancies_maximum.frm
-rw-rw---- 1 mysql mysql    22020096 Oct  1 08:01 content_field_occupancies_maximum.ibd
-rw-rw---- 1 mysql mysql        8668 May 26  2010 content_field_occupancies_normal.frm
-rw-rw---- 1 mysql mysql    22020096 Oct  1 08:01 content_field_occupancies_normal.ibd
-rw-rw---- 1 mysql mysql        8658 May 26  2010 content_field_property_type.frm
-rw-rw---- 1 mysql mysql    24117248 Oct  1 08:01 content_field_property_type.ibd
-rw-rw---- 1 mysql mysql        8644 May 26  2010 content_field_street.frm
-rw-rw---- 1 mysql mysql    22020096 Oct  1 08:00 content_field_street.ibd
-rw-rw---- 1 mysql mysql        8654 May 26  2010 content_field_unitownerid.frm
-rw-rw---- 1 mysql mysql    22020096 Oct  1 08:01 content_field_unitownerid.ibd
-rw-rw---- 1 mysql mysql        8648 May 26  2010 content_field_zip_code.frm
-rw-rw---- 1 mysql mysql    23068672 Oct  1 08:17 content_field_zip_code.ibd
-rw-rw---- 1 mysql mysql        8758 May 26  2010 content_group.frm
-rw-rw---- 1 mysql mysql       98304 May 26  2010 content_group.ibd
-rw-rw---- 1 mysql mysql        8654 May 26  2010 content_group_fields.frm
-rw-rw---- 1 mysql mysql       98304 May 26  2010 content_group_fields.ibd
-rw-rw---- 1 mysql mysql        8916 May 26  2010 content_node_field.frm
-rw-rw---- 1 mysql mysql       98304 May 26  2010 content_node_field.ibd
-rw-rw---- 1 mysql mysql        8968 May 26  2010 content_node_field_instance.frm
-rw-rw---- 1 mysql mysql       98304 May 26  2010 content_node_field_instance.ibd
-rw-rw---- 1 mysql mysql        8586 May 26  2010 content_type_ferienhaus.frm
-rw-rw---- 1 mysql mysql    15728640 Oct  1 08:01 content_type_ferienhaus.ibd
-rw-rw---- 1 mysql mysql        8586 May 26  2010 content_type_ferienpark.frm
-rw-rw---- 1 mysql mysql      196608 Oct  1 07:50 content_type_ferienpark.ibd
-rw-rw---- 1 mysql mysql        8586 May 26  2010 content_type_ferienwohnung.frm
-rw-rw---- 1 mysql mysql    14680064 Oct  1 07:34 content_type_ferienwohnung.ibd
-rw-rw---- 1 mysql mysql          61 Dec  1  2009 db.opt
-rw-rw---- 1 mysql mysql        8568 May 26  2010 edomizil_objects.frm
-rw-rw---- 1 mysql mysql    14680064 Oct  1 08:17 edomizil_objects.ibd
-rw-rw---- 1 mysql mysql        8812 May 27  2010 files.frm
-rw-rw---- 1 mysql mysql      147456 May 27  2010 files.ibd
-rw-rw---- 1 mysql mysql        8658 May 27  2010 filter_formats.frm
-rw-rw---- 1 mysql mysql      114688 May 27  2010 filter_formats.ibd
-rw-rw---- 1 mysql mysql        8692 May 27  2010 filters.frm
-rw-rw---- 1 mysql mysql      131072 May 27  2010 filters.ibd
-rw-rw---- 1 mysql mysql        8668 May 27  2010 flood.frm
-rw-rw---- 1 mysql mysql      114688 May 27  2010 flood.ibd
-rw-rw---- 1 mysql mysql        8626 May 27  2010 history.frm
-rw-rw---- 1 mysql mysql      114688 Sep 15  2010 history.ibd
-rw-rw---- 1 mysql mysql        8924 May 27  2010 languages.frm
-rw-rw---- 1 mysql mysql      114688 Jun  1  2010 languages.ibd
-rw-rw---- 1 mysql mysql        8706 May 27  2010 locales_source.frm
-rw-rw---- 1 mysql mysql     9437184 Aug 25 12:14 locales_source.ibd
-rw-rw---- 1 mysql mysql        8704 May 27  2010 locales_target.frm
-rw-rw---- 1 mysql mysql     9437184 Jun  1  2010 locales_target.ibd
-rw-rw---- 1 mysql mysql        8646 May 27  2010 menu_custom.frm
-rw-rw---- 1 mysql mysql       98304 May 27  2010 menu_custom.ibd
-rw-rw---- 1 mysql mysql       13504 May 27  2010 menu_links.frm
-rw-rw---- 1 mysql mysql     9437184 Aug 25 12:08 menu_links.ibd
-rw-rw---- 1 mysql mysql      166612 Aug 25 12:08 menu_router.MYD
-rw-rw---- 1 mysql mysql       77824 Nov 17 01:21 menu_router.MYI
-rw-rw---- 1 mysql mysql       17622 May 27  2010 menu_router.frm
-rw-rw---- 1 mysql mysql        9034 May 27  2010 node.frm
-rw-rw---- 1 mysql mysql    96468992 Oct  1 08:18 node.ibd
-rw-rw---- 1 mysql mysql        8752 May 27  2010 node_access.frm
-rw-rw---- 1 mysql mysql       98304 May 27  2010 node_access.ibd
-rw-rw---- 1 mysql mysql        8782 May 27  2010 node_comment_statistics.frm
-rw-rw---- 1 mysql mysql      114688 May 27  2010 node_comment_statistics.ibd
-rw-rw---- 1 mysql mysql        8678 May 27  2010 node_counter.frm
-rw-rw---- 1 mysql mysql       98304 May 27  2010 node_counter.ibd
-rw-rw---- 1 mysql mysql        8812 May 27  2010 node_revisions.frm
-rw-rw---- 1 mysql mysql    41943040 Oct  1 08:18 node_revisions.ibd
-rw-rw---- 1 mysql mysql       13154 May 27  2010 node_type.frm
-rw-rw---- 1 mysql mysql       98304 May 27  2010 node_type.ibd
-rw-rw---- 1 mysql mysql        8682 Jun  1  2010 nodewords.frm
-rw-rw---- 1 mysql mysql      212992 Sep 28  2010 nodewords.ibd
-rw-rw---- 1 mysql mysql        8688 May 27  2010 nodewords_custom.frm
-rw-rw---- 1 mysql mysql       98304 May 27  2010 nodewords_custom.ibd
-rw-rw---- 1 mysql mysql        8628 May 27  2010 page_title.frm
-rw-rw---- 1 mysql mysql       98304 May 27  2010 page_title.ibd
-rw-rw---- 1 mysql mysql        8808 May 27  2010 path_redirect.frm
-rw-rw---- 1 mysql mysql      163840 Jan  9 09:33 path_redirect.ibd
-rw-rw---- 1 mysql mysql        8644 May 27  2010 permission.frm
-rw-rw---- 1 mysql mysql      114688 Jun  1  2010 permission.ibd
-rw-rw---- 1 mysql mysql        8588 May 27  2010 role.frm
-rw-rw---- 1 mysql mysql      114688 May 27  2010 role.ibd
-rw-rw---- 1 mysql mysql   412769064 Oct  3 15:52 search_dataset.MYD
-rw-rw---- 1 mysql mysql     3329024 Nov 17 01:21 search_dataset.MYI
-rw-rw---- 1 mysql mysql        8654 May 26  2010 search_dataset.frm
-rw-rw---- 1 mysql mysql  1420292692 Oct  3 15:53 search_index.MYD
-rw-rw---- 1 mysql mysql  1270934528 Nov 17 01:21 search_index.MYI
-rw-rw---- 1 mysql mysql        8650 Dec  1  2009 search_index.frm
-rw-rw---- 1 mysql mysql           0 Dec  1  2009 search_node_links.MYD
-rw-rw---- 1 mysql mysql        1024 Dec  1  2009 search_node_links.MYI
-rw-rw---- 1 mysql mysql        8652 Dec  1  2009 search_node_links.frm
-rw-rw---- 1 mysql mysql    12907848 Oct  3 15:57 search_total.MYD
-rw-rw---- 1 mysql mysql    11265024 Nov 17 01:21 search_total.MYI
-rw-rw---- 1 mysql mysql        8592 Dec  1  2009 search_total.frm
-rw-rw---- 1 mysql mysql        8626 May 27  2010 semaphore.frm
-rw-rw---- 1 mysql mysql      114688 Dec 17 07:15 semaphore.ibd
-rw-rw---- 1 mysql mysql        8732 May 27  2010 sessions.frm
-rw-rw---- 1 mysql mysql    31457280 Jan  9 12:45 sessions.ibd
-rw-rw---- 1 mysql mysql        8886 May 27  2010 system.frm
-rw-rw---- 1 mysql mysql      229376 Jan  9 12:44 system.ibd
-rw-rw---- 1 mysql mysql        8588 May 27  2010 taxonomy_breadcrumb_term.frm
-rw-rw---- 1 mysql mysql       98304 May 27  2010 taxonomy_breadcrumb_term.ibd
-rw-rw---- 1 mysql mysql        8588 May 27  2010 taxonomy_breadcrumb_vocabulary.frm
-rw-rw---- 1 mysql mysql       98304 May 27  2010 taxonomy_breadcrumb_vocabulary.ibd
-rw-rw---- 1 mysql mysql        8616 Jun  1  2010 taxonomy_menu.frm
-rw-rw---- 1 mysql mysql      163840 Jun  1  2010 taxonomy_menu.ibd
-rw-rw---- 1 mysql mysql        8590 May 27  2010 taxonomy_title.frm
-rw-rw---- 1 mysql mysql      196608 Oct  1 00:09 taxonomy_title.ibd
-rw-rw---- 1 mysql mysql        8694 May 27  2010 term_data.frm
-rw-rw---- 1 mysql mysql      376832 Oct  1 00:08 term_data.ibd
-rw-rw---- 1 mysql mysql        8762 May 27  2010 term_fields.frm
-rw-rw---- 1 mysql mysql      114688 May 27  2010 term_fields.ibd
-rw-rw---- 1 mysql mysql        8700 May 27  2010 term_fields_term.frm
-rw-rw---- 1 mysql mysql      163840 Oct  1 00:08 term_fields_term.ibd
-rw-rw---- 1 mysql mysql        8592 May 27  2010 term_hierarchy.frm
-rw-rw---- 1 mysql mysql      212992 Oct  1 00:09 term_hierarchy.ibd
-rw-rw---- 1 mysql mysql        8614 May 27  2010 term_node.frm
-rw-rw---- 1 mysql mysql    50331648 Oct  1 08:18 term_node.ibd
-rw-rw---- 1 mysql mysql        8620 May 27  2010 term_relation.frm
-rw-rw---- 1 mysql mysql      131072 May 27  2010 term_relation.ibd
-rw-rw---- 1 mysql mysql        8618 May 27  2010 term_synonym.frm
-rw-rw---- 1 mysql mysql      131072 May 27  2010 term_synonym.ibd
-rw-rw---- 1 mysql mysql        8722 May 27  2010 upload.frm
-rw-rw---- 1 mysql mysql      131072 May 27  2010 upload.ibd
-rw-rw---- 1 mysql mysql        8652 May 27  2010 url_alias.frm
-rw-rw---- 1 mysql mysql    50331648 Oct  1 08:18 url_alias.ibd
-rw-rw---- 1 mysql mysql       13278 May 27  2010 users.frm
-rw-rw---- 1 mysql mysql      163840 Jan  9 12:44 users.ibd
-rw-rw---- 1 mysql mysql        8586 May 27  2010 users_roles.frm
-rw-rw---- 1 mysql mysql      114688 Jun  1  2010 users_roles.ibd
-rw-rw---- 1 mysql mysql        8592 May 27  2010 variable.frm
-rw-rw---- 1 mysql mysql     8388608 Jan  9 12:44 variable.ibd
-rw-rw---- 1 mysql mysql        8772 May 27  2010 views_display.frm
-rw-rw---- 1 mysql mysql      114688 May 28  2010 views_display.ibd
-rw-rw---- 1 mysql mysql        8682 May 27  2010 views_object_cache.frm
-rw-rw---- 1 mysql mysql      131072 May 28  2010 views_object_cache.ibd
-rw-rw---- 1 mysql mysql        8786 May 27  2010 views_view.frm
-rw-rw---- 1 mysql mysql      114688 May 28  2010 views_view.ibd
-rw-rw---- 1 mysql mysql        8916 May 27  2010 vocabulary.frm
-rw-rw---- 1 mysql mysql      114688 Jun  2  2010 vocabulary.ibd
-rw-rw---- 1 mysql mysql        8588 May 27  2010 vocabulary_node_types.frm
-rw-rw---- 1 mysql mysql      114688 Jun  2  2010 vocabulary_node_types.ibd
-rw-rw---- 1 mysql mysql        8912 May 27  2010 watchdog.frm
-rw-rw---- 1 mysql mysql    14680064 Jan  9 12:44 watchdog.ibd
-rw-rw---- 1 mysql mysql        1288 May 10  2010 wysiwyg.MYD
-rw-rw---- 1 mysql mysql        2048 May 10  2010 wysiwyg.MYI
-rw-rw---- 1 mysql mysql        8636 May 10  2010 wysiwyg.frm
-rw-rw---- 1 mysql mysql        9024 Jun  1  2010 xmlsitemap.frm
-rw-rw---- 1 mysql mysql    58720256 Oct  1 08:18 xmlsitemap.ibd
-rw-rw---- 1 mysql mysql        8744 Jun  1  2010 xmlsitemap_sitemap.frm
-rw-rw---- 1 mysql mysql      114688 Oct  1 09:54 xmlsitemap_sitemap.ibd
dawehner’s picture

dawehner
Primary language German
commented

Views implements hook_flush_caches which is used by system_cron().

Are you really using 6.x-2.10? Maybe there was a bug in some older versions of views, maybe you have configured views so it caches things for a long long long time, you newer know.

hass’s picture

hass commented

Yes, it was 2.10. View cache time is 1h - no longer. Some only 30 minutes.

hass’s picture

hass commented
Status: Active » Fixed

Issue seems to be fixed with latest version.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

ressa’s picture

ressa
he/him
commented
Issue summary: View changes

I found this issue after the cache_page table (cache_page.ibd) in my MariaDB database was filled up, and the database couldn't restart. The cache_page table ballooned with several GB's in a short time, up to 30GB. The solution was to set a maximum number of rows for caching, see Database cache bins are now fixed size — no more unlimited growth.

ressa’s picture

ressa
he/him
commented
Related issues: +#2896473: Add monitoring/reporting of cache table pruning