[MDEV-7756] Status variables not all alphabetical Created: 2015-03-11  Updated: 2022-09-08

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5, 10.0, 10.1, 10.2
Fix Version/s: 5.5, 10.1

Type: Bug Priority: Trivial
Reporter: Ian Gilfillan Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 0
Labels: verified

Issue Links:
Relates
relates to MDEV-5236 Status variables are not all listed a... Closed

 Description   

Some status variables not listed alphabetically

Bytes_received	250
 
Bytes_sent	243
 
Cassandra_row_inserts	0
 
Cassandra_row_insert_batches	0
 
Cassandra_multiget_keys_scanned	0
 

| Innodb_x_lock_spin_rounds                                    | 50          |
 
| Innodb_x_lock_spin_waits                                     | 0           |
 
| Innodb_page_compression_saved                                | 0           |
 
| Innodb_page_compression_trim_sect512                         | 0           |
 
| Innodb_page_compression_trim_sect1024                        | 0           |
 
... and all innodb_* following



 Comments   
Comment by Elena Stepanova [ 2015-03-12 ]

There are a few more, in 5.5 and 10.0 as well.

| Binlog_snapshot_position                 | 0           |
 
| Binlog_bytes_written                     | 0           |
 
| Binlog_cache_disk_use                    | 0           |
 
| Binlog_cache_use                         | 0           |
 
| Binlog_stmt_cache_disk_use               | 0           |

Comment by Ian Gilfillan [ 2015-04-15 ] 

SHOW STATUS LIKE '%Innodb_num_pages%';
 
+-----------------------------------------+-------+
 
| Variable_name                           | Value |
 
+-----------------------------------------+-------+
 
| Innodb_num_pages_page_compressed        | 0     |
 
| Innodb_num_pages_page_decompressed      | 0     |
 
| Innodb_num_pages_page_compression_error | 0     |
 
| Innodb_num_pages_encrypted              | 0     |
 
| Innodb_num_pages_decrypted              | 0     |
 
+-----------------------------------------+-------+

The latter two variables were renamed in 10.1.4, and are no longer alphabetical.

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