Drupal 6 can I truncate the batch table in the db

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` ;