Blog

TideSQL 5 Arrives in MariaDB, How Does It Stack Up Against InnoDB?

TideSQL 5.0.0 arrives as a MariaDB storage engine. A sysbench run on MariaDB 13.1.0 sees it beat InnoDB on nine of ten OLTP workloads, from 4x to 60x.

Keybench Analysis on TidesDB v10.0.0 and RocksDB v11.8.1

A five workload comparison of TidesDB v10.0.0 and RocksDB v11.8.1 using keybench, at 10 GiB per workload on two machines, a small server on SATA and a large server on NVMe, with the seed rates, write amplification and variance numbers and the caveats that come with them.

HammerDB TPC-C TideSQL v4.6.1 & InnoDB Analysis in MariaDB v11.8.6

Benchmark analysis comparing TideSQL v4.6.1 utilizing HammerDB 6 TPROC-C.

Retrieval-Augmented Generation on TideSQL - Hybrid full-text + vector search with TTL

Build the retrieval layer of a RAG pipeline on a single TideSQL table using a FULLTEXT index, a MariaDB VECTOR index, and TTL row expiry, with a runnable Python example.

sysbench zipfian read-write Analysis on TidesDB v9.3.11/TideSQL v4.5.9, RocksDB (MyRocks), in MariaDB v11.8.6

sysbench limited configuration, zipfian analysis on TidesDB v9.3.11, TideSQL v4.5.9 and RocksDB in MariaDB v11.8.6

TTL (Time to live) using TideSQL in MariaDB

TTL, what is it? how to use it, in MariaDB using TidesDB's TideSQL plugin engine.

Configuring TideSQL in MariaDB

Configure the TidesDB storage engine (TideSQL) in MariaDB, from sync modes and memory to compaction and per-table options, with side-by-side InnoDB comparisons.

Build Comparison TidesDB v9.3.6 & RocksDB v11.1.1

Timing the core library build for TidesDB v9.3.6 and RocksDB v11.1.1 on the same machine, with notes on method, fairness, and the usual caveats.

sysbench Analysis on TideSQL v4.5.6 & InnoDB in MariaDB v11.8.6

sysbench small cache/buffer, many tables analysis on TideSQL v4.5.6 & InnoDB in MariaDB v11.8.6

Keybench Analysis with TidesDB v9.3.6 and RocksDB v11.1.1

A first look at Keybench, a scriptable benchmark for sorted key value stores, with a four workload comparison of TidesDB v9.3.6 and RocksDB v11.1.1 on a modest SATA SSD and jemalloc.

TideSQL v4.5.5 & InnoDB Full-Text Search, Spatial, and Large Value Analysis in MariaDB v11.8.6

HammerDB TPC-C Analysis on TidesDB v9.3.3/TideSQL v4.5.4 and InnoDB in MariaDB v11.8.6

Benchmark analysis comparing TideSQL v4.5.4 and InnoDB in MariaDB v11.8.6 running HammerDB TPROC-C with jemalloc.

iibench Analysis on TideSQL v4.5.1 MyRocks, InnoDB in MariaDB v11.8.6

iibench(index-insertion) benchmark on TideSQL v4.5.1 MyRocks, InnoDB in MariaDB v11.8.6

Consumer TPC-C Analysis on TideSQL v4.5.0, MyRocks and InnoDB in MariaDB v11.8.6 using HammerDB

Benchmark analysis on a consumer custom high-end desktop environment running TideSQL, MyRocks and InnoDB in MariaDB 11.8.6 running TPC-C (TPROC-C) with HammerDB

Benchmark Analysis on TidesDB v9.2.1 and RocksDB v11.1.1

Extensive benchmark analysis on TidesDB v9.2.1 and RocksDB v11.1.1 across multiple workloads on dedicated server.

Benchmark Analysis on TideSQL v4.3.0 MINOR in MariaDB v11.8.6 TPC-C with jemalloc and PGO

Benchmark analysis comparing TideSQL v4.3.0 to v4.2.6 in MariaDB v11.8.6 running HammerDB TPROC-C with jemalloc and PGO.

PGO Build TPC-C Analysis MariaDB v11.8.6 TideSQL

PGO build TPC-C analysis for MariaDB v11.8.6 with TideSQL.

TPC-C Analysis with glibc, jemalloc, mimalloc, tcmalloc on TideSQL & InnoDB in MariaDB v11.8.6

TPC-C analysis with glibc, jemalloc, mimalloc, tcmalloc on TideSQL & InnoDB in MariaDB v11.8.6

MariaDB 11.8.6 InnoDB & TidesDB (TideSQL v4.2.4) TPC-C Benchmark Analysis

Analysis on small cache/buffer and large cache/buffer configurations storage engine performance comparison in MariaDB 11.8.6 InnoDB and TidesDB (TideSQL v4.2.4) TPC-C benchmarks.

Deploying TideSQL on AWS Kubernetes with S3 Object Store (Cloud-Native MariaDB)

Primary/replica cluster with automatic failover on EKS using S3-backed storage running MariaDB+TidesDB (TideSQL) on AWS

Deploying TideSQL (TidesDB+MariaDB) on AWS EC2

Video and notes on Deploying TideSQL (TidesDB+MariaDB) on AWS EC2

TPC-C Benchmark Analysis on TidesDB v9.0.2 in TideSQL v4.2.0 in MariaDB v11.8.6

TideSQL v4.2.0 Full-Text Search, Vector Similarity, Spatial Queries, and Cloud-Native Capabilities

An article detailing the new features and fixes in TideSQL 4.2.0 MINOR release.

Benchmark Analysis on TidesDB 9 (TideSQL 4.1), MyRocks, InnoDB in MariaDB 11.8.6 TPC-C HammerDB

Extensive benchmark analysis on TidesDB 9 (TideSQL 4.1), MyRocks, InnoDB in MariaDB 11.8.6 running HammerDB TPROC-C.

TidesDB (TideSQL 4) & RocksDB in MariaDB 11.8.6 TPC-C Analysis

Extensive benchmark analysis on LSM Tree storage engines in MariaDB 11.8.6 with TidesDB (TideSQL) & RocksDB (MyRocks) across multiple workloads.

TidesDB (TideSQL 4) & RocksDB in MariaDB 12.2.2 Sysbench Analysis

Extensive benchmark analysis on LSM Tree storage engines in MariaDB 12.2.2 with TidesDB (TideSQL) & RocksDB (MyRocks) across multiple workloads.

Benchmark Analysis on TidesDB v8.9.0 and RocksDB v11.0.3

Extensive benchmark analysis on TidesDB v8.9.0 and RocksDB v11.0.3 across multiple workloads.

Benchmark Analysis on TidesDB v8.7.1 and RocksDB v11.0.3

Extensive benchmark analysis on TidesDB v8.7.1 and RocksDB v11.0.3 across multiple workloads.

Benchmark Analysis on TidesDB (TideSQL v3.3.5) & InnoDB in MariaDB v12.2.2 & InnoDB in MySQL v9.5.0

Benchmark analysis comparing TidesDB (TideSQL v3.3.5) and InnoDB in MariaDB v12.2.2 and InnoDB in MySQL v9.5.0

Benchmark Analysis on TidesDB v8.6.0 and RocksDB v10.10.1

Extensive benchmark analysis on TidesDB v8.6.0 and RocksDB v10.10.1 across multiple workloads and servers.

Benchmark Analysis on TidesDB (TideSQL v3.1.0) & InnoDB in MariaDB v12.2.2

Benchmark analysis comparing TidesDB (TideSQL v3.1.0) and InnoDB in MariaDB v12.2.2

Benchmark Analysis on TidesDB v8.5.0 and RocksDB v10.10.1

Extensive benchmark analysis on TidesDB v8.5.0 and RocksDB v10.10.1 across multiple workloads on a dedicated optimized server.

Benchmark Analysis on TidesDB v8.4.0 and RocksDB v10.10.1

Extensive benchmark analysis on TidesDB v8.4.0 and RocksDB v10.10.1 across multiple workloads on a dedicated optimized server.

Benchmark Analysis on TidesDB v8.3.2 and RocksDB v10.10.1

Extensive benchmark analysis on TidesDB v8.3.2 and RocksDB v10.10.1 across multiple workloads on a dedicated optimized server.

New Benchmark Environment

Article on TidesDB new benchmark environment

Benchmark Analysis on TideSQL 3 and InnoDB within MariaDB 12.1.2

Deep benchmark analysis on TideSQL 3 (TidesDB Plugin) and InnoDB within MariaDB 12.1.2 across multiple OLTP workloads

Benchmark Analysis on TidesDB v8.2.4 and RocksDB v10.10.1

Deep benchmark analysis on TidesDB v8.2.4 and RocksDB v10.10.1 across multiple workloads

Benchmark Analysis on TidesDB v8.2.1 and RocksDB v10.10.1

Deep benchmark analysis on TidesDB v8.2.1 and RocksDB v10.10.1 across multiple workloads

Plugging into MariaDB

The journey of building TideSQL, a pluggable LSM-tree storage engine for MariaDB powered by TidesDB, with sysbench benchmarks against InnoDB and MyRocks.

Large Amount of Column Families with RocksDB and TidesDB

Comparisons of large amount of column families with RocksDB and TidesDB

Benchmark Analysis on TidesDB v8.1.1, RocksDB v10.10.1, and LMDB v0.9.24

Benchmark Analysis on TidesDB v8.1.1, RocksDB v10.10.1, and LMDB v0.9.24

TideSQL v1.1.0 and InnoDB in MariaDB 12.1 Benchmark Analysis

TideSQL v1.1.0 and InnoDB in MariaDB 12.1 Benchmark Analysis

TidesDB 8 with optional LSM-B+Tree KLog Indexes

TidesDB 8 introduces optional B+tree-backed KLog indexes for improved read performance.

Benchmark Analysis on TidesDB (TideSQL v1.0.0) & InnoDB in MariaDB v12.1.2

Benchmark analysis comparing TidesDB (TideSQL v1.0.0) and InnoDB in MariaDB v12.1.2

Benchmark Analysis on TidesDB v7.4.4 & RocksDB v10.9.1

Performance benchmarks comparing TidesDB v7.4.4 and RocksDB v10.9.1 on write, read, and mixed workloads with default glibc allocator on Linux.

Benchmark Analysis on TidesDB v7.4.3 & RocksDB v10.9.1

Performance benchmarks comparing TidesDB v7.4.3 and RocksDB v10.9.1 on write, read, and mixed workloads with default glibc allocator on Linux.

TidesDB vs InnoDB within MariaDB

Observations from custom benchmarks and Sysbench OLTP workloads comparing TidesDB 7 and InnoDB

TidesDB Differences with glibc, mimalloc, tcmalloc

An article on differences running TidesDB with glibc, mimalloc, tcmalloc

Building Reliable and Safe Systems

How TidesDB's testing infrastructure ensures correctness across 15+ platforms, 5 architectures, and 8,700+ tests on every commit.

TidesDB for Kafka Streams - Drop-in RocksDB Replacement

Introducing the TidesDB Kafka Streams plugin - a drop-in replacement for RocksDB that delivers better throughput, lower latency, and reduced storage footprint.

TidesDB & RocksDB on NVMe and SSD

TidesDB & RocksDB benchtool results on NVMe and SSD.

Benchmark Analysis on TidesDB v7.4.0(mimalloc) & RocksDB v10.9.1 (jemalloc)

Performance benchmarks comparing TidesDB v7.4.0 and RocksDB v10.9.1 on write, read, and mixed workloads with mimalloc and jemalloc allocators.

TideSQL - A Write and Space Optimized MySQL Fork

TideSQL is a MySQL fork using TidesDB as its default storage engine, providing LSM-tree based storage with excellent write performance and space efficiency.

TidesDB v7.3.1 vs RocksDB v10.9.1 Performance Benchmark

In-depth performance benchmark comparing TidesDB v7.3.1 and RocksDB v10.9.1 across real-world workloads, measuring throughput, latency, and efficiency.

TidesDB v7.3.0 & RocksDB v10.9.1 Benchmark Analysis

Comprehensive performance benchmarks comparing TidesDB v7.3.0 and RocksDB v10.9.1.

From Building Houses to Storage Engines

The journey of how TidesDB came to be.

TidesDB v7.2.3 & RocksDB v10.9.1 Benchmark Analysis

Comprehensive performance benchmarks comparing TidesDB v7.2.3 and RocksDB v10.9.1.

TidesDB v7.2.2 vs RocksDB v10.9.1 Latency Analysis

Analysis of TidesDB v7.2.2 vs RocksDB v10.9.1 Latency

Benchmark Analysis of TidesDB 7.2.1 vs RocksDB 10.9.1

Examining the performance of TidesDB 7.2.1 vs RocksDB 10.9.1

Administering TidesDB with Admintool

A guide to administering TidesDB with Admintool

TidesDB 7.1.1 vs RocksDB 10.9.1 Performance Benchmarks

Comprehensive performance benchmarks comparing TidesDB v7.1.1 and RocksDB v10.9.1 with sync disabled for maximum throughput.

Why We Benchmark on Modest Hardware

Learn why TidesDB benchmarks on consumer-grade hardware instead of high-end systems, and how our lock-free architecture scales linearly with better CPUs and storage.

TidesDB 7 vs RocksDB 10 Under Sync Mode

Comprehensive performance benchmarks comparing TidesDB v7.1.0 and RocksDB v10.7.5 with durable writes enabled.

1GB Value Observations TidesDB 7 & RocksDB 10

An article on observations of 1GB value benchmarks between TidesDB 7 & RocksDB 10

Comparative Analysis of TidesDB v7.0.7 & RocksDB v10.7.5

Comprehensive performance benchmarks comparing TidesDB v7.0.7 & RocksDB v10.7.5.

Using TidesDB with Java via JExtract

Step-by-step guide to using TidesDB with Java via JExtract. Learn how v7.0.6's simplified db.h header enables seamless Java bindings for high performance key-value storage.

Death by a Thousand Cycles - Micro-Optimizations in TidesDB v7.0.4

Optimizations done in TidesDB v7.0.4 PATCH and benchmark results against RocksDB v10.7.5

What I Learned Building a Storage Engine That Outperforms RocksDB

Lessons learned building TidesDB - an embeddable storage engine that outperforms RocksDB through lock-free concurrency, adaptive compaction, and aggressive caching.

TidesDB 7.0.0 vs RocksDB 10.7.5: A Detailed Performance Analysis

A comprehensive examination of benchmark results comparing TidesDB 7.0.0 against RocksDB 10.7.5 across diverse workloads, with architectural insights and performance characteristics.

TidesDB article title here..

A detailed description for the article

Seek and Range Query Performance · TidesDB v6.1.0 vs RocksDB v10.7.5

Deep dive into how block caching and index design deliver 4-9x faster seek operations.

Design Decisions and Performance Analysis of TidesDB v6.0.1 & RocksDB v10.7.5

Deep dive into architectural decisions and performance characteristics of TidesDB.

Comparative Analysis of TidesDB v6 & RocksDB v10.7.5

Comprehensive performance benchmarks and architectural implications of both engines.

TidesDB 4 vs RocksDB 10 Performance Analysis

Comprehensive performance analysis comparing TidesDB 4 and RocksDB 10 storage engines.