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/Jautocommitmysql

0 likes · 14 min read

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

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.

Configurationautocommitmysql

0 likes · 7 min read

How to Disable MySQL Autocommit for Faster Bulk Inserts