[MDEV-25286] Docu: aria status in docu does not reflect reality Created: 2021-03-29  Updated: 2021-04-29

Status: Open
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: 10.5.9
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Oli Sennhauser Assignee: Ian Gilfillan
Resolution: Unresolved Votes: 0
Labels: None
Environment:

n.a.



 Description   

1. Docu here: https://mariadb.com/kb/en/aria-status-variables/
could be more clear that:

  • Aria_pagecache_blocks_unused is the current state
  • Aria_pagecache_blocks_used is a high water mark from somewhen in the past

2. Docu here: https://mariadb.com/kb/en/aria-status-variables/
and here: https://mariadb.com/kb/en/flush/#flush-status

states that this 3 status variables:

Aria_pagecache_blocks_not_flushed
Aria_pagecache_blocks_unused
Aria_pagecache_blocks_used

can be reset with flush status. This does IMHO technically not make sense (at least for not_flushed and unused, possibly it does make sense for the high water mark used) but experiments show that flush status does not reset the values:

root@mariadb-105 [test] SQL> show global status like 'aria%';
-----------------------------------------+

Variable_name Value

-----------------------------------------+

Aria_pagecache_blocks_not_flushed 234
Aria_pagecache_blocks_unused 15396
Aria_pagecache_blocks_used 251
Aria_pagecache_read_requests 102435
Aria_pagecache_reads 50
Aria_pagecache_write_requests 33141
Aria_pagecache_writes 100
Aria_transaction_log_syncs 20

-----------------------------------------+
8 rows in set (0.001 sec)

root@mariadb-105 [test] SQL> flush status;
Query OK, 0 rows affected (0.000 sec)

root@mariadb-105 [test] SQL> show global status like 'aria%';
-----------------------------------------+

Variable_name Value

-----------------------------------------+

Aria_pagecache_blocks_not_flushed 202
Aria_pagecache_blocks_unused 15396
Aria_pagecache_blocks_used 251
Aria_pagecache_read_requests 102435
Aria_pagecache_reads 50
Aria_pagecache_write_requests 33141
Aria_pagecache_writes 132
Aria_transaction_log_syncs 20

-----------------------------------------+
8 rows in set (0.001 sec)

root@mariadb-105 [test] SQL> flush tables;
Query OK, 0 rows affected (0.042 sec)

root@mariadb-105 [test] SQL> flush status;
Query OK, 0 rows affected (0.000 sec)

root@mariadb-105 [test] SQL> show global status like 'aria%';
-----------------------------------------+

Variable_name Value

-----------------------------------------+

Aria_pagecache_blocks_not_flushed 0
Aria_pagecache_blocks_unused 15647
Aria_pagecache_blocks_used 251
Aria_pagecache_read_requests 102435
Aria_pagecache_reads 50
Aria_pagecache_write_requests 33142
Aria_pagecache_writes 335
Aria_transaction_log_syncs 21

-----------------------------------------+
8 rows in set (0.001 sec)

This should be fixed or at least clarified...


Generated at Thu Feb 08 09:36:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.