I have a huge magazine on dedicated server(1 website only on the server), all time the server have big load,
"top" tool show me that the user "mysql" make this load:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
16058 mysql 20 0 1453m 88m 6088 S 96.3 0.6 2:34.59 mysqld
what is the best configuration should I put in "my.cnf" to speed up and increase performance ?
this is my server information:
- CPU : Intel Core i7-4770 Quadcore
- RAM : 32 GB DDR3
- HDD : 240GB SSD
- OS : Centos 6.5 /64bit with cPanel
- mysql version: 5.5, default storage engine MYISAM
my website information:
- Database size: about 1GB
- 40000 vists per day
Please suggest what is the best configuration to decrease server load and speed up the site