pt mysql summary_Percona-Tookit工具包之pt-summary

ThoughtWorks中国

于 2021-02-09 00:26:00 发布

阅读量111

点赞数

文章标签： pt mysql summary

本文链接：https://blog.csdn.net/weixin_33254139/article/details/113960338

版权

1 [root@zlm2 10:09:49 ~]2 #pt-summary --save-samples=`date +%Y%m%d`3 # Percona Toolkit System Summary Report ######################4 Date | 2018-07-23 08:10:49 UTC (local TZ: CEST +0200)5 Hostname |zlm26 Uptime | 2:51, 2 users, load average: 0.03, 0.03, 0.05

7 System | innotek GmbH; VirtualBox; v1.2(Other)8 Service Tag | 0

14 SELinux |Disabled15 Virtualized |VirtualBox16 # Processor ##################################################17 Processors | physical = 1, cores = 1, virtual = 1, hyperthreading =no18 Speeds | 1x2396.405

19 Models | 1xIntel(R) Core(TM) i5-6200U CPU @ 2.30GHz20 Caches |1x3072 KB21 # Memory #####################################################22 Total | 993.6M

23 Free | 588.3M

24 Used | physical = 250.9M, swap allocated = 1016.0M, swap used = 0.0, virtual = 250.9M

25 Shared | 6.5M

26 Buffers | 154.5M

27 Caches | 606.5M

28 Dirty | 56kB29 UsedRSS | 296.2M

30 Swappiness | 30

31 DirtyPolicy | 30, 10

32 DirtyStatus | 0, 0

33 Locator Size Speed Form Factor Type Type Detail34 ========= ======== ================= ============= ============= ===========

35 # Mounted Filesystems ########################################36 Filesystem Size Used Type Opts Mountpoint37 /dev/mapper/centos-root 8.4G 83% xfs rw,relatime,attr2,inode64,noquota /

38 /dev/sda1 497M 24% xfs rw,relatime,attr2,inode64,noquota /boot39 devtmpfs 488M 0% devtmpfs rw,nosuid,size=499536k,nr_inodes=124884,mode=755 /dev40 none 87G 93% vboxsf rw,nodev,relatime /vagrant41 tmpfs 497M 0% tmpfs rw,nosuid,nodev /dev/shm42 tmpfs 497M 0% tmpfs rw,nosuid,nodev,mode=755 /dev/shm43 tmpfs 497M 0% tmpfs rw,nosuid,nodev,noexec,mode=755 /dev/shm44 tmpfs 497M 0% tmpfs rw,nosuid,nodev /sys/fs/cgroup45 tmpfs 497M 0% tmpfs rw,nosuid,nodev,mode=755 /sys/fs/cgroup46 tmpfs 497M 0% tmpfs rw,nosuid,nodev,noexec,mode=755 /sys/fs/cgroup47 tmpfs 497M 2% tmpfs rw,nosuid,nodev /run48 tmpfs 497M 2% tmpfs rw,nosuid,nodev,mode=755 /run49 tmpfs 497M 2% tmpfs rw,nosuid,nodev,noexec,mode=755 /run50 # Disk Schedulers And Queue Size #############################51 dm-0 | 128

52 dm-1 | 128

53 sda | [cfq] 128

54 sr0 | [cfq] 128

55 sr1 | [cfq] 128

56 # Disk Partioning ############################################57 Device Type Start End Size58 ============ ==== ========== ========== ==================

59 /dev/dm-0 Disk 8996782080

60 /dev/dm-1 Disk 1065353216

61 /dev/sda Disk 10632560640

62 /dev/sda1 Part 2048 1026047 524287488

63 /dev/sda2 Part 1026048 20766719 10107223552

64 # Kernel Inode State #########################################65 dentry-state | 22304 13658 45 0 0 0

66 file-nr | 1056 0 99224

67 inode-nr | 19311 307

68 # LVM Volumes ################################################69 LV VG Attr LSize Pool Origin Data% Meta% Move Log Cpy%Sync Convert70 root centos -wi-ao---- <8.38g71 swap centos -wi-ao---- 1016.00m

72 # LVM Volume Groups ##########################################73 VG VSize VFree74 centos 9.41g 40.00m

75 # RAID Controller ############################################76 Controller |No RAID controller detected77 # Network Config #############################################78 Controller | Intel Corporation 82540EM Gigabit Ethernet Controller (rev 02)79 Controller | Intel Corporation 82540EM Gigabit Ethernet Controller (rev 02)80 FIN Timeout | 60

81 Port Range | 61000

82 # Interface Statistics #######################################83 interface rx_bytes rx_packets rx_errors tx_bytes tx_packets tx_errors84 ========= ========= ========== ========== ========== ========== ==========

85 lo 5000 45 0 5000 45 0

86 enp0s3 70000 700 0 70000 450 0

87 enp0s8 250000 3000 0 125000 1250 0

88 # Network Devices ############################################89 Device Speed Duplex90 ========= ========= =========

91 enp0s3 1000Mb/s Full92 enp0s8 1000Mb/s Full93 # Network Connections ########################################94 Connections from remote IP addresses95 192.168.1.1 2

96 192.168.1.101 1

97 Connections to local IP addresses98 192.168.1.101 3

99 Connections to top 10local ports100 22 2

101 59131 1

102 States of connections103 CLOSE_WAIT 1

104 ESTABLISHED 2

105 LISTEN 4

106 # Top Processes ##############################################107 PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+COMMAND108 1 root 20 0 54188 3940 2408 S 0.0 0.4 0:00.68systemd109 2 root 20 0 0 0 0 S 0.0 0.0 0:00.00kthreadd110 3 root 20 0 0 0 0 S 0.0 0.0 0:00.27 ksoftirqd/0

111 5 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/0:0H112 6 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/u2:0

113 7 root rt 0 0 0 0 S 0.0 0.0 0:00.00 migration/0

114 8 root 20 0 0 0 0 S 0.0 0.0 0:00.00rcu_bh115 9 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcuob/0

116 10 root 20 0 0 0 0 S 0.0 0.0 0:01.07rcu_sched117 # Notable Processes ##########################################118 PID OOM COMMAND119 895 -17sshd120 # Simplified and fuzzy rounded vmstat (waitplease) ##########121 procs ---swap-- -----io---- ---system---- --------cpu--------

122 r b si so bi bo ir cs us sy il wa st123 1 0 0 0 15 3 35 100 0 0 100 0 0

124 0 0 0 0 0 0 700 1250 11 18 70 0 0

125 0 0 0 0 0 0 35 90 0 1 99 0 0

126 0 0 0 0 0 0 35 80 0 0 100 0 0

127 0 0 0 0 0 0 30 80 0 0 100 0 0

128 # Memory mamagement ##########################################129 Transparent huge pages are enabled.130 # The End ####################################################131

132 [root@zlm2 10:10:53 ~]133 #ls -l134 total 16

135 drwxr-xr-x 2 root root 4096 Jul 23 10:10 20180723 //This is the newly created directory which contains individual information of system status.

136 -rw-------. 1 root root 1431 Jul 16 2015 anaconda-ks.cfg137 -rwxr-xr-x 1 root root 54 Jun 13 04:16 mysqld.sh

138 drwxr-xr-x 13 root root 4096 Jul 4 03:21 sysbench-1.0

139

140 [root@zlm2 10:10:54 ~]141 #cd 20180723/

142

143 [root@zlm2 10:10:57 ~/20180723]144 #ls -l145 total 120

146 -rw-r--r-- 1 root root 27356 Jul 23 10:10dmesg_file147 -rw-r--r-- 1 root root 1788 Jul 23 10:10dmidecode148 -rw-r--r-- 1 root root 1134 Jul 23 10:10ip149 -rw-r--r-- 1 root root 757 Jul 23 10:10lspci_file150 -rw-r--r-- 1 root root 258 Jul 23 10:10lvs151 -rw-r--r-- 1 root root 1402 Jul 23 10:10memory152 -rw-r--r-- 1 root root 1096 Jul 23 10:10mounted_fs153 -rw-r--r-- 1 root root 862 Jul 23 10:10netstat154 -rw-r--r-- 1 root root 1428 Jul 23 10:10network_devices155 -rw-r--r-- 1 root root 45 Jul 23 10:10notable_procs156 -rw-r--r-- 1 root root 854 Jul 23 10:10partitioning157 -rw-r--r-- 1 root root 733 Jul 23 10:10proc_cpuinfo_copy158 -rw-r--r-- 1 root root 770 Jul 23 10:10processes159 -rw-r--r-- 1 root root 681 Jul 23 10:10summary160 -rw-r--r-- 1 root root 28342 Jul 23 10:10sysctl161 -rw-r--r-- 1 root root 62 Jul 23 10:10 uptime

162 -rw-r--r-- 1 root root 44 Jul 23 10:10vgs163 -rw-r--r-- 1 root root 570 Jul 23 10:10vmstat164

165 [root@zlm2 10:19:06 ~/20180723]166 #cat memory //We can get detail information of memory usage in the collected file "memory".

167 total used free shared buff/cache available168 Mem: 1041899520 263057408 616837120 6823936 162004992 635920384

169 Swap: 1065349120 0 1065349120

170 MemTotal: 1017480kB171 MemFree: 602380kB172 MemAvailable: 621016kB173 Buffers: 768kB174 Cached: 127208kB175 SwapCached: 0kB176 Active: 254360kB177 Inactive: 104200kB178 Active(anon): 230776kB179 Inactive(anon): 6488kB180 Active(file): 23584kB181 Inactive(file): 97712kB182 Unevictable: 0kB183 Mlocked: 0kB184 SwapTotal: 1040380kB185 SwapFree: 1040380kB186 Dirty: 56kB187 Writeback: 0kB188 AnonPages: 230636kB189 Mapped: 31420kB190 Shmem: 6664kB191 Slab: 30232kB192 SReclaimable: 19928kB193 SUnreclaim: 10304kB194 KernelStack: 2288kB195 PageTables: 4160kB196 NFS_Unstable: 0kB197 Bounce: 0kB198 WritebackTmp: 0kB199 CommitLimit: 1549120kB200 Committed_AS: 796324kB201 VmallocTotal: 34359738367kB202 VmallocUsed: 22112kB203 VmallocChunk: 34359713784kB204 HardwareCorrupted: 0kB205 AnonHugePages: 178176kB206 HugePages_Total: 0

207 HugePages_Free: 0

208 HugePages_Rsvd: 0

209 HugePages_Surp: 0

210 Hugepagesize: 2048kB211 DirectMap4k: 49088kB212 DirectMap2M: 999424 kB