Readyset is a MySQL and Postgres wire-compatible caching layer that sits in front of existing databases to speed up queries and horizontally scale read throughput. Under the hood, ReadySet caches the results of cached select statements and incrementally updates these results over time as the underlying data changes.
It can be difficult to know if/when a cached query is actually being used. Sometimes this is because the statement is only executed within a transaction (and thus readyset won't serve the query itself, but just proxy).
Thus, we should add a metric to the adapter to know if the query was executed during a transaction or not.
It can be difficult to know if/when a cached query is actually being used. Sometimes this is because the statement is only executed within a transaction (and thus readyset won't serve the query itself, but just proxy).
Thus, we should add a metric to the adapter to know if the query was executed during a transaction or not.