Worrying top output ?

Paul Civati paul at xciv.org
Fri Apr 30 13:46:00 BST 2004


James <James at reftech.co.uk> wrote:

> Yeah, it means that someone/you is hitting mysqld with lots of =

> concurrent requests; sleeping loops containing queries is the best way =

> of handling it, but mysqld 'ramps up' and 'ramps down' CPU usage as it =
goes.
> =

> Check your 'slow queries' output from mysql to see if someone's pushing=
 =

> something really heavy through; bad column optimisations or naive =

> searches can push usage through the roof on occasions.

mytop - a top like tool for MySQL, is supposed to be quite useful.

-Paul-





More information about the Ukfreebsd mailing list