TCMalloc and MySQL
Feb 22, 2013Ted Nyman
Summary
This post details the investigation into rising MySQL query times, identifying `kernel_mutex` contention in InnoDB transactions as the root cause. It describes the successful migration from stock malloc to TCMalloc, leveraging its strength in reducing lock contention for threaded applications. This change resulted in a 30% improvement in query performance and a significant reduction in thread contention, as evidenced by a decrease in `pt-stalk` trigger frequency.