OceanBase(4)OceanBase日常运维
397
2022-03-07
1、操作系统进程ID
MySQL是一个单进程多线程的服务程序,其进程ID使用ps命令即可看到
ps aux | grep mysqld
2、操作系统线程ID与MySQL线程ID
mysql -uroot -p123456 #假设通过show processlist查到该用户连接ID为25 +----+------+-----------+-------+---------+------+-------+------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +----+------+-----------+-------+---------+------+-------+------------------+-----------+---------------+ | 25 | root | localhost | mymgr | Query | 0 | init | show processlist | 0 | 0 | +----+------+-----------+-------+---------+------+-------+------------------+-----------+---------------+ begin; select *,sleep(1000) from t1 for update; #这个SQL会运行很长时间,方便观察
3、通过performance_schema.threads查看THREAD_OS_ID(MySQL 5.7之前没有该字段),该列记录了MySQL内部线程所对应的操作系统线程ID
SELECT * FROM threads WHERE PROCESSLIST_ID=25\G # 通过用户线程查询具体操作 *************************** 1. row *************************** THREAD_ID: 65 # MySQL内部线程ID NAME: thread/sql/one_connection TYPE: FOREGROUND PROCESSLIST_ID: 25 <-- MySQL连接ID PROCESSLIST_USER: root PROCESSLIST_HOST: localhost PROCESSLIST_DB: mymgr PROCESSLIST_COMMAND: Query PROCESSLIST_TIME: 246 PROCESSLIST_STATE: User sleep PROCESSLIST_INFO: select *,sleep(1000) from t1 for update # 正在运行的SQL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: Socket THREAD_OS_ID: 58412 # 对应操作系统的线程ID RESOURCE_GROUP: USR_default
4、查看对应的系统线程
ps -Lef | grep 58412 mysql 38801 1 58412 0 40 14:46 ? 00:00:00 /usr/local/GreatSQL-8.0.22/bin/mysqld --defaults-file=/mysql/data06/my.cnf
发表评论
暂时没有评论,来抢沙发吧~