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
Doug,
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
http://dev.mysql.com/doc/mysql/en/InnoDB_transaction_isolation.html how we do it.
-Mark