在主库搜索 show slave status\G;
Seconds_Behind_Master: 0 ## 查看主库是否有延迟
SQL延迟解决办法介绍
database介绍:
show variables like ‘%para%’;
| slave_parallel_type | DATABASE
主从延迟MGR WS
核心参数 :
binlog_transaction_dependency_tracking = WRITESET # COMMIT_ORDER
transaction_write_set_extraction = XXHASH64
