Details
-
New Feature
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
Description
Multi-threaded Linux programs (like Firefox or MySQL since 8.0.27 or so) usually set a name for each thread. This name will appear in the output of top and other utilities and would help to answer questions like "What thread uses most of CPU" etc.
Consider this example of MySQL 8.0.29:
openxs@ao756:~/dbs/8.0$ for task in $(ls /proc/$(pidof mysqld)/task/); do name=$(cat /proc/$(pidof mysqld)/task/${task}/comm); echo "TASK: ${task} (${name})"; done
|
TASK: 567049 (mysqld)
|
TASK: 567079 (ib_io_ibuf)
|
TASK: 567080 (ib_io_log)
|
TASK: 567081 (ib_io_rd-1)
|
TASK: 567082 (ib_io_rd-2)
|
TASK: 567083 (ib_io_rd-3)
|
TASK: 567084 (ib_io_rd-4)
|
TASK: 567085 (ib_io_wr-1)
|
TASK: 567086 (ib_io_wr-2)
|
TASK: 567087 (ib_io_wr-3)
|
TASK: 567088 (ib_io_wr-4)
|
TASK: 567089 (ib_pg_flush_co)
|
TASK: 567096 (ib_log_checkpt)
|
TASK: 567097 (ib_log_fl_notif)
|
TASK: 567098 (ib_log_flush)
|
TASK: 567099 (ib_log_wr_notif)
|
TASK: 567100 (ib_log_writer)
|
TASK: 567114 (ib_srv_lock_to)
|
TASK: 567115 (ib_srv_err_mon)
|
TASK: 567116 (ib_srv_mon)
|
TASK: 567117 (ib_buf_resize)
|
TASK: 567118 (ib_src_main)
|
TASK: 567119 (ib_dict_stats)
|
TASK: 567120 (ib_fts_opt)
|
TASK: 567122 (xpl_worker-1)
|
TASK: 567123 (xpl_worker-2)
|
TASK: 567124 (xpl_accept-1)
|
TASK: 567893 (ib_buf_dump)
|
TASK: 567894 (ib_clone_gtid)
|
TASK: 567895 (ib_srv_purge)
|
TASK: 567896 (ib_srv_wkr-1)
|
TASK: 567897 (ib_srv_wkr-2)
|
TASK: 567898 (ib_srv_wkr-3)
|
TASK: 567899 (evt_sched)
|
TASK: 567900 (sig_handler)
|
TASK: 567902 (xpl_accept-3)
|
TASK: 567903 (gtid_zip)
|
For MariaDB (10.6 here for example) we get:
openxs@ao756:~/dbs/maria10.6$ for task in $(ls /proc/$(pidof mariadbd)/task/); do name=$(cat /proc/$(pidof mariadbd)/task/${task}/comm); echo "TASK: ${task} (${name})"; done
|
TASK: 568093 (mariadbd)
|
TASK: 568095 (mariadbd)
|
TASK: 568096 (mariadbd)
|
TASK: 568097 (mariadbd)
|
TASK: 568098 (mariadbd)
|
TASK: 568099 (mariadbd)
|
TASK: 568104 (mariadbd)
|
TASK: 568105 (mariadbd)
|
openxs@ao756:~/dbs/maria10.6$
|
See also https://bugs.mysql.com/bug.php?id=70858
It makes sense to use the same thread name as used in Performance Schema.
