[MDEV-18252] Can't decrease max_connections below 10 - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Minor
Resolution: Fixed
Affects Version/s: 10.1.33, 10.2.15, 10.3.6, 10.3.10, 10.2.21, 10.3.12
Fix Version/s: N/A
Component/s: Documentation, Server, Variables
Labels:
None

Description

Setting max_connections to 1 is possible on MySQL 5.7 and 8.0, but doesn't work with recent versions of MariaDB. The documentation seems to indicate it should work as it gives the range from 1 to 100000.

MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'max_connections';

+-----------------+-------+

| Variable_name   | Value |

+-----------------+-------+

| max_connections | 100   |

+-----------------+-------+

1 row in set (0.00 sec)

MariaDB [(none)]> SET GLOBAL max_connections=1;

Query OK, 0 rows affected, 1 warning (0.00 sec)

MariaDB [(none)]> show warnings;

+---------+------+------------------------------------------------+

| Level   | Code | Message                                        |

+---------+------+------------------------------------------------+

| Warning | 1292 | Truncated incorrect max_connections value: '1' |

+---------+------+------------------------------------------------+

1 row in set (0.00 sec)

MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'max_connections';

+-----------------+-------+

| Variable_name   | Value |

+-----------------+-------+

| max_connections | 10    |

+-----------------+-------+

1 row in set (0.00 sec)

(I've tagged the specific versions I've tested, but it's obviously likely to affect other 10.2 and 10.3 versions as well.)

Attachments

Activity

People

Assignee:: Michael Widenius

Reporter:: Karl Levik

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2019-01-15 16:33

Updated:: 2023-09-04 09:17

Resolved:: 2019-06-10 08:43

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server