Anemometer icon indicating copy to clipboard operation
Anemometer copied to clipboard

There is no user@host field

Open Yhzhtk opened this issue 9 years ago • 2 comments

In the mysql-slow.log, there is User@Host like:

User@Host: abc[abc] @  [127.0.0.1]  Id: 146217455

But, there is no user@host field in the Table Fields for select.

I need know what system call the slow query, but I can't do it.

Yhzhtk avatar Jun 19 '15 06:06 Yhzhtk

+1.

hankya avatar Oct 10 '15 04:10 hankya

I figured this out, according to https://www.percona.com/doc/percona-toolkit/2.0/pt-query-digest.html#cmdoption-pt-query-digest--review-history, adding column user_max to history table will cause pt_query_digest tool to store user name into that column.

I will submit a pull request for this.

hankya avatar Oct 10 '15 10:10 hankya