walt, i get the same issue. I see the same output when doing mysql -D <db> as i do when doing mysql --help. i.e. its telling me that the variable for some reason cannot be configured.
-- anthony -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of walt Sent: Monday, July 14, 2003 7:44 AM To: [EMAIL PROTECTED] Cc: mysql-lists Subject: Re: can't set variable (sort_buffer) Anthony, Try adding this to the my.cnf file set-variable =sort_buffer=30M walt arobins wrote: > > I would like to change the sort_buffer variable but > that variable doesn't seem to be configurable. > > i.e. > > I get the following when doing mysql --help. > Don't understand why only these variables are configurable. > Using db version 3.23.51. > > Possible variables for option --set-variable (-O) are: > connect_timeout current value: 0 > max_allowed_packet current value: 16777216 > net_buffer_length current value: 16384 > select_limit current value: 1000 > max_join_size current value: 1000000 > > -- anthony > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]