I set the following MySQL parameter:
set global wait_timeout=2147483
However, after server restart it reverted to its default value 28800. Isn't the set
command persistent? In order to have this parameter persistent, should I edit a configuration file? Would that file be C:\Program Files\MySQL\MySQL Server 5.5\my.ini
? If so, is it simply
wait_timeout=2147483
If so, under which section should it be in my.ini
Set global doesn't make persistent variables.
You should write that under [mysqld] section in my.cnf:
[mysqld]
wait_timeout=86400
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With