Not the answer you need?
Register and ask your own question!

how to fix missing db name in slow query table in clickhouse?

romberromber ContributorCurrent User Role Supporter
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


  • PeterPeter Percona CEO Percona Moderator Role
    What MySQL version are you running and how does your slow query log looks like ? It might be the bug in the  log parser.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.