Ubuntu 20.04 update destroyed Java/Mysql app performance

java mysql ubuntu ubuntu-20.04

The MySQL JDBC driver default behavior apparently changed when updating the OS.

The previous driver turned off transaction auto commits for Java batch updates - manually adding/running setAutoCommit(false) on the data connection dropped the run time back to normal (apparently it was running atomic transactions for 1000 some inserts).

This is a good example of why people should defensively code and add intentional code even if the default behavior/configuration is what's used in code - the default can and will change!

https://coderanch.com/t/299833/databases/Batch-update-setAutoCommit-false

Related

Sometimes ipv4 address instead of ipv6 address
Is it possible to share files through Apache WebDAV?
.htaccess: Remove everything after '/index.php'
Email protected with SPF but received valid signature from other IP anyway
fail2ban: multiline "failregex" not working
How do I properly configure SSL on the backend between nginx and an app?
Compiling and building Linux packages for multiple distributions / platforms
Recursively delete empty folders with verbose output
How long will items be kept in an In-Place Archive with Microsoft's Default MDM Policy?
Cannot log into my RADIUS protected wireless connection. Here's the LOG contents
schtasks.exe adding repeat every 10 min when not desired
Fancy colored rendering issue on osx 10.8 retina with iTerm