Bug #105767 Documentation: innodb_ddl_threads is also a global variable.
Submitted: 1 Dec 2021 20:18 Modified: 10 Dec 2021 14:24
Reporter: Jean-François Gagné Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[1 Dec 2021 20:18] Jean-François Gagné
Description:
Hi,

(This is a documentation bug.)

in the documentation page about innodb_ddl_threads [1], this variable scope is indicated as Session, but I think it should be	Global, Session.  See How to repeat.

[1]: https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_ddl_threads

Thanks for looking into this,

Jean-François Gagné

How to repeat:
mysql [localhost:8027] {msandbox} ((none)) > select version();
+-----------+
| version() |
+-----------+
| 8.0.27    |
+-----------+
1 row in set (0.00 sec)

mysql [localhost:8027] {msandbox} ((none)) > show global variables like 'innodb_ddl_threads';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| innodb_ddl_threads | 4     |
+--------------------+-------+
1 row in set (0.01 sec)

mysql [localhost:8027] {msandbox} ((none)) > set global innodb_ddl_threads=1;
Query OK, 0 rows affected (0.00 sec)

mysql [localhost:8027] {msandbox} ((none)) > show global variables like 'innodb_ddl_threads';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| innodb_ddl_threads | 1     |
+--------------------+-------+
1 row in set (0.00 sec)

mysql [localhost:8027] {msandbox} ((none)) > show variables like 'innodb_ddl_threads';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| innodb_ddl_threads | 4     |
+--------------------+-------+
1 row in set (0.00 sec)
[1 Dec 2021 20:18] Jean-François Gagné
Doc screenshot.

Attachment: Screen Shot 2021-12-01 at 3.18.07 PM.png (image/png, text), 67.79 KiB.

[1 Dec 2021 20:41] MySQL Verification Team
Thank you for the bug report.
[10 Dec 2021 14:24] Daniel Price
Posted by developer:
 
Thank you for the bug report. The documentation update should appear online soon.