MySQL Fine-Grained Lock Tuning
Application scenario: MySQL OLTP with high-concurrency read/write operations
Technical principle: The performance in high-concurrency write scenarios is improved through Lock-sys fine-grained lock tuning, table lock queue check optimization, and ReadView version tracking.
Performance metric: The sysbench write-only performance is improved by 5%.
How to use:
For details, see MySQL 5.7.44 Fine-Grained Lock Tuning Feature Guide and MySQL 8.0.20 Fine-Grained Lock Tuning Feature Guide.
Parent topic: Lock and Atomic Variable Optimization