Mysql connection after release in node.js + mysql pool

Question

I cannot understand why could I connect to Mysql after release.

And is there a way to check the status of Mysql ?

Thanks for the help !

var mysqlConfig = {
    host     : "abcd",
    port     : "3306",
    user     : "root",
    password : "root",
    database : "test"
};
var pool = mysql.createPool(mysqlConfig);


pool.getConnection(function(err, conn) {
    // release pool
    conn.release();

    // After release, Why could I connect to Mysql ????
    conn.query('SELECT * FROM user_info WHERE user_id = ?', [id], function(err, rows) {
        if (err) {
            pushErr();
        }
        // ...
    });
});

Paul · Accepted Answer · 2014-10-23 16:55:37Z

1

Based on the documentation here: https://github.com/felixge/node-mysql it looks like the connection being 'released' doesn't destroy the connection per se, it just signals the pool that it can be used by someone else if needed. If you notice the example, they release as part of the query callback. If you need to actually get rid of the connection, you should use conn.destroy().

answered Oct 23, 2014 at 16:55

Paul

36.4k12 gold badges98 silver badges124 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mysql connection after release in node.js + mysql pool

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related