My batch table has become huge an开发者_如何学God is slowing down my site. No batch seems to be running. Can I truncate the table safely? Thanks
Yes, you can safely truncate that table if there are no batch processes running.
I had exactly the same problem as you did. My batch table was huge (almost 40 MiB). I went through the records in the database and I have found that the only thing that is stored in the database are settings of the batch task. I truncated the table manually without any noticable problem. I am not a Drupal DB guru but that solved my problem and none issue occured.
Maybe will someone advice othewise?
TRUNCATE `batch` ;
精彩评论