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
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.
-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
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://or
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
mysql> set option thread_cache_size=4M;
ERROR 1064: You have an error in your SQL syntax near
'thread_cache_size=4M' at line 1
mysql> set thread_cache_size=4M;
ERROR 1064: You