2023-03-03 mysql列存储-cpu占用100%-追踪思路

摘要:

最近在处理mysql列存储时, 发现在执行explain时, cpu占用达到了100%.

本文分析定位该问题的思路过程

现象:

1. mysqld进程占用100%
2. 使用kill processlist终止会话, 无响应
3. 查看show processings; 发现一直在运行

mysql>  show processlist;
+----+-----------------+-----------+------+---------+-------+------------------------+------------------+
| Id | User            | Host      | db   | Command | Time  | State                  | Info             |
+----+-----------------+-----------+------+---------+-------+------------------------+------------------+
|  5 | event_scheduler | localhost | NULL | Daemon  | 13188 | Waiting on empty queue | NULL             |
|  8 | root            | localhost | test | Query   |     0 | init                   |