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