mysql 锁超时和死锁

import mysql.connector
from mysql.connector import Error

try:
    connection = mysql.connector.connect(host='localhost',
                                         database='test_db',
                                         user='root',
                                         password='password')

    cursor = connection.cursor()

    # 设置锁等待超时时间为5秒
    cursor.execute("SET innodb_lock_wait_timeout = 5")

    try:
        # 开始事务
        cursor.execute("START TRANSACTION")

        # 执行SQL语句（示例）
        cursor.execute("UPDATE table_name SET column1 = value1 WHERE condition")

        # 提交事务
        connection.commit()
    except mysql.connector.Error as err:
        # 发生错误时回滚事务
        connection.rollback()
        print(f"Error: {err}")
    finally:
        # 关闭游标和连接
        cursor.close()
        connection.close()

except Error as e:
    print(f"Error while connecting to MySQL: {e}")