[MDEV-28496] show full processlist does not show the tcp ports Created: 2022-05-06  Updated: 2022-07-18  Resolved: 2022-07-18

Status: Closed
Project: MariaDB Server
Component/s: Admin statements
Affects Version/s: 10.5.13
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Francisco Panis Kaseker Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None
Environment:

centos 7


 Description   

show full processlist; or SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST; just show the "localhost" connections without the tcp port used.

I tested doing a localhost connection thorugh 3306 and I confirmed that the port did not appear.

is this expected for localhost connections?

 Comments   
Comment by Daniel Black [ 2022-05-09 ]

Could it be the localhost connections where a unix socket based and TCP wasn't actually used? Look at \s on the mysql prompt. Try also with --protocol tcp for a comparison.

Comment by Francisco Panis Kaseker [ 2022-05-23 ]

I manually did some tcp connectins and I still can not see the port. I tried \s and --protocol and I still can not see the ports.

Server: MariaDB
Server version: 10.5.13-MariaDB-log MariaDB Server
Protocol version: 10

Comment by Sergei Golubchik [ 2022-06-12 ]

Does \s show

Connection:             localhost via TCP/IP

?
What does \s show for current user?

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