mysql api内存增加

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

async function query(sql, params) {
  const connection = await mysql.createConnection({
    host: 'localhost',
    user: 'user',
    password: 'password',
    database: 'database'
  });

  try {
    const [results] = await connection.execute(sql, params);
    return results;
  } finally {
    connection.end(); // 确保连接被关闭
  }
}

const cache = new Map();

function getFromCache(key) {
  const cachedData = cache.get(key);
  if (cachedData && Date.now() < cachedData.expires) {
    return cachedData.data;
  }
  return null;
}

function setToCache(key, data, ttl = 60000) {
  cache.set(key, { data, expires: Date.now() + ttl });
}

// 示例：确保文件句柄被正确关闭
const fs = require('fs');

function readFile(filePath) {
  let data;
  try {
    data = fs.readFileSync(filePath, 'utf8');
  } finally {
    // 文件句柄在 readFileSync 中自动关闭
  }
  return data;
}