MySQL Forums
Forum List  »  General

Re: Long running queries over tcp don’t “respond” to client after completion
Posted by: Matthew Lenz
Date: March 25, 2021 08:13AM

Peter, I think I figured it out! It's the GCE firewall. I happened to find and saw that it mentions only tracking idle connections for 10 minutes. I lowered the keepalives for the two servers in question to the following:


(not sure these are the values I'll stick with, I was just playing around)

And now the script continues to run after completing the LOAD DATA.

Do you know if the mysql server/client can be configured to send keep alives at a lower interval than the system defaults?

net.ipv4.tcp_keepalive_intvl = 75
net.ipv4.tcp_keepalive_probes = 9
net.ipv4.tcp_keepalive_time = 7200 <-- needed to be lower than 300 seconds for GCE firewall idle connection tracking

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.