Release Notes

Readyset is currently released as a docker container and Linux distro binary packages. For installation with docker, see the Install with Docker documentation. Available Linux distribution binary packages for x86_64/amd64 and arm64/aarch64 include deb package for Ubuntu 22.04, Debian 12 and later, and rpm packages for Amazon Linux 2023 and RedHat 9. See package installation instructions.

What's New

• 6f43c07: Interactive MySQL clients (such as the mysql CLI) now have their CLIENT_INTERACTIVE capability forwarded to the upstream connection, so their sessions honor interactive_timeout rather than wait_timeout.
• 67859fc: Stopped dropped shallow caches from reappearing after an adapter restart, and stopped the persisted cache DDL list from growing after repeated create-and-drop cycles of the same cache.
• 6713d3e: Shallow cache refresher connections now report the program/application name READYSET_SHALLOW_REFRESHER to the upstream database, making them identifiable in pg_stat_activity (PostgreSQL) and performance_schema.session_connect_attrs (MySQL).
• 9435cb9: Fixed shallow caches not serving traffic after an adapter restart.
• 14fdce2: The SHOW READYSET STATUS command now reports some information about the host Readyset is running on, such as CPU count, RAM capacity, and disk capacity.
• ee10242: Reduced CPU load for shallow cache workloads by approximately 75% by disabling the legacy nom-sql parser when running Readyset with the now-default --cache-mode shallow.
• a324257: Fixed hint-created shallow caches from losing sub-second COALESCE windows after an adapter restart.
• f881244: Added Prometheus gauges for adaptive shallow caches: actual refresh load, baseline refresh load, and over-cap state, labeled by query ID.
• 4ea6799: Added a Prometheus gauge for the refresh scheduler queue depth of scheduled shallow caches, labeled by query ID.
• a936d79: Added Prometheus metrics for shallow cache COALESCE waits: a wait-time histogram and resolved/timeout outcome counters, labeled by query ID.
• bd0963e: Added Prometheus gauges for the shallow refresh worker pool: live workers, idle workers, and queued refresh requests.
• ce6cd5: Added a readyset.shallow_cache_stats virtual relation exposing per-cache adaptive load, over-cap state, scheduler queue depth, and hit rate.
• 1af9f1e: Fixed Postgres unnamed prepared statements from returning rows resolved against the wrong schema after changing search_path.
• 2721c75: Fixed BEGIN / START TRANSACTION isolation-level and read-only modifiers from being silently dropped when proxied to upstream.
• 8bbf226: Stopped Postgres unnamed prepared statements from staying pinned to the upstream after a transaction, which bypassed the cache for the rest of the connection's life.
• 58fc39c: Added the readyset.shallow_cache_coalesce_stats vrel, which shows additional coalescing stats such as time spent coalescing and an estimate of upstream execution time avoided due to coalescing.
• abd686d: Added a dropped-refresh stat to the readyset.shallow_cache_refresh_stats vrel.
• 6ec2ae6: Stopped CREATE CACHE for shallow caches from failing against PostgreSQL upstreams when the query references columns by ordinal position in ORDER BY or GROUP BY (for example, ORDER BY 2, 1), including the SELECT DISTINCT case that was rejected outright.