Percona Community Live Conference - Day 2 - Open Source Databases Conference
summary
Shows how a real core‑banking app reaches 1000 TPS on TiDB: missing indexes fixed a full table scan, enabling index_merge cuts a 50M‑row scan to 8ms, NUMA binding and changing TiDB/TiKV/PD topology raises TPS from 1→30→320→600→880→1200; tools include Grafana/TiDB dashboard, mpstat, perf, JVM binding and client‑side load‑balancing, and fixes (disk mount, 10Gb NIC) that actually work. Other sessions demo MySQL ALTER algorithms with algorithm=INSTANT vs COPY/INPLACE and locking effects, a varchar32 PK cost study, and PMM alerting setup.
AI-written summary · about
related talks
55mThe Future of MySQL
47m10 Reasons Why the TiDB Database Should Power Your Next Development Project
29mDistributed SQL How TiDB Modernized Data Management
29mDistributed SQL: How TiDB Modernized Data Management
44mConfessions of a DBA: worst and best things I've done in production
01mDatabase Talks and Tutorials
51mResolving MySQL Problems Quickly
01h 02mHow-to MySQL Performance Diagnostic Using Percona PMM