MySQL Forums
Forum List  »  Memory Storage Engine

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Hang while executing UPDATE against MEMORY table
6066
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.