node中的mysql连接池

const mysql = require('mysql2/promise');

async function main() {
  const pool = mysql.createPool({
    host: 'localhost',
    user: 'your_username',
    password: 'your_password',
    database: 'your_database',
    waitForConnections: true,
    connectionLimit: 10,
    queueLimit: 0
  });

  try {
    const connection = await pool.getConnection();
    console.log('Connected to the database');
    await connection.query('SELECT 1 + 1 AS solution');
    console.log('Query executed');
    connection.release();
  } catch (err) {
    console.error('Error:', err);
  }
}

main();

const pool = mysql.createPool({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database',
  waitForConnections: true,
  connectionLimit: 20, // 增加连接数
  queueLimit: 100 // 允许更多请求排队
});

async function queryDatabase() {
  let connection;
  try {
    connection = await pool.getConnection();
    const [results] = await connection.query('SELECT * FROM your_table');
    console.log(results);
  } catch (err) {
    console.error('Error:', err);
  } finally {
    if (connection) connection.release();
  }
}