Search code examples
node.jsnode-mysql

Node Mysql Pool Not Ending / Closing


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();

Solution

  • 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();
    });