Groups keyboard shortcuts have been updated
Dismiss
See shortcuts

No query digest record for cached query

11 views
Skip to first unread message

Nikola Sivkov

unread,
Nov 26, 2024, 7:20:06 PM11/26/24
to proxysql
Hello, I'm observing the following scenario

I have 2 queries, one has 2 records in the stats_mysql_query_digest table, one with hostgroup -1 and one with 0

the other query even tho it's hit thousands of times, doesn't have a record with hostgroup -1. 

If i query the stats_mysql_query_rules, there it shows it has hits 

here's a query result from a query to demonstrate

Screenshot 2024-11-27 015823.png

here's my query 

select d.hostgroup, d.digest, d.digest_text, d.count_Star, qr.*
from stats_mysql_query_digest d
left join mysql_query_rules r on d.digest = r.digest
left join stats_mysql_query_rules qr on qr.rule_id = r.rule_id
where d.digest = '0x1E5A2E2862FBF7ED' or d.digest = '0x4999EE69F09D0B90'
order by d.digest;

I even tried manually executing a ps_address query 50 times with the same data, but to no avail. there's no record creaded for hostgroup  -1


Any clues why this might be and if i should open a bug?

Thanks
Nikola Sivkov




Reply all
Reply to author
Forward
0 new messages