Views Cache Can Crash MYSQL

User contributed module views does not clear on cron runs. This is by design. The cache must be cleared manually through the views UI using the views --> tools menu.

Views queries and pages cached for months or years can wreck havoc on your MYSQL database. Recently a client had enabled views caching and reported intermittent MYSQL crashes.

The culprit was the servers database backup process dying every night it tried to backup a particular Drupal database. This DB was over 5GB all due to a cache_views_data table that was 7.7 GB.

Clearing the views cache resolves the issue research is under way to find a method of clearing the cache automatically. There is no obvious solution other than clearing the cache manually every month or so.