pt-summary
pt-summary主要是用来统计机器信息:
[root@mxqmongodb2 bin]# ./pt-summary # Percona Toolkit System Summary Report ###################### Date | 2017-06-27 02:47:13 UTC (local TZ: CST +0800) Hostname | mxqmongodb2 Uptime | 80 days, 23:07, 7 users, load average: 0.35, 0.38, 0.33 System | VMware, Inc.; VMware Virtual Platform; vNone (Other) Service Tag | VMware-42 13 2d 06 65 9d df f3-35 be 5e 0a c8 12 9a 3a Platform | Linux Release | CentOS release 6.5 (Final) Kernel | 2.6.32-431.el6.x86_64 Architecture | CPU = 64-bit, OS = 64-bit Threading | NPTL 2.12 SELinux | Disabled Virtualized | VMWare # Processor ################################################## Processors | physical = 2, cores = 4, virtual = 4, hyperthreading = no Speeds | 4x2394.000 Models | 4xIntel(R) Xeon(R) CPU E5645 @ 2.40GHz Caches | 4x12288 KB # Memory ##################################################### Total | 5.7G Free | 123.4M Used | physical = 5.6G, swap allocated = 7.8G, swap used = 2.2G, virtual = 7.8G Shared | 0.0 Buffers | 229.8M Caches | 2.5G Dirty | 240 kB UsedRSS | 2.3G Swappiness | 10 DirtyPolicy | 20, 10 DirtyStatus | 0, 0 Locator Size Speed Form Factor Type Type Detail ========= ======== ================= ============= ============= =========== RAM slot #1 2048 MB Unknown DIMM DRAM EDO RAM slot #0 4096 MB Unknown DIMM DRAM EDO RAM slot #10 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #11 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #12 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #13 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #14 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #15 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #16 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #17 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #18 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #19 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #20 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #21 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #22 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #23 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #24 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #25 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #26 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #27 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #28 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #29 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #2 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #30 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #31 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #32 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #33 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #34 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #35 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #36 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #37 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #38 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #39 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #3 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #40 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #41 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #42 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #43 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #44 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #45 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #46 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #47 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #48 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #49 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #4 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #50 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #51 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #52 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #53 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #54 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #55 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #56 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #57 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #58 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #59 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #5 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #60 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #61 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #62 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #63 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #6 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #7 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #8 {EMPTY} Unknown DIMM DRAM Unknown RAM slot #9 {EMPTY} Unknown DIMM DRAM Unknown # Mounted Filesystems ######################################## Filesystem Size Used Type Opts Mountpoint /dev/sda1 128M 19% vfat rw,uid=0,gid=0,umask=0077,shortname=winnt /boot/efi /dev/sda2 97M 32% ext4 rw /boot /dev/sda3 9.9G 15% ext4 rw / /dev/sda5 9.9G 4% ext4 rw,nosuid /var /dev/sda7 4.9G 3% ext4 rw,noexec,nosuid,nodev /tmp /dev/sda8 47G 72% ext4 rw,nosuid,nodev /home tmpfs 2.9G 0% tmpfs rw /dev/shm # Disk Schedulers And Queue Size ############################# sda | [cfq] 128 sr0 | [cfq] 128 # Disk Partioning ############################################ Device Type Start End Size ============ ==== ========== ========== ================== /dev/sda Disk 85899345920 /dev/sda1 Part 1 17 131604480 /dev/sda2 Part 17 30 106928640 /dev/sda3 Part 30 1335 10733990400 /dev/sda4 Part 1335 10444 74924075520 /dev/sda5 Part 1335 2641 10742215680 /dev/sda6 Part 2641 3661 8389785600 /dev/sda7 Part 3661 4307 5313530880 /dev/sda8 Part 4307 10444 50478543360 # Kernel Inode State ######################################### dentry-state | 47363 41655 45 0 0 0 file-nr | 928 0 592931 inode-nr | 52370 5785 # LVM Volumes ################################################ Unable to collect information # LVM Volume Groups ########################################## Unable to collect information # RAID Controller ############################################ Controller | No RAID controller detected # Network Config ############################################# Controller | VMware VMXNET3 Ethernet Controller (rev 01) FIN Timeout | 10 Port Range | 65535 # Interface Statistics ####################################### interface rx_bytes rx_packets rx_errors tx_bytes tx_packets tx_errors ========= ========= ========== ========== ========== ========== ========== lo 3500000000 350000000 0 3500000000 350000000 0 eth0 1750000000 350000000 0 50000000 350000000 0 # Network Devices ############################################ Device Speed Duplex ========= ========= ========= eth0 10000Mb/s Full # Network Connections ######################################## Connections from remote IP addresses 172.16.9.108 1 172.16.16.34 60 172.16.16.35 40 127.0.0.1 4 Connections to local IP addresses 172.16.16.35 100 127.0.0.1 4 Connections to top 10 local ports 17001 5 17002 5 17003 5 26379 2 27017 7 27018 9 3306 3 6379 4 6380 4 7618 1 States of connections ESTABLISHED 100 LISTEN 20 TIME_WAIT 1 # Top Processes ############################################## PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 23529 root 20 0 134m 6956 732 S 2.0 0.1 117:20.07 redis-server 1 root 20 0 19232 584 404 S 0.0 0.0 0:01.56 init 2 root 20 0 0 0 0 S 0.0 0.0 0:00.06 kthreadd 3 root RT 0 0 0 0 S 0.0 0.0 0:02.05 migration/0 4 root 20 0 0 0 0 S 0.0 0.0 0:30.19 ksoftirqd/0 5 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/0 6 root RT 0 0 0 0 S 0.0 0.0 0:09.66 watchdog/0 7 root RT 0 0 0 0 S 0.0 0.0 0:02.01 migration/1 8 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/1 # Notable Processes ########################################## PID OOM COMMAND 32339 -17 sshd # Simplified and fuzzy rounded vmstat (wait please) ########## procs ---swap-- -----io---- ---system---- --------cpu-------- r b si so bi bo ir cs us sy il wa st 1 0 0 0 2 15 0 0 0 0 98 1 0 0 0 0 0 300 100 2500 2500 4 5 88 4 0 0 0 0 0 0 300 1250 1250 1 0 91 9 0 0 0 0 0 0 100 1000 1250 0 0 97 3 0 0 0 0 0 0 500 1250 1250 1 0 93 6 0 # The End ####################################################
热衷于学习讨论MySQL和SQL Server,NoSQL等数据库技术,欢迎加入SQL优化群:659336691