Planet for the MySQL Community

Replication Internals: Decoding the MySQL Binary Log Part 7: TABLE_MAP_EVENT – Table Metadata for Row-Based Replication ^{(from Readyset Blog)}

Learn how MySQL's TABLE_MAP_EVENT maps table IDs to database names and column layouts before row-based replication events. Includes a full byte-level breakdown of column types, null bitmaps, and optional metadata. [...]

Published Wednesday, 08. April 2026 14:00 • 5 hours ago

The Insert Benchmark vs MariaDB 10.2 to 13.0 on a 24-core server ^{(from Small Datum)}

pThis has results for MariaDB versions 10.2 through 13.0 vs the Insert Benchmark on a 24-core server. The goal is to see how performance changes over time to find regressions or highlight improvements./ppMariaDB 13.0.0 is faster than 10.2.30 on most benchmark steps and otherwise as fast as 10.2.30. This is a great result./pptl;dr/pp/pullifor a CPU-bound workload/liullithe write-heavy step [...]

Published Wednesday, 08. April 2026 01:39 • 17 hours ago | Updated Wednesday, 08. April 2026 01:43 • 17 hours ago

Thanks AWS Open Source ^{(from J-F Gagné's MySQL Blog)}

I would like to thank AWS Open Source for their support. For some time, I am maintaining Planet for the MySQL Community, a blog / news aggregator for the MySQL Community/Ecosystem. I am also maintaining a similar aggregator for the Valkey Community. Maintaining blog / news aggregators is not free. It incurs hosting, domain registration, and other costs (in addition to time, [...]

Published Tuesday, 07. April 2026 20:11 • 23 hours ago | Updated Tuesday, 07. April 2026 20:11 • 22 hours ago

Monitor custom database metrics in Amazon RDS for SQL Server using Amazon CloudWatch ^{(from AWS Database Blog)}

In this post, we demonstrate how to create custom Amazon RDS for SQL Server CloudWatch metrics. You accomplish this by using SQL Server Agent jobs and CloudWatch Logs integration. We walk through an example of monitoring table size within a SQL Server database however, this approach works for various other metrics. You can adapt this approach to track row counts, database size, job counts, user ses [...]

Published Tuesday, 07. April 2026 18:29 • a day ago

The AWS Lambda ‘Kiss of Death’ ^{(from Shattered Silicon OSDB Blog)}

pOur story begins as most database issues start: with hands on foreheads, internally or externally, saying ‘WTF is going on?’. We observed a series of database freezes on our production environment. It was quite severe. Connections spiked, writes were stalled and at some point, a large database freeze and they cleared. Being a Galera environment, […]/p pThe post The AWS Lambda ‘Kiss of [...]

Published Tuesday, 07. April 2026 18:15 • a day ago

Writing My Own Extension for Village SQL Part I ^{(from Dave's MySQL Stuff)}

pSince my previous post on Village SQL, life has been filled with too many other things. But finally I was able this past weekend to circle back and try to write my own extension./ppThe Village SQL TL;DR -> MySQL with PostgreSQL like extensions. /ppThe documentation on writing new extensions seems complete, but I have run into issues that are probably caused by me, and not the d [...]

Published Tuesday, 07. April 2026 13:46 • a day ago

What enterprise devops teams should learn from SaaS ^{(from InfoWorld)}

pMany enterprise devops teams struggle to deploy frequently, increase test automation, and ensure reliable releases. What can they learn from SaaS companies, where developing and deploying software for thousands of customers is core to their revenue and business operations?/p pSaaS companies must have robust testing, observability, deployment, and monitoring capabilities. [...]

Published Tuesday, 07. April 2026 09:00 • a day ago

Announcing ProxySQL 3.0.7, 3.1.7, and 4.0.7 ^{(from ProxySQL Blog)}

ProxySQL 3.0.7 brings protocol hardening, zstd compression, TLS certificate tracking, and new security improvements. Also announcing 3.1.7 and 4.0.7. [...]

Published Tuesday, 07. April 2026 00:00 • 2 days ago

Starting from PostgreSQL’s fsync Failure ^{(from Chen Zongzhi's Medium blog)}

♦IntroductionpIn 2018, the PostgreSQL community discovered a severe problem that had existed for 20 years: when fsync() fails, PostgreSQL's handling could lead to silent data loss. This incident, known as "fsyncgate", not only revealed an architectural flaw in PostgreSQL itself, but also exposed a deep conflict between the Linux kernel, file systems, and databases regarding I/O error [...]

Published Monday, 06. April 2026 21:00 • 2 days ago

Tournament of Databases: The Winner! ^{(from VillageSQL)}

MySQL beats PostgreSQL to win our Tournament of Databases. See how multi-threaded architecture and replication carried MySQL to the championship. [...]

Published Monday, 06. April 2026 19:00 • 2 days ago

Optimize full-text search in Amazon RDS for MySQL and Amazon Aurora MySQL ^{(from AWS Database Blog)}

In this post, we show you how to optimize full-text search (FTS) performance in Amazon RDS for MySQL and Amazon Aurora MySQL-Compatible Edition through proper maintenance and monitoring. We discuss why FTS indexes require regular maintenance, common issues that can arise, and best practices for keeping your FTS-enabled databases running smoothly. [...]

Published Monday, 06. April 2026 18:11 • 2 days ago

MySQL Tools for Performance Tuning and Test Data Generation ^{(from Kedar MySQL Blog)}

pAs a MySQL consultant, I keep running into the same two problems: reviewing MySQL configurations and generating realistic test data for validation. So I built two focused MySQL tools to…/p The post MySQL Tools for Performance Tuning and Test Data Generation first appeared on Change Is Inevitable. [...]

Published Monday, 06. April 2026 14:00 • 2 days ago

Your MySQL Backups Won’t Pass a Compliance Audit Alone ^{(from dbtrail Blog)}

pEvery compliance framework that touches data recovery says some version of the same thing: you need to be able to restore data, prove that you can, and show…/p pThe post Your MySQL Backups Won’t Pass a Compliance Audit Alone appeared first on dbtrail Blog./p [...]

Published Monday, 06. April 2026 13:08 • 2 days ago

Sysbench vs MariaDB on a small server: using the same charset for all versions ^{(from Small Datum)}

pThis has results for sysbench vs MariaDB on a small server. I repeated tests using the same charset (latin1) for all versions as explained here. In previous results I used a multi-byte charset for modern MariaDB (probably 11.4+) by mistake and that adds a 5% CPU overhead for many tests./pptl;dr/pp/pulliMariaDB has done much better than MySQL at avoid regressions from code bloat./liliThere are seve [...]

Published Monday, 06. April 2026 03:38 • 3 days ago | Updated Monday, 06. April 2026 03:38 • 3 days ago

Sysbench vs MySQL on a small server: no new regressions, many old ones ^{(from Small Datum)}

pThis has performance results for InnoDB from MySQL 5.6.51, 5.7.44, 8.0.X, 8.4.8 and 9.7.0 on a small server with sysbench microbenchmarks. The workload here is cached by InnoDB and my focus is on regressions from new CPU overheads. /ppIn many cases, MySQL 5.6.51 gets about 1.5X more QPS than modern MySQL (8.0.x thru 9.7). The root cause is new CPU overhead, possibly from code bloat./pptl;dr/p [...]

Published Tuesday, 24. March 2026 21:31 • 15 days ago | Updated Monday, 06. April 2026 02:43 • 3 days ago

从 PostgreSQL fsync EIO 失败处理说起 ^{(from Chen Zongzhi's GitHub blog)}

2018 年, PostgreSQL 社区发现了一个存在了 20 年的严重问题: 当 fsync() 失败时, PostgreSQL 的处理方式可能导致静默数据丢失. 这个被称为 “fsyncgate” 的事件, 不仅揭示了 PostgreSQL 自身的架构缺陷, 更暴露了 Linux 内核, 文件系统与数据库之间在 I/O 错误处理上的深层矛盾. [...]

Published Monday, 06. April 2026 00:00 • 3 days ago

A response to Percona’s 2026 MySQL ecosystem benchmark: useful data, but not a realistic MariaDB comparison ^{(from lefred's blog)}

Percona’s new 2026 benchmark report is interesting because it puts several MySQL-family releases on the same graphs and shares a public repository for the test harness. That openness is welcome. But after reading both the article and the published scripts, I do not think the post supports broad conclusions about “ecosystem performance,” and I especially […] [...]

Published Sunday, 05. April 2026 08:42 • 3 days ago

What's Coming to dbdeployer ^{(from ProxySQL Blog)}

A preview of the features we're shipping — from InnoDB Cluster to PostgreSQL support. This is just the beginning. [...]

Published Sunday, 05. April 2026 00:00 • 4 days ago

How to fix write latency in MySQL 8.4 Upgrade ^{(from Kedar MySQL Blog)}

pDuring any MySQL major version upgrade, especially when moving from 8.0 to 8.4, it’s not just about compatibility checks. Subtle default changes can directly impact MySQL performance tuning, and if…/p The post How to fix write latency in MySQL 8.4 Upgrade first appeared on Change Is Inevitable. [...]

Published Saturday, 04. April 2026 17:01 • 4 days ago

CPU-bound sysbench on a large server: Postgres, MySQL and MariaDB ^{(from Small Datum)}

pThis post has results for CPU-bound sysbench vs Postgres, MySQL and MariaDB on a large server using older and newer releases. /ppThe goal is to measure:br/pullihow performance changes over time from old versions to new versions/liliperformance between modern MySQL, MariaDB and Postgres/li/ulp/ppThe context here is a collection of microbenchmarks using a large server with high concurrency. Res [...]

Published Saturday, 04. April 2026 02:30 • 5 days ago | Updated Saturday, 04. April 2026 02:36 • 5 days ago

Why dbdeployer Matters to Me — and Why ProxySQL Took Over Its Maintenance ^{(from ProxySQL Blog)}

A first look at why this project matters, why we decided to maintain it, and why supporting tools for both MySQL and PostgreSQL is part of our broader open source commitment [...]

Published Saturday, 04. April 2026 00:00 • 5 days ago

How to Enable MySQL HeatWave Telemetry and Analyze Logs with OCI Log Analytics ^{(from The Oracle MySQL Blog)}

MySQL HeatWave Service on Oracle Cloud Infrastructure (OCI) provides built-in telemetry and logging capabilities that help organizations monitor database activity, troubleshoot issues, and maintain operational health. These logs are valuable not only for operations and performance tuning, but also for governance and regulatory compliance, where audit logging can be essential for tracking database a [...]

Published Friday, 03. April 2026 18:06 • 5 days ago

Monthly Product Pulse: April 2026—Oracle Technical Resources ^{(from Oracle ACE Program)}

Momentum builds when useful resources meet real-world use cases. In this April edition of Monthly Product Pulse, we’re bringing together practical developer-focused updates across Oracle AI Database and Autonomous AI Database, SQL and Ask TOM learning resources, Select AI and in-database machine learning innovations, along with MySQL community news and upcoming events. Oracle AI Database: […] [...]

Published Friday, 03. April 2026 12:48 • 5 days ago

A response to Percona’s 2026 MySQL ecosystem benchmark: useful data, but not a realistic MariaDB comparison ^{(from MariaDB Foundation Blog)}

pPercona’s new 2026 benchmark report is interesting because it puts several MySQL-family releases on the same graphs and shares a public repository for the test harness. … /p pContinue reading \"A response to Percona’s 2026 MySQL ecosystem benchmark: useful data, but not a realistic MariaDB comparison\"/p pThe post A response to Percona’s 2026 MySQL ecosystem benchmark: useful data, but [...]

Published Friday, 03. April 2026 07:35 • 5 days ago

Percona Bug Report: March 2026 ^{(from Percona Community Blog)}

At Percona, we operate on the premise that full transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form, report back on any issues or bugs you might encounter along the way. [...]

Published Friday, 03. April 2026 00:00 • 6 days ago

Vibe-Coded Agents for Vibe-Coded Issues ^{(from DoltHub Blog)}

Gas Town's vibe-coded agents introduced a plethora of new issues to Dolt. I vibe-coded a Go CLI to fight back: parallel agents to reproduce the issues agents caused. [...]

Published Friday, 03. April 2026 00:00 • 6 days ago

ProxySQL 3.1.6: Embedded TSDB for Built-in Time-Series Metrics ^{(from ProxySQL Blog)}

Built-in Time-Series Metrics, No Prometheus Required. Query Your Metrics History Directly from ProxySQL [...]

Published Friday, 03. April 2026 00:00 • 6 days ago

We ran an internal AI demo competition: Here are the winners! ^{(from MariaDB Corporation Blog)}

As developers, we are skeptical of “AI marketing”. We want to see it run. We want to see the actual […] [...]

Published Thursday, 02. April 2026 15:53 • 6 days ago

Query Hints: Let Your Application Decide What Gets Cached ^{(from Readyset Blog)}

Readyset Query Hints let developers embed caching directives directly in their MySQL SQL queries, no admin connection, no separate deployment, no waiting on a change request. GA now for MySQL, coming soon for PostgreSQL. [...]

Published Thursday, 02. April 2026 15:29 • 6 days ago

Oracle Ignites AI Innovation at TEDAI San Francisco ^{(from The Oracle MySQL Blog)}

Oracle was proud to sponsor and participate in TEDAI San Francisco, a sold-out event that brought together over 1,200 attendees from across industries to explore, debate, and celebrate the transformative potential of artificial intelligence. Through a mix of key panels, a 48-hour hackathon, and thought leadership engagement, Oracle showcased its commitment to responsible AI innovation […] [...]

Published Thursday, 02. April 2026 14:45 • 6 days ago

MariaDB Vector: How it works. Part III ^{(from MariaDB Foundation Blog)}

pIn the previous parts of this series we’ve seen how MariaDB stores vector indexes in a table and how to implement HNSW for a good performance. … /p pContinue reading \"MariaDB Vector: How it works. Part III\"/p pThe post MariaDB Vector: How it works. Part III appeared first on MariaDB.org./p [...]

Published Thursday, 02. April 2026 06:46 • 6 days ago

Announcing Fabric Mirroring integration for Azure Database for MySQL - Public Preview at FabCon 2026 ^{(from Azure for MySQL Blog)}

pAt FabCon 2026, we’re excited to announce the Public Preview of Microsoft Fabric Mirroring integration for Azure Database for MySQL. This integration makes it easier than ever to analyze MySQL operational data using Fabric’s unified analytics platform, without building or maintaining ETL pipelines./p pThis milestone brings near real-time data replication from Azure Database for MySQL into Microsof [...]

Published Thursday, 02. April 2026 04:43 • 7 days ago

InnoDB Buffer Pool Tuning: From Rule-of-Thumb to Real Signals ^{(from Percona Community Blog)}

Introduction Many MySQL setups begin life with a familiar incantation: [...]

Published Thursday, 02. April 2026 00:00 • 7 days ago

Patterns for Postgres Traffic Control ^{(from PlanetScale Blog)}

Practical patterns for leveraging Database traffic Control [...]

Published Thursday, 02. April 2026 00:00 • 7 days ago

MariaDB Java Connector 3.5.8 now available ^{(from MariaDB Corporation Blog)}

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/J 3.5.8 release. Release Notes and Changelogs MariaDB Connector/J […] [...]

Published Wednesday, 01. April 2026 22:35 • 7 days ago

Percona Operator for PostgreSQL 2.9.0: PostgreSQL 18 Default, PVC Snapshot Backups, LDAP Support, and More! ^{(from Percona Database Blog)}

♦We are excited to announce Percona Operator for PostgreSQL 2.9.0! In this release, we bring significant improvements across database lifecycle management, security, backup/restore, and operational observability, making it easier than ever to run production PostgreSQL on Kubernetes. Here’s a deep dive into what’s new. Percona Operator for PostgreSQL 2.9.0 PostgreSQL 18 Is Now the [...]

Published Wednesday, 01. April 2026 18:00 • 7 days ago

March Product Update ^{(from Readyset Blog)}

See what's new at Readyset in March 2026, including Shallow Caching now on by default, the Skip Cache hint, smarter query visibility, and how Hussle Technology eliminated peak-season database load with QueryPilot. [...]

Published Wednesday, 01. April 2026 17:30 • 7 days ago

Replication Internals: Decoding the MySQL Binary Log - Part 6: QUERY_EVENT — DDL Statements and Transaction Boundaries ^{(from Readyset Blog)}

Understand how MySQL's binary log captures DDL statements and transaction boundaries using QUERY_EVENT. Includes field-by-field decoding of headers, status variables, and SQL mode flags. [...]

Published Wednesday, 01. April 2026 14:00 • 7 days ago

Benchmarking MyRocks vs. InnoDB in Memory-Constrained Environments ^{(from Percona Database Blog)}

Benchmarking MyRocks vs. InnoDB in Memory-Constrained Environments It is a well-known fact in the database world that InnoDB is incredibly fast when the entire database fits into memory. But what happens when your data grows beyond your available RAM? MyRocks, built on RocksDB, is frequently recommended as a superior choice for environments constrained by memory, […] [...]

Published Wednesday, 01. April 2026 13:31 • 7 days ago

MySQL 8.0 Is Reaching End of Life. Here Are Your Options. ^{(from VillageSQL)}

MySQL 8.0 reaches EOL in April 2026. Your options: cloud-extended support, Percona contracts, or upgrading to MySQL 8.4 LTS. Here's what to know. [...]

Published Wednesday, 01. April 2026 13:00 • 7 days ago

Know a MariaDB champion? Submit a nomination ^{(from lefred's blog)}

One of the things I really like about open source is that a project is never only about the software. Yes, code is important. Very important. But a project like MariaDB exists and grows because of people. People who contribute code, of course, but also people who help users, review bugs, write blog posts, speak […] [...]

Published Wednesday, 01. April 2026 11:27 • 7 days ago

Using PHP and Readyset for the First Time with MySQL ^{(from Another Boring Tech Blog)}

pSpeed up your PHP application without changing a single query. A few days ago I set out to answer a simple question: how much faster can a PHP app go if you drop a SQL cache in front of MySQL — without touching application code? The answer is below. On a four-table join aggregating revenue.../p pO post Using PHP and Readyset for the First Time with MySQL apareceu primeiro em Another Boring Tech Bl [...]

Published Tuesday, 31. March 2026 21:18 • 8 days ago

CPU efficiency for MariaDB, MySQL and Postgres on TPROC-C with a small server ^{(from Small Datum)}

pI started to use TPROC-C from HammerDB to test MariaDB, MySQL and Postgres and published results for MySQL and Postgres on small and large servers. This post provides more detail on CPU overheads for MariaDB, MySQL and Postgres on a small server./pptl;dr/pp/pulliPostgres get the most throughput and the difference is large./liliMariaDB gets more throughput than MySQL/liliThroughput improves for Mar [...]

Published Monday, 16. March 2026 19:35 • 23 days ago | Updated Tuesday, 31. March 2026 20:57 • 8 days ago

MySQL Metadata Store service not able to start on an ODA ^{(from dbi Blog)}

pI was recently doing some consulting on some ODA at one of our customers, and I faced an issue with the DCS Agent and the MySQL Metadata Store. In this blog, I will show you the problem and how I could resolved it. Problem description On an Oracle Database Appliance, the DCS agent is the […]/p pL’article MySQL Metadata Store service not able to start on an ODA est apparu en premier sur dbi B [...]

Published Tuesday, 31. March 2026 20:32 • 8 days ago

gcc vs clang for sysbench on a small server with Postgres, MySQL and MariaDB ^{(from Small Datum)}

pThis has results for sysbench on a small server and compares performanc for Postgres, MySQL and MariaDB compiled using clang vs using gcc./pptl;dr/pp/pulliThroughput with clang and gcc is similar/li/ulp/pBuilds, configuration and hardwarep/pp/pp/pI compiled Postgres 18.3, MySQL 8.4.8 and MariaDB 11.8.6 from source. The server has 8 AMD cores with SMT disabled and 32G of RAM. The OS is Ubuntu 24.04 [...]

Published Tuesday, 31. March 2026 20:28 • 8 days ago | Updated Tuesday, 31. March 2026 20:28 • 8 days ago

MySQL Automatic Failover: When to Automate vs. Manual Intervention ^{(from Continuent Blog)}

A practical guide to MySQL failover strategies, comparing automated and manual approaches, and examining risks such as replication lag, split-brain, and incorrect promotion in high availability environments.Tags: failoverautomation [...]

Published Tuesday, 31. March 2026 17:51 • 8 days ago

What’s New in MariaDB AI RAG 1.1: Ingestion, Reranking, and Docker Deployment ^{(from MariaDB Corporation Blog)}

Moving a RAG (Retrieval-Augmented Generation) application from a local prototype to a production-grade system requires solving for data messy ingestion, […] [...]

Published Tuesday, 31. March 2026 17:38 • 8 days ago

Introducing MySQL HeatWave Telemetry data with OCI Log Analytics ^{(from The Oracle MySQL Blog)}

Announcing MySQL HeatWave Telemetry data publishing into OCI Log Analytics — the easiest way to view , analyze the MYSQL Heatwave Logs New build-in feature to publish the MySQL Logs to OCI Log Analytics Telemetry Data: The Following data will be published based on the user selection1. Error log: Contains a record of mysqld startup and shutdown […] [...]

Published Tuesday, 31. March 2026 16:00 • 8 days ago

Village News: MySQL/Database News (31 March 2026) ^{(from VillageSQL)}

MySQL and database news for March 31, 2026: Oracle community updates, Percona Live details, vector database progress, and upcoming conferences. [...]

Published Tuesday, 31. March 2026 13:56 • 8 days ago

PostgreSQL Internals for the MySQL DBA ^{(from Rendiment)}

PostgreSQL internals explained for MySQL DBAs. MVCC, heap vs clustered index, VACUUM, WAL, and replication, all mapped to their InnoDB equivalents. [...]

Published Tuesday, 31. March 2026 04:00 • 9 days ago

MySQL at a Crossroads: Oracle Control, Community Frustration, and MariaDB’s Rise ^{(from One-Time MySQL Community/Ecosystem Posts)}

For more than two decades, MySQL has been one of the pillars of modern web infrastructure. According to the Stack Overflow Developer Survey, it continues to rank among the most widely used databases worldwide. It powered early startups, supported the rise of PHP applications, and became a default choice for teams that needed a reliable relational database without enterprise complexity. Today, that [...]

Published Tuesday, 31. March 2026 00:00 • 9 days ago

Graceful degradation in Postgres ^{(from PlanetScale Blog)}

Not all traffic is created equal.When a database is overwhelmed, you want the important queries to keep executing, even if that means shedding lower-priority work.This is a much better outcome than the alternative: a total database outage. [...]

Published Tuesday, 31. March 2026 00:00 • 9 days ago

Know a MariaDB champion? Submit a nomination ^{(from MariaDB Foundation Blog)}

pOne of the things I really like about open source is that a project is never only about the software.br Yes, code is important. Very important. … /p pContinue reading \"Know a MariaDB champion? Submit a nomination\"/p pThe post Know a MariaDB champion? Submit a nomination appeared first on MariaDB.org./p [...]

Published Monday, 30. March 2026 14:01 • 9 days ago

Contributions As a Cost-saver ^{(from MariaDB Foundation Blog)}

pThe economics of open source contribution development. And some questions./p pThe post Contributions As a Cost-saver appeared first on MariaDB.org./p [...]

Published Monday, 30. March 2026 12:18 • 9 days ago

Hussle Technology Trusts Readyset QueryPilot to Handle Peak-Season MySQL Load ^{(from Readyset Blog)}

See how Hussle Technology eliminated peak-season database pressure across 1,700 queries and 11 databases, with zero application changes and no additional read replicas, using ReadySet QueryPilot. [...]

Published Monday, 30. March 2026 11:00 • 9 days ago

High memory usage in Postgres is good, actually ^{(from PlanetScale Blog)}

A high memory percentage in PlanetScale Postgres is not necessarily a problem. Let's compare how memory and CPU usage are different, how not all memory usage is created equal, and which signals actually require attention. [...]

Published Monday, 30. March 2026 00:00 • 10 days ago

Talking PostgreSQL with ProxySQL at Percona Live SF 2026 ^{(from ProxySQL Blog)}

ProxySQL Is Coming to Percona Live 2026 – And It's Not Just for MySQL Anymore [...]

Published Monday, 30. March 2026 00:00 • 10 days ago

Technical Analysis: Why 0.2ms Queries Can Still Result in Low QPS ^{(from Another Boring Tech Blog)}

pIt is a classic trap: you spend a week fine-tuning your cache and your database hits only to realize your application is essentially running with the handbrake on. I saw this with my tests: MySQL and Readyset were returning rows in 0.2 ms, but the application throughput remained capped at 40 queries per second (QPS). The database isn’t.../p pO post Technical Analysis: Why 0.2ms Queries Can S [...]

Published Sunday, 29. March 2026 20:29 • 10 days ago

MyVector v1.26.3: Maintenance, CI, and Readiness for MySQL 9.7 ^{(from AskDba)}

In my recent series on Scoped Vector Search, we looked at the query patterns that make vector search a first-class citizen in MySQL. While the logic for those searches is now established, the infrastructure supporting them requires constant attention as the MySQL ecosystem moves toward its new release model. Today, I’m announcing MyVector v1.26.3. This is a foundational release […] [...]

Published Sunday, 29. March 2026 18:38 • 10 days ago

Selecting a character set for MySQL and MariaDB clients ^{(from Small Datum)}

p MySQL and MariaDB have many character-set related options, perhaps too many:/pp/pollicharacter_set_client/lilicharacter_set_connection/lilicharacter_set_database/lilicharacter_set_filesystem/lilicharacter_set_results/lilicharacter_set_server/lilicharacter_set_system/li/olThis is a topic that I don't know much about and I am still far from an expert. My focus has been other DBMS topics. But I [...]

Published Sunday, 29. March 2026 00:26 • 11 days ago | Updated Sunday, 29. March 2026 00:26 • 11 days ago

If you're running MySQL on a symlink... ^{(from One-Time MySQL Community/Ecosystem Posts)}

If you're running MySQL on a symlink and using versions 8.0.34 through 9.6.0, it's important to be aware of a critical bug that can cause MySQL to crash after executing a TRUNCATE command. [...]

Published Sunday, 29. March 2026 00:00 • 11 days ago

MySQL Performance Tuning for High-Traffic Applications ^{(from MinervaDB Blog)}

MySQL Performance Tuning & Scalability Services for High-Traffic Applications In today’s digital landscape, high-traffic applications and growth-stage SaaS platforms demand robust, responsive, and scalable database solutions. MySQL, as one of the most popular open-source relational [...] [...]

Published Saturday, 28. March 2026 19:23 • 11 days ago

MySQL HeatWave observability updates in OCI ^{(from The Oracle MySQL Blog)}

Moving from Ops Insights/Database Management to OCI Monitoring and Unified Log Analytics OCI is updating the recommended approach for observing MySQL HeatWave. This includes changes to existing integrations, along with a path forward that provides stronger log analytics and AI-assisted analysis—while continuing to use OCI Monitoring as the foundational layer for metrics and alarms. What’s […] [...]

Published Friday, 27. March 2026 20:36 • 12 days ago

MariaDB observability – results from the poll: the community has clearly chosen its default stack ^{(from lefred's blog)}

Before I share my takeaway from this MariaDB observability poll, I would like to thank all participants and highlight that these recent polls are very popular, and your participation makes us happy. That said, we recently asked the MariaDB community the following question: Which observability tools do you use for MariaDB? I like polls like […] [...]

Published Friday, 27. March 2026 16:49 • 12 days ago

Tournament of Databases: Round 2 ^{(from VillageSQL)}

Round 2 is set: Oracle vs. MongoDB, MySQL vs. DuckDB, PostgreSQL vs. Snowflake, SQL Server vs. Databricks. DuckDB's run continues. Who makes the Final Four? [...]

Published Friday, 27. March 2026 14:00 • 12 days ago

Skeema v2 updates and timeline ^{(from Skeema Blog)}

pAs the community looks ahead to new LTS releases of both MySQL and MariaDB over the next couple months, the timeline for Skeema v2 has finally taken shape. In this post, we’ll reveal the preliminary schedule, and also cover some important changes to EOL database support, download URLs, and more./p [...]

Published Thursday, 26. March 2026 21:26 • 13 days ago

Four Data Architecture Decisions That Make or Break Agentic Systems ^{(from PingCAP Blog)}

pEditor’s note: This post originally appeared on The New Stack and is republished with permission. The original version is available here. Data teams that thrived in the last wave of Software as a Service (SaaS) platform scale weren’t the ones that chased hype. They were the ones that made a few smart decisions: They adopted cloud-first […]/p pThe post Four Data Architecture Decisions That Ma [...]

Published Thursday, 26. March 2026 20:48 • 13 days ago

Binary Log Compression is Safe since MySQL 8.0.34 ^{(from J-F Gagné's MySQL Blog)}

This is a quick one. My attention was recently brought (thanks Simon) on a relatively recent comment (25 Nov 2025) in Bug #103672 - Binlog compression transaction payload event exceeds max allowed packet : The underlying server bug was fixed in 8.0.34 in BUG#33588473. The server now falls back to writing the transaction without compression, if the compressed size would [...]

Published Thursday, 26. March 2026 20:41 • 13 days ago | Updated Thursday, 26. March 2026 20:41 • 13 days ago

Understanding MySQL Views & HeatWave In-Memory Execution ^{(from The Oracle MySQL Blog)}

In the world of database management, MySQL HeatWave offers powerful in-memory analytics capabilities that can supercharge your OLTP queries. But what happens when you introduce views into the mix? A common question I get is: “If I create a view in MySQL, does this view run against the data stored in the tables in HeatWave […] [...]

Published Thursday, 26. March 2026 17:56 • 13 days ago

Unified MySQL Monitoring Across HeatWave and On-Prem with Grafana Dashboard ^{(from The Oracle MySQL Blog)}

MySQL observability is essential in modern enterprises, whether you run a few critical databases or operate at massive scale. With the right real‑time monitoring, teams reduce MTTD/MTTR, avoid cascading failures, and continuously track workload health—CPU, memory, I/O, buffer pool efficiency, session contention, transaction/replication lag, error rates, and query latency. This Grafana monitoring te [...]

Published Thursday, 26. March 2026 15:32 • 13 days ago

MariaDB Keeps Climbing: Community, Adoption, and Momentum ^{(from lefred's blog)}

If you’ve been around the MariaDB community for a while, you can probably feel it already: things are moving in the right direction. And no, I’m not talking about one vanity metric, one lucky spike, or one noisy social post. I’m talking about a broader trend. The latest Adoption Index data shows something I really […] [...]

Published Thursday, 26. March 2026 12:28 • 13 days ago

2026 – MySQL Ecosystem Performance Benchmark Report ^{(from Percona Database Blog)}

By Percona Lab Results · 2026 · MySQL MariaDB Percona Benchmark Database MySQL Ecosystem Performance Benchmark Report 2026 Comparative Analysis of InnoDB-Compatible Engines — Percona Lab Results Repository: github.com/Percona-Lab-results/2026-interactive-metrics Interactive graphs available: Explore the full dataset dynamically — click any graph below to open the interactive version. OLTP Read- [...]

Published Thursday, 26. March 2026 10:04 • 13 days ago

MariaDB observability – results from the poll: the community has clearly chosen its default stack ^{(from MariaDB Foundation Blog)}

pBefore I share my takeaway from this MariaDB observability poll, I would like to thank all participants and highlight that these recent polls are very popular, and your participation makes us happy. … /p pContinue reading \"MariaDB observability – results from the poll: the community has clearly chosen its default stack\"/p pThe post MariaDB observability – results from the poll: the communi [...]

Published Thursday, 26. March 2026 08:35 • 13 days ago

MariaDB Vector: How it works. Part II ^{(from MariaDB Foundation Blog)}

pIn the first post of this series, I’ve described how the vector index is stored in a table and how it achieves full transactional behavior and ACID properties compatible with the storage engine of the table the user created. … /p pContinue reading \"MariaDB Vector: How it works. Part II\"/p pThe post MariaDB Vector: How it works. Part II appeared first on MariaDB.org./p [...]

Published Thursday, 26. March 2026 07:34 • 13 days ago

Strengthening the MySQL Community: Highlights from Our Second Public Discussion ^{(from The Oracle MySQL Blog)}

On March 23, 2026, the MySQL Community Team hosted our second public discussion focused on shaping a new era of MySQL community engagement. With over 50 attendees participating, the session brought together members of the MySQL ecosystem to share feedback, discuss priorities, and help guide future efforts. Building on our earlier session, this webinar continued […] [...]

Published Thursday, 26. March 2026 06:00 • 14 days ago

Stripe Projects partnership: Provision PlanetScale Postgres and MySQL databases from the Stripe CLI ^{(from PlanetScale Blog)}

PlanetScale is a co-design and launch partner for the Stripe Projects developer preview, allowing you or your coding agents to provision and manage databases and other dev tools directly from the Stripe CLI. [...]

Published Thursday, 26. March 2026 00:00 • 14 days ago

[In preview] Public Preview: Fabric Mirroring integration for Azure Database for MySQL ^{(from Azure Updates)}

We are excited to announce the public preview of Fabric Mirroring integration for Azure Database for MySQL – Flexible Server. You can now replicate MySQL operational data into Microsoft Fabric in near real time, without building or maintaining ETL pipelin [...]

Published Wednesday, 25. March 2026 17:45 • 14 days ago

Announcing VillageSQL Server 0.0.3 ^{(from VillageSQL)}

VillageSQL 0.0.3 adds parametrized types, MySQL 8.4.8 LTS support, expanded SQL compatibility, and ChatGPT and Ollama inference via the vsql-ai extension. [...]

Published Wednesday, 25. March 2026 16:27 • 14 days ago

Datography Joins MariaDB Foundation as Silver Sponsor ^{(from MariaDB Foundation Blog)}

pWe are pleased to welcome Datography as a Silver Sponsor of the MariaDB Foundation.br Datography focuses on helping organizations understand, map, and manage complex data environments. … /p pContinue reading \"Datography Joins MariaDB Foundation as Silver Sponsor\"/p pThe post Datography Joins MariaDB Foundation as Silver Sponsor appeared first on MariaDB.org./p [...]

Published Wednesday, 25. March 2026 14:42 • 14 days ago

Replication Internals: Decoding the MySQL Binary Log Part 5: GTID_LOG_EVENT — The Global Transaction Identifier ^{(from Readyset Blog)}

Decode the GTID_LOG_EVENT byte by byte: how MySQL assigns unique transaction IDs, drives parallel replication, and keeps replicas in sync. [...]

Published Wednesday, 25. March 2026 14:00 • 14 days ago

MySQL Archiving: 3 Ways to Clear the Bloat ^{(from Continuent Blog)}

Practical guide to reducing MySQL data bloat through three archiving approaches: controlled deletes, partitioning, and replication-based offloading, with trade-offs and operational considerations.Tags: archivingpartitioningperformance [...]

Published Wednesday, 25. March 2026 12:56 • 14 days ago

MariaDB Keeps Climbing: Community, Adoption, and Momentum ^{(from MariaDB Foundation Blog)}

pIf you’ve been around the MariaDB community for a while, you can probably feel it already: things are moving in the right direction.br And no, I’m not talking about one vanity metric, one lucky spike, or one noisy social post. … /p pContinue reading \"MariaDB Keeps Climbing: Community, Adoption, and Momentum\"/p pThe post MariaDB Keeps Climbing: Community, Adoption, and Momentum [...]

Published Wednesday, 25. March 2026 09:59 • 14 days ago

MariaDB Curiosity: Since When in MariaDB do we use REPLICA? ^{(from lefred's blog)}

As a former MySQL DBA, I am less familiar with some MariaDB details. Also, the evolution of MariaDB Server is ongoing, with many new features, data types, and syntax, and more… I decided then to create a new blog series for those like me who need to reinforce their MariaDB knowledge and be unbeatable during […] [...]

Published Wednesday, 25. March 2026 09:28 • 14 days ago

MySQL at 30 – does it still have a future? QnA ^{(from One-Time MySQL Community/Ecosystem Posts)}

Last year MySQL marked its 30th birthday, but with end of life for the current version (8.0) coming up next month and moves towards a community edition what does the future hold for the platform? We spoke to Peter Zaitsev, founder of database support specialist Percona, to discuss what MySQL users should be doing now and whether there’s still life in the old database yet. [...]

Published Wednesday, 25. March 2026 00:00 • 15 days ago

Lessons from Using Claude Code to Implement Double Write Buffer in PostgreSQL ^{(from Chen Zongzhi's Medium blog)}

pI’ve been exploring how to use Claude Code to help write database kernel code. The specific task was implementing a Double Write Buffer in PostgreSQL, modeled after InnoDB’s implementation. Claude was fast at writing the code, but I ran into a problem along the way: it can’t do design./ppThe Buffer I/O vs Direct I/O Gap/ppI asked Claude to implement a DWB in PostgreSQL following InnoDB’s approach. [...]

Published Tuesday, 24. March 2026 22:30 • 15 days ago

Automatically scale storage for Amazon RDS Multi-AZ DB clusters using AWS Lambda ^{(from AWS Database Blog)}

In this post, we walk you through building an automated storage scaling solution for Amazon RDS Multi-AZ clusters with two readable standbys. We use AWS Lambda to execute scaling logic, Amazon CloudWatch to detect and alarm on storage thresholds, and Amazon SNS to deliver timely notifications. This combination provides event-driven automation, native AWS integration, and operational visibility with [...]

Published Tuesday, 24. March 2026 21:46 • 15 days ago

Your monitoring knows how your database is doing. It has no idea what happened to your data. ^{(from dbtrail Blog)}

pYou’ve got Grafana dashboards. PMM is collecting metrics. Datadog has agents on every host. CloudWatch alarms are set up. You know your CPU is at 34%, your queries…/p pThe post Your monitoring knows how your database is doing. It has no idea what happened to your data. appeared first on dbtrail Blog./p [...]

Published Tuesday, 24. March 2026 18:52 • 15 days ago

MySQL Early Access Release Builds Available: What to Test and How to Share Feedback ^{(from The Oracle MySQL Blog)}

Last week, we published MySQL Early Access Release builds available for community testing and feedback ahead of the upcoming stable releases. Early Access builds are ideal for developers and DBAs who want to validate compatibility, behavior, and performance in non-production environments—and help us catch regressions early or identify areas where the documentation could be clearer. We […] [...]

Published Tuesday, 24. March 2026 18:06 • 15 days ago

MariaDB Doesn't Depend on MySQL ^{(from DZone)}

pWhen MariaDB was first announced in 2009 by Michael “Monty” Widenius, it was positioned as a “fork of MySQL”. I think that was a Bad Idea™. Okay, maybe it wasn’t a bad idea as such. After all, MariaDB indeed is a fork of MySQL. But what is a fork in the software sense, and how is this reflected in MariaDB? /p pA fork is a software project that takes the source code of another project and cont [...]

Published Tuesday, 24. March 2026 16:00 • 15 days ago

Building and testing MySQL 9.7.0 early access build on macOS ^{(from Laurynas Biveinis' blog)}

p Oracle released 9.7.0 community early access build, which is a part of their work towards fulfilling their new promises to the community. This is great news for community testing and I did my part in my usual way (previously: 8.0.45 / 8.4.8 / 9.6.0). /p Build p No changes from 9.6.0: the current Xcode (26.3) builds the 9.7.0 early access build fine, LLVM 21 still fails (bug #119246). /p Test [...]

Published Tuesday, 24. March 2026 14:25 • 15 days ago | Updated Tuesday, 24. March 2026 14:25 • 15 days ago

MariaDB 13.0 Preview Now Available ^{(from lefred's blog)}

We are pleased to announce the availability of a preview of the MariaDB 13.0 series. MariaDB 13.0 is a preview rolling release, published on 23 March 2026, and it continues the work started in 12.3 while adding a solid set of entirely new features. And this one is interesting. This preview release brings a nice […] [...]

Published Tuesday, 24. March 2026 13:02 • 15 days ago

The Agentic Era: Why Infrastructure is the New Innovation Frontier ^{(from MariaDB Corporation Blog)}

Eighteen months ago, when I joined MariaDB, the industry was already feeling the first tremors of the AI boom. While […] [...]

Published Tuesday, 24. March 2026 13:02 • 15 days ago

MariaDB 13.0 Preview Now Available ^{(from MariaDB Foundation Blog)}

pWe are pleased to announce the availability of a preview of the MariaDB 13.0 series. MariaDB 13.0 is a preview rolling release, published on 23 March 2026, and it continues the work started in 12.3 while adding a solid set of entirely new features. … /p pContinue reading \"MariaDB 13.0 Preview Now Available\"/p pThe post MariaDB 13.0 Preview Now Available appeared first on MariaDB.org./p [...]

Published Tuesday, 24. March 2026 12:49 • 15 days ago

DBaasNow Joins MariaDB Foundation as Silver Sponsor ^{(from MariaDB Foundation Blog)}

pWe are pleased to welcome DBaasNow as a Silver Sponsor of the MariaDB Foundation.br As the MariaDB ecosystem continues to expand across cloud, hybrid, and on-premise environments, the need for consistent, reliable, and scalable database operations has never been more important. … /p pContinue reading \"DBaasNow Joins MariaDB Foundation as Silver Sponsor\"/p pThe post DBaasNow Joins MariaDB F [...]

Published Tuesday, 24. March 2026 07:05 • 15 days ago

TiDB Cloud Zero Public Preview: Get a Database in 1 Second, Claim It in 3 Clicks ^{(from PingCAP Blog)}

pWe’re excited to announce that TiDB Cloud Zero is now available in Public Preview. TiDB Cloud Zero is designed for a new generation of AI agents and developers who want instant access to a real production-grade database without the traditional onboarding friction. With TiDB Cloud Zero, you can: This blog walks through the entire flow from zero to a claimed […]/p pThe [...]

Published Tuesday, 24. March 2026 05:32 • 16 days ago

Enhanced tagging in Postgres Query Insights ^{(from PlanetScale Blog)}

Introducing query tagging improvements in Postgres Query Insights [...]

Published Tuesday, 24. March 2026 00:00 • 16 days ago

A Guide to Multi-Region Disaster Recovery with MariaDB Cloud ^{(from MariaDB Corporation Blog)}

Recent global events remind us of a difficult truth: infrastructure failures rarely happen at convenient times. From geopolitical conflicts and […] [...]

Published Monday, 23. March 2026 21:54 • 16 days ago

MariaDB Python Connector 2.0.0rc2 ^{(from MariaDB Corporation Blog)}

Today’s release candidate for MariaDB Connector/Python 2.0 marks a transition from the architecture used in version 1.1. Although the previous […] [...]

Published Monday, 23. March 2026 18:31 • 16 days ago

MariaDB/MySQL Environment MyEnv 3.0.0 has been released ^{(from Shinguz's Blog)}

pFromDual has the pleasure to announce the release of the new version 3.0.0 of its popular MariaDB, MySQL and PostgreSQL multi-instance environment MyEnv./p pThe new MyEnv can be downloaded here. How to install MyEnv is described in the MyEnv Installation Guide./p pIn the inconceivable case that you find a bug in the MyEnv please report it to us by sending an email./p pAny feedback, statements and [...]

Published Monday, 23. March 2026 16:42 • 16 days ago

Queen Shrugged ^{(from MariaDB Foundation Blog)}

pIt’s easy to be a queen. Why? Because you can always count on your true selfless friends. I learned this already as a young princess. Nothing brightens a ball quite like a comment from one of your most trusted girlfriends:br It’s beautiful. … /p pContinue reading \"Queen Shrugged\"/p pThe post Queen Shrugged appeared first on MariaDB.org./p [...]

Published Monday, 23. March 2026 16:33 • 16 days ago

Behind the scenes: How Database Traffic Control works ^{(from PlanetScale Blog)}

Learn how Traffic Control enforces real-time limits on Postgres queries. [...]

Published Monday, 23. March 2026 16:00 • 16 days ago

MariaDB Innovation: InnoDB-Based Binary Log ^{(from lefred's blog)}

I am starting a new series on what makes MariaDB Server distinct from MySQL, highlighting innovations that make the difference. MariaDB 12.3 introduces a new binary log implementation that stores binlog events directly in InnoDB-managed tablespaces rather than in separate flat files on disk. This is an incredible innovation; for a long time, binary logs […] [...]

Published Monday, 23. March 2026 08:03 • 16 days ago

Introducing Database Traffic Control ^{(from PlanetScale Blog)}

Enforce real-time limits on your Postgres query traffic to protect your database from runaway queries and unexpected load spikes. [...]

Published Monday, 23. March 2026 00:00 • 17 days ago

ProxySQL 3.1.6: Full Query Observability in Fast Forward Mode with FFTO ^{(from ProxySQL Blog)}

Fast Forward Mode Is No Longer a Blind Spot [...]

Published Monday, 23. March 2026 00:00 • 17 days ago

用 Claude Code 在 PostgreSQL 实现 Double Write Buffer 遇到的一些问题 ^{(from Chen Zongzhi's GitHub blog)}

最近一直在探索怎么用 Claude Code 来帮忙写数据库内核的代码. 一开始是直接让 Claude code 在 PostgreSQL 上实现一套 Double Write Buffer, 参考 InnoDB 的实现. 代码 Claude 确实写得挺快, 但过程中发现一个问题: 它不会做设计. [...]

Published Monday, 23. March 2026 00:00 • 17 days ago

Continued Momentum Leading up to MySQL Community Edition Release ^{(from The Oracle MySQL Blog)}

More MySQL Worklogs and MySQL Developer Guide published As we ramp up to the MySQL Community Edition release in April, and as part of your our updated community engagement approach (see: A New Era of MySQL Community Engagement), we are announcing more MySQL worklogs, a MySQL Developer Guide and a reminder to please provide feedback […] [...]

Published Friday, 20. March 2026 16:11 • 19 days ago

I spent 4 hours restoring a backup for one deleted row ^{(from dbtrail Blog)}

pSomeone ran a DELETE without the right WHERE clause. One row gone. One customer record. And I spent the next four hours of my life getting it back.…/p pThe post I spent 4 hours restoring a backup for one deleted row appeared first on dbtrail Blog./p [...]

Published Friday, 20. March 2026 15:42 • 19 days ago

DuckDB Storage Engine for MariaDB: Full-Speed Analytics Inside Your Database ^{(from One-Time MySQL Community/Ecosystem Posts)}

MariaDB has long been celebrated for its pluggable storage engine architecture — the same design that lets you run InnoDB, Aria, ColumnStore, and other engines within a single server. Now there's a new player joining the lineup: the DuckDB Storage Engine, bringing the full power of DuckDB's columnar analytical engine right inside MariaDB. [...]

Published Friday, 20. March 2026 00:00 • 20 days ago

Migrating Etsy’s database sharding to Vitess ^{(from Etsy Code as Craft)}

pEtsy has maintained a sharded MySQL architecture since around 2010. This database cluster contains most of Etsy’s online data and is made up of ~1,000 tables distributed across ~1,000 shards. Over the last 16 years, it has grown significantly: combined, these tables have over 425 TB of data and receive roughly 1.7 million requests per second. /p pEtsy engineers access our MySQL data through a prop [...]