Score:0

pt-query-digest on large slowlog files runs slow - only singlethread

it flag

I have large slowlogfiles generated by percona 5.7 packed by zstd. Its for test, logging all queries, query time is set to 0s

I need it process quickly than in 12 hrs :) The pt-query-digest is probably only singlethread app in default setting and in man i cant see any parallelization.

The command is

zstdcat *.zst | pt-query-digest [some options] > out_slow.log

Is there any tool that do this task more quickly ?

I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.