Re: my.cnf mystery
My point was that this is a configuration file, text, not a program. Still, there should be an appendix in the documentation that lists all of the options rather than have this hunt-and-seek approach. Quoting Paul DuBois [EMAIL PROTECTED]: At 8:15 PM -0400 6/12/01, William M. Quarles wrote: Which program? Uh ... what? mysqld, mysql, mysqladmin, mysqldump, mysqlshow, ... For example, if you run mysql --help, the output includes: Possible variables for option --set-variable (-O) are: connect_timeout current value: 0 max_allowed_packetcurrent value: 16777216 net_buffer_length current value: 16384 select_limit current value: 1000 max_join_size current value: 100 --On Tuesday, June 12, 2001 15:52 -0500 Paul DuBois [EMAIL PROTECTED] wrote: At 4:34 PM -0400 6/12/01, William M. Quarles wrote: I don't think that's what Dennis person wants to know, I think he wants to know every single variable that he can control in my.cnf. Running a program with the --help option will list the program's variables. The syntax for setting any of them is the same. --On Tuesday, June 12, 2001 3:09 PM -0500 Paul DuBois [EMAIL PROTECTED] wrote: At 3:36 PM -0400 6/12/01, Dennis wrote: Of the many mysql resources I have (including a book and searching the website), there doesnt seem to be a definitive outline of what variables can be controlled by my.cnf. set-variable = var_name=var_value should work for pretty much any variable that a program knows about... Is there a list somewhere outlining the possibilities? Dennis -- Paul DuBois, [EMAIL PROTECTED] - 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: my.cnf mystery
At 08:30 PM 06/12/2001, Philip Mak wrote: [client] port=3306 socket=/home/mysql/mysql.sock [mysqld] port=3306 socket=/home/mysql/mysql.sock here are examples of variables that you could not deduce from using --help. the socket one,for example, was one that I asked about last week, when the consensus answer was to use a link to change this. Clearly the my.cnf route is a better choice. Dennis - 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: my.cnf mystery
At 2:30 PM -0400 6/13/01, Dennis wrote: At 08:30 PM 06/12/2001, Philip Mak wrote: [client] port=3306 socket=/home/mysql/mysql.sock [mysqld] port=3306 socket=/home/mysql/mysql.sock here are examples of variables that you could not deduce from using --help. the socket one,for example, was one that I asked about last week, when the consensus answer was to use a link to change this. Clearly the my.cnf route is a better choice. Dennis Perhaps this will be considered nitpicking, but ... 1) socket isn't a variable. It's a parameter. Variable are those things that are set with set-variable=varname=value. 2) my.cnf is not clearly a better choice. For programs that don't consult option files, it won't work. -- Paul DuBois, [EMAIL PROTECTED] - 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: my.cnf mystery
At 3:36 PM -0400 6/12/01, Dennis wrote: Of the many mysql resources I have (including a book and searching the website), there doesnt seem to be a definitive outline of what variables can be controlled by my.cnf. set-variable = var_name=var_value should work for pretty much any variable that a program knows about... Is there a list somewhere outlining the possibilities? Dennis - 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 -- Paul DuBois, [EMAIL PROTECTED] - 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: my.cnf mystery
I don't think that's what Dennis person wants to know, I think he wants to know every single variable that he can control in my.cnf. --On Tuesday, June 12, 2001 3:09 PM -0500 Paul DuBois [EMAIL PROTECTED] wrote: At 3:36 PM -0400 6/12/01, Dennis wrote: Of the many mysql resources I have (including a book and searching the website), there doesnt seem to be a definitive outline of what variables can be controlled by my.cnf. set-variable = var_name=var_value should work for pretty much any variable that a program knows about... Is there a list somewhere outlining the possibilities? Dennis - 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 -- Paul DuBois, [EMAIL PROTECTED] - 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 -- William M. Quarles Vice Pres, Society of Physics Students Jr. Warden, Canterbury Episcopal Campus Ministry James Madison University [EMAIL PROTECTED] * This e-mail was sent using Mulberry, JMU's new official e-mail client. - 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: my.cnf mystery
Which program? --On Tuesday, June 12, 2001 15:52 -0500 Paul DuBois [EMAIL PROTECTED] wrote: At 4:34 PM -0400 6/12/01, William M. Quarles wrote: I don't think that's what Dennis person wants to know, I think he wants to know every single variable that he can control in my.cnf. Running a program with the --help option will list the program's variables. The syntax for setting any of them is the same. --On Tuesday, June 12, 2001 3:09 PM -0500 Paul DuBois [EMAIL PROTECTED] wrote: At 3:36 PM -0400 6/12/01, Dennis wrote: Of the many mysql resources I have (including a book and searching the website), there doesnt seem to be a definitive outline of what variables can be controlled by my.cnf. set-variable = var_name=var_value should work for pretty much any variable that a program knows about... Is there a list somewhere outlining the possibilities? Dennis - 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 -- Paul DuBois, [EMAIL PROTECTED] - 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 -- William M. Quarles Vice Pres, Society of Physics Students Jr. Warden, Canterbury Episcopal Campus Ministry James Madison University [EMAIL PROTECTED] * This e-mail was sent using Mulberry, JMU's new official e-mail client. -- Paul DuBois, [EMAIL PROTECTED] -- William M. Quarles Vice Pres, Society of Physics Students Jr. Warden, Canterbury Episcopal Campus Ministry James Madison University [EMAIL PROTECTED] * This e-mail was sent using Mulberry, JMU's new official e-mail client. - 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: my.cnf mystery
On Tue, 12 Jun 2001, William M. Quarles wrote: Which program? Here's what the /etc/my.cnf file on my system looks like: [client] port=3306 socket=/home/mysql/mysql.sock [mysqld] port=3306 socket=/home/mysql/mysql.sock The first section affects the mysql client. The second section affects the mysqld server. So, type mysql --help for a list of things that you can put in the client section, and /usr/sbin/mysqld --help (substitute the correct path name for mysqld) for a list of things that you can put in the server section. That said, I do think the MySQL manual should include a section that explains my.cnf better, if it doesn't have one already. -Philip Mak ([EMAIL PROTECTED]) - 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: my.cnf mystery
At 8:15 PM -0400 6/12/01, William M. Quarles wrote: Which program? Uh ... what? mysqld, mysql, mysqladmin, mysqldump, mysqlshow, ... For example, if you run mysql --help, the output includes: Possible variables for option --set-variable (-O) are: connect_timeout current value: 0 max_allowed_packetcurrent value: 16777216 net_buffer_length current value: 16384 select_limit current value: 1000 max_join_size current value: 100 --On Tuesday, June 12, 2001 15:52 -0500 Paul DuBois [EMAIL PROTECTED] wrote: At 4:34 PM -0400 6/12/01, William M. Quarles wrote: I don't think that's what Dennis person wants to know, I think he wants to know every single variable that he can control in my.cnf. Running a program with the --help option will list the program's variables. The syntax for setting any of them is the same. --On Tuesday, June 12, 2001 3:09 PM -0500 Paul DuBois [EMAIL PROTECTED] wrote: At 3:36 PM -0400 6/12/01, Dennis wrote: Of the many mysql resources I have (including a book and searching the website), there doesnt seem to be a definitive outline of what variables can be controlled by my.cnf. set-variable = var_name=var_value should work for pretty much any variable that a program knows about... Is there a list somewhere outlining the possibilities? Dennis -- Paul DuBois, [EMAIL PROTECTED] - 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: my.cnf mystery
The command lines are divided up by topics in the manual, I think. I know that there is a specific section on replication. A table of all of them in one place would be a helpful appendix in a future edition of the documentation. [hint, hint, MySQL AB developers...] --On Tuesday, June 12, 2001 20:30 -0400 Philip Mak [EMAIL PROTECTED] wrote: On Tue, 12 Jun 2001, William M. Quarles wrote: Which program? Here's what the /etc/my.cnf file on my system looks like: [client] port=3306 socket=/home/mysql/mysql.sock [mysqld] port=3306 socket=/home/mysql/mysql.sock The first section affects the mysql client. The second section affects the mysqld server. So, type mysql --help for a list of things that you can put in the client section, and /usr/sbin/mysqld --help (substitute the correct path name for mysqld) for a list of things that you can put in the server section. That said, I do think the MySQL manual should include a section that explains my.cnf better, if it doesn't have one already. -Philip Mak ([EMAIL PROTECTED]) -- William M. Quarles Vice Pres, Society of Physics Students Jr. Warden, Canterbury Episcopal Campus Ministry James Madison University [EMAIL PROTECTED] * This e-mail was sent using Mulberry, JMU's new official e-mail client. - 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