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 10:56AM

*************************** 1. row ***************************
Variable_name: connect_timeout
Value: 10
*************************** 2. row ***************************
Variable_name: delayed_insert_timeout
Value: 300
*************************** 3. row ***************************
Variable_name: have_statement_timeout
Value: YES
*************************** 4. row ***************************
Variable_name: innodb_flush_log_at_timeout
Value: 1
*************************** 5. row ***************************
Variable_name: innodb_lock_wait_timeout
Value: 50
*************************** 6. row ***************************
Variable_name: innodb_print_lock_wait_timeout_info
Value: OFF
*************************** 7. row ***************************
Variable_name: innodb_rollback_on_timeout
Value: OFF
*************************** 8. row ***************************
Variable_name: interactive_timeout
Value: 28800
*************************** 9. row ***************************
Variable_name: lock_wait_timeout
Value: 31536000
*************************** 10. row ***************************
Variable_name: mysqlx_connect_timeout
Value: 30
*************************** 11. row ***************************
Variable_name: mysqlx_idle_worker_thread_timeout
Value: 60
*************************** 12. row ***************************
Variable_name: mysqlx_interactive_timeout
Value: 28800
*************************** 13. row ***************************
Variable_name: mysqlx_port_open_timeout
Value: 0
*************************** 14. row ***************************
Variable_name: mysqlx_read_timeout
Value: 30
*************************** 15. row ***************************
Variable_name: mysqlx_wait_timeout
Value: 28800
*************************** 16. row ***************************
Variable_name: mysqlx_write_timeout
Value: 60
*************************** 17. row ***************************
Variable_name: net_read_timeout
Value: 30
*************************** 18. row ***************************
Variable_name: net_write_timeout
Value: 60
*************************** 19. row ***************************
Variable_name: rpl_stop_slave_timeout
Value: 31536000
*************************** 20. row ***************************
Variable_name: slave_net_timeout
Value: 60
*************************** 21. row ***************************
Variable_name: thread_pool_idle_timeout
Value: 60
*************************** 22. row ***************************
Variable_name: wait_timeout
Value: 28800


Would you have any insight into the correlation between:


1. Those numbers above.
2. The tcp keepalive values at the operating system level.
3. firewall tracked idle connection timeouts (I have no control over this with GCP/GCE it's not configurable and is 10 minutes)

Options: ReplyQuote




Sorry, only registered users may post in this forum.

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.