BestHub
Sign in
Tag

BenchmarkSQL

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 25, 2024 · Databases

Analyzing a BenchmarkSQL‑Induced Infinite Loop in MySQL under REPEATABLE‑READ Isolation

This article investigates why BenchmarkSQL stalls during MySQL performance testing, tracing the issue to REPEATABLE‑READ isolation causing a dead‑loop in delete‑select transactions, and demonstrates how switching to READ‑COMMITTED resolves the problem through detailed code inspection and experimental verification.

BenchmarkSQLMySQLPerformance Testing
0 likes · 8 min read
Analyzing a BenchmarkSQL‑Induced Infinite Loop in MySQL under REPEATABLE‑READ Isolation
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 29, 2022 · Databases

Performance Tuning and Observation Techniques for dble Using BenchmarkSQL

This article shares practical configuration recommendations, system‑resource monitoring methods, and thread‑adjustment strategies for optimizing dble performance during BenchmarkSQL TPC‑C style load testing, highlighting how observable metrics guide effective tuning of the middleware and underlying MySQL nodes.

BenchmarkSQLDBLEDatabase Middleware
0 likes · 10 min read
Performance Tuning and Observation Techniques for dble Using BenchmarkSQL