Re: Mysql and Tomcat 5.5 strange performance
Posted by: Mark Matthews
Date: December 21, 2004 09:44AM

Doug Furbush wrote:
> Hello Mark,
> Thanks for replying. I am trying lots of
> parameters but so far no success.
> I am using the default mySQL which I believe uses
> InnoDB. There is no commit/rollback on the


InnoDB tables are not the default type in MySQL. What does 'show create table [tablename]' say for each of the tables in your application? That will tell you what storage engine the tables are using.

> refresh since it is just reading the DB. You
> mention REPEATABLE_REA - is this an option? Where
> do I read up on it.

Doug, REPEATABLE_READ is a 'standard' RDBMS setting, it means that a transaction will always see the 'same' state of the data as when the transaction started, see for how we do it.


Options: ReplyQuote

Written By
Re: Mysql and Tomcat 5.5 strange performance
December 21, 2004 09:44AM

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.