Bug #93403 Opened_streams status variable is missing
Submitted: 29 Nov 2018 12:03 Modified: 1 Aug 2019 13:42
Reporter: Oli Sennhauser Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version:8.0.13 OS:Any
Assigned to: CPU Architecture:Any

[29 Nov 2018 12:03] Oli Sennhauser
Description:
For every Open_xxx status information we do have an Opened_xxx status information:
SQL> show global status like 'open%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| Open_files               | 2     |
| Open_streams             | 0     |
| Open_table_definitions   | 47    |
| Open_tables              | 102   |

| Opened_files             | 23    |
| Opened_table_definitions | 68    |
| Opened_tables            | 126   |
+--------------------------+-------+
Except for Open_streams. Add Opened_streams status information if this feature is still supported. Otherwise remove it.

How to repeat:
SQL> show global status like 'open%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| Open_files               | 2     |
| Open_streams             | 0     |
| Open_table_definitions   | 47    |
| Open_tables              | 102   |

| Opened_files             | 23    |
| Opened_table_definitions | 68    |
| Opened_tables            | 126   |
+--------------------------+-------+

Suggested fix:
Opened_streams status counter should be added.
[1 Aug 2019 13:42] MySQL Verification Team
Hi Olli,

Thank you for your bug report.

I think that this would be a useful feature.
[1 Aug 2019 13:43] MySQL Verification Team
Verified as a feature request.