Hello Chetan, CL> hi, CL> I wanted to set variable query_cache_size.. CL> I have tried for this as in below but the machine hangs up every time i CL> am doing this... CL> Any other method by which I can set this Variable..?
Try to run safe_mysqld in background mode. CL> shell> mysqld -u root --set-variable query_cache-size=1; CL> 020124 15:55:11 InnoDB:Started CL> mysqld ready for connection.. You can also set variables by editing my.cnf: [mysqld] set variable=query_cache_size=1; -- For technical support contracts, goto https://order.mysql.com/ 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