rocksdb_commit_in_the_middle is a session variable to implicitly commit every rocksdb_bulk_load_size. This variable is mainly used for bulk loading and bulk deletes, so that long running statements don't hold row locks for a long time. But Sveta pointed out that if statements fail, there is no way to know how many rows are actually committed. Let's consider adding some diagnostic variable.