SLTechnology News&Howtos › Database ›

Mysql percona-toolkit Swiss Army knife

Shulou Source: shulou.com Published: 2022-06-01 06:11:28 10月02日 Update

View master-slave delay

Main library:

. / pt-heartbeat-user=root-password=123456-D test-master-server-id=1-create-table-update &

From the library:

. / pt-heartbeat-user=root-password=123456-D test-master-server-id=1-monitor-print-master-server-id

Skip errors from the library

. / pt-slave-restart-- user=root-- password=123456-error-numbers=1062

Capture the slowest 10 sql

. / pt-query-digest-- since=24h / data/mysql/slow.log > 1.log