Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18252

Can't decrease max_connections below 10

    Details

    • Type: Bug
    • Status: Confirmed (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • 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:
              monty Michael Widenius
              Reporter:
              karll Karl Levik
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated: