开发者

{help}--drupal---cache_form table is too big

开发者 https://www.devze.com 2023-02-04 08:34 出处:网络
1,what\'s record cached in the table cache_form? 2,my site\'s cache_form table is too big(1.0G). t开发者_StackOverflowhe cron hasn\'t been working for a month. when i run it manually, it still can\'t

1,what's record cached in the table cache_form?

2,my site's cache_form table is too big(1.0G). t开发者_StackOverflowhe cron hasn't been working for a month. when i run it manually, it still can't work. why. the drupal version is 6.19.


DELETE FROM cache_form where expire < UNIX_TIMESTAMP(NOW())


A hot fix, would be to manually delete all the rows from the database. However, the problem is not that form table it getting to big, but that cron is failing. Not running cron on your site will cause a lot of problems, in the future if you don't find and fix that problem.


The problem with cron_cache is that is does a truncate on the tables. So that means that active sessions also gets deleted.


To answer your first question the cache_form holds exactly what it sounds like, cached forms. So on sites with a bunch of forms, such as a big ubercart site where every product page is an add to cart form, this table can get ginormous.

It does appear as though this table getting too big is a direct result of cron not running properly as @googletorp indicates.


I'm using Drupal7.22 and i installed the cron_cache module that clears all the cache including cache_form every 24hours .

0

精彩评论

暂无评论...
验证码 换一张
取 消