Planet MariaDB Server
MariaDB innovation: binlog_storage_engine, small server, Insert Benchmark
MariaDB 12.3 has a new feature enabled by the option binlog_storage_engine. When enabled it uses InnoDB instead of raw files to store the binlog. A big benefit from this is reducing…
MariaDB innovation: binlog_storage_engine
MariaDB 12.3 has a new feature enabled by the option binlog_storage_engine. When enabled it uses InnoDB instead of raw files to store the binlog. A big benefit from this is…
HammerDB tproc-c on a large server, Postgres and MySQL
This has results for HammerDB tproc-c on a small server using MySQL and Postgres. I am new to HammerDB and still figuring out how to explain and present results so I will…
What is the quickest way to load data into the database?
We had some really exciting problems to solve for the last customer! Especially because the database wasn’t exactly small. Here are some key data: CPU: 2 sockets x 24 cores…
What is the quickest way to load data into the database?
We had some really exciting problems to solve for the last customer! Especially because the database wasn’t exactly small. Here are some key data: CPU: 2 sockets x 24 cores…
MariaDB has broken the concept of dynamically configurable buffer pools!
Problem description MySQL introduced the dynamically configurable InnoDB buffer pool with 5.7.5 in September 2014 (here and here): The innodb_buffer_pool_size configuration option can be set dynamically using a SET statement,…
MariaDB has broken the concept of dynamically configurable buffer pools!
Problem description MySQL introduced the dynamically configurable InnoDB buffer pool with 5.7.5 in September 2014 (here and here): The innodb_buffer_pool_size configuration option can be set dynamically using a SET statement,…
Pre-FOSDEM & FOSDEM 2026, Community, Databases, and Open Source
This is a recap of Percona at preFosdem and Fosdem! Before FOSDEM officially started, the database community gathered for MySQL Belgium Days (Pre-FOSDEM), a two-day event bringing together MySQL developers,…
Wireshark now can decode MySQL X Protocol
The new protocol dissector for X Protocol in MySQL was just merged to the master branch in Wireshark. To get it build Wireshark from the master branch or wait for…
Wireshark now can decode MySQL X Protocol
The new protocol dissector for X Protocol in MySQL was just merged to the master branch in Wireshark. To get it build Wireshark from the master branch or wait for…
How much space does NULL need?
The last time I consulted a customer, he came up to me beaming with joy and said that he had taken my advice and changed all the primary key columns…
How much space does NULL need?
The last time I consulted a customer, he came up to me beaming with joy and said that he had taken my advice and changed all the primary key columns…
Someone is deleting my shared memory segments!
When we work with PostgreSQL under our myEnv, we regularly get shared memory segment errors. Example: psql: error: connection to server on socket “/tmp/.s.PGSQL.5433” failed: FATAL: could not open shared…
Someone is deleting my shared memory segments!
When we work with PostgreSQL under our myEnv, we regularly get shared memory segment errors. Example: psql: error: connection to server on socket “/tmp/.s.PGSQL.5433” failed: FATAL: could not open shared…
Load CSV files into the database
Recently, I wanted to display the places of residence of the members of my club on a map for a personal gimmick (IGOC members). I knew the addresses of the…