Issue with watchdog database and cache

A

aub972017-09-15 11:10:35

Drupal

aub97, 2017-09-15 11:10:35

Issue with watchdog database and cache_form. What to do?

The watchdog and cache_form tables weigh an abnormally large amount of 1.8 and 1.7 GB, respectively. Because of this size, the site was temporarily blocked. Can they be removed, and why are they needed at all? I've never worked with a database, so I'm afraid to break something. I've attached a photo of what the phpAdmin panel looks like. help me please

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

A

andead, 2017-09-15
@andead

PHP errors are written to the watchdog, fix them and the table will not grow. The table can be cleared (not deleted).
The cache_form stores the cache for ajax forms. The table can be cleared (not deleted).
Set up cron to run regularly .

A

Alexander Alexandrov, 2017-09-15
@BraveHeart

If the site is working (no work is being done on it), disable all logging (dblog, syslog) in the admin panel.
For the cache_form table, the condition in settings.php should already work out of the box $conf['form_cache_expiration'] = 21600; https://www.drupal.org/node/2857751
In addition, you can configure the task scheduler to auto-clear the optimizedb cache .