This guide explains what pt‑kill is, how it works within Percona Toolkit to kill MySQL connections based on execution time and various filters, demonstrates command‑line usage, victim‑selection modes, filtering options, source‑code logic, and common patterns such as logging and daemonizing.
This article examines how session IDs are derived for the kill command in OceanBase, compares IDs obtained through show processlist, information_schema.processlist, and oceanbase.__all_virtual_processlist, and demonstrates methods to terminate all connections of a specific tenant across different observers and obproxies.
The article investigates a MySQL 8.0.26 crash triggered by setting the terminology_use_previous parameter to BEFORE_8_0_26, analyzes stack traces and core dumps, compares processlist access methods, references related bugs, and offers mitigation recommendations for monitoring tools.
This article explains how to use MySQL's SHOW FULL PROCESSLIST command, interpret its output, kill problematic threads, and address metadata lock issues by inspecting InnoDB transactions and adjusting lock_wait_timeout, providing practical code examples for database administrators.
This article walks through a practical MySQL troubleshooting experiment that shows how to identify a CPU‑intensive query using the processlist, locate the offending thread with top‑H, interpret performance_schema IDs, and safely terminate the problematic SQL statement.
This guide explains how to use MySQL's show processlist command, interprets each column and common state values, and offers practical tips for diagnosing and resolving performance problems such as sleeping connections, locked queries, temporary tables, and query cache issues.
