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 ..

Read more

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..

Read more

# 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 – ..

Read more

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 — ..

Read more

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 ..

Read more