Difference between revisions of "3rd party software/SQL"
From Freeside
(→Postgresql) |
(→MySQL) |
||
| Line 22: | Line 22: | ||
;Manuals | ;Manuals | ||
:http://dev.mysql.com/doc/#refman | :http://dev.mysql.com/doc/#refman | ||
| + | ;FAQ - Why do I get "Too many connections" when connecting to MySQL, and how can I solve it? | ||
| + | :The MySQL server limits how many connections are used when connecting. This prevents complications from out of control, or too many connections that might otherwise leave the server unresponsive. | ||
| + | :See more information about the max_connections setting at http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html | ||
| + | :Also, you can set this on a per user basis, so 'freeside' could have 30 connections, and the radius server could have 50 connections. This finer grained tuning is an exercise left to the user. (feel free to log your findings in the talk page if you see fit) | ||
= See Also = | = See Also = | ||
[http://en.wikipedia.org/wiki/Category:Database_management_systems List of DBMS on Wikipedia] | [http://en.wikipedia.org/wiki/Category:Database_management_systems List of DBMS on Wikipedia] | ||
Revision as of 07:32, 11 February 2008
PostgreSQL
- Website
- http://www.postgresql.org/
- About
- http://www.postgresql.org/about/
- FAQ
- http://www.postgresql.org/docs/faqs.FAQ.html
- Wikipedia
- http://en.wikipedia.org/wiki/Postgresql
- Manuals
- http://www.postgresql.org/docs/
MySQL
- Website
- http://www.mysql.com
- About
- http://www.mysql.org/company/
- FAQ
- http://www.mysql.com/industry/faq/
- Wikipedia
- http://en.wikipedia.org/wiki/MySQL
- Manuals
- http://dev.mysql.com/doc/#refman
- FAQ - Why do I get "Too many connections" when connecting to MySQL, and how can I solve it?
- The MySQL server limits how many connections are used when connecting. This prevents complications from out of control, or too many connections that might otherwise leave the server unresponsive.
- See more information about the max_connections setting at http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html
- Also, you can set this on a per user basis, so 'freeside' could have 30 connections, and the radius server could have 50 connections. This finer grained tuning is an exercise left to the user. (feel free to log your findings in the talk page if you see fit)
