Edit File: threads_innodb.test
# Tests for special content of performance_schema.threads # # Show InnoDB related content in performance_schema.threads --source include/not_embedded.inc --source include/have_innodb.inc --source include/have_perfschema.inc # There are several InnoDB io_handler_threads servicing for read IO, write IO etc. # The number of these threads is at least for some types configurable. # We suppress here duplicates rows with the goal to avoid that the test fails # in case some defaults are changed. SELECT name, type, processlist_user, processlist_host, processlist_db, processlist_command, processlist_time, processlist_state, processlist_info, parent_thread_id, role, instrumented FROM performance_schema.threads WHERE name LIKE 'thread/innodb/%' GROUP BY name;