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:
I'm using phpMyAdmin and I executed
2. In your my.conf file (usually located in /etc) find the line that says:
And somewhere below that set
Or whatever numeric value you need. More information here: https://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html |
Revisions
- January 28, 2017 @ 23:22:19 [Current Revision] by admin
- January 28, 2017 @ 23:22:19 by admin
- January 28, 2017 @ 23:22:01 by admin
Revision Differences
January 28, 2017 @ 23:22:01 | Current 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 | Added: If you see the error "... To many connections..." while you are accessing your website, you can do the following ways: | ||
Unchanged: </p> | Unchanged: </p> | ||
Unchanged: <p> | Unchanged: <p> | ||
Unchanged: 1. In your mysql my must to run this: | Unchanged: 1. 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'm using phpMyAdmin and I executed | Unchanged: I'm using phpMyAdmin and I executed | ||
Unchanged: </p> | Unchanged: </p> | ||
Unchanged: <p> | Unchanged: <p> | ||
Unchanged: | Unchanged: | ||
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 set | Unchanged: 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: <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: <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.