...
- Steps to change the wait_timeout server system variable
- Login into database which is used by JOC Cockpit via MySQL command line or any other MySQL GUI client such as MySQL Workbench. (Note: the following commands will only be effective for the currently selected database.)
- Set wait_timeout variable's value by running following command. To Refer to the following article to get the default and maximum value values for idle
wait_timeout
for your platform refer following article:- On Unix systems you can useThe following setting would set the timeout to 24 hours:
set @wait_timeout = 3153600086400;
(this is the max. value on Unixvalue is set in seconds)
- On Unix systems you can useThe following setting would set the timeout to 24 hours:
- Check the updated value of the wait_timeout variable by running the following command:
- select @wait_timeout;
- Restart your JOC Cockpit Windows service or Linux demon, to create a new database connection between JOC Cockpit and MySQL.
...