SHOW PROCESSLIST

Aikesheng Open Source Community

Jul 11, 2022 · Databases

Avoiding Global Mutex Contention in MySQL SHOW PROCESSLIST with performance_schema_show_processlist

This article explains how the default MySQL SHOW PROCESSLIST command can create a global mutex that slows down busy systems, demonstrates the problem with slow INSERTs reproduced via mysqlslap, and shows how enabling the performance_schema_show_processlist variable in MySQL 8.0.22+ eliminates the contention while providing best‑practice recommendations.

Database PerformanceMySQLPerformance Schema

0 likes · 6 min read

Avoiding Global Mutex Contention in MySQL SHOW PROCESSLIST with performance_schema_show_processlist

Aikesheng Open Source Community

Dec 3, 2019 · Databases

Understanding How MySQL SHOW PROCESSLIST Calculates the Time Column and Why Negative Values Appear

This article explains the internal calculation of the Time column shown by MySQL's SHOW PROCESSLIST command, covering the source functions, overloads of THD::set_time, various scenarios that affect the result—including replication lag, manual timestamp settings, and idle sessions—and why Percona and official builds may display different values.

Database InternalsMySQLReplication

0 likes · 10 min read

Understanding How MySQL SHOW PROCESSLIST Calculates the Time Column and Why Negative Values Appear