Re: Long running queries over tcp don’t “respond” to client after completion

[Matthew Lenz]

*************************** 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)