mysql升级后 连接特别慢

-- 检查并调整my.cnf或my.ini文件
[mysqld]
innodb_buffer_pool_size = 1G  -- 根据服务器内存调整
max_connections = 500          -- 根据需求调整

-- 更改用户认证插件
ALTER USER 'your_user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password';
FLUSH PRIVILEGES;

-- 分析表和索引
ANALYZE TABLE your_table;
-- 查看慢查询日志
SHOW VARIABLES LIKE 'slow_query_log';

import mysql.connector

config = {
    'user': 'your_user',
    'password': 'your_password',
    'host': 'localhost',
    'database': 'your_database',
    'raise_on_warnings': True
}

try:
    cnx = mysql.connector.connect(**config)
    cursor = cnx.cursor()
    # 执行查询
    cursor.execute("SELECT * FROM your_table")
    for row in cursor:
        print(row)
except mysql.connector.Error as err:
    print(f"Error: {err}")
finally:
    cursor.close()
    cnx.close()