Re: Problems faced onm igration from myISAM to INNODB
"Christopher G. Stach II" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.java |
|---|---|
| Message-ID | <[email protected]> |
[email protected] wrote: > Hi All, > > I have migrated my database storage engine from myISAM to INNODB. > > I am seeing a strange problem in INNODB. Under loaded conditions where multiple threads are writing and reading data from the DB, the select queries are returning data in-consistently. I am using the default transaction isolation leve that comes with INNODB. > > For eg,. > For the same table select count(*) and select * returns different number of rows. I do not have any delete/modify operations going on. Only I am doing creating and selecting of data from the tables. > > Could someone please help me on this. > > Thanks in advance. > Prasad First of all, I don't see how this belongs on the Java list. Anyway, set a transaction isolation level that makes sense and try your queries. It just sounds like you are getting phantom reads, which makes total sense for REPEATABLE READ, InnoDB's default. -- Christopher G. Stach II -- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe: http://lists.mysql.com/[email protected]