...
- 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 get the default and maximum value for idle
wait_timeout
for your platform refer following article: Server System Variables : wait_timeout.- On Unix systems you can use:
set @wait_timeout = 31536000;
(this is the max. value on Unix
- )
- On Unix systems you can use:
- 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.
...