Difference between revisions of "3rd party software/SQL"

From Freeside
Jump to: navigation, search
(MySQL)
(MySQL)
Line 26: Line 26:
 
:See more information about the max_connections setting at http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html
 
: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)
 
: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)
 +
;FAQ - How do I tell what port mysql uses?
 +
:You can check the server directly, or make a good guess from a client.  The default port is most always <code>3306</code>.  Use these steps to confirm, or to isolate for troubleshooting.
 +
:On the server
 +
:* <code># netstat -tlnp | grep mysqld</code>
 +
:* <code>$ grep mysql /etc/services</code>
 +
:* Review the <code>[mysqld]</code> section of <code>/etc/mysql/my.cnf</code> for <code>port = </code> settings. (file location varies)
 +
:As a mysql client
 +
:* Review the <code>[client]</code> section of <code>/etc/mysql/my.cnf</code> for <code>port = </code> settings. (file location varies)
 +
:* As a last resort, <code>strace -e connect mysql -h example.com</code> Output will be less noisy if you use <code>example.com</code> as a literal.  Eg, <code>connect(3, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("208.77.188.166")}, 16 <unfinished ...></code>
  
 
= 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 08:06, 12 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)
FAQ - How do I tell what port mysql uses?
You can check the server directly, or make a good guess from a client. The default port is most always 3306. Use these steps to confirm, or to isolate for troubleshooting.
On the server
  • # netstat -tlnp | grep mysqld
  • $ grep mysql /etc/services
  • Review the [mysqld] section of /etc/mysql/my.cnf for port = settings. (file location varies)
As a mysql client
  • Review the [client] section of /etc/mysql/my.cnf for port = settings. (file location varies)
  • As a last resort, strace -e connect mysql -h example.com Output will be less noisy if you use example.com as a literal. Eg, connect(3, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("208.77.188.166")}, 16 <unfinished ...>

See Also

List of DBMS on Wikipedia