Nodejs and MySQL connection Pool application (pool)

/*
* Technology for connection pooling and caching
*
*/

var mysql = require (' mysql '); var pool = Mysql.createpool ({    connectionlimit:2,//connection pool can create a maximum number of connections    host: ',    User: ' Root ',    database: ' Yudi ',    password: ',    queuelimit:8//queue to wait for the maximum number of connections, 0 is unlimited. });//Pool.query (' select * from person ', function (err,rows,fileds) {//     console.log (rows);/});p Ool.on (' Connection ', function () {Console.log (' Create a Connection ');}); /When a back-down press-in team waits for the connection to trigger the queue event Pool.on (' Enqueue ', function () {Console.log (' queue ');}); function query () {pool.getconnection (function (err,connection) {connection.query (' select * from person ', function (err,　　rows) {//console.log (row.length);　　SetTimeout (function () {connection.release (); },200)})};query ();//queue query ();//Create a connection query ();//Create a connection

　　

　　

Nodejs and MySQL connection Pool application (pool)