Very slow MySQL performance
mgb-ubuntu at yosemite.net
Tue Jan 3 18:08:25 UTC 2006
On Tue, 2006-01-03 at 09:37, Dave M G wrote:
> Okay, these are the results from "top", captured pretty much in the
> middle of simply selecting to view the structure of a database in
> phpMyAdmin. The task took about 10 seconds to execute.
> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
> 9351 root 16 0 88684 15m 5424 R 43.4 6.1 36:18.90 Xorg
> 17323 dave 15 0 134m 37m 13m S 32.9 14.9 20:51.49 firefox-bin
The top lines of the top output are missing from your email.
You're obviously running into the firefox CPU overload problem.
You could try using a different browser, such as Konqueror.
However, there's more to it than that. Your initial email said
that your system had 512MB RAM. These figures suggest that your
system is only finding about 248MB RAM. There may even be other
processes hogging most of that memory.
Therefore, please post the top lines of the "top" output and also
the output from "ps vax k-rss | head -20 | cut -b-79".
6.6% CPU to display "top" in gnome-terminal is rather a lot for
a 500MHz P3. Let's check "cat /proc/cpuinfo" while we're at it.
More information about the ubuntu-users