mtoth <[EMAIL PROTECTED]> wrote: > This is on a production server and I would rather not stop and restart it. > Also I don't think HUPing mysqld will make it read my.cnf again. >
In version 3.23.51 there are very few options and variables that you can reset via SET command. In your case you need restart server with a new value of thread_cache_size in my.cnf > > -Michael > > "Well finally! We did everthing but to leave a note pinned to the hem of her dress > that said, Oh by the way, the Prelate and the prophet are still alive, you dolt." > -Nathan > > On Thu, 29 May 2003, Egor Egorov wrote: > >> mtoth <[EMAIL PROTECTED]> wrote: >> > I am unable to set thread_cache_size via the mysql tool. >> > Should I be able to? >> > Am I doing something wrong? >> > >> > Ver: 3.23.51 >> >> You could do it only editing my.cnf file or run mysqld with appropriate option. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]