# Percona Toolkit System Summary Report ###################### Date | 2016-09-01 04:22:12 UTC (local TZ: UTC +0000) Hostname | xxxxxxxx.hkdc Uptime | 21 days, 21:15, 3 users, load average: 0.22, 0.46, 0.58 System | HP; ProLiant DL360 Gen9; vNot Specified (Rack Mount Chassis) Service Tag | SGH626WWM4 Platform | Linux Release | CentOS Linux release 7.2.1511 (Core) Kernel | 3.10.0-327.28.2.el7.x86_64 Architecture | CPU = 64-bit, OS = 64-bit Threading | NPTL 2.17 SELinux | Disabled Virtualized | No virtualization detected # Processor ################################################## Processors | physical = 2, cores = 16, virtual = 32, hyperthreading = yes Speeds | 30x1200.000, 1x1320.000, 1x2397.109 Models | 32xIntel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz Caches | 32x20480 KB # Memory ##################################################### Total | 125.6G Free | 2.9G Used | physical = 121.6G, swap allocated = 1024.0M, swap used = 1024.0M, virtual = 122.6G Buffers | 1.2G Caches | 3.2G Dirty | 6044 kB UsedRSS | 120.5G Swappiness | 1 DirtyPolicy | 20, 10 DirtyStatus | 0, 0 Locator Size Speed Form Factor Type Type Detail ========= ======== ================= ============= ============= =========== PROC 1 DIMM 12 16384 MB 2133 MHz DIMM DDR4 Synchronous Registered (Buffered) PROC 1 DIMM 1 16384 MB 2133 MHz DIMM DDR4 Synchronous Registered (Buffered) PROC 1 DIMM 4 16384 MB 2133 MHz DIMM DDR4 Synchronous Registered (Buffered) PROC 1 DIMM 9 16384 MB 2133 MHz DIMM DDR4 Synchronous Registered (Buffered) PROC 2 DIMM 12 16384 MB 2133 MHz DIMM DDR4 Synchronous Registered (Buffered) PROC 2 DIMM 1 16384 MB 2133 MHz DIMM DDR4 Synchronous Registered (Buffered) PROC 2 DIMM 4 16384 MB 2133 MHz DIMM DDR4 Synchronous Registered (Buffered) PROC 2 DIMM 9 16384 MB 2133 MHz DIMM DDR4 Synchronous Registered (Buffered) PROC 1 DIMM 10 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 1 DIMM 11 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 1 DIMM 2 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 1 DIMM 3 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 1 DIMM 5 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 1 DIMM 6 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 1 DIMM 7 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 1 DIMM 8 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 2 DIMM 10 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 2 DIMM 11 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 2 DIMM 2 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 2 DIMM 3 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 2 DIMM 5 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 2 DIMM 6 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 2 DIMM 7 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 2 DIMM 8 {EMPTY} Unknown DIMM DDR4 Synchronous /run # Disk Schedulers And Queue Size ############################# dm-0 | 128 dm-1 | 128 dm-2 | 128 sda | [deadline] 128 sdb | [deadline] 128 # Disk Partioning ############################################ Device Type Start End Size ============ ==== ========== ========== ================== /dev/dm-0 Disk 1073741824 /dev/dm-1 Disk 118145155072 /dev/dm-2 Disk 1920324337664 /dev/sda Disk 119998218240 /dev/sdb Disk 1920326787072 /dev/sdb1 Part 2048 3750638255 1920325737984 # Kernel Inode State ######################################### dentry-state | 26361 10989 45 0 0 0 file-nr | 5440 0 9843551 inode-nr | 25115 444 # LVM Volumes ################################################ LV VG Attr LSize Pool Origin Data% Meta% Move Log Cpy%Sync Convert LogVol00 VolGroup00 -wi-ao---- 110.03g LogVol01 VolGroup00 -wi-ao---- 1.00g data VolGroup01 -wi-ao---- 1.75t # LVM Volume Groups ########################################## VG VSize VFree VolGroup00 111.07g 40.00m VolGroup01 1.75t 0 # RAID Controller ############################################ Controller | HP Smart Array logicaldrive 1 (111.8 GB, RAID 1, OK) physicaldrive 2I:2:1 (port 2I:box 2:bay 1, Solid State SATA, 120 GB, OK) physicaldrive 2I:2:2 (port 2I:box 2:bay 2, Solid State SATA, 120 GB, OK) logicaldrive 2 (1.7 TB, RAID 1+0, OK) physicaldrive 1I:1:1 (port 1I:box 1:bay 1, Solid State SATA, 960.1 GB, OK) physicaldrive 1I:1:2 (port 1I:box 1:bay 2, Solid State SATA, 960.1 GB, OK) physicaldrive 1I:1:3 (port 1I:box 1:bay 3, Solid State SATA, 960.1 GB, OK) physicaldrive 1I:1:4 (port 1I:box 1:bay 4, Solid State SATA, 960.1 GB, OK) # Network Config ############################################# Controller | Broadcom Corporation NetXtreme BCM5719 Gigabit Ethernet PCIe (rev 01) Controller | Broadcom Corporation NetXtreme BCM5719 Gigabit Ethernet PCIe (rev 01) Controller | Broadcom Corporation NetXtreme BCM5719 Gigabit Ethernet PCIe (rev 01) Controller | Broadcom Corporation NetXtreme BCM5719 Gigabit Ethernet PCIe (rev 01) Controller | Intel Corporation 82599ES 10-Gigabit SFI/SFP+ Network Connection (rev 01) Controller | Intel Corporation 82599ES 10-Gigabit SFI/SFP+ Network Connection (rev 01) FIN Timeout | 30 Port Range | 65000 # Interface Statistics ####################################### interface rx_bytes rx_packets rx_errors tx_bytes tx_packets tx_errors ========= ========= ========== ========== ========== ========== ========== lo 4000000000 25000000 0 4000000000 25000000 0 eno49 300000000000 900000000 0 2000000000000 1750000000 0 eno1 1250000000000 1500000000 0 3500000000000 2500000000 0 eno2 0 0 0 0 0 0 eno3 0 0 0 0 0 0 eno50 0 0 0 0 0 0 eno4 0 0 0 0 0 0 # Network Devices ############################################ Device Speed Duplex ========= ========= ========= eno49 10000Mb/s Full eno50 Unknown! Unknown! eno1 1000Mb/s Full eno2 Unknown! Unknown! eno3 Unknown! Unknown! eno4 Unknown! Unknown! # Network Connections ######################################## Connections from remote IP addresses Connections to top 10 local ports 10050 125 22 2 3306 350 52134 1 53649 1 681 1 9104 45 9105 10 9106 1 9126 3 States of connections ESTABLISHED 300 LISTEN 15 SYN_SENT 1 TIME_WAIT 250 # Top Processes ############################################## PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 14408 mysql 20 0 0.134t 0.117t 7980 S 12.5 95.1 495:23.72 mysqld 28925 root 20 0 0 0 0 S 6.2 0.0 0:04.21 kworker/17+ 1 root 20 0 192856 6740 1468 S 0.0 0.0 3:17.55 systemd 2 root 20 0 0 0 0 S 0.0 0.0 0:00.24 kthreadd 3 root 20 0 0 0 0 S 0.0 0.0 0:15.15 ksoftirqd/0 5 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/0:+ 6 root 20 0 0 0 0 S 0.0 0.0 0:15.50 kworker/u6+ 8 root rt 0 0 0 0 S 0.0 0.0 0:20.68 migration/0 9 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcu_bh # Notable Processes ########################################## PID OOM COMMAND 12630 -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 70 100 0 0 1 0 99 0 0 0 0 0 0 100 1500 6000 15000 1 1 98 0 0 0 0 0 0 10 1250 7000 10000 1 0 99 0 0 1 0 0 0 80 350 2250 4000 0 0 100 0 0 1 0 0 0 80 600 2500 4000 1 0 99 0 0 # The End ####################################################