Using Batch Inserts

Using batch inserts improves replication performance for transactions that perform multiple inserts into a single table. To enable batch mode, modify the spock.batch_inserts parameter, setting it to true and spock.conflict_resolution parameter, setting it to error. Once enabled, Spock will switch to batch mode when a transaction does more than five INSERTs.

You can only use batch mode if there are no INSTEAD OF INSERT and BEFORE INSERT triggers on the table, and when there are no defaults with volatile expressions for columns of the table.