Description:
mysql> select * from performance_schema.threads where name like '%gtid%'\G
*************************** 1. row ***************************
THREAD_ID: 24
NAME: thread/sql/compress_gtid_table
TYPE: FOREGROUND
PROCESSLIST_ID: 1
PROCESSLIST_USER: NULL
PROCESSLIST_HOST: NULL
PROCESSLIST_DB: NULL
PROCESSLIST_COMMAND: Daemon
PROCESSLIST_TIME: 41
PROCESSLIST_STATE: Suspending
PROCESSLIST_INFO: NULL
PARENT_THREAD_ID: 1
ROLE: NULL
INSTRUMENTED: YES
1 row in set (0.00 sec)
mysql> select * from information_schema.processlist;
+----+------+------+------+---------+------+-----------+----------------------------------------------+
| ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO |
+----+------+------+------+---------+------+-----------+----------------------------------------------+
| 2 | root | | test | Query | 0 | executing | select * from information_schema.processlist |
+----+------+------+------+---------+------+-----------+----------------------------------------------+
1 row in set (0.00 sec)
How to repeat:
https://dev.mysql.com/doc/refman/5.7/en/threads-table.html
"The thread type, either FOREGROUND or BACKGROUND. User connection threads are foreground threads. Threads associated with internal server activity are background threads."
Suggested fix:
In my understanding BACKGROUND would be better for the gtid compress thread.
Description: mysql> select * from performance_schema.threads where name like '%gtid%'\G *************************** 1. row *************************** THREAD_ID: 24 NAME: thread/sql/compress_gtid_table TYPE: FOREGROUND PROCESSLIST_ID: 1 PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Daemon PROCESSLIST_TIME: 41 PROCESSLIST_STATE: Suspending PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 1 ROLE: NULL INSTRUMENTED: YES 1 row in set (0.00 sec) mysql> select * from information_schema.processlist; +----+------+------+------+---------+------+-----------+----------------------------------------------+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | +----+------+------+------+---------+------+-----------+----------------------------------------------+ | 2 | root | | test | Query | 0 | executing | select * from information_schema.processlist | +----+------+------+------+---------+------+-----------+----------------------------------------------+ 1 row in set (0.00 sec) How to repeat: https://dev.mysql.com/doc/refman/5.7/en/threads-table.html "The thread type, either FOREGROUND or BACKGROUND. User connection threads are foreground threads. Threads associated with internal server activity are background threads." Suggested fix: In my understanding BACKGROUND would be better for the gtid compress thread.