服务器数据库占内存满

-- MySQL示例，查看缓存使用情况
SHOW STATUS LIKE 'Qcache%';

-- PostgreSQL示例，查找长时间运行的事务
SELECT * FROM pg_stat_activity WHERE state = 'active' AND now() - query_start > INTERVAL '1 hour';

-- MySQL示例，分析表和索引
ANALYZE TABLE your_table;

# MySQL my.cnf示例，调整缓冲池大小
[mysqld]
innodb_buffer_pool_size = 1G

import mysql.connector
import time

def monitor_and_clean_db(host, user, password, database):
    conn = mysql.connector.connect(host=host, user=user, password=password, database=database)
    cursor = conn.cursor()
    
    while True:
        cursor.execute("SHOW STATUS LIKE 'Qcache%';")
        result = cursor.fetchone()
        if result and int(result[1]) > 80:  # 如果缓存使用率超过80%
            cursor.execute("RESET QUERY CACHE;")
            print("Query cache reset.")
        
        time.sleep(60)  # 每分钟检查一次

monitor_and_clean_db('localhost', 'your_user', 'your_password', 'your_database')