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.