Node Mysql Pool Not Ending / Closing

Question

Am I missing something here? This should work fine, but I find that Node run loop stays active.

var mysql   = require('mysql');

//Setup Connections and Parser
var pool = mysql.createPool({
    host     : 'localhost',
    user     : 'me',
    password : '12345',
    database : 'A2014',
    connectionLimit: 100
});

pool.getConnection(function(err, connection) {

    connection.query( 'select count(9) from mytbl;', function(err, rows) {
        connection.release();
    });

});

pool.end();

move the `pool.end()` to inside the pool.getConnection function — fmodos, Dec 09 '14 at 18:46
Thanks, @fmodos, you're right. But what if I have multiple getConnection blocks? — 4m1r, Dec 09 '14 at 18:51

score 3 · Accepted Answer · edited May 16 '16 at 07:07

var mysql   = require('mysql');

//Setup Connections and Parser
var pool = mysql.createPool({
    host     : 'localhost',
    user     : 'me',
    password : '12345',
    database : 'A2014',
    connectionLimit: 100
});

pool.getConnection(function(err, connection) {

    connection.query( 'select count(9) from mytbl;', function(err, rows) {
        connection.release();
    });
    pool.end();
});

Node Mysql Pool Not Ending / Closing

1 Answers1