Try maatkit mk-query-digest
mk-query-digest --filter '($event->{user} || "") =~ m/user/' mysql.slow.log
2010/9/28 Stefan Onken <supp...@stonki.de>
> Hello,
>
> is there any way to run a a slow query analyse with "mysdumpslow" only on
> specific mysql user connections? We have multiply application accessing
> the same server and sometimes even the same databases and tables. Now we
> want to analyse only one specific application which uses a specific
> username for login into the mysql DB.
>
> The slow query looks like:
>
> # u...@host: my_user[my_user] @ [192.168.111.111]
> # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 146
> ....
>
>
> Thanks!
> Stonki
>
> --
> www.stonki.de
> www.proftpd.de
> www.kbarcode.net
> www.krename.net
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=maxb...@gmail.com
>
>
