Network Management

 View Only
last person joined: 8 hours ago 

Keep an informative eye on your network with HPE Aruba Networking network management solutions
Expand all | Collapse all

IMC installation error about mysql max_connections

This thread has been viewed 0 times
  • 1.  IMC installation error about mysql max_connections

    Posted Jan 05, 2015 03:40 AM

    I have a problem about IMC installation and confuse me  a long time.I have checked mysql configuration file that locate /etc/my.cnf and confirm that it is  right.But when I perform install.sh script , it told me that Max_connections is Error.The my.cnf paste follow:

       

    [root@iMC ~]# cat /etc/my.cnf

    # For advice on how to change settings please see

    # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

     

    [mysqld]

    #

    # Remove leading # and set to the amount of RAM for the most important data

    # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

    # innodb_buffer_pool_size = 128M

    max_connections=200

    lower_case_table_names=1

    innodb_buffer_pool_size=512M

    innodb_additional_mem_pool_size=16M

    max_allowed_packet=200M

    # Remove leading # to turn on a very important data integrity option: logging

    # changes to the binary log between backups.

    # log_bin

    #

    # Remove leading # to set options mainly useful for reporting servers.

    # The server defaults are faster for transactions and fast SELECTs.

    # Adjust sizes as needed, experiment to find the optimal values.

    # join_buffer_size = 128M

    # sort_buffer_size = 2M

    # read_rnd_buffer_size = 2M

    datadir=/var/lib/mysql

    socket=/var/lib/mysql/mysql.sock

     

    # Disabling symbolic-links is recommended to prevent assorted security risks

    symbolic-links=0

     

    # Recommended in standard MySQL setup

    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

     

    [mysqld_safe]

    log-error=/var/log/mysqld.log

    pid-file=/var/run/mysqld/mysqld.pid

    open-files-limit=8192

     

     

     

    Do you come accross this problem ever?How to solve this problem?thanks!


    #imcmysql
    #max_connections


  • 2.  RE: IMC installation error about mysql max_connections

    Posted Jan 06, 2015 02:44 AM

    I have solved this problem.Just need to perform this command "set global max_connections=500;" in mysql.