mysql如何解决高并发

-- 配置主库
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log

-- 配置从库
server-id = 2
relay_log = /var/log/mysql/mysql-relay-bin.log
read_only = 1

-- 假设将用户表分成多个表
CREATE TABLE user_0 (
    id INT PRIMARY KEY,
    name VARCHAR(255)
);

CREATE TABLE user_1 (
    id INT PRIMARY KEY,
    name VARCHAR(255)
);

import redis
import pymysql

r = redis.Redis(host='localhost', port=6379, db=0)
conn = pymysql.connect(host='localhost', user='root', password='password', db='test')

def get_user(user_id):
    data = r.get(f'user:{user_id}')
    if data:
        return data.decode('utf-8')
    else:
        cursor = conn.cursor()
        cursor.execute(f'SELECT * FROM users WHERE id={user_id}')
        user = cursor.fetchone()
        r.set(f'user:{user_id}', user)
        return user

from mysql.connector.pooling import MySQLConnectionPool

pool = MySQLConnectionPool(pool_name="mypool",
                            pool_size=5,
                            host='localhost',
                            database='test',
                            user='root',
                            password='password')

conn = pool.get_connection()
cursor = conn.cursor()
cursor.execute("SELECT * FROM users")
result = cursor.fetchall()
cursor.close()
conn.close()

-- 使用版本号实现乐观锁
UPDATE users SET name='new_name', version=version+1 WHERE id=1 AND version=1;

-- 增加最大连接数
max_connections = 500