pt-summary # Percona Toolkit System Summary Report ###################### Date | 2018-07-23 05:33:50 UTC (local TZ: WEST +0100) Hostname | db2 Uptime | 416 days, 18:31, 2 users, load average: 0.28, 0.40, 0.46 System | HP; ProLiant BL460c Gen9; vNot Specified (Blade) Service Tag | CZ252303HN Platform | Linux Release | Red Hat Enterprise Linux Server release 7.3 (Maipo) Kernel | 3.10.0-514.16.1.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 = 24, virtual = 48, hyperthreading = yes Speeds | 1x2297.426, 47x2300.000 Models | 48xIntel(R) Xeon(R) CPU E5-2670 v3 @ 2.30GHz Caches | 48x30720 KB # Memory ##################################################### Total | 15.3G Free | 213.2M Used | physical = 11.1G, swap allocated = 7.8G, swap used = 696.7M, virtual = 11.8G Shared | 808.5M Buffers | 3.9G Caches | 2.8G Dirty | 2272 kB UsedRSS | 11.1G Swappiness | 1 DirtyPolicy | 2, 10 DirtyStatus | 0, 0 Locator Size Speed Form Factor Type Type Detail ========= ======== ================= ============= ============= =========== PROC 1 DIMM 1 8192 MB 2133 MHz DIMM DDR4 Synchronous Registered (Buffered) PROC 2 DIMM 1 8192 MB 2133 MHz DIMM DDR4 Synchronous Registered (Buffered) PROC 1 DIMM 2 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 1 DIMM 3 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 1 DIMM 4 {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 2 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 2 DIMM 3 {EMPTY} Unknown DIMM DDR4 Synchronous PROC 2 DIMM 4 {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 # Mounted Filesystems ######################################## Filesystem Size Used Type Opts Mountpoint /dev/mapper/rhel-aux0 9.8G 5% ext4 rw,relatime,stripe=64,data=ordered /aux0 /dev/mapper/rhel-aux1 144G 22% ext4 rw,relatime,stripe=64,data=ordered /aux1 /dev/mapper/rhel-home 40G 10% ext4 rw,relatime,stripe=64,data=ordered /home /dev/mapper/rhel-opt 39G 2% ext4 rw,relatime,stripe=64,data=ordered /opt /dev/mapper/rhel-root 20G 18% ext4 rw,relatime,stripe=64,data=ordered / /dev/mapper/rhel-var 4.7G 64% ext4 rw,relatime,stripe=64,data=ordered /var /dev/mapper/vg_db-LogVol01 1.6T 12% ext4 rw,noatime,nodiratime,stripe=256,data=ordered /share1 /dev/mapper/vg_db-LogVol02 1.6T 15% ext4 rw,noatime,nodiratime,stripe=256,data=ordered /share2 /dev/sda1 200M 5% vfat rw,relatime,fmask=0077,dmask=0077,codepage=437,iocharset=ascii,shortname=winnt,errors=remount-ro /boot/efi /dev/sda2 477M 43% ext4 rw,relatime,stripe=256,data=ordered /boot devtmpfs 7.7G 0% devtmpfs rw,nosuid,size=8002772k,nr_inodes=2000693,mode=755 /dev tmpfs 1.6G 0% tmpfs rw,nosuid,nodev /run/user/0 tmpfs 1.6G 0% tmpfs rw,nosuid,nodev,mode=755 /run/user/0 tmpfs 1.6G 0% tmpfs rw,nosuid,nodev,relatime,size=1602848k,mode=700 /run/user/0 tmpfs 1.6G 0% tmpfs rw,nosuid,nodev,relatime,size=1602848k,mode=700,uid=1000,gid=1000 /run/user/0 tmpfs 1.6G 0% tmpfs rw,nosuid,nodev,relatime,size=1602848k,mode=700,uid=1031,gid=1032 /run/user/0 tmpfs 1.6G 0% tmpfs ro,nosuid,nodev,noexec,mode=755 /run/user/0 tmpfs 1.6G 0% tmpfs rw,nosuid,nodev /run/user/1000 tmpfs 1.6G 0% tmpfs rw,nosuid,nodev,mode=755 /run/user/1000 tmpfs 1.6G 0% tmpfs rw,nosuid,nodev,relatime,size=1602848k,mode=700 /run/user/1000 tmpfs 1.6G 0% tmpfs rw,nosuid,nodev,relatime,size=1602848k,mode=700,uid=1000,gid=1000 /run/user/1000 tmpfs 1.6G 0% tmpfs rw,nosuid,nodev,relatime,size=1602848k,mode=700,uid=1031,gid=1032 /run/user/1000 tmpfs 1.6G 0% tmpfs ro,nosuid,nodev,noexec,mode=755 /run/user/1000 tmpfs 1.6G 0% tmpfs rw,nosuid,nodev /run/user/1031 tmpfs 1.6G 0% tmpfs rw,nosuid,nodev,mode=755 /run/user/1031 tmpfs 1.6G 0% tmpfs rw,nosuid,nodev,relatime,size=1602848k,mode=700 /run/user/1031 tmpfs 1.6G 0% tmpfs rw,nosuid,nodev,relatime,size=1602848k,mode=700,uid=1000,gid=1000 /run/user/1031 tmpfs 1.6G 0% tmpfs rw,nosuid,nodev,relatime,size=1602848k,mode=700,uid=1031,gid=1032 /run/user/1031 tmpfs 1.6G 0% tmpfs ro,nosuid,nodev,noexec,mode=755 /run/user/1031 tmpfs 7.7G 0% tmpfs rw,nosuid,nodev /dev/shm tmpfs 7.7G 0% tmpfs rw,nosuid,nodev,mode=755 /dev/shm tmpfs 7.7G 0% tmpfs rw,nosuid,nodev,relatime,size=1602848k,mode=700 /dev/shm tmpfs 7.7G 0% tmpfs rw,nosuid,nodev,relatime,size=1602848k,mode=700,uid=1000,gid=1000 /dev/shm tmpfs 7.7G 0% tmpfs rw,nosuid,nodev,relatime,size=1602848k,mode=700,uid=1031,gid=1032 /dev/shm tmpfs 7.7G 0% tmpfs ro,nosuid,nodev,noexec,mode=755 /dev/shm tmpfs 7.7G 0% tmpfs rw,nosuid,nodev /sys/fs/cgroup tmpfs 7.7G 0% tmpfs rw,nosuid,nodev,mode=755 /sys/fs/cgroup tmpfs 7.7G 0% tmpfs rw,nosuid,nodev,relatime,size=1602848k,mode=700 /sys/fs/cgroup tmpfs 7.7G 0% tmpfs rw,nosuid,nodev,relatime,size=1602848k,mode=700,uid=1000,gid=1000 /sys/fs/cgroup tmpfs 7.7G 0% tmpfs rw,nosuid,nodev,relatime,size=1602848k,mode=700,uid=1031,gid=1032 /sys/fs/cgroup tmpfs 7.7G 0% tmpfs ro,nosuid,nodev,noexec,mode=755 /sys/fs/cgroup tmpfs 7.7G 11% tmpfs rw,nosuid,nodev /run tmpfs 7.7G 11% tmpfs rw,nosuid,nodev,mode=755 /run tmpfs 7.7G 11% tmpfs rw,nosuid,nodev,relatime,size=1602848k,mode=700 /run tmpfs 7.7G 11% tmpfs rw,nosuid,nodev,relatime,size=1602848k,mode=700,uid=1000,gid=1000 /run tmpfs 7.7G 11% tmpfs rw,nosuid,nodev,relatime,size=1602848k,mode=700,uid=1031,gid=1032 /run tmpfs 7.7G 11% tmpfs ro,nosuid,nodev,noexec,mode=755 /run # Disk Schedulers And Queue Size ############################# dm-0 | 128 dm-1 | 128 dm-2 | [deadline] 128 dm-3 | 128 dm-4 | 128 dm-5 | 128 dm-6 | 128 dm-7 | 128 dm-8 | 128 dm-9 | 128 sda | [deadline] 128 sdb | [deadline] 128 sdc | [deadline] 128 sdd | [deadline] 128 sde | [deadline] 128 # Disk Partioning ############################################ Device Type Start End Size ============ ==== ========== ========== ================== /dev/dm-0 Disk 8388608000 /dev/dm-1 Disk 21474836480 /dev/dm-2 Disk 3596997361664 /dev/dm-3 Disk 1771674009600 /dev/dm-4 Disk 1771674009600 /dev/dm-5 Disk 42949672960 /dev/dm-6 Disk 10737418240 /dev/dm-7 Disk 157038936064 /dev/dm-8 Disk 5242880000 /dev/dm-9 Disk 41943040000 /dev/sda Disk 299966445568 /dev/sdb Disk 3596997361664 /dev/sdc Disk 3596997361664 /dev/sdd Disk 3596997361664 /dev/sde Disk 3596997361664 # Kernel Inode State ######################################### dentry-state | 110265 97391 45 0 0 0 file-nr | 7200 0 1583394 inode-nr | 72563 24195 # LVM Volumes ################################################ LV VG Attr LSize Pool Origin Data% Meta% Move Log Cpy%Sync Convert aux0 rhel -wi-ao---- 10.00g aux1 rhel -wi-ao---- 146.25g home rhel -wi-ao---- 40.00g opt rhel -wi-ao---- 39.06g root rhel -wi-ao---- 20.00g swap rhel -wi-ao---- 7.81g var rhel -wi-ao---- 4.88g LogVol01 vg_db -wi-ao---- 1.61t LogVol02 vg_db -wi-ao---- 1.61t # LVM Volume Groups ########################################## VG VSize VFree rhel 268.01g 0 vg_db 3.27t 49.96g # RAID Controller ############################################ Controller | HP Smart Array RAID controller software not found; try getting it from your package repository or the manufacturer's website # Network Config ############################################# Controller | Broadcom Limited BCM57840 NetXtreme II 10/20-Gigabit Ethernet (rev 11) Controller | Broadcom Limited BCM57840 NetXtreme II 10/20-Gigabit Ethernet (rev 11) Controller | Intel Corporation I350 Gigabit Backplane Connection (rev 01) Controller | Intel Corporation I350 Gigabit Backplane Connection (rev 01) Controller | Intel Corporation I350 Gigabit Backplane Connection (rev 01) Controller | Intel Corporation I350 Gigabit Backplane Connection (rev 01) FIN Timeout | 60 Port Range | 60999 # Interface Statistics ####################################### interface rx_bytes rx_packets rx_errors tx_bytes tx_packets tx_errors ========= ========= ========== ========== ========== ========== ========== lo 400000000000 2500000000 0 400000000000 2500000000 0 bond0 3500000000000 17500000000 0 30000000000000 35000000000 0 eno49 2250000000000 12500000000 0 10000000000000 15000000000 0 eno50 70000000 1000000 0 0 0 0 ens2f0 3500000 60000 0 3000000 60000 0 ens2f1 2500 35 0 450 7 0 ens2f2 0 0 0 0 0 0 ens2f3 0 0 0 0 0 0 bond1 3500000 60000 0 3000000 60000 0 bond0.11@bond0 1750000000000 10000000000 0 10000000000000 10000000000 0 bond0.14@bond0 12500000000 60000000 0 10000000000 50000000 0 bond0.17@bond0 50000000 600000 0 45000000 300000 0 # Network Devices ############################################ Device Speed Duplex ========= ========= ========= eno49 1000Mb/s Full bond0 1000Mb/s Full bond1 1000Mb/s Full eno50 1000Mb/s Full ens2f0 1000Mb/s Full ens2f1 1000Mb/s Full ens2f2 Unknown! Unknown! ens2f3 Unknown! Unknown! # Network Connections ######################################## Connections from remote IP addresses 10.76.44.216 1 10.104.117.202 25 10.104.117.203 45 10.104.117.204 4 10.104.117.205 6 10.104.117.206 5 10.104.117.207 15 10.104.117.208 10 10.104.117.209 1 10.104.118.202 35 10.104.118.203 30 10.104.118.204 4 10.104.118.205 2 10.104.118.206 1 10.104.118.207 5 10.104.118.208 4 10.229.243.27 1 10.229.243.28 2 10.229.243.32 1 10.229.243.37 1 10.254.173.242 2 127.0.0.1 6 Connections to local IP addresses 10.104.117.206 150 10.104.117.208 45 10.104.200.199 6 127.0.0.1 6 Connections to top 10 local ports 13994 9 22 3 3306 125 39638 3 57001 5 60080 1 60176 1 60968 1 60970 1 80 25 States of connections ESTABLISHED 125 LISTEN 35 TIME_WAIT 80 # Top Processes ############################################## PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 27931 root 20 0 264408 12164 3300 S 12.5 0.1 9961:39 occluster_+ 6212 root 20 0 253788 5924 2564 S 6.2 0.0 47342:24 octransfer+ 27914 root 20 0 623124 86076 1280 S 6.2 0.5 26:56.02 clusterman+ 1 root 20 0 194204 3212 1900 S 0.0 0.0 748:49.77 systemd 2 root 20 0 0 0 0 S 0.0 0.0 0:22.27 kthreadd 3 root 20 0 0 0 0 S 0.0 0.0 13:27.35 ksoftirqd/0 5 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/0:+ 8 root rt 0 0 0 0 S 0.0 0.0 0:16.33 migration/0 9 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcu_bh # Notable Processes ########################################## PID OOM COMMAND 42240 -17 sshd # Memory mamagement ########################################## Transparent huge pages are enabled. # The End ####################################################