MySQL localhost:33060+ ssl SQL > SELECT * FROM performance_schema.threads\G *************************** 1. row *************************** THREAD_ID: 1 NAME: thread/sql/main TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: mysql PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 446 PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1957 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 2. row *************************** THREAD_ID: 3 NAME: thread/innodb/io_ibuf_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1960 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 3. row *************************** THREAD_ID: 4 NAME: thread/innodb/io_read_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1961 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 4. row *************************** THREAD_ID: 5 NAME: thread/innodb/io_read_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1962 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 5. row *************************** THREAD_ID: 6 NAME: thread/innodb/io_read_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1963 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 6. row *************************** THREAD_ID: 7 NAME: thread/innodb/io_read_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1964 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 7. row *************************** THREAD_ID: 8 NAME: thread/innodb/io_write_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1965 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 8. row *************************** THREAD_ID: 9 NAME: thread/innodb/io_write_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1966 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 9. row *************************** THREAD_ID: 10 NAME: thread/innodb/io_write_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1967 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 10. row *************************** THREAD_ID: 11 NAME: thread/innodb/io_write_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1968 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 11. row *************************** THREAD_ID: 12 NAME: thread/innodb/page_flush_coordinator_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 456 PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1969 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 12. row *************************** THREAD_ID: 20 NAME: thread/innodb/log_checkpointer_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1979 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 13. row *************************** THREAD_ID: 21 NAME: thread/innodb/log_flush_notifier_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1980 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 14. row *************************** THREAD_ID: 22 NAME: thread/innodb/log_flusher_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1981 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 15. row *************************** THREAD_ID: 23 NAME: thread/innodb/log_write_notifier_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1982 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 16. row *************************** THREAD_ID: 24 NAME: thread/innodb/log_writer_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1983 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 17. row *************************** THREAD_ID: 25 NAME: thread/innodb/log_files_governor_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1984 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 18. row *************************** THREAD_ID: 30 NAME: thread/innodb/srv_lock_timeout_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1989 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 19. row *************************** THREAD_ID: 31 NAME: thread/innodb/srv_error_monitor_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1990 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 20. row *************************** THREAD_ID: 32 NAME: thread/innodb/srv_monitor_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1991 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 21. row *************************** THREAD_ID: 33 NAME: thread/innodb/buf_resize_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1993 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 22. row *************************** THREAD_ID: 34 NAME: thread/innodb/srv_master_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 450 PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1994 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 23. row *************************** THREAD_ID: 35 NAME: thread/innodb/dict_stats_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 450 PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1995 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 24. row *************************** THREAD_ID: 36 NAME: thread/innodb/fts_optimize_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 450 PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1996 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 25. row *************************** THREAD_ID: 39 NAME: thread/mysqlx/acceptor_network TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 1 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 1999 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 26. row *************************** THREAD_ID: 40 NAME: thread/group_rpl/THD_mysql_thread_handler TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 450 PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 1 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2000 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 27. row *************************** THREAD_ID: 41 NAME: thread/group_rpl/THD_mysql_thread_handler_read_only_mode TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 450 PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 1 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2001 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 28. row *************************** THREAD_ID: 45 NAME: thread/innodb/buf_dump_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2005 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 29. row *************************** THREAD_ID: 46 NAME: thread/innodb/clone_gtid_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 449 PROCESSLIST_STATE: waiting for handler commit PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2006 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 30. row *************************** THREAD_ID: 47 NAME: thread/innodb/srv_purge_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 449 PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2007 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 31. row *************************** THREAD_ID: 48 NAME: thread/innodb/srv_worker_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 449 PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2008 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 32. row *************************** THREAD_ID: 49 NAME: thread/innodb/srv_worker_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 449 PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2009 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 33. row *************************** THREAD_ID: 50 NAME: thread/innodb/srv_worker_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 449 PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2010 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 34. row *************************** THREAD_ID: 51 NAME: thread/sql/event_scheduler TYPE: FOREGROUND PROCESSLIST_ID: 7 PROCESSLIST_USER: event_scheduler PROCESSLIST_HOST: localhost PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Daemon PROCESSLIST_TIME: 446 PROCESSLIST_STATE: Waiting on empty queue PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 1 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2011 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 35. row *************************** THREAD_ID: 52 NAME: thread/sql/signal_handler TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 1 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2012 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 36. row *************************** THREAD_ID: 53 NAME: thread/mysqlx/acceptor_network TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 1 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2014 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 37. row *************************** THREAD_ID: 55 NAME: thread/sql/compress_gtid_table TYPE: FOREGROUND PROCESSLIST_ID: 9 PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Daemon PROCESSLIST_TIME: 446 PROCESSLIST_STATE: Suspending PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 1 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2015 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 38. row *************************** THREAD_ID: 59 NAME: thread/group_rpl/THD_Gcs_ext_logger_impl::m_consumer TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: serverconfig PROCESSLIST_HOST: db1-2.db1-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 57 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2018 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 39. row *************************** THREAD_ID: 61 NAME: thread/group_rpl/THD_applier_module_receiver TYPE: FOREGROUND PROCESSLIST_ID: 14 PROCESSLIST_USER: serverconfig PROCESSLIST_HOST: db1-2.db1-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Connect PROCESSLIST_TIME: 441 PROCESSLIST_STATE: Group Replication Module: Executing PROCESSLIST_INFO: Group replication applier module PARENT_THREAD_ID: 57 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2020 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 40. row *************************** THREAD_ID: 62 NAME: thread/group_rpl/THD_certifier_broadcast TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: serverconfig PROCESSLIST_HOST: db1-2.db1-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 440 PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 61 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2021 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 41. row *************************** THREAD_ID: 63 NAME: thread/sql/replica_sql TYPE: FOREGROUND PROCESSLIST_ID: 16 PROCESSLIST_USER: serverconfig PROCESSLIST_HOST: db1-2.db1-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Query PROCESSLIST_TIME: 358 PROCESSLIST_STATE: Replica has read all relay log; waiting for more updates PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 61 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2022 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 42. row *************************** THREAD_ID: 64 NAME: thread/sql/replica_worker TYPE: FOREGROUND PROCESSLIST_ID: 17 PROCESSLIST_USER: serverconfig PROCESSLIST_HOST: db1-2.db1-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Connect PROCESSLIST_TIME: 441 PROCESSLIST_STATE: Waiting for Binlog Group Commit ticket PROCESSLIST_INFO: COMMIT PARENT_THREAD_ID: 63 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2023 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 43. row *************************** THREAD_ID: 65 NAME: thread/sql/replica_worker TYPE: FOREGROUND PROCESSLIST_ID: 18 PROCESSLIST_USER: serverconfig PROCESSLIST_HOST: db1-2.db1-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Connect PROCESSLIST_TIME: 440 PROCESSLIST_STATE: Waiting for an event from Coordinator PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 63 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2024 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 44. row *************************** THREAD_ID: 66 NAME: thread/sql/replica_worker TYPE: FOREGROUND PROCESSLIST_ID: 19 PROCESSLIST_USER: serverconfig PROCESSLIST_HOST: db1-2.db1-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Connect PROCESSLIST_TIME: 440 PROCESSLIST_STATE: Waiting for an event from Coordinator PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 63 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2025 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 45. row *************************** THREAD_ID: 67 NAME: thread/sql/replica_worker TYPE: FOREGROUND PROCESSLIST_ID: 20 PROCESSLIST_USER: serverconfig PROCESSLIST_HOST: db1-2.db1-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Connect PROCESSLIST_TIME: 440 PROCESSLIST_STATE: Waiting for an event from Coordinator PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 63 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2026 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 46. row *************************** THREAD_ID: 68 NAME: thread/group_rpl/THD_message_service_handler TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: serverconfig PROCESSLIST_HOST: db1-2.db1-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 440 PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 57 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2027 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 47. row *************************** THREAD_ID: 69 NAME: thread/group_rpl/THD_mysql_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: serverconfig PROCESSLIST_HOST: db1-2.db1-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 439 PROCESSLIST_STATE: waiting for handler commit PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 57 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2028 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 48. row *************************** THREAD_ID: 70 NAME: thread/group_rpl/THD_Gcs_xcom_control::m_xcom_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: serverconfig PROCESSLIST_HOST: db1-2.db1-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 60 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2029 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 49. row *************************** THREAD_ID: 72 NAME: thread/group_rpl/THD_Gcs_xcom_control::m_suspicions_processing_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: serverconfig PROCESSLIST_HOST: db1-2.db1-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 60 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2031 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 50. row *************************** THREAD_ID: 309 NAME: thread/mysqlx/worker TYPE: FOREGROUND PROCESSLIST_ID: 600 PROCESSLIST_USER: clusteradmin PROCESSLIST_HOST: db2-2.db2-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Sleep PROCESSLIST_TIME: 29 PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: SSL/TLS THREAD_OS_ID: 1998 RESOURCE_GROUP: USR_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 51. row *************************** THREAD_ID: 316 NAME: thread/mysqlx/worker TYPE: FOREGROUND PROCESSLIST_ID: 612 PROCESSLIST_USER: serverconfig PROCESSLIST_HOST: localhost PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Query PROCESSLIST_TIME: 0 PROCESSLIST_STATE: executing PROCESSLIST_INFO: SELECT * FROM performance_schema.threads PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: SSL/TLS THREAD_OS_ID: 2075 RESOURCE_GROUP: USR_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 52. row *************************** THREAD_ID: 338 NAME: thread/sql/one_connection TYPE: FOREGROUND PROCESSLIST_ID: 601 PROCESSLIST_USER: clusteradmin PROCESSLIST_HOST: db2-2.db2-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Query PROCESSLIST_TIME: 27 PROCESSLIST_STATE: starting PROCESSLIST_INFO: CHANGE REPLICATION SOURCE TO SOURCE_HOST = 'db2-2.db2-endpoints.o7.svc.cluster.local', SOURCE_USER = 'mysqlsh.test', SOURCE_PASSWORD = , SOURCE_PORT = 3306, SOURCE_RETRY_COUNT = 0, SOURCE_DELAY = 0, SOURCE_SSL = 1 FOR CHANNEL 'mysqlsh.test' PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: SSL/TLS THREAD_OS_ID: 2016 RESOURCE_GROUP: USR_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 53. row *************************** THREAD_ID: 348 NAME: thread/mysqlx/worker TYPE: FOREGROUND PROCESSLIST_ID: 619 PROCESSLIST_USER: clusteradmin PROCESSLIST_HOST: db2-1.db2-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Sleep PROCESSLIST_TIME: 11 PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: SSL/TLS THREAD_OS_ID: 2076 RESOURCE_GROUP: USR_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 54. row *************************** THREAD_ID: 350 NAME: thread/mysqlx/worker TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2222 RESOURCE_GROUP: USR_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 55. row *************************** THREAD_ID: 351 NAME: thread/sql/one_connection TYPE: FOREGROUND PROCESSLIST_ID: 620 PROCESSLIST_USER: clusteradmin PROCESSLIST_HOST: db2-1.db2-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Sleep PROCESSLIST_TIME: 10 PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: SSL/TLS THREAD_OS_ID: 2030 RESOURCE_GROUP: USR_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 56. row *************************** THREAD_ID: 353 NAME: thread/mysqlx/worker TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2057 RESOURCE_GROUP: USR_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 57. row *************************** THREAD_ID: 356 NAME: thread/sql/one_connection TYPE: FOREGROUND PROCESSLIST_ID: 625 PROCESSLIST_USER: clusteradmin PROCESSLIST_HOST: db2-1.db2-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Query PROCESSLIST_TIME: 10 PROCESSLIST_STATE: executing PROCESSLIST_INFO: SELECT c.channel_name, c.host, c.port, c.user, s.source_uuid, s.group_name, s.last_heartbeat_timestamp, s.service_state io_state, st.processlist_state io_thread_state, s.last_error_number io_errno, s.last_error_message io_errmsg, s.last_error_timestamp io_errtime, co.service_state co_state, cot.processlist_state co_thread_state, co.last_error_number co_errno, co.last_error_message co_errmsg, co.last_error_timestamp co_errtime, w.service_state w_state, wt.processlist_state w_thread_state, w.last_error_number w_errno, w.last_error_message w_errmsg, w.last_error_timestamp w_errtime, /*!80011 TIMEDIFF(NOW(6), IF(TIMEDIFF(s.LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP, s.LAST_HEARTBEAT_TIMESTAMP) >= 0, s.LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP, s.LAST_HEARTBEAT_TIMESTAMP )) as time_since_last_message, IF(s.LAST_QUEUED_TRANSACTION='' OR s.LAST_QUEUED_TRANSACTION=latest_w.LAST_APPLIED_TRANSACTION, 'IDLE', 'AP PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: SSL/TLS THREAD_OS_ID: 2084 RESOURCE_GROUP: USR_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 58. row *************************** THREAD_ID: 164 NAME: thread/sql/replica_io TYPE: FOREGROUND PROCESSLIST_ID: 167 PROCESSLIST_USER: clusteradmin PROCESSLIST_HOST: db2-2.db2-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Connect PROCESSLIST_TIME: 367 PROCESSLIST_STATE: Waiting for source to send event PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 163 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2098 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 59. row *************************** THREAD_ID: 165 NAME: thread/sql/replica_monitor TYPE: FOREGROUND PROCESSLIST_ID: 168 PROCESSLIST_USER: clusteradmin PROCESSLIST_HOST: db2-2.db2-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Connect PROCESSLIST_TIME: 27 PROCESSLIST_STATE: Wait before trying to fetch next membership changes from source PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 163 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2099 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 60. row *************************** THREAD_ID: 166 NAME: thread/sql/replica_sql TYPE: FOREGROUND PROCESSLIST_ID: 169 PROCESSLIST_USER: clusteradmin PROCESSLIST_HOST: db2-2.db2-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Query PROCESSLIST_TIME: 358 PROCESSLIST_STATE: Waiting for replica workers to process their queues PROCESSLIST_INFO: NULL PARENT_THREAD_ID: 163 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2100 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 61. row *************************** THREAD_ID: 167 NAME: thread/sql/replica_worker TYPE: FOREGROUND PROCESSLIST_ID: 170 PROCESSLIST_USER: clusteradmin PROCESSLIST_HOST: db2-2.db2-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Query PROCESSLIST_TIME: 358 PROCESSLIST_STATE: Waiting for preceding transaction to commit PROCESSLIST_INFO: BEGIN PARENT_THREAD_ID: 166 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2101 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 62. row *************************** THREAD_ID: 168 NAME: thread/sql/replica_worker TYPE: FOREGROUND PROCESSLIST_ID: 171 PROCESSLIST_USER: clusteradmin PROCESSLIST_HOST: db2-2.db2-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Query PROCESSLIST_TIME: 359 PROCESSLIST_STATE: Waiting for Binlog Group Commit ticket PROCESSLIST_INFO: BEGIN PARENT_THREAD_ID: 166 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2102 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 63. row *************************** THREAD_ID: 169 NAME: thread/sql/replica_worker TYPE: FOREGROUND PROCESSLIST_ID: 172 PROCESSLIST_USER: clusteradmin PROCESSLIST_HOST: db2-2.db2-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Query PROCESSLIST_TIME: 358 PROCESSLIST_STATE: Waiting for preceding transaction to commit PROCESSLIST_INFO: BEGIN PARENT_THREAD_ID: 166 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2103 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 64. row *************************** THREAD_ID: 170 NAME: thread/sql/replica_worker TYPE: FOREGROUND PROCESSLIST_ID: 173 PROCESSLIST_USER: clusteradmin PROCESSLIST_HOST: db2-2.db2-endpoints.o7.svc.cluster.local PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: Query PROCESSLIST_TIME: 358 PROCESSLIST_STATE: Waiting for preceding transaction to commit PROCESSLIST_INFO: BEGIN PARENT_THREAD_ID: 166 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2104 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 65. row *************************** THREAD_ID: 176 NAME: thread/innodb/page_archiver_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2105 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO *************************** 66. row *************************** THREAD_ID: 177 NAME: thread/innodb/log_archiver_thread TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: NULL PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: NULL PROCESSLIST_STATE: NULL PROCESSLIST_INFO: NULL PARENT_THREAD_ID: NULL ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: NULL THREAD_OS_ID: 2106 RESOURCE_GROUP: SYS_default EXECUTION_ENGINE: PRIMARY CONTROLLED_MEMORY: 0 MAX_CONTROLLED_MEMORY: 0 TOTAL_MEMORY: 0 MAX_TOTAL_MEMORY: 0 TELEMETRY_ACTIVE: NO 66 rows in set (0.0009 sec) MySQL localhost:33060+ ssl SQL > SELECT * FROM performance_schema.threads\G