Tagged articles
Database Benchmark
13 articles · Page 1 of 1
This article benchmarks PostgreSQL JSON and JSONB types on 1 million rows, revealing JSONB delivers 6-9x faster queries and 26% less storage despite 31% slower writes, with practical guidance on when to choose each type and how to leverage GIN indexes for optimal performance.
Database BenchmarkGIN IndexJSON
0 likes · 20 min read

This article presents a systematic benchmark comparing ClickHouse, Doris, and Redis for IP‑range dimension lookups using Flink‑Kafka pipelines, detailing test design, result table schema, query interfaces, and performance results across varying data rates, concluding that Redis offers the fastest and most stable query latency.
ClickHouseDatabase BenchmarkDoris
0 likes · 7 min read

This article explains how to use MySQL's built‑in mysqlslap tool and the third‑party sysbench utility to benchmark MySQL performance, covering configuration changes, command‑line options, data preparation, execution of read/write and I/O tests, and interpretation of the resulting metrics.
Database BenchmarkLinuxMySQL
0 likes · 16 min read

This article demonstrates how to use the FunTester framework to benchmark Redis hash (map) and INCR commands, detailing the test design, Java code implementation, multithreaded execution, and summarizing the observed performance results.
ConcurrencyDatabase BenchmarkFunTester
0 likes · 6 min read

This article presents a detailed multi‑threaded performance benchmark of Redis list commands using the FunTester framework, describing three test scenarios, Java implementation details, raw JSON results, and observations on QPS and latency for insert, pop, and combined add‑remove operations.
Database BenchmarkFunTesterJava
0 likes · 11 min read

This guide explains how to configure MySQL for high‑concurrency testing, use the built‑in mysqlslap tool and the third‑party sysbench utility to benchmark read/write performance, CPU, I/O, and memory, and interpret the resulting metrics for database optimization.
Database BenchmarkLinuxMySQL
0 likes · 15 min read

This guide explains how to create a delayed‑disk device on Linux, place MySQL binlog files on it, and use tools like mysqlslap and pt‑ioprofile to observe the impact of artificially slow I/O on MySQL performance.
Database BenchmarkLinuxMySQL
0 likes · 3 min read

Over nine years, Ant Financial's OceanBase team transformed a fledgling distributed database into the first Chinese system to top the TPC‑C benchmark, beating Oracle's long‑standing record by more than double, while pioneering cloud‑based testing, intensive performance tuning, and a culture of relentless engineering dedication.
Database BenchmarkOceanBaseTPC-C
0 likes · 15 min read

This article details OceanBase’s achievement in the TPC‑C benchmark, explaining the test architecture, the role of ODBC and OBProxy, and the various link‑layer performance, resource, and durability optimizations that enable high throughput and continuous service in a distributed database environment.
Database BenchmarkOBproxyODBC
0 likes · 10 min read

This article provides a comprehensive technical analysis of OceanBase’s record‑breaking TPC‑C benchmark, covering the preparation work, test system design, planning, performance testing methodology, ACID verification, and the lessons learned from achieving 60.88 million tpmC on a distributed cloud platform.
ACIDDatabase BenchmarkDistributed Database
0 likes · 12 min read

This article provides a detailed technical analysis of OceanBase’s TPC‑C benchmark performance, covering the database’s development history, benchmark methodology, identified shortcomings, future improvement plans, and the strict standards and audit processes that ensure reliable OLTP benchmarking results.
Database BenchmarkDistributed DatabaseOceanBase
0 likes · 12 min read

OceanBase, the distributed database from Ant Financial, topped the latest TPC‑C benchmark, and this article explains the benchmark’s significance, the rigorous certification process, the performance and cost metrics, and how OceanBase’s architecture and Alibaba Cloud support enabled this achievement.
Database BenchmarkDistributed DatabaseOceanBase
0 likes · 13 min read

A sysbench benchmark comparing MySQL 5.7.25 and MySQL 8.0.15 shows that latin1 charset favors 5.7, while utf8mb4 dramatically improves 8.0 performance, and that collations such as utf8mb4_unicode_ci can further affect query speed.
CharsetDatabase BenchmarkMySQL
0 likes · 4 min read
