Stale connection Issue in MySQL 8.0.26
Posted by: Arul�* velan
Date: October 19, 2021 09:47AM

We are using MySQL Document store with below timeout configs. After few hours(< 8) of inactivity, jdbc client is unable to establish a connection with server. We had to reboot MySQL or Application server instance to make the connection pool active.
Is there any ways to keep the connection active such as Validation query or ping command in xdev jdbc connection string? Pls provide examples.

How to set the query timeout /read time out from client side jdbc pool?

How server side params mysqlx_connect_timeout and mysqlx_read_timeout works with client jdbc connection?

JDBC Connection pool:
---------------------
DB_CONNECTION_POOLING_ENABLED=true
DB_CONNECTION_POOLING_MAXSIZE=10
DB_CONNECTION_POOLING_MAXIDLETIME=5000
DB_CONNECTION_POOLING_QUEUETIMEOUT=1000

Server params
-------------
connect_timeout 30
delayed_insert_timeout 300
have_statement_timeout YES
innodb_flush_log_at_timeout 1
innodb_lock_wait_timeout 50
innodb_rollback_on_timeout OFF
interactive_timeout 28800
lock_wait_timeout 31536000
mysqlx_connect_timeout 30
mysqlx_idle_worker_thread_timeout 60
mysqlx_interactive_timeout 28800
mysqlx_port_open_timeout 0
mysqlx_read_timeout 30
mysqlx_wait_timeout 28800

Options: ReplyQuote


Subject
Written By
Posted
Stale connection Issue in MySQL 8.0.26
October 19, 2021 09:47AM


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.