Show information about top cpu, top latency, top memory and top IO dstat -c –top-cpu -d –top-bio –top-latency..
Quick cheatsheet from here – https://www.rosehosting.com/blog/optimizing-and-repairing-mysql-databases-with-mysqlcheck/ 1. Check one table in the MySQL database mysqlcheck -c database table -u root -p 2. Check ALL tables in the MySQL database mysqlcheck -a database -u root -p 3. Optimize all tables in all MySQL database mysqlcheck -o database -u root -p 4. Repair MySQL database mysqlcheck -r ..
Install Repo cd /etc/yum.repos.d/ wget http://packages.ntop.org/centos-stable/ntop.repo -O ntop.repo Install Epel rpm -ivh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm Install NTOP-NG yum erase zeromq3 yum clean all yum update yum install pfring n2disk nprobe ntopng ntopng-data cento yum install pfring-drivers-zc-dkms Open Firewall firewall-cmd –zone=public –add-port=3000/tcp –permanent firewall-cm..
# tuned-adm list Available profiles: – balanced – General non-specialized tuned profile – desktop – Optimize for the desktop use-case – latency-performance – Optimize for deterministic performance at the cost of increased power consumption – network-latency – Optimize for deterministic performance at the cost of increased power consumption, focused on low latency network performance – ..
SELECT cpu_count , [max_workers_count], [scheduler_count], [scheduler_total_count] FROM sys.[dm_os_sys_..
Nothing new, just for copy and paste purposes # netstat -ant | grep :80 | awk ‘{print $6}’ | sort | uniq -c | sort -n 1 CLOSING 1 LISTEN 2 LAST_ACK 11 FIN_WAIT2 16 FIN_WAIT1 67 ESTABLISHED 425..
Had to do this recently, couldn’t remember how to do it… mstsc.exe /admin /v:your..
cat /proc/version > r1soft.txt cat /etc/*release >> r1soft.txt uname -a >> r1soft.txt uname -r >> r1soft.txt serverbackup-setup -v >> r1soft.txt rpm -qa |grep serverback >> r1soft.txt rpm -qa |grep kernel >> ..
Great stuff from – https://lonesysadmin.net/2013/12/22/better-linux-disk-caching-performance-vm-dirty_ratio/ # sysctl -a | grep dirty vm.dirty_background_ratio = 10 vm.dirty_background_bytes = 0 vm.dirty_ratio = 20 vm.dirty_bytes = 0 vm.dirty_writeback_centisecs = 500 vm.dirty_expire_centisecs = 3000 vm.dirty_background_ratio is the percentage of system memory that can be filled with “dirty” pages — memory pages that still need to be written to disk — ..
Strace useful – https://linux-audit.com/the-ultimate-strace-cheat-sheet/ strace -p PID -e trace=network -e trace=ipc – Track communication between processes (IPC) -e trace=memory – Track memory syscalls -e trace=network – Track memory syscalls -e trace=process – Track process calls (like fork, exec) -e trace=signal – Track process signal handling (like HUP, exit) -e trace=file – Track file related syscalls ..