--- title: MySQL's 21-year trigger bug gets fixed, Postgres 19... description: A curated roundup of major database engineering news: MySQL finally fixed a 21-year-old bug where FK cascades silently skipped triggers by moving FK logic into... canonical: https://daily.dev/posts/mysql-s-21-year-trigger-bug-gets-fixed-postgres-19-lands-query-hints-qhyyrdc8v twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: MySQL's 21-year trigger bug gets fixed, Postgres 19 lands query hints | daily.dev og:description: A curated roundup of major database engineering news: MySQL finally fixed a 21-year-old bug where FK cascades silently skipped triggers by moving FK logic into... og:url: https://daily.dev/posts/mysql-s-21-year-trigger-bug-gets-fixed-postgres-19-lands-query-hints-qhyyrdc8v og:image: https://api.daily.dev/og/posts/qhyyRDC8v.png og:image:alt: MySQL's 21-year trigger bug gets fixed, Postgres 19 lands query hints og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # MySQL's 21-year trigger bug gets fixed, Postgres 19 lands query hints **[Databases Digest](https://daily.dev/sources/databases_digest)** · 4 min read · 0 upvotes · 1 comments ## Summary A curated roundup of major database engineering news: MySQL finally fixed a 21-year-old bug where FK cascades silently skipped triggers by moving FK logic into the SQL layer. Postgres 19 is adding native query hints via two new contrib modules after 15 years of community debate. Datadog published benchmarks showing synchronous replication on Kubernetes costs 32-53% latency and 23-34% throughput. ClickHouse detailed how they achieved a 26x join speedup on TPC-H SF100 through correlated subquery decorrelation, lazy column replication, runtime bloom filters, and statistics-based join reordering. Also covered: Valkey 9.1 as default on ElastiCache, Redis 8 returning to open source, TypeORM 1.0 release, ProxySQL vs PgBouncer benchmarks, Django security releases, and AWS BYOM for RDS SQL Server. ## Content **TLDR:** MySQL finally closed a 21-year-old bug where foreign key cascades silently skipped triggers — the fix required moving FK logic out of InnoDB and into the SQL layer. Postgres 19 is getting native query hints via two new contrib modules, ending a 15-year community debate. Datadog published hard numbers on synchronous replication costs for HA Postgres on Kubernetes. ClickHouse dropped detailed engineering notes on how they achieved a 26x join speedup over two years. --- ## MySQL bug #11472 fixed after 21 years: FK cascades now fire triggers Filed in 2005, MySQL bug #11472 caused triggers to silently not fire when a foreign key cascade deleted rows. The root cause was a 1990s architectural decision: foreign keys lived inside InnoDB, entirely below the SQL layer where triggers run. The fix required pulling FK logic up into the SQL layer — the major structural work the team had been deferring for two decades. If you rely on triggers for audit logging or referential side effects, this is worth testing against your cascade paths. [Read more](https://app.daily.dev/posts/SrWtYBZ07) ## Postgres 19 adds native query hints via pg_plan_advice and pg_stash_advice After 15 years of community resistance, Postgres 19 ships two new contrib modules that bring query hints — called 'plan advice' — to core PostgreSQL. The design addresses every historical objection: advice lives outside SQL, constrains rather than replaces the planner, degrades gracefully with feedback, and can be persisted per-session, role, or database via a stash. The planner can also generate its own advice strings from EXPLAIN output, so capturing and tweaking an existing plan is straightforward. This is a meaningful shift for anyone who's been working around bad plans with pg_hint_plan or rewritten queries. [Read more](https://app.daily.dev/posts/UbJiQEhqi) ## Datadog: synchronous replication on Kubernetes costs 32-53% latency, 23-34% throughput Datadog engineers found during a gameday simulation that their Kubernetes Postgres clusters couldn't safely fail over under zonal network failures — replicas lagged too far behind to promote safely. They rebuilt using synchronous replication for standby nodes coordinated by Patroni and ZooKeeper, benchmarked all four synchronous_commit modes, and landed on remote_apply. The cost: 32-53% higher latency and 23-34% lower throughput. Read replicas stay on async. The post covers five specific failure scenarios and the monitoring signals to watch, including SyncRep wait events and patroni_sync_standby metrics. [Read more](https://app.daily.dev/posts/nlJmhOJvB) ## ClickHouse achieves 26x join speedup on TPC-H SF100 over two years ClickHouse published the engineering behind their 26x improvement on join-heavy TPC-H SF100 workloads. Four changes drove it: correlated subquery decorrelation, lazy column replication (1.9x faster), runtime bloom filters that pre-filter probe-side rows before hash-table lookups (2.1x faster, 7x less memory), and statistics-based join reordering — one 6-table query dropped from 3,903 seconds to 2.7 seconds. Column statistics are now generated automatically since 26.4, so these gains apply with default settings. A companion benchmark post shows the full SF100 workload completing in 19.8 seconds at $0.063, roughly 2x better cost-performance than Snowflake Large. [Read more](https://app.daily.dev/feed-by-ids?id=Lcg879ZKP&id=cYr7SIo3u) --- ## Also notable - **Valkey 9.1 is the default on ElastiCache and Cloud Memorystore, Redis 8 returns to open source under AGPLv3:** Valkey 9.1 is production-ready and the default managed option on both AWS ElastiCache and Google Cloud Memorystore; Redis 8 returned to open source under AGPLv3 and bundles JSON, search, time series, and vector sets into core — migration from Redis 7.2.x is near drop-in via the same RESP protocol and RDB/AOF files. [Read more](https://app.daily.dev/posts/KrLnOJD3v) - **TypeORM 1.0 released after nearly a decade, requires Node.js 20+:** TypeORM 1.0 ships with ECMAScript 2023 as the compile target (Node.js 20+ required), 575 merged PRs, parameterized queries across all drivers, INSERT INTO ... SELECT and RETURNING clause support, and an automated codemod for migrating from 0.3.x. [Read more](https://app.daily.dev/posts/XLLvkfXOc) - **ProxySQL claims 2.16x PgBouncer throughput at 100 concurrent clients:** ProxySQL's PostgreSQL benchmark with 4 worker threads shows roughly 2.16x the throughput of PgBouncer at 100 concurrent connections, alongside two new first-party tools: dbdeployer for rapid sandbox deployment and Orchestrator for topology-aware HA management. [Read more](https://app.daily.dev/feed-by-ids?id=F00nJ4irP&id=64hfu3VRd) - **Django security releases 6.0.6 and 5.2.15 fix five CVEs:** Django 6.0.6 and 5.2.15 are out with fixes for five CVEs; the project recommends treating the upgrade as urgent. [Read more](https://app.daily.dev/posts/0r7W6h8w1) - **AWS BYOM for RDS lets enterprises reuse existing SQL Server Enterprise/Standard licenses:** AWS Bring Your Own Media for RDS removes the double-licensing cost for SQL Server Enterprise and Standard Edition on managed RDS instances, requiring Microsoft Software Assurance and a License Mobility Verification process. [Read more](https://app.daily.dev/posts/0geu35Ibv) --- Tags: [#backend](https://daily.dev/tags/backend), [#postgresql](https://daily.dev/tags/postgresql), [#mysql](https://daily.dev/tags/mysql), [#clickhouse](https://daily.dev/tags/clickhouse) [View this post on daily.dev](https://daily.dev/posts/mysql-s-21-year-trigger-bug-gets-fixed-postgres-19-lands-query-hints-qhyyrdc8v) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"DiscussionForumPosting","mainEntityOfPage":"https://daily.dev/posts/mysql-s-21-year-trigger-bug-gets-fixed-postgres-19-lands-query-hints-qhyyrdc8v","headline":"MySQL's 21-year trigger bug gets fixed, Postgres 19 lands query hints","text":"A curated roundup of major database engineering news: MySQL finally fixed a 21-year-old bug where FK cascades silently skipped triggers by moving FK logic into the SQL layer. Postgres 19 is adding native query hints via two new contrib modules after 15 years of community debate. Datadog published benchmarks showing synchronous replication on Kubernetes costs 32-53% latency and 23-34% throughput. ClickHouse detailed how they achieved a 26x join speedup on TPC-H SF100 through correlated subquery decorrelation, lazy column replication, runtime bloom filters, and statistics-based join reordering. Also covered: Valkey 9.1 as default on ElastiCache, Redis 8 returning to open source, TypeORM 1.0 release, ProxySQL vs PgBouncer benchmarks, Django security releases, and AWS BYOM for RDS SQL Server.","url":"https://daily.dev/posts/mysql-s-21-year-trigger-bug-gets-fixed-postgres-19-lands-query-hints-qhyyrdc8v","datePublished":"2026-06-06T04:17:54.009Z","dateModified":"2026-06-06T04:18:18.564Z","author":{"@type":"Organization","name":"Databases Digest","logo":"https://media.daily.dev/image/upload/s--ir1hdV8b--/f_auto,q_auto/v1773839400/logos/databases_digest?_a=BAMAMiiu0","url":"https://daily.dev/sources/databases_digest"},"interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":1}],"isPartOf":{"@type":"WebPage","url":"https://daily.dev/sources/databases_digest","name":"Databases Digest"}} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Databases Digest","item":"https://daily.dev/sources/databases_digest"},{"@type":"ListItem","position":3,"name":"MySQL's 21-year trigger bug gets fixed, Postgres 19 lands query hints"}]} ```