Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_ddl_threads_basic.test

raw
1 #
2 # Show the global and session values. Default is ON.
3 #
4 SELECT @@global.innodb_ddl_threads;
5 SELECT @@session.innodb_ddl_threads;
6
7 SHOW GLOBAL VARIABLES LIKE 'innodb_ddl_threads';
8 SHOW SESSION VARIABLES LIKE 'innodb_ddl_threads';
9
10 SELECT * FROM performance_schema.global_variables
11 WHERE variable_name='innodb_ddl_threads';
12
13 SELECT * FROM performance_schema.session_variables
14 WHERE variable_name='innodb_ddl_threads';
15
16 #
17 # Test that it's not read-only.
18 #
19 set global innodb_ddl_threads=8;
20 set session innodb_ddl_threads=8;
21
22 # Set back to default.
23 set global innodb_ddl_threads=4;
24 set session innodb_ddl_threads=4;
25