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: > Actually the first query is returning correct data and the second query > is missing out some records. When the execute the same queries from the > sql prompt , I get the data correctly. > > I have not taken any ISAM dump, but creating data in the INNODB tables > directly. > > Actually this is a performance testing I am doing, where I have 10 > threads running concurrently inserting 10K rows each and a cron that > triggers every five minutes that reads the data and does certain > operations. > > Do you feel I should check some INNODB configurations for such stress > conditions ? Do both queries happen in the same transaction? Does it happen when you set that transaction's isolation level to SERIALIZABLE? -- Christopher G. Stach II -- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe: http://lists.mysql.com/[email protected]