Hello! I’ve read pt-query-digest ¶ documentation but didn’t find out how to do the thing I need
I have tcpdump pcap file and I want to extract all unique dataless sql queries
So I don’t need fingerprint logic, but something really similar without queries merging into subclasses but with uniqueness logic in place
In the end I’d like to receive info something like that:
(client ip) (operations over table: select, update, join etc) (table names in the query)
I guess fingerprinting would be okay but I need IPs to be grouped by table with all types of fingerprints
(Table/tables names) (ips of clients who accessed tables) (Fingerprints corresponding to tables)
I hope someone could help me and I will really appreciate any suggestions. Have a good day and thank you!