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

From Freeside
Jump to: navigation, search
(Postgresql)
 
(3 intermediate revisions by one other user not shown)
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?
= See Also =
+
:Your max_connections setting is too low, See http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html
[http://en.wikipedia.org/wiki/Category:Database_management_systems List of DBMS on Wikipedia]
+
;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>

Latest revision as of 20:33, 6 April 2009


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?
Your max_connections setting is too low, See http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html
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 ...>