Re: High Load Average

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
.

Relevant Pages

  • Re: High Load Average
    ... It seems as if mysql connections live longer than what its ... PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND ... I would think the SQL queries may be the cause to the high load, ...
    (alt.os.linux)
  • Re: Playing .pls file in Unix?
    ... > shoutcast.com on the Unix command line. ... > My FreeBSD jukebox is a headless thing that I control with a web ... > them withe the jukebox interface. ... > of high load. ...
    (comp.unix.bsd.freebsd.misc)