Tuning MySQL dan Apache2

Cek penggunaan Apache :

#echo [PID]  [MEM]  [PATH] &&  ps aux | awk '{print $2, $4, $11}' | sort -k2rn | head -n 20
#ps -eo pcpu,pid,user,args | sort -k 1 -r | head -20

#ps -ylC apache2 | awk '{x += $8;y += 1} END {print "Apache Memory Usage (MB): "x/1024; print "Average Proccess Size (MB): "x/((y-1)*1024)}'

Utk check Performansi Mysql sy menggunakan

#ps aux | grep 'mysql' | awk '{print $6/1024 " MB";}'

tuner-primer.sh

cd /usr/local/bin
wget https://launchpadlibrarian.net/78745738/tuning-primer.sh
chmod u+x tuning-primer.sh

Catatan : Utk menjalankan tuning-primer, hati2 masukkan user handy dan password saja, lainnya No / N

open_files_limit di my.cnf :
open_files_limit = minimal 2x / 3x table_cache. Keterangan Tuning

CLI cek SATA

Cek versi :
SATA REVISION => SPEED ({Gbit|MB}/s)
SATA revision 1.0 => 1.5 Gbit/s, 150 MB/s
SATA revision 2.0 => 3 Gbit/s, 300 MB/s
SATA revision 3.0 => 6 Gbit/s, 600 MB/s
SATA revision 3.2 => 16 Gbit/s, 1969 MB/s

#dmesg | grep -i sata | grep 'link up'


atau gunakan lshw , bisa untuk lihat perangkat yg lain.
Lebih lengkap.....