Re: RE: How to set max_connections ?
Rekha, Tuesday, June 11, 2002, 8:48:12 PM, you wrote: RD Do I need to have some kind of permissions to change a variable ? No, you should have permissions to run mysqld. RD Thanks, RD Rekha -- 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: RE: How to set max_connections ?
Rekha, Tuesday, June 11, 2002, 8:17:01 PM, you wrote: RD Where can I get a sample my.cnf? You can find examples of *.cnf in /usr/doc/MySQL-X.XX. RD Thanks, RD Rekha -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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 set max_connections ?
Hello Steve Katen [EMAIL PROTECTED], How do you tell the number of connections currently in use? On Mon, 10 Jun 2002 18:17:19 -0700 Steve Katen [EMAIL PROTECTED] wrote: what do you mean it doesn't do anything? you should be able to set it on the command line as: --set-variable=max_connections=200 or you could edit the my.cnf file that mysql is using when it starts-up. if you can't find the my.cnf, then you should create one. here is a link to the manpage and some default entires on mysql.com: http://www.mysql.com/doc/O/p/Option_files.html either way, you can check to see if the max connections has been updated by running the below command at the mysql prompt: show variables; katen At 06:05 PM 6/10/2002, Rekha Das wrote: Hi all, I am trying to set max_connections to 200 on my server. Currently it is 100. My mysql version 3.22.32. My problem is I am not able to find my.cnf. And if I set the variable on command line like this: --set-variable = max_connections=200; Then it does not do anything. What am I doing wrong ? Thanks, Rekha - 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 -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - 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 set max_connections ?
Where can I get a sample my.cnf? Thanks, Rekha -Original Message- From: Steve Katen [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 6:17 PM To: Rekha Das; '[EMAIL PROTECTED]' Subject: Re: How to set max_connections ? what do you mean it doesn't do anything? you should be able to set it on the command line as: --set-variable=max_connections=200 or you could edit the my.cnf file that mysql is using when it starts-up. if you can't find the my.cnf, then you should create one. here is a link to the manpage and some default entires on mysql.com: http://www.mysql.com/doc/O/p/Option_files.html either way, you can check to see if the max connections has been updated by running the below command at the mysql prompt: show variables; katen At 06:05 PM 6/10/2002, Rekha Das wrote: Hi all, I am trying to set max_connections to 200 on my server. Currently it is 100. My mysql version 3.22.32. My problem is I am not able to find my.cnf. And if I set the variable on command line like this: --set-variable = max_connections=200; Then it does not do anything. What am I doing wrong ? Thanks, Rekha - 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: How to set max_connections ?
Do I need to have some kind of permissions to change a variable ? Thanks, Rekha -Original Message- From: Steve Katen [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 6:17 PM To: Rekha Das; '[EMAIL PROTECTED]' Subject: Re: How to set max_connections ? what do you mean it doesn't do anything? you should be able to set it on the command line as: --set-variable=max_connections=200 or you could edit the my.cnf file that mysql is using when it starts-up. if you can't find the my.cnf, then you should create one. here is a link to the manpage and some default entires on mysql.com: http://www.mysql.com/doc/O/p/Option_files.html either way, you can check to see if the max connections has been updated by running the below command at the mysql prompt: show variables; katen At 06:05 PM 6/10/2002, Rekha Das wrote: Hi all, I am trying to set max_connections to 200 on my server. Currently it is 100. My mysql version 3.22.32. My problem is I am not able to find my.cnf. And if I set the variable on command line like this: --set-variable = max_connections=200; Then it does not do anything. What am I doing wrong ? Thanks, Rekha - 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: How to set max_connections ?
what do you mean it doesn't do anything? you should be able to set it on the command line as: --set-variable=max_connections=200 or you could edit the my.cnf file that mysql is using when it starts-up. if you can't find the my.cnf, then you should create one. here is a link to the manpage and some default entires on mysql.com: http://www.mysql.com/doc/O/p/Option_files.html either way, you can check to see if the max connections has been updated by running the below command at the mysql prompt: show variables; katen At 06:05 PM 6/10/2002, Rekha Das wrote: Hi all, I am trying to set max_connections to 200 on my server. Currently it is 100. My mysql version 3.22.32. My problem is I am not able to find my.cnf. And if I set the variable on command line like this: --set-variable = max_connections=200; Then it does not do anything. What am I doing wrong ? Thanks, Rekha - 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