Re: Should I throttle deletes?

[Vitalii Tymchyshyn]

05.01.12 22:29, Philippe ???????(??):

    Then I do have a question, what do people generally use as the
    batch size?

I used to do batches from 500 to 2000 like you do.
After investigating issues such as the one you've encountered I've 
moved to batches of 20 for writes and 256 for reads. Everything is a 
lot smoother : no more timeouts.

I'd better reduce mutation thread pool with concurrent_writes setting. 
This will lower server load no matter, how many clients are sending 
batches, at the same time you still have good batching.

Best regards, Vitalii Tymchyshyn