Mysql2: close client connection

ruby database connection client mysql2
Marco picture Marco · Aug 12, 2013 · Viewed 10.5k times · Source

I am using Mysql2 to query a database on ruby. I initialize the connection by:

client = Mysql2::Client.new(:host => "localhost", :database => 'mydb', :username => "root")

Once the query is done successfully, how can I close the client connection? If I do not close it, I soon reach the maximum number of possible open connections.

Solution

Thanks to @joonty:

client.close

Answer

Jon Cairns picture Jon Cairns · Aug 12, 2013

Use client.close. From the docs:

Mysql2::Client#close

Immediately disconnect from the server, normally the garbage collector will disconnect automatically when a connection is no longer needed. Explicitly closing this will free up server resources sooner than waiting for the garbage collector.

Have you got multiple long-running processes that only use the mysql connection for a short time? That should be the only case where this is an issue. If your processes are ending then the connection will be closed as part of garbage collection, so your issue lies elsewhere.

Related questions

How to drop columns using Rails migration

What's the syntax for dropping a database table column through a Rails migration?

Read More
Difference between rake db:migrate db:reset and db:schema:load

The difference between rake db:migrate and rake db:reset is pretty clear in my head. The thing which I don't understand is how rake db:schema:load different from the former two. Just to be sure that I am …

Read More
Rails :include vs. :joins

This is more of a "why do things work this way" question rather than a "I don't know how to do this" question... So the gospel on pulling associated records that you know you're going to use is to use :…

Read More