Overview

Pinned:

• Benchmarks

Posts for 2020:

• Explaining explain to understand index usage in MySQL

Benchmark reports for 2022:

• Insert Benchmark on Beelink (AMD, 8-core, 16G RAM, NVMe)
  • Cached by DBMS, 20M rows
    • MySQL 5.6, 5.7, 8.0 with InnoDB and MyRocks: 1 client, 2 clients, 3 clients, 4 clients
    • Postgres 12, 13, 14 and 15: 1 client, 2 clients, 3 clients, 4 clients
  • IO-bound, 500m rows
    • MySQL 5.6, 5.7, 8.0 with InnoDB and MyRocks: 1 client, 2 clients, 3 clients, 4 clients
    • Postgres 12, 13, 14 and 15: 1 client, 2 clients, 3 clients, 4 clients
• Insert Benchmark on AWS c7g.2xl with io2 SSD (256G, 10K IOPs)
  • 1 client, 20M rows, cached by DBMS
• Insert Benchmark on AWS c6i.2xl with io2 SSD (256G, 10K IOPs)
  • 1 client, 20M rows, cached by DBMS, hyperthread disabled
• Insert Benchmark on AWS c7g.4xl with io2 SSD (1T, 32K IOPs)
  • 4 clients, 50M rows, cached by DBMS
  • 8 clients, 50M rows, cached by DBMS
• Insert Benchmark on AWS c6i.4xl with io2 SSD (1T, 32K IOPs)
  • 4 clients, 50M rows, cached by DBMS, hyperthread disabled
  • 8 clients, 50M rows, cached by DBMS, hyperthread disabled
• Insert Benchmark on AWS c7g.8xl with io2 SSD (2T, 64K IOPs)
  • 8 clients, 100M rows, cached by DBMS
  • 16 clients, 100M rows, cached by DBMS
• Insert Benchmark on AWS c6i.8xl with io2 SSD (2T, 64K IOPs)
  • 8 clients, 100M rows, cached by DBMS, hyperthread disabled
  • 16 clients, 100M rows, cached by DBMS, hyperthread disabled
• Insert Benchmark on AWS c7g.16xl with io2 SSD (5T, 100K IOPs)
  • 22 clients, 500M rows, cached by DBMS
  • 44 clients, 500M rows, cached by DBMS
• Insert Benchmark on AWS c6i.16xl with io2 SSD (5T, 64K IOPs)
  • 22 clients, 500M rows, cached by DBMS, hyperthread disabled
  • 22 clients, 500M rows, cached by DBMS, hyperthread enabled
  • 44 clients, 500M rows, cached by DBMS, hyperthread disabled
  • 44 clients, 500M rows, cached by DBMS, hyperthread enabled
• Insert Benchmark
  • Intel NUC, not IO-bound, Postgres
  • Intel NUC, IO-bound, Postgres
  • Intel NUC, not IO-bound, InnoDB
  • Intel NUC, IO-bound, InnoDB
  • Intel NUC, not IO-bound, MyRocks
  • Intel NUC, IO-bound, MyRocks
• Insert Benchmark to test wal_compression in Postgres 15
  • Intel NUC, IO-bound
  • Intel NUC, not IO-bound
• Insert Benchmark for Postgres 12.11, 13.7, 14.3 and 15beta
  • Intel NUC, IO-bound
  • Intel NUC, IO-bound, uses prepared statements
  • Intel NUC, IO-bound, uses prepared statements, 15b1 with patch 1
  • Intel NUC, IO-bound, uses prepared statements, 15b1 with patch 1, larger WAL
  • Intel NUC, IO-bound, uses prepared statements, larger WAL, includes 15beta
  • Intel NUC, not IO-bound
  • Intel NUC, not IO-bound, uses prepared statements
  • Intel NUC, not IO-bound, uses prepared statements, 15b1 with patch 1
  • Intel NUC, not IO-bound, uses prepared statements, 15b1 with patch 1, larger WAL
  • Intel NUC, IO-bound, uses prepared statements, larger WAL, includes 15beta
• Insert Benchmark for Postgres 14.0, 14.1, 14.2, 14.3
  • Intel NUC, IO-bound
  • Intel NUC, not IO-bound

Benchmark reports for 2021:

• November
  • Insert benchmark, Intel NUC, 1 user, 20M rows (in memory)
    • InnoDB in MySQL 5.6, 5.7 and 8.0
    • Postgres 12.4, 13.4 and 14.0
    • MyRocks 5.6.35 and 8.0.20
  • Insert benchmark, Intel NUC, 1 user, 500M rows (IO-bound)
    • InnoDB in MySQL 5.6, 5.7 and 8.0
    • Postgres 12.4, 13.4 and 14.0
    • MyRocks 5.6.35 and 8.0.20
• January, Intel NUC
  • Insert benchmark, 20M rows, 1 user, NUC server
  • Insert benchmark, 100M rows, 1 user, NUC server
  • Insert benchmark, 500M rows, 1 user, NUC server

Benchmark reports for 2020:

• Insert benchmark tests with a table per user
  • CPU-bound, 15m rows, 1 user
  • CPU-bound, 40m rows, 8 user
  • IO-bound 800m rows, 8 users
  • IO-bound 2000m rows, 8 users
• Insert benchmark tests with 1 table shared by all users
  • CPU-bound, 40m rows, 8 user
  • IO-bound 800m rows, 8 users
  • IO-bound 2000m rows, 8 users
• Linkbench
  • CPU-bound, maxid1=10m, 8 users
  • IO-bound, maxid1=200m, 8 users
  • IO-bound, maxid1=500m, 8 users
• Insert benchmark on NUC to determine the best configuration
  • CPU-bound, 20m rows for InnoDB, MyRocks and Postgres
  • Less IO-bound, 100m rows for InnoDB, MyRocks and Postgres
  • More IO-bound, 500m rows for InnoDB, MyRocks and Postgres