pt-query-digest doesn't parse user info from general logs

[Mike Siekkinen]

Running version 2.1.2.

The output of pt-query-digest --type=genlog does not include any user, host summary information.

The summary looks like

# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 29
# Exec time 0 0 0 0 0 0 0 0
# Query size 0 5.04k 177 179 178 174.84 0 174.84
# String:
# Databases db1 (28/96%), db2 (1/3%)
# Query_time distribution

I realize not as much information is available as the slow query logs but the general log does include Connect lines. Taking a look at the script, the parse_event method seems to be looking for the Connect lines and storing the info per thread id.

Around line 9618

if ( $cmd eq 'Connect' ) {
            if ( $arg =~ m/^Access denied/ ) {
               $cmd = $arg;
            }
            else {
               my ($user, undef, $db) = $arg =~ /(\S+)/g;
               my $host;
               ($user, $host) = split(/@/, $user);
.....

I'd like to use this tool to get better insight into what specific accounts are accessing specific tables this this granularity isn't available from the information_schema statistics

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-580