in pmm2.x, slow queries are stored in clickhouse,
but when I connect to clickhouse and select the table, I found that lots of queries missing db name,
so it’s hard to alert the slow queries to correct deverlopers,
I know that some of slow queries does not contain the “use xxxx;” statement in original slow log file in mysql,
but at that point, db name shoud be as same as previous entry of slow log,
so why is db name missing?how to fix this problem?
thanks in advance
What MySQL version are you running and how does your slow query log looks like ? It might be the bug in the log parser.