BestHub
search
Sign in
Tag

processlist

1 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 27, 2023 · Databases

Investigation of session_id source and bulk tenant connection termination in OceanBase via observer and obproxy

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.

DatabaseKill CommandOBproxy
0 likes · 7 min read
Investigation of session_id source and bulk tenant connection termination in OceanBase via observer and obproxy
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 10, 2022 · Databases

Analysis of MySQL 8.0.26 Crash Caused by the terminology_use_previous Parameter and INFORMATION_SCHEMA.PROCESSLIST Access

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.

INFORMATION_SCHEMAPerformance Schemabug
0 likes · 12 min read
Analysis of MySQL 8.0.26 Crash Caused by the terminology_use_previous Parameter and INFORMATION_SCHEMA.PROCESSLIST Access
Selected Java Interview Questions
Selected Java Interview Questions
Jan 6, 2021 · Databases

Using SHOW FULL PROCESSLIST to Diagnose and Resolve MySQL Table Locks

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.

Database TroubleshootingInnoDBkill query
0 likes · 8 min read
Using SHOW FULL PROCESSLIST to Diagnose and Resolve MySQL Table Locks
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 31, 2020 · Databases

Diagnosing MySQL High CPU Usage with Processlist and Performance Schema

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.

CPUDatabase TroubleshootingKill
0 likes · 3 min read
Diagnosing MySQL High CPU Usage with Processlist and Performance Schema