Bug #106232 The minimum value of global_connection_memory_limit is different from the refere

• Submitted: 21 Jan 2022 6:32
• Modified: 12 Feb 2022 9:42
• Reporter: MAKOTO FUKUMOTO
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 8.0.28
• OS: Red Hat (RHEL7.9)
• Assigned to: Jon Stephens
• CPU Architecture: Any

[21 Jan 2022 6:32] MAKOTO FUKUMOTO

Description:
The following document states that the minimum value of global_connection_memory_limit is 2097152 bytes, but this value cannot be set.

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_global_connect...

mysql> show global variables like 'global_connection_memory_limit';
+--------------------------------+----------------------+
| Variable_name                  | Value                |
+--------------------------------+----------------------+
| global_connection_memory_limit | 18446744073709551615 |
+--------------------------------+----------------------+
1 row in set (0.00 sec)

mysql> set global global_connection_memory_limit = 2097152;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> show warnings;
+---------+------+---------------------------------------------------------------------+
| Level   | Code | Message                                                             |
+---------+------+---------------------------------------------------------------------+
| Warning | 1292 | Truncated incorrect global_connection_memory_limit value: '2097152' |
+---------+------+---------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> show global variables like 'global_connection_memory_limit';
+--------------------------------+----------+
| Variable_name                  | Value    |
+--------------------------------+----------+
| global_connection_memory_limit | 16777216 |
+--------------------------------+----------+
1 row in set (0.00 sec)

mysql>

How to repeat:
Please refer to the Description.

Suggested fix:
Please make sure that the minimum value is correctly stated in the documentation.

[21 Jan 2022 7:26] MySQL Verification Team

Hello MAKOTO-San,

Thank you for the report and feedback.

regards,
Umesh

[12 Feb 2022 9:35] Jon Stephens

Fixed in mysqldoc rev 71928.

The changes in the online documentation should appear shortly.

Thanks for bringing this to our attention.

[12 Feb 2022 10:24] Jon Stephens

The fix also corrects the minimum value for connection_memory_limit.