nodejs mysql 高并发_nodejs处理高并发问题

function (err, res) {

if (!err) {

var insert = "insert into testlog(testid,num,`desc`) values ('" + id + "','" + num + "','" + dateFormat(new Date()) + "')";

connection.query(insert, function (err, res) {

if (!err) {

connection.end();

console.log("update sucess!");

} else {

console.log(err);

}

});

} else {

connection.end();

console.log(err);

}

});

});

function dateFormat(date) {

var fmt = "yyyy-MM-dd hh:mm:ss:SS";

var o = {

"M+": date.getMonth() + 1, //??

"d+": date.getDate(), //?

"h+": date.getHours(), //С?

"m+": date.getMinutes(), //?

"s+": date.getSeconds(), //?

"q+": Math.floor((date.getMonth() + 3) / 3), //??

"S+": date.getMilliseconds() //?ī

};

if (/(y+)/.test(fmt)) {

fmt = fmt.replace(RegExp.$1, (date.getFullYear() + "").substr(4 - RegExp.$1.length));

}

for (var k in o) {

if (new RegExp("(" + k + ")").test(fmt)) {

fmt = fmt.replace(RegExp.$1, (RegExp.$1.length == 1) ? (o[k]) : (("00" + o[k]).substr(("" + o[k]).length)));

}

}

return fmt;

}

}).listen(3000);