[rt-users] User abusing the mysql

[Harald Wagener]

Am 03.05.2006 um 19:46 schrieb Asif Iqbal:

> Hi
>
> Is there way to find out which user abusing mysql? Once in a while I
> have user who runs a query which causes the mysql to take over about
> 45% of cpu and at the same time slow down mysql queries for the rest.

You can enable logging of slow queries and use mytop.

Regards,
     Harald

-- 
harald wagener
technischer leiter

fcb wilkens
an der alster 42
20099 hamburg
germany

t. +49 (0)40 2881-1252
f. +49 (0)40 2881-1217
m. +49 (0)172 4030-964
hwagener at hamburg.fcb.com
http://www.footeconebelding.de