Re: How to add the max_connections
Liu, Monday, June 17, 2002, 8:33:46 AM, you wrote: LQq Please tell me how to add the max_connections of mysql. Please give me a example. max_connections is a mysqld variable. You can't add\drop max_connections, you can only increase\decrease its value. If you want to change default value (100), you can specify new values in my.cnf file in the [mysqld] section: [mysqld] set-variable = max_connections = # or start mysqld with -O max_connections=# options. LQq Best Regards, LQq Q.H Liu -- 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 - 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: How to add the max_connections
Yes, thanks a lot. I still have a question though. Up to how many connection can mysql handle? Thanks, Louie... - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 18, 2002 3:29 PM Subject: Re: How to add the max_connections Liu, Monday, June 17, 2002, 8:33:46 AM, you wrote: LQq Please tell me how to add the max_connections of mysql. Please give me a example. max_connections is a mysqld variable. You can't add\drop max_connections, you can only increase\decrease its value. If you want to change default value (100), you can specify new values in my.cnf file in the [mysqld] section: [mysqld] set-variable = max_connections = # or start mysqld with -O max_connections=# options. LQq Best Regards, LQq Q.H Liu -- 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 - 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: Re: How to add the max_connections
louie, Tuesday, June 18, 2002, 12:36:14 PM, you wrote: lm Yes, thanks a lot. lm I still have a question though. lm Up to how many connection can mysql handle? The maximum number of connections depends not only on max_connections value. It also depends on thread library on your OS, on amount of RAM, on what is your client doing. lm Thanks, lm Louie... -- 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 - 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