$ cd /usr/bin/

$ pt-kill --version
pt-kill 3.3.1

$ cp pt-kill pt-kill_20221028_bak

修改前：
foreach my $query ( @queries ) {
if ( $o->get('print') ) {
printf "# %s %s %d (%s %d sec) %s\n",
ts(time), $o->get('kill-query') ? 'KILL QUERY' : 'KILL',
$query->{Id}, ($query->{Command} || 'NULL'), $query->{Time},
($query->{Info} || 'NULL');
}
if ( $o->get('query-id') ) {
my $fp = $qr->fingerprint($query->{'Info'});
my $chksm = Transformers::make_checksum($fp);
print "Query ID: 0x$chksm\n";
}

修改后：
if ( $o->get('print') ) {
printf "# 检测时间: %s ,操作类型: %s ,Query_Id: %d ,用户名: %s ,客户端地址: %s ,库名: %s (%s %d sec) ,SQL明细: %s\n",
ts(time), ($o->get('kill-query') ||$o->get('kill')) ? 'KILL QUERY OR KILL' : 'ONLY_PRINT',
$query->{Id},$query->{User},$query->{Host},($query->{db} ? $query->{db} :'none'),($query->{Command} || 'NULL'), $query->{Time},
($query->{Info} || 'NULL');
}
if ( $o->get('query-id') ) {
my $fp = $qr->fingerprint($query->{'Info'});
my $chksm = Transformers::make_checksum($fp);
print "Query ID: 0x$chksm\n";
}

create database percona;

use percona;

CREATE TABLE `kill_log` (
`kill_id` int unsigned NOT NULL AUTO_INCREMENT,
`server_id` bigint NOT NULL DEFAULT '0',
`timestamp` datetime DEFAULT NULL,
`reason` text,
`kill_error` text,
`Id` bigint NOT NULL DEFAULT '0',
`User` varchar(16) NOT NULL DEFAULT '',
`Host` varchar(64) NOT NULL DEFAULT '',
`db` varchar(64) DEFAULT NULL,
`Command` varchar(16) NOT NULL DEFAULT '',
`Time` int NOT NULL DEFAULT '0',
`State` varchar(64) DEFAULT NULL,
`Info` longtext,
`Time_ms` bigint DEFAULT '0',
PRIMARY KEY (`kill_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;