Skip navigation links

MySQL Forums :: Connector/JDBC and Java :: Costs of a Connection in ! autocommit mode


Advanced Search

Costs of a Connection in ! autocommit mode
Posted by: th nb ()
Date: November 12, 2012 01:37PM

Are there any costs (viz. in memory usage) incurred by the server when working with a Connection whose autoCommit property is false vs one whose autoCommit property is true? Specifically before any CRUD statement has been issued on the connection.

compare:
DataSource ds = . . .
Connection conAuto = ds.getConnection();
conAuto.setAutoCommit(true);

Connection conTx = ds.getConnection();
conTx.setAutoCommit(false);


In terms of memory costs (or other costs for that matter), do conAuto and conTx consume the same amount of memory overhead on the server? Or does a MySQL server pre-allocate some extra memory for conTx?, sort of a "get ready for a tx"

Options: ReplyQuote


Subject Written By Posted
Costs of a Connection in ! autocommit mode th nb 11/12/2012 01:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.