Skip to content

'mysqlplus' blocks the entire Ruby process when connecting to DB #3

Open
ibc opened this Issue Dec 28, 2009 · 3 comments

2 participants

@ibc
ibc commented Dec 28, 2009

Hi, "mysqlplus" (and of course also "mysql") driver blocks totally the Ruby process when it's trying to connect to a MySQL server. In case the server doesn't respond then we get our Tuby application stopped forever.

Please check the following code which shows the issue:
http://gist.github.com/264866

Is it possible to make MySQL connection non-blocking?

Regards.

@ibc
ibc commented Dec 28, 2009

I've reported same bug for 'pg' driver and it's fixed now (it already implemented non-blocking connection):

http://bitbucket.org/ged/ruby-pg/issue/14/pgconnconnect-blocks-forever-if-the-db-host-is#comment-100487
http://bitbucket.org/ged/ruby-pg/changeset/f5af71167dea/

@skiz
skiz commented Feb 17, 2010

To create a non-blocking connection you need to provide a timeout (works in all mysql libs) as by default there is no connect timeout defined.
con = Mysql.init
con.options(Mysql::OPT_CONNECT_TIMEOUT, 5) # 5 second timeout

@ibc
ibc commented Feb 18, 2010

Great, I didn't know such option. I will report to Sequel developer to include it.
Thanks.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.