https://drupal.org/project/db_maintenance will also optimize the database tables

Comments

sergeypavlenko’s picture

Hi, thanks for the issue.

The module "DB Maintenance" is similar to the module "OptimizeDB" but there are important differences:

1. Table Optimization is not performed by Cron, as this may disrupt the experience of site.
2. There is a cleaning table cache_form, because this table is very often grows and sometimes is large.
3. In the settings module, you can see the size of all tables in the database, there is the ability to sort by size.
4. Optimization tables is performed using Batch Api.
5. Optimization by Cron replaced by warning of the need to optimize.
6. Separate output size of the table cache_form
7. Withdraw the total size of all the tables.

Perhaps there are still some differences, but I have listed the main ones.

sergeypavlenko’s picture

Status: Active » Fixed

Since the module checks out in the issue - #2023561: [D7] OptimizeDB, I think the question of comparison can be closed.

Status: Fixed » Closed (fixed)

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

MatthijsG’s picture

Version: » 7.x-1.5
Issue summary: View changes
Status: Closed (fixed) » Needs review

This comparison is 2 years old. What are the differences now?

sergeypavlenko’s picture

Hi, @Lenn-art

Thanks for the question.

In addition to old items, there are now the following options:

1. The table listing all tables in the database have the opportunity "Checks", "Repair" and "Optimization" tables.
2. #2451863: Clear entire cache_form table at specified hour, ex: 4:00am Possible ? Opportunity to select the amount of time to perform the Cron operations. Feature will be added soon to the stable branch.

Remained all the old features, only optimized code.

sergeypavlenko’s picture

Status: Needs review » Fixed

Status: Fixed » Closed (fixed)

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