RE: Problems faced onm igration from myISAM to INNODB

Hi,

Thanks for your response. Actually I am using JDBC to communicate with
the DB , that's the reason why I posted this query in the java list.

This does not seem to be a phantom read, as the first query is returning
me more number of rows than the second one and I am not doing any
deletes.

Regards
Prasad

-----Original Message-----
From: Christopher G. Stach II [mailto:[email protected]]
Sent: Wednesday, June 14, 2006 8:13 AM
To: Prasad Ramisetti (WT01 - Broadband Networks)
Cc: [email protected]
Subject: Re: Problems faced onm igration from myISAM to INNODB

[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


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

-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]