MySQL Forums
Forum List  »  InnoDB

Re: innodb update locks table...
Posted by: Anda Zhao
Date: February 28, 2006 04:41PM

Heikki,

I have ran the same load test without using prepared statement, and it finished without problems (100 threads with MaxPoolSize set to 60 running for 8 hours, at the end, the max_used_connections from show status is 54, and transaction response time was stable during the test).

Looks like we are also hitting the bug you mentioned earlier. I am wondering if there is any work around we can use? We are using blob data type (in the test I just set it to null to avoid the biding), anyway to do this without using prepared statement?

And if this bug is confirmed with MySQL, what is the bug turn around time, usually?

Please let me know, thanks very much for your help.

Anda

Options: ReplyQuote


Subject
Views
Written By
Posted
6061
February 26, 2006 04:23PM
3331
February 27, 2006 05:45AM
2715
February 27, 2006 01:58PM
Re: innodb update locks table...
2844
February 28, 2006 04:41PM
2627
February 28, 2006 05:57PM
2547
February 28, 2006 06:28PM
2409
March 01, 2006 08:26AM
5136
March 10, 2006 04:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.