Database Community Insights
Community pulse
Database Community Insights
Follow MySQL and MariaDB project updates, database engineering articles, SQL discussions, performance tuning, administration and community insights.
MySQL: Planet MySQL
Community and Oracle MySQL team blog aggregation covering MySQL development, releases, performance and operations.
Queries with OR conditions are commonly used to implement business logic. However, it might be slower than we expected. Although the query below scans only 1 million rows, it runs for 6,7254 seconds.# User@Host: msandbox[msandbox] @ localhost [127.0.0.1] Id...
Welcome back to Village News, our curated roundup of MySQL and database news. This week, MariaDB shipped its Q4 maintenance releases across four LTS series, and OurSQL Foundation opened a call for MySQL-compatible projects to share its FOSDEM 2027 booth. If...
MySQL transactions help maintain data consistency by grouping related SQL updates so they can be committed together or rolled back when an operation fails. See how START TRANSACTION and ROLLBACK work with inventory updates and database constraints to revers...
We've heard positive feedback about VillageSQL's documentation, so we wanted to share a bit more on how we build it and how we hope to evolve it. VillageSQL Server tracks upstream MySQL and adds an extension framework, so the documentation has two moving ta...
Some of the first large database servers I worked with were DEC VAX/VMS systems running Sybase. They were physically huge machines. Towers of quad 90.91 MHz processors, with more towers beside them holding mirrored RAID5 storage. At the time, this was big i...
Your Amazon Aurora MySQL cluster looks healthy. Reads and writes succeed and every metric is green. Then a routine CREATE INDEX fails with error 63955, and from then on no index that includes a virtual column can be created on the cluster until you rebuild ...
Welcome back to Village News, our curated roundup of MySQL and database news. This week, PostgreSQL shipped updates fixing 52 security vulnerabilities and retired PostgreSQL 14, and the FOSDEM M-Ecosystem devroom opened its call for participation. If you wa...
We all know that when using a cluster based on Galera (Codership) such as Percona XtraDB Cluster (PXC), it is recommended to deploy an odd number of nodes. The generic answer to this recommendation is that otherwise the risk of having an inconsistent cluste...
MySQL's LAG() window function helps you compare sales totals across rows and calculate changes between consecutive records. See how to retrieve previous row values, order sales data by date, and calculate sales differences using the LAG() function in MySQL:...
It’s Thursday afternoon, and a developer has an idea. Nothing complicated. They are working on a new application feature and want to test an idea before committing to a larger implementation. A quick prototype is already running locally. So far, so good. Ne...
MariaDB Foundation: Planet MariaDB
Community-driven MariaDB articles, project developments, releases and ecosystem updates from the MariaDB Foundation.
Queries with OR conditions are commonly used to implement business logic. However, it might be slower than we expected. Although the query below scans only 1 million rows, it runs for 6,7254 seconds. [crayon-6afe48c3b9849522232293/] The CPU profile indicate...
Junction is Europe’s biggest hackathon: about 2,000 people building for 48 hours in Espoo, Finland. At Junction 2026, on 13–15 November, the MariaDB Foundation hosted MariaDB’s Wikipedia challenge: build tools that make Wikipedia better, using MariaDB Vecto...
Another quarter, another round of MariaDB Server maintenance releases! On November 16, 2026, we released updates for our four currently maintained Long Term Support (LTS) series: As usual, these releases bring bug fixes, stability improvements, and security...
MariaDB Cloud AI Retrieval... is a managed retrieval-augmented generation (RAG) service that grounds AI applications and agents in your documents and in the live data in your MariaDB databases, through a simple REST API. MariaDB Cloud AI Retrieval: Managed ...
Performance regression investigations rarely follow a straight line. Mark Callaghan has been providing me with some great MariaDB performance issues to investigate. These are exactly the kinds of problems I enjoy working on. A benchmark shows that something...
Autumn is the time when leaves change color and fall. It’s also the time when new PostgreSQL releases come out, or at least that’s been the tradition for quite a while. PGConf.EU 2026: It’s About More Than PostgreSQL appeared first on MariaDB.org
How Valkey/Redis data lives on RocksDB Based on my Percona Live 2026 talk “On-disk and Redis Compatible: Evaluating Kvrocks.” I will cover benchmarking Kvrocks in a separate post. We all run Valkey or Redis for well-known reasons: all the data lives in RAM,...
MariaDB is pleased to announce the immediate availability of MariaDB Community Server 12.3.4, 11.8.10, 11.4.14, and 10.11.20 maintenance releases. See […] MariaDB Community Server Q4 2026 maintenance releases appeared first on MariaDB.org
Atarim moves its RAG storage from Qdrant to MariaDB, optimizer hints in MariaDB Server 13.0, TLS connections more than 3x faster, our first India meetup, and a security researcher on hunting bugs in MariaDB’s connectors. MariaDB Foundation Newsletter – 15 N...
Choosing where to host your MariaDB database is about much more than performance, pricing and the resources available. Good operational support, good backup practices, a clear upgrade path and the ability to move your data are just as important, if not more...
MariaDB Foundation: Official Blog
Official MariaDB Foundation news, release announcements, community activity and technical articles.
Junction is Europe’s biggest hackathon: about 2,000 people building for 48 hours in Espoo, Finland. At Junction 2026, on 13–15 November, the MariaDB Foundation hosted MariaDB’s Wikipedia challenge: build tools that make Wikipedia better, using MariaDB Vecto...
Another quarter, another round of MariaDB Server maintenance releases! On November 16, 2026, we released updates for our four currently maintained Long Term Support (LTS) series: As usual, these releases bring bug fixes, stability improvements, and security...
Performance regression investigations rarely follow a straight line. Mark Callaghan has been providing me with some great MariaDB performance issues to investigate. These are exactly the kinds of problems I enjoy working on. A benchmark shows that something...
Atarim moves its RAG storage from Qdrant to MariaDB, optimizer hints in MariaDB Server 13.0, TLS connections more than 3x faster, our first India meetup, and a security researcher on hunting bugs in MariaDB’s connectors. MariaDB Foundation Newsletter – 15 N...
Choosing where to host your MariaDB database is about much more than performance, pricing and the resources available. Good operational support, good backup practices, a clear upgrade path and the ability to move your data are just as important, if not more...
More than 90 security reports, 14 CVEs, and one finding that got fixed across five connectors. A conversation with the researcher behind them about drivers as attack surface, incomplete fixes, and what changes when AI agents get database access. Fix the cla...
A plugin catalog that installs extensions with one SQL command. An analytics engine that runs inside MariaDB Server. A contributor’s patch that makes metadata queries two and a half times faster. On 12 November, the MariaDB Foundation’s first India meetup s...
Atarim has replaced Qdrant with MariaDB as the vector store for its internal RAG system. The team describes the change as close to a direct replacement, made for easier integration, data sovereignty and fewer vendors to manage. Vectors and their metadata ar...
Some of the first large database servers I worked with were DEC VAX/VMS systems running Sybase. They were physically huge machines. Towers of quad 90.91 MHz processors, with more towers beside them holding mirrored RAID5 storage. At the time, this was big i...
I was able to get a (seemingly) significant TLS connect/disconnect performance boost with WolfSSL on non-x86 64bit platforms/compiler combinations. Here are the numbers, in seconds per 100 localhost connect/disconnects: That’s 3x+! From a 2-line change! Wha...
Percona: Database Performance Blog
Independent database engineering insights, MySQL and MariaDB performance, reliability, backups and operations.
November 19, 2026 | Percona Security Team Percona is aware of the recently disclosed Java4Shell vulnerability (CVE-2026-114938), a critical security issue reportedly affecting OpenJDK and related Java distributions. The vulnerability involves memory corrupt...
Queries with OR conditions are commonly used to implement business logic. However, it might be slower than we expected. Although the query below scans only 1 million rows, it runs for 6,7254 seconds. [crayon-6afed2b0662dc849162864/] The CPU profile indicate...
How Valkey/Redis data lives on RocksDB Based on my Percona Live 2026 talk “On-disk and Redis Compatible: Evaluating Kvrocks.” I will cover benchmarking Kvrocks in a separate post. We all run Valkey or Redis for well-known reasons: all the data lives in RAM,...
You were assigned one of the most common, yet feared, tasks in the life of a database administrator: Upgrades are needed for many reasons, whether to fix an existing bug or to keep the environment under support and eligible to receive security fixes. Either...
We all know that when using a cluster based on Galera (Codership) such as Percona XtraDB Cluster (PXC), it is recommended to deploy an odd number of nodes. The generic answer to this recommendation is that otherwise the risk of having an inconsistent cluste...
Your MongoDB cluster has been running fine for years on 4.4 or 6.0. Then the version goes end of life, a CVE shows up in an audit, or a new feature needs 8.0, and the MongoDB upgrade lands on your desk. The upgrade itself is not hard. Knowing everything you...
It’s Thursday afternoon, and a developer has an idea. Nothing complicated. They are working on a new application feature and want to test an idea before committing to a larger implementation. A quick prototype is already running locally. So far, so good. Ne...
Part 1 of 2: From bare Ubuntu servers to a running MySQL cluster OpenEverest is an open source platform for running databases such as MySQL, PostgreSQL and MongoDB on Kubernetes. You get a web console and an API, and Kubernetes operators handle provisioning...
Part 2 of 2: Reading wsrep status, killing the writer, and proving zero data loss In Part 1 we built a 3-node K3s cluster, installed OpenEverest, and created a 3-node Percona XtraDB Cluster (PXC) named mysql-vjg. In this post we look inside that cluster. Se...
Between any two glibc versions, locales can change, and those changes alter the order of character string comparison (text/varchar/char/citext). It may also happen that locales are removed, such as en_US@ampm, present in RHEL8 and removed in RHEL9, and aa_E...
Reddit: r/mysql
Community discussions about MySQL development, SQL, administration, performance and troubleshooting.
Recent items are temporarily unavailable. Visit the source directly to explore its latest discussions and resources.
Reddit: r/mariadb
Community conversations about MariaDB Server, migrations, configuration, performance and troubleshooting.
Recent items are temporarily unavailable. Visit the source directly to explore its latest discussions and resources.
Reddit: r/Database
Broader database discussions covering relational databases, architecture, data modelling and operations.
Recent items are temporarily unavailable. Visit the source directly to explore its latest discussions and resources.
Database Administrators: Stack Exchange
Technical questions and answers from database administrators about SQL engines, reliability, performance and database operations.
Postgres doesnt maintain repo of plan and there is no way to revert to old plans if performance degrades with new plans. Can someone guide best possible option to create repository and ways to switch to old plans. Already considering pg_store_plans and pg_h...
I am trying to install Microsoft SQL Server 2022 Developer Edition on my Windows 11 Pro (64-bit) computer, but the installation fails. During installation, I receive this error: "Wait on the Database Engine recovery handle failed. Check the SQL Server error...
To implement data retention policy on temporal tables I script: Set Xact_Abort On Begin Tran Alter Table ___ Set (System_Versioning = Off); Delete From ___History Where ValidFrom < @DeletionDate Alter Table ___ Set (System_Versioning = On (History_Table = _...
I have a problem: I have taken a backup of a master table in Oracle database, which has a lot of child tables, and now that the master table has some corrupted data and I need to delete the data from that table, and recover from that backup. The problem is ...
I am setting up a brand new bare-metal/VM installation of PostgreSQL 18 on Linux and want the database cluster initialized directly onto a dedicated 500GB volume mounted at /mnt/dbdata from day one (no existing data to migrate). Environment OS & Kernel: RHE...
The console shows a database storage usage of 963 GB, but when I calculate the actual data size in MySQL: SELECT SUM(data_length + index_length) / 1024 / 1024 / 1024 AS size_gb FROM information_schema.tables; it only reports 627 GB — a gap of about 336 GB t...
The following are well known and agreed by just about everyone: Query Store's WAIT_STATS_CAPTURE_MODE is a very nice thing to have because it can be helpful for performance tuning. If any part of Query Store is likely to be a bottleneck, it is the collectio...
Nagios XI on Ubuntu 20.04, MySQL 8.0.42, same VM (16 vCPU, 54 GB RAM) innodb_buffer-pool-size = 20G, max_connections = 300 Load average around 100 during the problem xi_metain the nagiosxi database has about 27.4 million rows and 39 GB of data. Its only ind...
I'm on IBM i (Db2 for i) and need to deploy a schema change that adds one new field to a physical file/table. The table has about 200 million records in each library, and the same change must be applied to about 150 libraries in a single 5-hour deployment w...
I have a request to build a function that finds a specific condition in a temporal table and am having a difficult time creating a good solution. This specific condition can be boiled down to finding, "the oldest record for the most recent single or group o...
Discussions are sourced from public third-party communities. Their content, opinions and availability are controlled by the respective platforms and users. Flipnzee does not endorse every opinion or product mentioned. Please follow each community’s rules when participating.
