Worrying top output ?
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 =
> 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.
More information about the Ukfreebsd