[MXS-3919] Add `interactive_timeout` and `wait_timeout` inputs in the Query Editor settings Created: 2021-12-16  Updated: 2024-01-25  Resolved: 2024-01-02

Status: Closed
Project: MariaDB MaxScale
Component/s: maxgui
Affects Version/s: None
Fix Version/s: 24.02.0

Type: New Feature Priority: Major
Reporter: Naresh Chandra Assignee: Duong Thien Ly
Resolution: Fixed Votes: 0
Labels: None

Attachments: PNG File screenshot-1.png    
Sprint: MXS-SPRINT-196, MXS-SPRINT-197

 Description   

We set the timeout option to 300 seconds during the new DB connection, which is default. If the SQL editor session is idle(we are just keeping the DB connection without running the queries on the SQL GUI editor more than 300 seconds) then the backend connection is not closing after 300 seconds as expected.

As a user after creating the connections to the Databases on the SQL editor, if we don't use the connection as per the timeout value then the backend connection must close from the DB.

 Comments   
Comment by Duong Thien Ly [ 2021-12-20 ]

The `timeout` value in the editor is referring to the number of seconds it waits to create a connection to the database. Check REST API docs here
I believe what you're looking for is this https://mariadb.com/docs/reference/mdb/system-variables/interactive_timeout/

Comment by Naresh Chandra [ 2021-12-21 ]

Hi Duong,

If I keep SQL editor session idle then after sometime, sql editor should close the backend connection.
If we can implement this feature would be fine.

Comment by Duong Thien Ly [ 2021-12-21 ]

The connection to the database is currently kept for 24 hours. After that, it'll be closed automatically.

Comment by Naresh Chandra [ 2021-12-22 ]

Can't we reduce this time to 8 hours instead of 24 hours from the Maxscale end.

Comment by Duong Thien Ly [ 2021-12-22 ]

This value is hard-coded in the GUI. Even we allow users to change the value. It won't solve your problem properly. The simplest way is to click the logout button from the menu in the right corner of the page.

Comment by Naresh Chandra [ 2021-12-22 ]

Duong, thanks for the update.

At least, can we make auto logout option. For example if we keep idle then after sometime if its logout from the browser automatically then it would be good.
If we have more users in the organization, this auto logout option very useful for us.

Comment by Duong Thien Ly [ 2021-12-22 ]

I think it was set to 8 hours a while ago but some customers want it to last longer since 8 hours is not enough. So we decided to set it to last for 24 hours.

Comment by Naresh Chandra [ 2021-12-22 ]

okay, thanks for the update.
If possible give an option in the Maxscale.cnf file, so that whoever wants, how many hours they can configure accordingly, it would be good.

Comment by markus makela [ 2022-03-15 ]

I'll convert this to a New Feature since this is expected behavior.

Comment by Naresh Chandra [ 2022-03-15 ]

Thanks Markus.

Generated at Thu Feb 08 04:24:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.