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

Even I set max_connection in /etc/my.cnf on CentOS 7, it not work

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Not a Bug
    • 10.1.12
    • N/A
    • OTHER
    • None
    • CentOS 7 VM

      Mariadb 10.1.12

    Description

      Hi

      I changed max_connection in /etc/my.cnf on CentOS 7 but it not work
      Could you guide me why?

      Thanks!

      My OS is Centos 7

      [root@localhost ~]# uname -a
      Linux localhost.localdomain 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
       
      [root@localhost ~]# lsb_release -a
      LSB Version:    :core-4.1-amd64:core-4.1-noarch
      Distributor ID: CentOS
      Description:    CentOS Linux release 7.2.1511 (Core)
      Release:        7.2.1511
      Codename:       Core
       
      Mariadb version is 10.1.12
      [root@localhost ~]# rpm -qa | grep mariadb
      mariadb-10.1.12-4.el7.x86_64
      mariadb-server-10.1.12-4.el7.x86_64
      mariadb-errmsg-10.1.12-4.el7.x86_64
      mariadb-config-10.1.12-4.el7.x86_64
      mariadb-common-10.1.12-4.el7.x86_64
      mariadb-libs-10.1.12-4.el7.x86_64
      

      [root@localhost ~]# cat /etc/my.cnf
      [mysqld]
      datadir=/var/lib/mysql
      socket=/var/lib/mysql/mysql.sock
      # Disabling symbolic-links is recommended to prevent assorted security risks
      symbolic-links=0
      # Settings user and group are ignored when systemd is used.
      # If you need to run mysqld under a different user or group,
      # customize your systemd unit file for mariadb according to the
      # instructions in http://fedoraproject.org/wiki/Systemd
       
      # Added for Openstack
      bind-address = 172.16.7.195
      default-storage-engine = innodb
      innodb_file_per_table
      collation-server = utf8_general_ci
      character-set-server = utf8
       
      max_connections = 500
       
      [mysqld_safe]
      log-error=/var/log/mariadb/mariadb.log
      pid-file=/var/run/mariadb/mariadb.pid
       
      #
      # include all files from the config directory
      #
      !includedir /etc/my.cnf.d
      

      MariaDB [(none)]> show variables like 'max_connections';
      +-----------------+-------+
      | Variable_name   | Value |
      +-----------------+-------+
      | max_connections | 214   |
      +-----------------+-------+
      1 row in set (0.00 sec)
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            xugang_ustc@sina.com xugang
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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