Very slow MySQL performance

[Mike Bird]

On Tue, 2006-01-03 at 00:28, Dave M G wrote:
> 	I am running MySQL 4.1 on Ubunti 5.10 on a Pentium 3 500Mhz with 512MB
> ram.
> 	I control MySQL through phpMyAdmin via FireFox, in order to simulate as
> close as possible the environment that I use to manage my web sites on
> my hosting service.
> 
> 	The performance of executing even the simplest of commands is brutally
> slow. A good thirty seconds to a minute for just about any command
> executed.

That's plenty of computer.  You can run a mid-range LAMP stack on that
serving dozens of hits per second.

I assume that "top" shows the system is idle.  The first thing I'd
check then would be hosts/DNS/reverse-DNS.

--Mike Bird