[MDEV-16340] Implement way to determine which connections are using SSL/TLS Created: 2018-05-30  Updated: 2020-08-25  Resolved: 2020-03-11

Status: Closed
Project: MariaDB Server
Component/s: Server, SSL
Fix Version/s: 10.5.2

Type: Task Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Sergei Golubchik
Resolution: Fixed Votes: 2
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-21156 Feature request - identify secure and... Closed
PartOf
is part of MDEV-6114 merge new P_S instrumentation and tab... Closed

 Description   

There is not currently an easy way to determine which connections are using SSL/TLS. The Performance Schema implementation from MySQL 5.7 added the CONNECTION_TYPE column to the threads table, which does specify whether a given connection is using SSL/TLS:

https://dev.mysql.com/doc/refman/5.7/en/threads-table.html

However, that implementation has not yet been merged into MariaDB. That task is being tracked as MDEV-6114, and it is currently stalled.

If we do not end up merging performance schema from MySQL 5.7, would it make sense to add this information elsewhere? It seems to me that this information would fit nicely in "SHOW FULL PROCESSLIST" output or the information_schema.processlist table.


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