Debian Codegraph @

mysql-test/suite/perfschema/t/threads_innodb.test

raw
1
2 # Tests for special content of performance_schema.threads
3 #
4 # Show InnoDB related content in performance_schema.threads
5
6 --source include/turn_off_only_full_group_by.inc
7
8 # There are several InnoDB io_handler_threads servicing for read IO, write IO etc.
9 # The number of these threads is at least for some types configurable.
10 # We suppress here duplicates rows with the goal to avoid that the test fails
11 # in case some defaults are changed.
12 # Also 'thread/innodb/trx_recovery_rollback_thread' is disabled explicitly
13 # because it's a short life thread which results in result mismatch sporadically
14 --sorted_result
15 SELECT name, type, processlist_user, processlist_host, processlist_db,
16 processlist_command, processlist_state, processlist_info,
17 parent_thread_id, `role`, instrumented
18 FROM performance_schema.threads
19 WHERE name LIKE 'thread/innodb/%'
20 AND name NOT LIKE 'thread/innodb/trx\_recovery\_rollback\_thread'
21 AND name NOT LIKE 'thread/innodb/clone_gtid_thread'
22 GROUP BY name;
23
24 --source include/restore_sql_mode_after_turn_off_only_full_group_by.inc