MySQL 在 Node.js 服务器空闲时间后给出“read ECONNRESET”错误

MySQL 在 Node.js 服务器空闲时间后给出“read ECONNRESET”错误

javascript
const mysql = require('mysql');
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});
function keepAlive() {
  connection.query('SELECT 1', (error, results) => {
    if (error) throw error;
    console.log('Database connection is active');
  });
}
setInterval(keepAlive, 60000); // 每隔一分钟发送一个查询操作

javascript
const mysql = require('mysql');
const pool = mysql.createPool({
  connectionLimit: 10,
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});
function queryDatabase(sql, values) {
  return new Promise((resolve, reject) => {
    pool.getConnection((error, connection) => {
      if (error) {
        reject(error);
      } else {
        connection.query(sql, values, (error, results) => {
          connection.release();
          if (error) {
            reject(error);
          } else {
            resolve(results);
          }
        });
      }
    });
  });
}
// 使用示例
queryDatabase('SELECT * FROM users')
  .then(results => {
    console.log(results);
  })
  .catch(error => {
    console.error(error);
  });