MySQL Forums
Forum List  »  Memory Storage Engine

Advanced Search
New Topic

Re: Hang while executing UPDATE against MEMORY table
Posted by: Eric Liang
Date: June 10, 2008 05:13AM

Hi,I'v solved this.

This was a bug of the mysql and was fix after 4.1.22,http://bugs.mysql.com/bug.php?id=9678

You should add a timeout clock when you query from the mysql server,that's mean you should use the function:mysql_options and set MYSQL_OPT_READ_TIMEOUT.

The docs:http://dev.mysql.com/doc/refman/5.0/en/mysql-options.html says:
This option works only for TCP/IP connections, and only for Windows prior to MySQL 5.0.25.

But according to the bugzilla page,it works on linux.And as you know,it works well on my machine,ubuntu 8.04.

Hope helpful for you.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Hang while executing UPDATE against MEMORY table
10224
Simon Gregory
November 28, 2007 03:56AM
Re: Hang while executing UPDATE against MEMORY table
5345
Simon Gregory
December 06, 2007 02:57AM
Re: Hang while executing UPDATE against MEMORY table
5978
Liang Eric
June 05, 2008 03:52AM
Re: Hang while executing UPDATE against MEMORY table
5699
Eric Liang
June 05, 2008 04:14AM
Re: Hang while executing UPDATE against MEMORY table
6131
Eric Liang
June 10, 2008 05:13AM


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.