BestHub
Sign in
Tag

Partition Tables

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 10, 2022 · Databases

How to Effectively Use Partition Tables in Multi-Table Joins to Improve Query Performance

This article examines various multi‑table join scenarios in MySQL, demonstrating when partition tables can accelerate queries and when they degrade performance, supported by concrete examples, execution times, and explain plans to guide proper partition key usage.

Database OptimizationJoin PerformanceMySQL
0 likes · 11 min read
How to Effectively Use Partition Tables in Multi-Table Joins to Improve Query Performance
Ctrip Technology
Ctrip Technology
Sep 4, 2017 · Databases

Investigation of Performance Degradation and Locking Issues in MySQL 5.7.18 Partition Tables

This article investigates the performance degradation and lock timeout issues observed in MySQL 5.7.18 partition tables, reproduces the problem with test cases, analyzes InnoDB lock behavior through source code debugging, validates the root cause related to partition scan locking, and confirms it as a regression bug in MySQL 5.7.

DatabaseInnoDBMySQL
0 likes · 8 min read
Investigation of Performance Degradation and Locking Issues in MySQL 5.7.18 Partition Tables