Project Description:
Hi
we have loading problem by server and the problem is by mysql
* The load of our server is > 3 most of the time.
* The mysql process is the most active one:
top - 12:07:29 up 257 days, 21:59, 0 users, load average: 3.15, 3.61, 3.80
Tasks: 37 total, 5 running, 32 sleeping, 0 stopped, 0 zombie
Cpu(s): 73.3%us, 26.7%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 3145728k total, 1912804k used, 1232924k free, 0k buffers
Swap: 3145728k total, 0k used, 3145728k free, 0k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
17568 mysql 15 0 417m 108m 8204 S 171 3.5 7783:23 mysqld
9351 www-data 16 0 443m 158m 4736 R 11 5.2 0:03.73 apache2
9353 www-data 16 0 443m 152m 4660 S 10 5.0 0:01.62 apache2
* Using queries like "SELECT *" are usually not very efficient.
What we need is To lower the load :
our request is:
* Optimise mysql queries.
* Set indices.
* Tune database configuration.
