Bug #106232 The minimum value of global_connection_memory_limit is different from the refere
Submitted: 21 Jan 6:32 Modified: 12 Feb 9:42
Reporter: MAKOTO FUKUMOTO Email Updates:
Status: Closed Impact on me:
None 
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 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 7:26] MySQL Verification Team
Hello MAKOTO-San,

Thank you for the report and feedback.

regards,
Umesh
[12 Feb 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 10:24] Jon Stephens
The fix also corrects the minimum value for connection_memory_limit.