4974
4974
my $slow_log_ts_line = qr/^# Time: ([0-9: ]{15})/;
4975
my $slow_log_uh_line = qr/# User\@Host: ([^\[]+|\[[^[]+\]).*?@ (\S*) \[(.*)\]/;
4975
my $slow_log_uh_line = qr/# User\@Host: ([^\[]+|\[[^[]+\]).*?@ (\S*) \[(.*)\]\s*(?:Id:\s*(\d+))?/;
4976
4976
my $slow_log_hd_line = qr{
4978
4978
T[cC][pP]\s[pP]ort:\s+\d+ # case differs on windows/unix
5036
5036
push @properties, 'ts', $time;
5039
&& ( my ( $user, $host, $ip ) = $line =~ m/$slow_log_uh_line/o )
5039
&& ( my ( $user, $host, $ip, $thread_id ) = $line =~ m/$slow_log_uh_line/o )
5041
5041
PTDEBUG && _d("Got user, host, ip", $user, $host, $ip);
5042
5042
push @properties, 'user', $user, 'host', $host, 'ip', $ip;
5044
push @properties, 'Thread_id', $thread_id;
5047
5050
elsif ( !$got_uh
5048
&& ( my ( $user, $host, $ip ) = $line =~ m/$slow_log_uh_line/o )
5051
&& ( my ( $user, $host, $ip, $thread_id ) = $line =~ m/$slow_log_uh_line/o )
5050
PTDEBUG && _d("Got user, host, ip", $user, $host, $ip);
5051
push @properties, 'user', $user, 'host', $host, 'ip', $ip;
5053
PTDEBUG && _d("Got user, host, ip", $user, $host, $ip);
5054
push @properties, 'user', $user, 'host', $host, 'ip', $ip;
5056
push @properties, 'Thread_id', $thread_id;