How to optimize apache and mysql on my dedicated server?
Hi,
Any one please suggest me the best mysql apache settings for the given below scenario.
My Server config:
Intel(R) Xeon(R) CPU E5504 @ 2.00GHz
8GB RAM
300GB HDD
Website:
It's a famous wordpress blog
Mysql DB size: 235MB
Expectations:
Server should be handle 600+ concurrent connections.
OS: Ubuntu 10.04.2 LTS
Arc: 64Bit
Mysql Version: 5.1.41
Apache version: Apache/2.2.14
Now I have optimized the apache and mysql(using with mysqltuner,mysqlreport) but mysql always using more cpu.
top - 12:50:47 up 33 days, 23:26, 1 user, load average: 4.48, 3.79, 2.97
Tasks: 281 total, 2 running, 279 sleeping, 0 stopped, 0 zombie
Cpu(s): 6.2%us, 1.4%sy, 0.0%ni, 91.4%id, 0.9%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 8181836k total, 7335392k used, 846444k free, 22908k buffers
Swap: 11595768k total, 636300k used, 10959468k free, 1060196k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
14276 mysql 20 0 1727m 283m 3192 S 340 3.5 842:12.36 /usr/sbin/mysqld --pid-file=/var/run/mysqld/mysqld.pid
Thanks,
Jay
|