filter slowquerylog on specific user

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:

# User@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=gcdmg-mysql-2@m.gmane.org

Re: filter slowquerylog on specific user

--001485f9f446146b8e049157dd33
Content-Type: text/plain; charset=ISO-8859-1

Try maatkit mk-query-digest

mk-query-digest --filter '($event->{user} || "") =~ m/user/' mysql.slow.log



2010/9/28 Stefan Onken

> 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:
>
> # User@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=maxbube@gmail.com
>
>

--001485f9f446146b8e049157dd33--