mysql一直死锁解决方法

SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;

START TRANSACTION;
-- 执行SQL操作
COMMIT;

-- 假设有两个表table1和table2
START TRANSACTION;
SELECT * FROM table1 WHERE id = 1 FOR UPDATE;
SELECT * FROM table2 WHERE id = 1 FOR UPDATE;
COMMIT;

SET innodb_lock_wait_timeout = 5; -- 设置超时时间为5秒

SHOW ENGINE INNODB STATUS;

CREATE INDEX idx_column_name ON table_name(column_name);

-- 创建表
CREATE TABLE table1 (
    id INT PRIMARY KEY,
    name VARCHAR(255)
);

CREATE TABLE table2 (
    id INT PRIMARY KEY,
    description VARCHAR(255)
);

-- 插入数据
INSERT INTO table1 (id, name) VALUES (1, 'Item1');
INSERT INTO table2 (id, description) VALUES (1, 'Description1');

-- 事务1
START TRANSACTION;
SELECT * FROM table1 WHERE id = 1 FOR UPDATE;
SELECT * FROM table2 WHERE id = 1 FOR UPDATE;
COMMIT;

-- 事务2
START TRANSACTION;
SELECT * FROM table2 WHERE id = 1 FOR UPDATE;
SELECT * FROM table1 WHERE id = 1 FOR UPDATE;
COMMIT;