You are viewing an old revision of this post, from January 28, 2017 @ 23:22:01. See below for differences between this version and the current revision.

Mysql – Too many connections

If you see the error "... To many connections..." while you are accessing your website, you can do the following ways:

1. In your mysql my must to run this:

Set Global max_connections=2000

I'm using phpMyAdmin and I executed

 

2. In your my.conf file (usually located in /etc) find the line that says:

[mysqld]

And somewhere below that set

max-connections=500

Or whatever numeric value you need.

More information here: https://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html

Revisions

Revision Differences

January 28, 2017 @ 23:22:01Current Revision
Content
Unchanged: <table>Unchanged: <table>
Unchanged: <tbody>Unchanged: <tbody>
Unchanged: <tr>Unchanged: <tr>
Unchanged: <td>Unchanged: <td>
Unchanged: <p>Unchanged: <p>
Deleted: If you face see the error &quot;... To many connections...&quot; while you are accessing your website, you can do the following ways: Added: If you&nbsp;see the error &quot;... To many connections...&quot; while you are accessing your website, you can do the following ways:
Unchanged: </p>Unchanged: </p>
Unchanged: <p>Unchanged: <p>
Unchanged: 1.&nbsp;In your mysql my must to run this:Unchanged: 1.&nbsp;In your mysql my must to run this:
Unchanged: </p>Unchanged: </p>
Unchanged: <pre>Unchanged: <pre>
Unchanged: <code>Set Global max_connections= 2000</code></pre>Unchanged: <code>Set Global max_connections= 2000</code></pre>
Unchanged: <p>Unchanged: <p>
Unchanged: I&#39;m using phpMyAdmin and I executedUnchanged: I&#39;m using phpMyAdmin and I executed
Unchanged: </p>Unchanged: </p>
Unchanged: <p>Unchanged: <p>
Unchanged: &nbsp;Unchanged: &nbsp;
Unchanged: </p>Unchanged: </p>
Unchanged: <p>Unchanged: <p>
Unchanged: 2. In your my.conf file (usually located in /etc) find the line that says:Unchanged: 2. In your my.conf file (usually located in /etc) find the line that says:
Unchanged: </p>Unchanged: </p>
Unchanged: <pre>Unchanged: <pre>
Unchanged: <code>[mysqld]< /code></pre>Unchanged: <code>[mysqld]< /code></pre>
Unchanged: <p>Unchanged: <p>
Unchanged: And somewhere below that setUnchanged: And somewhere below that set
Unchanged: </p>Unchanged: </p>
Unchanged: <pre>Unchanged: <pre>
Unchanged: <code>max-connections= 500</code></pre>Unchanged: <code>max-connections= 500</code></pre>
Unchanged: <p>Unchanged: <p>
Unchanged: Or whatever numeric value you need.Unchanged: Or whatever numeric value you need.
Unchanged: </p>Unchanged: </p>
Unchanged: <p>Unchanged: <p>
Unchanged: More information here:&nbsp;<a href="https:/ /dev.mysql.com/doc/refman/ 5.5/en/too-many- connections.html" >https://dev.mysql.com/doc/ refman/5.5/en/ too-many-connections.html</a>Unchanged: More information here:&nbsp;<a href="https:/ /dev.mysql.com/doc/refman/ 5.5/en/too-many- connections.html" >https://dev.mysql.com/doc/ refman/5.5/en/ too-many-connections.html</a>
Unchanged: </p>Unchanged: </p>
Unchanged: </td>Unchanged: </td>
Unchanged: </tr>Unchanged: </tr>
Unchanged: </tbody>Unchanged: </tbody>
Unchanged: </table>Unchanged: </table>

Note: Spaces may be added to comparison text to allow better line wrapping.

No comments yet.

Leave a Reply