[CONJ-30] Performance degradation caused by excessive select and set autocommit queries Created: 2013-03-20 Updated: 2013-04-09 Resolved: 2013-04-09 |
|
| Status: | Closed |
| Project: | MariaDB Connector/J |
| Component/s: | None |
| Affects Version/s: | 1.1.0, 1.1.1 |
| Fix Version/s: | 1.1.2 |
| Type: | Task | Priority: | Major |
| Reporter: | Marissa Hollingsworth | Assignee: | Vladislav Vaintroub |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | autocommit, jdbc | ||
| Environment: |
MariaDB Java Client connecting to MySQL Community Server through Hibernate persistence layer. |
||
| Description |
|
We noticed some performance degradation in our product when we replaced the MySQL Connector/J client with MariaDB Java client and were able to trace the performance decrease back to the large number of 'get @@autocommit' and 'set autocommit' queries sent to the database. Instead of sending these queries to the databse each time getAutocommit() and setAutocommit() are called, the autocommit value may be cached on a per connection basis to improve performance. |