<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: IMC installation error about mysql max_connections in IMC</title>
    <link>https://community.hpe.com/t5/imc/imc-installation-error-about-mysql-max-connections/m-p/6690906#M1770</link>
    <description>&lt;P&gt;I have solved this problem.Just need to perform this command "set global max_connections=500;" in mysql.&lt;/P&gt;</description>
    <pubDate>Tue, 06 Jan 2015 07:44:21 GMT</pubDate>
    <dc:creator>chaguan</dc:creator>
    <dc:date>2015-01-06T07:44:21Z</dc:date>
    <item>
      <title>IMC installation error about mysql max_connections</title>
      <link>https://community.hpe.com/t5/imc/imc-installation-error-about-mysql-max-connections/m-p/6690385#M1768</link>
      <description>&lt;P&gt;I have a problem about IMC installation and confuse me &amp;nbsp;a long time.I have checked mysql configuration file that locate /etc/my.cnf and confirm that it is &amp;nbsp;right.But when I perform install.sh script , it told me that Max_connections is Error.The my.cnf paste follow:&lt;/P&gt;&lt;P&gt;&amp;nbsp; &amp;nbsp;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;[root@iMC ~]# cat /etc/my.cnf&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;# For advice on how to change settings please see&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;# &lt;A href="http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html" target="_blank"&gt;http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html&lt;/A&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p2"&gt;&amp;nbsp;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;[mysqld]&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;#&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;# Remove leading # and set to the amount of RAM for the most important data&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;# innodb_buffer_pool_size = 128M&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;max_connections=200&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;lower_case_table_names=1&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;innodb_buffer_pool_size=512M&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;innodb_additional_mem_pool_size=16M&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;max_allowed_packet=200M&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;# Remove leading # to turn on a very important data integrity option: logging&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;# changes to the binary log between backups.&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;# log_bin&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;#&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;# Remove leading # to set options mainly useful for reporting servers.&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;# The server defaults are faster for transactions and fast SELECTs.&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;# Adjust sizes as needed, experiment to find the optimal values.&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;# join_buffer_size = 128M&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;# sort_buffer_size = 2M&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;# read_rnd_buffer_size = 2M&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;datadir=/var/lib/mysql&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;socket=/var/lib/mysql/mysql.sock&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p2"&gt;&amp;nbsp;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;# Disabling symbolic-links is recommended to prevent assorted security risks&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;symbolic-links=0&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p2"&gt;&amp;nbsp;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;# Recommended in standard MySQL setup&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES &lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p2"&gt;&amp;nbsp;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;[mysqld_safe]&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;log-error=/var/log/mysqld.log&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;pid-file=/var/run/mysqld/mysqld.pid&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;open-files-limit=8192&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="p1"&gt;&amp;nbsp;&lt;/P&gt;&lt;P class="p1"&gt;&amp;nbsp;&lt;/P&gt;&lt;P class="p1"&gt;&amp;nbsp;&lt;/P&gt;&lt;P class="p1"&gt;&lt;SPAN class="s1"&gt;Do you come accross this problem ever?How to solve this problem?thanks!&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 05 Jan 2015 08:40:04 GMT</pubDate>
      <guid>https://community.hpe.com/t5/imc/imc-installation-error-about-mysql-max-connections/m-p/6690385#M1768</guid>
      <dc:creator>chaguan</dc:creator>
      <dc:date>2015-01-05T08:40:04Z</dc:date>
    </item>
    <item>
      <title>Re: IMC installation error about mysql max_connections</title>
      <link>https://community.hpe.com/t5/imc/imc-installation-error-about-mysql-max-connections/m-p/6690906#M1770</link>
      <description>&lt;P&gt;I have solved this problem.Just need to perform this command "set global max_connections=500;" in mysql.&lt;/P&gt;</description>
      <pubDate>Tue, 06 Jan 2015 07:44:21 GMT</pubDate>
      <guid>https://community.hpe.com/t5/imc/imc-installation-error-about-mysql-max-connections/m-p/6690906#M1770</guid>
      <dc:creator>chaguan</dc:creator>
      <dc:date>2015-01-06T07:44:21Z</dc:date>
    </item>
  </channel>
</rss>

