Timeline for mysql connection timeout on small traffic server
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 7, 2015 at 4:04 | comment | added | Vérace | To @CodeMed - try [mysqld]. Another question is - what, exactly, have you put into the file - what is the line you added? Yes, you can modify it from the MySQL command line - but let's get it right! :-) | |
| Apr 7, 2015 at 4:03 | comment | added | CodeMed |
Is there a way to set it from the MySQL command line? Perhaps SET wait_timeout=31536000? I am just looking for some way to get around the fact that changing the config file and then restarting the database server did not work, as shown in my preceding comment and in the EDIT.
|
|
| Apr 7, 2015 at 3:51 | history | edited | Vérace | CC BY-SA 3.0 |
added 25 characters in body
|
| Apr 7, 2015 at 3:50 | comment | added | Vérace | Oh, I see the confusion - strange copy and paste behaviour. I've added arrows pointing out the Max Value for Windows (2147483) and Unix (31536000). If you check the page that I quoted from the MySQL docco, you'll see that in the "Permitted Values" sections, there is a distinction between Windows and Others. For some reason, when I copied over the table, these didn't come over. Check the table now. You're on Unix, so your Max Value is a year. | |
| Apr 7, 2015 at 3:50 | comment | added | CodeMed |
OK, but there is no [mysql] section in my.cnf, only a [mysqld] section. And placing it there and restarting the database service at the CentOS command line as shown in my EDIT did not change anything. What am I doing wrong, as described in the steps in my EDIT?
|
|
| Apr 7, 2015 at 3:47 | history | edited | Vérace | CC BY-SA 3.0 |
added 50 characters in body
|
| Apr 7, 2015 at 3:38 | comment | added | Vérace | 31536000 = 60 * 60 * 24 * 365 = 1 year in seconds. @CodeMed has given the duration of the other value. Put a line in the[mysql] section of my.cnf "wait_timeout = 31536000" - et voilà! | |
| Apr 7, 2015 at 3:35 | comment | added | CodeMed |
((2147483 seconds / 60 = 35791 minutes)/60 = 596 hours) / 24 = 24 days. Is this the wrong formula?
|
|
| Apr 7, 2015 at 3:30 | comment | added | CodeMed | Please see EDIT at the end of my OP with results of following your advice. What am I doing wrong? Also, I estimated 2147483 as less than 25 days. What formula are you using to convert it into a full year? | |
| Apr 7, 2015 at 3:07 | history | answered | Vérace | CC BY-SA 3.0 |