10 messages in com.mysql.lists.javaRE: Problems faced onm igration from ...| From | Sent On | Attachments |
|---|---|---|
| pras...@wipro.com | 13 Jun 2006 09:44 | |
| Christopher G. Stach II | 13 Jun 2006 19:42 | |
| pras...@wipro.com | 13 Jun 2006 20:36 | |
| Christopher G. Stach II | 13 Jun 2006 20:43 | |
| pras...@wipro.com | 13 Jun 2006 20:51 | |
| Christopher G. Stach II | 13 Jun 2006 21:04 | |
| pras...@wipro.com | 13 Jun 2006 21:12 | |
| Christopher G. Stach II | 13 Jun 2006 21:45 | |
| pras...@wipro.com | 13 Jun 2006 22:04 | |
| Christopher G. Stach II | 13 Jun 2006 22:06 |
| Subject: | RE: Problems faced onm igration from myISAM to INNODB |
|---|---|
| From: | pras...@wipro.com (pras...@wipro.com) |
| Date: | 06/13/2006 09:12:35 PM |
| List: | com.mysql.lists.java |
Acually these queries are executed from different transactions. We take two different connections and then execute these two select queries.
I have not tried with SERIALIZABLE option.
-----Original Message----- From: Christopher G. Stach II [mailto:cg...@ldsys.net] Sent: Wednesday, June 14, 2006 9:35 AM To: Prasad Ramisetti (WT01 - Broadband Networks) Cc: ja...@lists.mysql.com Subject: Re: Problems faced onm igration from myISAM to INNODB
pras...@wipro.com 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
The information contained in this electronic message and any attachments to this
message are intended for the exclusive use of the addressee(s) and may contain
proprietary, confidential or privileged information. If you are not the intended
recipient, you should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately and destroy all copies of this message and any
attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The company
accepts no liability for any damage caused by any virus transmitted by this
email.
www.wipro.com