Tagged articles

autoCommit

3 articles · Page 1 of 1
samdeepthink
samdeepthink
Aug 25, 2026 · Backend Development

How RocketMQ Implements Ordered Consumption Locking

The article explains RocketMQ's two‑layer locking mechanism that guarantees ordered consumption by holding a queue‑level lock inside a while loop, clarifies why autoCommit only affects offset reporting, and shows how the client correctly processes multiple messages in a single thread.

MessageListenerOrderlyRocketMQautoCommit
0 likes · 11 min read
How RocketMQ Implements Ordered Consumption Locking
Programmer DD
Programmer DD
Jun 22, 2022 · Databases

Why Did My Spring @Transactional Rollback Fail? Uncovering a MySQL Connector Bug

An in‑depth investigation reveals that Spring’s @Transactional rollback can silently fail due to a bug in mysql‑connector‑java 8.0.28 when useLocalSessionState=true, causing auto‑commit to stay enabled; the article explains the root cause, debugging steps, and how upgrading to 8.0.29 resolves the issue.

Connector/JMySQLautoCommit
0 likes · 14 min read
Why Did My Spring @Transactional Rollback Fail? Uncovering a MySQL Connector Bug
ITPUB
ITPUB
Nov 2, 2016 · Databases

How to Disable MySQL Autocommit for Faster Bulk Inserts

This guide explains why MySQL's default autocommit slows down large data imports, demonstrates two ways to turn it off—using SET commands and editing the my.ini file—and shows how disabling autocommit can boost insert performance by more than ten times.

ConfigurationMySQLautoCommit
0 likes · 7 min read
How to Disable MySQL Autocommit for Faster Bulk Inserts