online prescription solutions
online discount medstore
pills online
buy lorazepam without prescription
xanax for sale
buy xanax without prescription
buy ambien without prescription
ambien for sale
buy modafinil without prescription
buy phentermine without prescription
modafinil for sale
phentermine for sale
lorazepam for sale
buy lexotan without prescription
bromazepam for sale
xenical for sale
buy stilnox without prescription
valium for sale
buy prosom without prescription
buy mefenorex without prescription
buy sildenafil citrate without prescription
buy adipex-p without prescription
librium for sale
buy restoril without prescription
buy halazepam without prescription
cephalexin for sale
buy zoloft without prescription
buy renova without prescription
renova for sale
terbinafine for sale
dalmane for sale
buy lormetazepam without prescription
nobrium for sale
buy klonopin without prescription
priligy dapoxetine for sale
buy prednisone without prescription
buy aleram without prescription
buy flomax without prescription
imovane for sale
adipex-p for sale
buy niravam without prescription
seroquel for sale
carisoprodol for sale
buy deltasone without prescription
buy diazepam without prescription
zopiclone for sale
buy imitrex without prescription
testosterone anadoil for sale
buy provigil without prescription
sonata for sale
nimetazepam for sale
buy temazepam without prescription
buy xenical without prescription
buy famvir without prescription
buy seroquel without prescription
rivotril for sale
acyclovir for sale
loprazolam for sale
buy nimetazepam without prescription
buy prozac without prescription
mogadon for sale
viagra for sale
buy valium without prescription
lamisil for sale
camazepam for sale
zithromax for sale
buy clobazam without prescription
buy diflucan without prescription
modalert for sale
diflucan for sale
buy alertec without prescription
buy zyban without prescription
buy serax without prescription
buy medazepam without prescription
buy imovane without prescription
mefenorex for sale
lormetazepam for sale
prednisone for sale
ativan for sale
buy alprazolam without prescription
buy camazepam without prescription
buy nobrium without prescription
mazindol for sale
buy mazindol without prescription
buy mogadon without prescription
buy terbinafine without prescription
diazepam for sale
buy topamax without prescription
cialis for sale
buy tafil-xanor without prescription
buy librium without prescription
buy zithromax without prescription
retin-a for sale
buy lunesta without prescription
serax for sale
restoril for sale
stilnox for sale
lamotrigine for sale

MySQL wait_timeout setting


We were having issues with mysql threads where they would be in sleep mode and wouldn’t die off for long time. At the same time we started having issues with our servers where the load will spike and eventually server will come to halt unless we killed all the apache processes and restarted apache (which seems to be the hung application). We traced it back eventually and noticed that the time when server hung was when it burned through all the ram and was using up all the swap also. So we started to work backwards and tried to resolve one thing at a time. We started with MySQL. We put in wait_timeout = 30 in to my.cnf and restarted mysql. Than I closely watched the server for few hours and noticed that we didn’t have any more of those sleep connections. GREAT! A work around until we get to bottom of whats causing this. That was on Friday. Sat we started noticing different problem. Problem worsened and we started to look into what might’ve caused it and found out that we had a script which was pulling row at a time, processing it, and deleting the row. Except, it was never getting to delete the row due to timeout would kick in and close the connection. We found this out when we watched error logs and saw: Mysql has gone away message.

We took out the wait timeout and everything seems to started to work fine. Did anybody ever notice this behavior where you would loose connection to the mysql server due to timeout? The script which processes line by line and deletes line by line takes fraction of second to process that particular line. Does wait timeout starts counting from the starting of the connection? Does it mean that wait timeout is actually a max connection time limit? Suggestions/comments?

Edit 5/31/09: Friend of mine was getting this error: database error: Lost connection to MySQL server during query
he got around it by adjusting wait_timeout setting.


7 Responses to “ MySQL wait_timeout setting ”

  1. Chris
    March 14th, 2007 | 11:44 am

    When you remove the wait_timeout, the timeout defaults to 28800 or 8 hours

  2. July 31st, 2007 | 4:15 am

    When a mysql process is in SLEEP state, it could indicate the process is waiting for another, long query to finish.

    In your case, the query selecting rows is probably taking more than 30 seconds, your timeout setting kills the process, so the delete query is not executed anymore.

  3. February 5th, 2008 | 2:35 am

    We got the “too many connection” error in our site. we were approached to our server peoples. they did some of the correction in mysql system variable (wait_timeout set to 28800, interactive_timeout set to 28800) and restart the mysql server. Our problem solved. I think this will help you sort your problem.

  4. The Mikeness
    June 24th, 2008 | 2:29 pm

    The Microsoft way to solve this problem is to increase the max connections.

    Nah but seriously tho, some mysql_close() calls would be in order, if you are having problems i doubt its one script thats making tons of connections its probably just other connections are being made in other highly used scripts and are not getting closed after. If youre using PHP for example and objects, you can create a destructor like __destruct(){$this->link->close();} to close it at the end of execution because when the object is destroyed it closes the connection then.

  5. September 11th, 2008 | 7:18 am

    [...] MySQL wait_timeout setting [...]

  6. November 7th, 2009 | 3:21 am

    Hi..
    If you set the property value wait_timeout as 30 it seems your web application ll going to met MySQLNonTransientConnectionException.

    In my web application met this problem while my setup wait_timeout as 30. When it sets to default variable 8 hours which is 28800 seconds its working fine.

    i m using c3p0 connection pooling with hibernet in JAVA. Here what happends means the connections goign to kill every 30 seconds which is sleeping state but it live.

    So its major problem keep aware with this time out variable on mysql server.

    Hope this information usefull for all. :)

  7. October 20th, 2010 | 7:43 am

    At a dos prompt, type:
    C:\>mysql –verbose –help

    Then look for
    …i-am-a-dummy FALSE
    connect_timeout 0
    max_allowed_packet 16777216

    Then, at mysql prompt

    mysql> set GLOBAL connect_timeout=259200;
    Query OK, 0 rows affected (0.03 sec)

Leave a reply

*
To prove that you're not a bot, enter this code
Anti-Spam Image