There is well-known issue with fast-growing table cache_form. This table stores Drupal form cache and it isn’t cleared when you flush all cache or run cron. Also you can struggle with problem of fragmentation with InnoDB tables on active delete/insert operations. This module provide functionality to solve this problem. Also its provide additional tools for maintenance database.
Module OptimizeDB provide such features:
- Ability to clean cache_from in administrative page or do it by cron.
- Ability to optimize all database’s tables and display its sizes.
- Configuration of notification about necessity to perform maintenance tasks.
- Perform check and repair operation with tables.
- Prevent crashing tables when perform all maintained actions.
- Work with MySQL and PgSQL
- Execute operations with Drush
- DB Maintenance - differences https://drupal.org/node/2013040
Module works with PHP 5.2.x +
I advise you to make backup of database before you perform optimization operations, because probability of lost data is exist.
In Drupal 8 problem with table "cache_form" is fixed. Forms cache is automatically cleared on some site pages, after the page loads.
Cleaning takes place in the method:
Need porting others functions module to Drupal 8.
In Russian - http://drupal.ua/node/300998
The sponsor of this module: Elasticweb.
- Maintenance status: Actively maintained
- Development status: Under active development
- Reported installs: 7,042 sites currently report using this module. View usage statistics.
- Downloads: 38,378
- Automated tests: Enabled
- Last modified: 6 February 2017
- Stable releases for this project are covered by the security advisory policy.
Look for the shield icon below.