Difference between revisions of "3rd party software/SQL"
From Freeside
(→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? | |
| − | + | :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 <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.cnfforport =settings. (file location varies)
-
- As a mysql client
- Review the
[client]section of/etc/mysql/my.cnfforport =settings. (file location varies) - As a last resort,
strace -e connect mysql -h example.comOutput will be less noisy if you useexample.comas a literal. Eg,connect(3, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("208.77.188.166")}, 16 <unfinished ...>
- Review the
