According to the KB the P_S.THREADS.CONNECTION_TYPE column should show NULL for background threads, and the source code has these possible states:
static const LEX_CSTRING vio_type_names[] =
|
{
|
{ STRING_WITH_LEN("Error") }, // cannot happen
|
{ STRING_WITH_LEN("TCP/IP") },
|
{ STRING_WITH_LEN("Socket") },
|
{ STRING_WITH_LEN("Named Pipe") },
|
{ STRING_WITH_LEN("SSL/TLS") },
|
{ STRING_WITH_LEN("Shared Memory") }
|
};
|
Yet it actually indeed shows "Error" instead of "NULL":
MariaDB [performance_schema]> select name, connection_type from threads where type="BACKGROUND";
|
+-----------------------------------+-----------------+
|
| name | connection_type |
|
+-----------------------------------+-----------------+
|
| thread/sql/main | Error |
|
| thread/mysys/statement_timer | Error |
|
| thread/aria/checkpoint_background | Error |
|
| thread/innodb/page_cleaner_thread | Error |
|
| thread/innodb/thread_pool_thread | Error |
|
| thread/innodb/thread_pool_thread | Error |
|
| thread/innodb/thread_pool_thread | Error |
|
| thread/innodb/thread_pool_thread | Error |
|
| thread/innodb/thread_pool_thread | Error |
|
| thread/innodb/thread_pool_thread | Error |
|
| thread/sql/signal_handler | Error |
|
| thread/sql/manager | Error |
|
+-----------------------------------+-----------------+
|
Bug
Major
