Results 1 to 7 of 7
-
05-04-2010, 07:00 AM #1Junior Guru Wannabe
- 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
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
-
05-04-2010, 08:02 AM #2Web Hosting Evangelist
- 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.
-
05-04-2010, 08:29 AM #3Junior Guru Wannabe
- 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.
-
05-04-2010, 08:46 AM #4Web Hosting Master
- Join Date
- Oct 2004
- Location
- Kerala, India
- Posts
- 4,771
David | www.cliffsupport.com
Affordable Server Management Solutions sales AT cliffsupport DOT com
CliffWebManager | Access WHM from iPhone and Android
-
05-04-2010, 09:18 AM #5Junior Guru Wannabe
- Join Date
- Dec 2007
- Posts
- 32
Thank you very much.
-
05-04-2010, 09:22 AM #6Web Hosting Master
- 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
-
05-04-2010, 11:34 AM #7Newbie
- Join Date
- May 2010
- Posts
- 14
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
-
MySQL wait_timeout setting
By Mirrorball in forum Hosting Security and TechnologyReplies: 10Last Post: 02-11-2012, 05:20 PM -
Any way to block junk sites that interrupt your destination???
By the love below in forum Web Hosting LoungeReplies: 6Last Post: 08-10-2009, 07:37 PM -
eth0:Too much work at interrupt, IntrStatus=0x0010.
By atul in forum Hosting Security and TechnologyReplies: 3Last Post: 07-08-2004, 05:18 AM -
We interrupt this program for .... duh da dah oh boy...
By ChickenSteak in forum Web Hosting LoungeReplies: 19Last Post: 10-29-2002, 10:41 PM -
Changing wait_timeout in MYSQL
By mercury in forum Hosting Security and TechnologyReplies: 0Last Post: 11-09-2001, 07:06 AM