Introduction

Here are benchmarking results for «MySQL BLOB Fetch Performance In Java» blog post.

The performance tests are performed via JMH. The configuration of a hardware is Intel® Core™ i7-1165G7 @ 2.80GHz × 8 (4 core + 4 HT) with 16 GB RAM. Scala version: 2.13.6.

avg - average, min - minimal, p50 - percentile 50 (median), p95 - percentile 95, p99 - percentile 99, max - maximum

Charts for real data

Effective throughput after decompression

Charts for stub (random) data

Effective throughput after decompression

Fetch performance for different compression ratios

  • 1KB
  • 5.0MB

Comparisons

Uncompressed vs LZ4 with different compression ratios

Compressed Table vs DECOMPRESS with different compression ratios

Java vs MySQL with different compression ratios

Full JMH logs: localhost (json), AWS (json), Ethernet (json), Wi‑Fi (json).