Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2007
    Posts
    32

    Would wait_timeout parameter interrupt mysqldump?

    Hello,

    We would like to add a parameter to our my.cnf file

    Code:
    wait_timeout = 120
    which would basically kill any mysql connections which are over 2 minutes.

    That parameter is explained as "The number of seconds the server waits for activity on a noninteractive connection before closing it"

    We're just wondering, we have a cron backup job, which calls mysqldump on our database. If this mysqldump was taking longer than 120 seconds, would wait_timeout setting interrupt it? We assume not, because mysqldump is surely not "a noninteractive connection", but just to make sure?

    Cheers

  2. #2
    Join Date
    Apr 2009
    Location
    Romania
    Posts
    473
    Did you checked:
    http://dev.mysql.com/doc/refman/5.0/...r_wait_timeout

    Here is what interests you:

    The number of seconds the server waits for activity on a noninteractive connection before closing it. This timeout applies only to TCP/IP and Unix socket file connections, not to connections made via named pipes, or shared memory.
    PidginHost.com - Managed dedicated servers, cloud servers and software development.

  3. #3
    Join Date
    Dec 2007
    Posts
    32
    Yes, in fact, that is where I pasted the description of the parameter from

    The thing is, when I googled these two words, wait_timeout and mysqldump, google was retrieving a lot of documents which were saying that mysqldump did not finish or was throwing an error, but most of the documents I looked up had no clear answer to what was causing the interrupt.


    So I pretty much just wanted to check empirically - surely people here have wait_timeout set to 20, 30, 60 seconds, and their mysqldumps which take longer than that - I mostly asked just to make sure.

  4. #4
    Join Date
    Oct 2004
    Location
    Kerala, India
    Posts
    4,771
    Quote Originally Posted by Dave_77 View Post
    Hello,

    We would like to add a parameter to our my.cnf file

    Code:
    wait_timeout = 120
    which would basically kill any mysql connections which are over 2 minutes.
    This will not affect the mysqldump function working. Even if we set both interactive_timeout and wait_timeout to very low value, it will not affect the mysqldump.
    David | www.cliffsupport.com
    Affordable Server Management Solutions sales AT cliffsupport DOT com
    CliffWebManager | Access WHM from iPhone and Android

  5. #5
    Join Date
    Dec 2007
    Posts
    32
    Thank you very much.

  6. #6
    Join Date
    Nov 2004
    Location
    India
    Posts
    1,104
    The values in wait_timeout will not affect the mysqldump but it will get affected if no proper values set for max_allowed_packet and net_write_timeout.
    AssistanZ - Beyond Boundaries...
    Cloudstack Consultancy / 24x7 Web Hosting Support / 24x7 Server Management / Infrastructure Management Services
    Web & Mobile Apps Development / Web Designing Services / Php, Grails, Java Development

  7. #7
    Hi,

    There shouldn't be any issue with the mysql server dumps, the best part is that you can get rid of the mysql server gone away errors if you have a higher wait_timeout.

Similar Threads

  1. MySQL wait_timeout setting
    By Mirrorball in forum Hosting Security and Technology
    Replies: 10
    Last Post: 02-11-2012, 05:20 PM
  2. Any way to block junk sites that interrupt your destination???
    By the love below in forum Web Hosting Lounge
    Replies: 6
    Last Post: 08-10-2009, 07:37 PM
  3. eth0:Too much work at interrupt, IntrStatus=0x0010.
    By atul in forum Hosting Security and Technology
    Replies: 3
    Last Post: 07-08-2004, 05:18 AM
  4. We interrupt this program for .... duh da dah oh boy...
    By ChickenSteak in forum Web Hosting Lounge
    Replies: 19
    Last Post: 10-29-2002, 10:41 PM
  5. Changing wait_timeout in MYSQL
    By mercury in forum Hosting Security and Technology
    Replies: 0
    Last Post: 11-09-2001, 07:06 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •