SELECT
name,
thread_os_id,
thread_id,
processlist_id
FROM threads
ORDER BY processlist_id DESC ;
+--------------------------------+------------+---------+--------------+
|name |thread_os_id|thread_id|processlist_id|
+--------------------------------+------------+---------+--------------+
|thread/sql/one_connection |7248 |51 |25 |
|thread/sql/one_connection |14216 |50 |24 |
|thread/sql/compress_gtid_table |6116 |26 |1 |
|thread/sql/main |4800 |1 |NULL |
|thread/sql/thread_timer_notifier|5376 |2 |NULL |
|thread/innodb/io_ibuf_thread |5428 |3 |NULL |
|thread/innodb/io_read_thread |5436 |4 |NULL |
|thread/innodb/io_log_thread |5432 |5 |NULL |
|thread/innodb/io_read_thread |5448 |6 |NULL |
|thread/innodb/io_read_thread |5444 |7 |NULL |
+--------------------------------+------------+---------+--------------+