查看主从延迟
主库:
./pt-heartbeat –user=root –password=123456 -D test –master-server-id=1 –create-table –update &
从库:
./pt-heartbeat –user=root –password=123456 –D test –master-server-id=1 –monitor –print-master-server-id
从库跳过错误
./pt-slave-restart –user=root –password=123456 -error-numbers=1062
捕获最慢的10条sql
./pt-query-digest –since=24h /data/mysql/slow.log >1.log