My Drupal database becomes very huge, it just related to cache_menu table:
~4,291,529 rows and 2.9 GiB
What can I do to prevent this? is there any way to change cache strategy for menu items? or simply I should EMPTY this table every week?
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 community
It has been a bug in Drupal, but should be corrected since Drupal version 7.13. See more details here: http://drupal.org/node/1234830
As a workaround, you can empty (truncate) the cache_menu table, since it is just a cache table and will be regenerated. Of cource, you'll have a trade-off in performance, in that case.