Very slow MySQL performance

[Mike Bird]

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.

--Mike Bird