Bug #110877 Timestamp of established connection
| Submitted: | 1 May 2023 16:07 | Modified: | 3 May 2023 12:43 |
|---|---|---|---|
| Reporter: | Oli Sennhauser | Email Updates: | |
| Status: | Analyzing | Impact on me: | |
| Category: | MySQL Server: Performance Schema | Severity: | S4 (Feature request) |
| Version: | 8.0.31 | OS: | Linux (Ubuntu 22.04) |
| Assigned to: | CPU Architecture: | Any (n.a.) | |
| Tags: | Connection, performance schema | ||
[2 May 2023 14:43]
MySQL Verification Team
Hi Mr. Sennhauser, Thank you for your feature request. This would not make just a tiny intervention in the code. Hence, we wish you could define your feature more precisely , which timestamp would you required. The one from the handshake, client handshake parsing, it's response, the server establishing connection, sending back the OK or at any other point. We also require a very precise table in which you would see this info, the title etc .......
[3 May 2023 6:28]
Oli Sennhauser
For troubleshooting purposes the relevant timestamp is the timestamp when the client connection was established. The question to answer is: "When was this connection established?" As I have already written earlier: "It would be cool to have this information in the P_S threads or socket_instances view." Or wherever it fits best...
[3 May 2023 12:43]
MySQL Verification Team
Hi, We shall have it analysed more .......
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
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.
Description: I wanted to find out, when a MySQL connection was established (timestamp). But I did not find these information neither in the performance schema nor elsewhere... I also tried to match the timestamp via O/S means but they do not provide this information. How to repeat: SELECT thread_id, processlist_user, thread_os_id FROM performance_schema.threads WHERE processlist_user = 'app' OR thread_id = 1 LIMIT 3; +-----------+------------------+--------------+ | thread_id | processlist_user | thread_os_id | +-----------+------------------+--------------+ | 1 | NULL | 2055 | | 760 | app | 170388 | +-----------+------------------+--------------+ SELECT so.event_name, so.thread_id, so.socket_id, so.ip, so.port, so.state , th.processlist_user AS user, th.thread_os_id FROM performance_schema.socket_instances AS so JOIN performance_schema.threads AS th ON th.thread_id = so.thread_id WHERE so.event_name LIKE '%client_connection%' ; +--------------------------------------+-----------+-----------+------------------+-------+--------+------+--------------+ | event_name | thread_id | socket_id | ip | port | state | user | thread_os_id | +--------------------------------------+-----------+-----------+------------------+-------+--------+------+--------------+ | wait/io/socket/sql/client_connection | 753 | 39 | | 0 | ACTIVE | root | 6114 | | wait/io/socket/sql/client_connection | 760 | 40 | ::ffff:127.0.0.1 | 56214 | IDLE | app | 170388 | +--------------------------------------+-----------+-----------+------------------+-------+--------+------+--------------+ system lsof -p 2055 | grep -e IP -e unix mysqld 2055 mysql 24u IPv6 28909 0t0 TCP *:33060 (LISTEN) mysqld 2055 mysql 25u unix 0x0000000000000000 0t0 28237 /tmp/mysqlx.sock type=STREAM mysqld 2055 mysql 26u IPv6 28911 0t0 TCP *:3326 (LISTEN) mysqld 2055 mysql 28u unix 0x0000000000000000 0t0 28912 /var/run/mysqld/mysql-3326.sock type=STREAM mysqld 2055 mysql 39u unix 0x0000000000000000 0t0 960023 /var/run/mysqld/mysql-3326.sock type=STREAM mysqld 2055 mysql 40u IPv6 925118 0t0 TCP localhost:3326->localhost:56214 (ESTABLISHED) system ls -la /proc/2055/fd | grep socket lrwx------ 1 mysql mysql 64 May 1 14:57 24 -> socket:[28909] lrwx------ 1 mysql mysql 64 May 1 14:57 25 -> socket:[28237] lrwx------ 1 mysql mysql 64 May 1 14:57 26 -> socket:[28911] lrwx------ 1 mysql mysql 64 May 1 14:57 28 -> socket:[28912] lrwx------ 1 mysql mysql 64 May 1 17:15 40 -> socket:[925118] system stat /proc/2055/fd/40 File: 40 -> socket:[925118] Size: 64 Blocks: 0 IO Block: 1024 symbolic link Device: 17h/23d Inode: 921492 Links: 1 Access: (0700/lrwx------) Uid: ( 1001/ mysql) Gid: ( 1001/ mysql) Access: 2023-05-01 17:21:22.407168685 +0200 Modify: 2023-05-01 17:15:04.220973687 +0200 Change: 2023-05-01 17:15:04.220973687 +0200 Birth: - -> This is wrong! Suggested fix: It would be cool to have this information in the P_S threads or socket_instances view.