RE: simultaneous connections
PREVIOS THREAD ON THIS TOPIC: Hope it helps Hi, Make sure that MySQL on your OS supports 5000 connections ! Check OS specific restrictions in MySQL documentation. Regards -- Joseph Bueno NetClub/Trader.com John Barton wrote: Try putting a line like the following in your my.cnf file: This has always worked for me, including 3.23.37 set-variable = max_connections= John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Thu, 10 May 2001, Mark Lo (3) wrote: Hi, I would like to set a higher values in max_connections for mysql. I have tried to use the following command mysqld --set-variables max_connections=900 -u root -ppassword. Then, it shows that I have successfully changed the variable of max_connections. But, when I check it with the command of mysqladmin variables -u root -ppassword. The max_connections return to 100 which is the default value. I wonder what is wrong with mysql3.23.37. Is this a bug, or I am using the wrong command. In additions, Can I set the max_connections values higher than 5000. Thank you Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -Original Message- From: Don Pro [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 2:37 PM To: msql list Subject: simultaneous connections Hi, I'm reading in my documentation (I have a book) that MySQL allows up to 101 simultaneous connections. Gadzooks! How can MySQL claim to be at the Enterprise level with this limit? Is there any way around this? Thanks, Don - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: simultaneous connections
Mysql allows 101 connections by default, 100 client connections plut it reserves one for administrator access. You can set your own maximum connection limit in the my.cnf file by using the directive: [mysqld] set-variable = max_connections= where xxx is the amount you want to set as the max. See the documentation for information and recommendations on what to set the max as for your particular OS. John Barton System Administrator Mpower Communications [EMAIL PROTECTED] - Original Message - From: Don Pro [EMAIL PROTECTED] To: msql list [EMAIL PROTECTED] Sent: Friday, May 11, 2001 2:37 PM Subject: simultaneous connections Hi, I'm reading in my documentation (I have a book) that MySQL allows up to 101 simultaneous connections. Gadzooks! How can MySQL claim to be at the Enterprise level with this limit? Is there any way around this? Thanks, Don - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: simultaneous connections
Don Pro wrote: Hi, I'm reading in my documentation (I have a book) that MySQL allows up to 101 simultaneous connections. Gadzooks! How can MySQL claim to be at the Enterprise level with this limit? Is there any way around this? Thanks, Don http://www.mysql.com/doc/T/o/Too_many_connections.html The limit is build in to protect people from themselves. If you wish to change the limit, have at it, note that you may also need to ajust parameters on your system including number of open files as well as mysql memory allocation. It's pretty much just saying 100 is safe for any normal machine, if you have the resources to go beyond that, read the manual, and change it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: simultaneous connections
Don Pro wrote: Hi, I'm reading in my documentation (I have a book) that MySQL allows up to 101 simultaneous connections. Gadzooks! How can MySQL claim to be at the Enterprise level with this limit? Is there any way around this? Thanks, Don http://www.mysql.com/doc/T/o/Too_many_connections.html The limit is build in to protect people from themselves. If you wish to change the limit, have at it, note that you may also need to ajust parameters on your system including number of open files as well as mysql memory allocation. It's pretty much just saying 100 is safe for any normal machine, if you have the resources to go beyond that, read the manual, and change it. Don: fix you mail program, your reply-to is messed, up, how can you expect any replies. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php