[MDEV-30543] Request new status variable: Max_used_connections_time Created: 2023-02-02  Updated: 2023-03-30  Resolved: 2023-03-30

Status: Closed
Project: MariaDB Server
Component/s: Server
Fix Version/s: 11.1.1, 11.0.2

Type: Task Priority: Minor
Reporter: Pandikrishnan Gurusamy Assignee: Daniel Black
Resolution: Fixed Votes: 0
Labels: beginner-friendly, compat80

Issue Links:
PartOf
is part of MDEV-28906 MySQL 8.0 desired compatibility Open

 Description   

Max_used_connections_time - The time at which Max_used_connections reached its current value. This will be helpful during the troubleshooting and helpful for the user. MySQL 8 has a similar status variable 

mysql> select version();
 
+-----------+
 
| version() |
 
+-----------+
 
| 8.0.32    |
 
+-----------+
 
1 row in set (0.00 sec)
 
 
 
mysql> show status like 'max_use%';
 
+---------------------------+---------------------+
 
| Variable_name             | Value               |
 
+---------------------------+---------------------+
 
| Max_used_connections      | 20                   |
 
| Max_used_connections_time | 2023-02-02 03:57:19 |
 
+---------------------------+---------------------+
 
2 rows in set (0.00 sec)



 Comments   
Comment by Daniel Black [ 2023-02-02 ]

Good idea. Did you want to contribute some code about here?

Comment by Otto Kekäläinen [ 2023-03-01 ]

Since the submitted was not keen on contributing, Mikhail from my team will take a stab at this some time in March.

Comment by Ahmed Ibrahim [ 2023-03-13 ]

I would like to work on this.

Comment by Otto Kekäläinen [ 2023-03-13 ]

PR already submitted at https://github.com/MariaDB/server/pull/2540

Comment by Otto Kekäläinen [ 2023-03-18 ]

ahmedibrahim Since you had interest in this topic, could you please review https://github.com/MariaDB/server/pull/2540 and add your approval/comments?

Comment by Ahmed Ibrahim [ 2023-03-19 ]

Sure! I will review it

Generated at Thu Feb 08 10:17:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.