Aikesheng Open Source Community

Mar 25, 2019 · Databases

Investigation of MySQL Temporary Tablespace Limits with JDBC useCursorFetch and Alternative Solutions

This article analyzes how MySQL's temporary tablespace (ibtmp1) grows when using JDBC with the useCursorFetch=true parameter, why errors are hidden, presents test scenarios reproducing the issue, compares segment and stream reading methods, and proposes configuration and code‑level solutions to control temporary space and ensure proper error reporting.