Re: Increasing number of sockets
Robert Canary [EMAIL PROTECTED] wrote: I am getting an error on my radius server asking me to increase the number of sockets on mysql. Probably you mean connections. Enlarge the value of max_connections variable. You can write it in the /etc/my.cnf in [mysqld] section: [mysqld] max_connections=300 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Increasing number of sockets
Gee, how about just a little more coffee... ;-)
I meant, {long version}...
It could be the radius error is reflecting its
failure to connect to the database because the
database has no connections available. I found
the max_connection variable (default is 90) and
applied it to the safe_mysqld section in the my.cn
it seemed to have did the trick, I am not getting
the error anymore.
Paul DuBois wrote:
At 6:47 -0500 7/7/04, Robert Canary wrote:
Unless it the error is referring to the number of simultaneous
connections. Which defualts to 90 (max_connection under safe_mysql).
I'm sorry, I'm unable to parse those sentences...
TCP/IP of course
Paul DuBois wrote:
At 22:09 -0500 7/6/04, Robert Canary wrote:
I am getting an error on my radius server asking me to increase the
number of sockets on mysql.
What kind of socket? TCP/IP socket? Unix domain socket file?
Either way, that sounds like an odd message. The server listens to
a single TCP/IP port and a single Unix socket file. There's no need
for more.
I'm looking the man pages for safe_mysqld and mysql but I don't see
anything that offers to provision this.
How does increase the number of sockets on the mysql?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Increasing number of sockets
At 13:41 -0500 7/7/04, Robert Canary wrote:
Gee, how about just a little more coffee... ;-)
I meant, {long version}...
It could be the radius error is reflecting its failure to connect to
the database because the database has no connections available. I
found the max_connection variable (default is 90) and applied it to
the safe_mysqld section in the my.cn it seemed to have did the
trick, I am not getting the error anymore.
Okay. Then the error really was about increasing the number of available
connections (not sockets), and setting max_connections is the right thing
to do.
Paul DuBois wrote:
At 6:47 -0500 7/7/04, Robert Canary wrote:
Unless it the error is referring to the number of simultaneous
connections. Which defualts to 90 (max_connection under
safe_mysql).
I'm sorry, I'm unable to parse those sentences...
TCP/IP of course
Paul DuBois wrote:
At 22:09 -0500 7/6/04, Robert Canary wrote:
I am getting an error on my radius server asking me to increase
the number of sockets on mysql.
What kind of socket? TCP/IP socket? Unix domain socket file?
Either way, that sounds like an odd message. The server listens to
a single TCP/IP port and a single Unix socket file. There's no need
for more.
I'm looking the man pages for safe_mysqld and mysql but I don't
see anything that offers to provision this.
How does increase the number of sockets on the mysql?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Increasing number of sockets
I am getting an error on my radius server asking me to increase the number of sockets on mysql. I'm looking the man pages for safe_mysqld and mysql but I don't see anything that offers to provision this. How does increase the number of sockets on the mysql? thanks in advance -- robert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Increasing number of sockets
At 22:09 -0500 7/6/04, Robert Canary wrote: I am getting an error on my radius server asking me to increase the number of sockets on mysql. What kind of socket? TCP/IP socket? Unix domain socket file? Either way, that sounds like an odd message. The server listens to a single TCP/IP port and a single Unix socket file. There's no need for more. I'm looking the man pages for safe_mysqld and mysql but I don't see anything that offers to provision this. How does increase the number of sockets on the mysql? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
