From: Peter Brawley Date: October 19 2005 2:20am Subject: Re: the difference between server option and Server System Variables List-Archive: http://lists.mysql.com/mysql/190551 Message-Id: <4355AD70.9080906@earthlink.net> MIME-Version: 1.0 Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: 7bit liulian, >In mysql,server system variables's function like server option function. >How do i choosing between the server opiton and the system variables. >thanks! MySQL has more than 300 system variables that can be set in the option file my.cnf/ini, on the server command line, and/or with SELECT statements. Some can be set with all those methods, some with just one or two of them. What do you want to know? PB > -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.12.3/141 - Release Date: 10/18/2005