mysql 主从延时问题

import mysql.connector

def check_slave_delay(master_host, master_port, master_user, master_password, slave_host, slave_port, slave_user, slave_password):
    master_conn = mysql.connector.connect(host=master_host, port=master_port, user=master_user, password=master_password)
    slave_conn = mysql.connector.connect(host=slave_host, port=slave_port, user=slave_user, password=slave_password)

    master_cursor = master_conn.cursor()
    slave_cursor = slave_conn.cursor()

    master_cursor.execute("SHOW MASTER STATUS")
    master_status = master_cursor.fetchone()

    slave_cursor.execute("SHOW SLAVE STATUS")
    slave_status = slave_cursor.fetchone()

    if master_status and slave_status:
        master_file = master_status[0]
        master_position = master_status[1]
        slave_file = slave_status[5]
        slave_position = slave_status[6]

        if master_file == slave_file:
            delay = slave_position - master_position
        else:
            delay = None

        return delay
    else:
        return None

# 使用示例
master_host = "your_master_host"
master_port = 3306
master_user = "your_master_user"
master_password = "your_master_password"
slave_host = "your_slave_host"
slave_port = 3306
slave_user = "your_slave_user"
slave_password = "your_slave_password"

delay = check_slave_delay(master_host, master_port, master_user, master_password, slave_host, slave_port, slave_user, slave_password)
if delay is not None:
    print(f"Slave replication delay: {delay} events")
else:
    print("Unable to determine replication delay.")