Get the App
SLTechnology News&Howtos  ›  Database  › 

Pt-summary is mainly used to count machine information, pt-mysql-summary analysis, mysq database

Shulou Source: shulou.com Published: 2022-06-01 19:19:57 10月01日 Update

This section shows the current date and time, as well as an overview of the server and operating system.

Percona Toolkit System Summary Report

This segment is extracted from / proc/cpuinfo

Processor

Memory information. Generated from free, ps, sysctl, and dmidecode.

Memory

Mount the file system. Generated from mount and df.

Mounted Filesystems

Disk scheduling information. Extracted from / sys.

Disk Schedulers And Queue Size

Disk partition information. Generated from fdisk-l.

Disk Partioning

Kernel index node information. They are extracted from files of the same name in the / proc/sys/fs directory.

Kernel Inode State

RAID controller. Generated from lvs.

RAID Controller

Network configuration. Generated from lspci and sysctl.

Network Config

Network interface statistics. Generated from ip-s link.

Interface Statistics

Summary of network connections. Generated from netstat.

Network Connections

The first few lines of top.

Top Processes

Vmstat 1 5 after cropping

Simplified and fuzzy rounded vmstat (wait please)

Time refers to the current time of the MySQL server, not the time of the system on which the MySQL server resides

Pt-mysql-summary-user=root-password=energy@db-port=3307

Tags: Generation information time server system network service file disk statistics operating system memory kernel location interface controller date overview directory index Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Microsoft macOS NVidia OPPO Reno Redmi