Re: High Load Average

Hello,

I tested all SQL queries and almost all respond in less than 0.02
seconds. It seems as if mysql connections live longer than what its
needed.

What more info do you need to figure out what might be the problem?

Thanks!

J.O. Aho ha escrit:
Antoni wrote:
Hello,

My server receives about 10K visits per day.
top - 18:26:35 up 39 days, 1:47, 1 user, load average: 27.78,
20.28, 16.71
Tasks: 260 total, 40 running, 220 sleeping, 0 stopped, 0 zombie
Cpu(s): 89.6% user, 10.4% system, 0.0% nice, 0.0% idle
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2906 mysql 20 0 165m 165m 4236 R 25 8.2 0:01.13 mysqld
22769 mysql 18 0 165m 165m 4236 R 7 8.2 0:00.32 mysqld
Any idea what may cause this high load average and why http access is
so slow?

I would think the SQL queries may be the cause to the high load, badly
designed queries and/or tables can cause the mysql to work hard, as you have a
high visitor numbers you will just multiply the trouble.

Without any more information it's difficult to know if there would be other
reasons too.

--

//Aho

.