Re: Mysql and Tomcat 5.5 strange performance
Posted by: Mark Matthews
Date: December 20, 2004 10:11PM

Doug,

Are you using InnoDB tables? Do you keep an 'open' transaction on the 'refresh' page (i.e. no commit/rollback)? If so, since InnoDB runs by default in REPEATABLE_READ isolation level, you'll _never_ see the updates done by other threads/connections from your 'refresh' page until you commit/rollback _after_ the other transactions complete.

The JDBC driver itself does no caching behind scenes, it only delivers what's in the database itself.

Options: ReplyQuote


Subject
Written By
Posted
Re: Mysql and Tomcat 5.5 strange performance
December 20, 2004 10:11PM


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.