Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.11.4, 11.2.1
-
Ubuntu 22.04, n.a.
Description
The view sys.session_ssl_status is empty:
MariaDB [sys]> select * from sys.session_ssl_status;
|
Empty set (0.005 sec)
|
Even thought the P_S is enabled:
show global variables like 'performance_schema';
|
+--------------------+-------+
|
| Variable_name | Value |
|
+--------------------+-------+
|
| performance_schema | ON |
|
+--------------------+-------+
|
The reason is, that the performance_schema.status_by thread does NOT contain any entry about ssl:
select variable_name from `performance_schema`.`status_by_thread` where `VARIABLE_NAME` LIKE 'S%';
|
+---------------------------+
|
| variable_name |
|
+---------------------------+
|
| Select_full_join |
|
| Select_full_range_join |
|
| Select_range |
|
| Select_range_check |
|
| Select_scan |
|
| Slave_connections |
|
| Slow_queries |
|
| Sort_merge_passes |
|
| Sort_priority_queue_sorts |
|
| Sort_range |
|
| Sort_rows |
|
| Sort_scan |
|
+---------------------------+
|
It should contain more or less:
SQL> select variable_name from `performance_schema`.`status_by_thread` where `VARIABLE_NAME` LIKE 'Ssl%';
|
+-----------------------+
|
| variable_name |
|
+-----------------------+
|
| Ssl_cipher |
|
| Ssl_cipher_list |
|
| Ssl_default_timeout |
|
| Ssl_server_not_after |
|
| Ssl_server_not_before |
|
| Ssl_sessions_reused |
|
| Ssl_verify_depth |
|
| Ssl_verify_mode |
|
| Ssl_version |
|
| Ssl_cipher |
|
| Ssl_cipher_list |
|
| Ssl_default_timeout |
|
| Ssl_server_not_after |
|
| Ssl_server_not_before |
|
| Ssl_sessions_reused |
|
| Ssl_verify_depth |
|
| Ssl_verify_mode |
|
| Ssl_version |
|
+-----------------------+
|
to produce such a result:
SQL> select * from sys.session_ssl_status;
|
+-----------+-------------+------------------------+---------------------+
|
| thread_id | ssl_version | ssl_cipher | ssl_sessions_reused |
|
+-----------+-------------+------------------------+---------------------+
|
| 6213 | | | 0 |
|
| 6219 | TLSv1.3 | TLS_AES_256_GCM_SHA384 | 0 |
|
+-----------+-------------+------------------------+---------------------+
|