there is no way to store "user" and "host" on query_history_table

[Miguel Angel Nieto]

pt-query-digest shows "Users" and "Hosts" fields in the query report, but there is no way to store those on query_history table using --history parameter. I have tried creating custom columns but it doesn't work.

[Sveta Smirnova (svetasmirnova)]

This is possible, you just need to change table definition as appropriate:

mysql> alter table query_history add column Host_min text;
Query OK, 0 rows affected (10.20 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> alter table query_history add column Host_max text;
Query OK, 0 rows affected (8.82 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> alter table query_history add column User_min text;
Query OK, 0 rows affected (8.82 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> alter table query_history add column User_max text;
Query OK, 0 rows affected (8.82 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> select sample, User_min, User_max, Host_min, Host_max from query_history\G
*************************** 1. row ***************************
sample: show tables
User_min: foo
User_max: foo
Host_min: localhost
Host_max: localhost
*************************** 2. row ***************************
sample: select user, host from mysql.user
User_min: foo
User_max: foo
Host_min: localhost
Host_max: localhost
*************************** 3. row ***************************
sample: SELECT CONCAT(@@hostname, @@port)
User_min: root
User_max: root
Host_min: localhost
Host_max: localhost
...

However this is not very clear from the documentation, so will verify as documentation bug.

[Shahriyar Rzayev (rzayev-sehriyar)]

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