I have noticed in mysql that cache_form.MYD table is 14GB. Why did it grow so big? Is it safe to empty it? and how can I avoid this happening in the future?
Thanks
Drupal Answers is a question and answer site for Drupal developers and administrators. It only takes a minute to sign up.
Sign up to join this communityI have noticed in mysql that cache_form.MYD table is 14GB. Why did it grow so big? Is it safe to empty it? and how can I avoid this happening in the future?
Thanks
https://drupal.org/project/optimizedb - module that will solve your problem. He can clear the table cache_form by Cron, also perform optimization and more. Versions available for Drupal 6.7.
This is a known issue in Drupal 6 and 7 for that matter. It is not cleared when running cron. You can safely delete all rows that has expired.
DELETE FROM {cache_form} WHERE expire < now();
should do the trick.
I suspect that cron isn't running on your site. I am not 100% positive about that particular table, but other cache tables do get stale entries removed when cron runs.
If you need help setting up cron, peruse http://drupal.org/cron