Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Pt-stalk diagnosing MySQL problems pt-sift

2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Pt-stalk

Collect on-site data when a problem occurs

Triggered under certain conditions, some monitoring data are collected to facilitate the analysis of the problem. Root permission is required to run this feature. It can be used as a real-time acquisition function, or you can set trigger conditions.

Pt-stalk-disk-pct-free 20-collect-tcpdump-function status-variable Threads_connected-threshold 20-iterations 2000-daemonize-user=root-password=energy@db

Default log storage: / var/log/pt-stalk.log

Pid default storage: / run/pt-stalk.pid

Default storage of record files: / var/lib/pt-stalk

-- disk-pct-free 20: if the remaining space is less than 20%, data is no longer collected

-- collect-tcpdump: call tcpdump to collect network packet information

-- function status-- variable Threads_connected-- threshold 20:MySQL status value Threads_connected exceeding 20:00 triggers data collection

-- iterations 2000: this parameter specifies that pt-stalk will exit after collecting 2000 fault sites

-- daemonize: runs in the background

Tail-f / var/log/pt-stalk.log

Pt-sift analyzes the output of pt-stalk

Find the file analysis prefixed with 2018'07'04'10'03'51 in the default directory

Display only disk information

Pt-sift / var/lib/pt-stalk/2018_07_04_10_03_51

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report