Aria Status Variables

This page documents status variables related to the Aria storage engine. See Server Status Variables for a complete list of status variables that can be viewed with SHOW STATUS.

See also the Full list of MariaDB options, system and status variables.

Aria_pagecache_blocks_not_flushed

• Description: The number of dirty blocks in the Aria page cache. The global value can be flushed by FLUSH STATUS.
• Scope: Global
• Data Type: numeric

Aria_pagecache_blocks_unused

• Description: Free blocks in the Aria page cache. The global value can be flushed by FLUSH STATUS.
• Scope: Global
• Data Type: numeric

Aria_pagecache_blocks_used

• Description: Blocks used in the Aria page cache. The global value can be flushed by FLUSH STATUS.
• Scope: Global
• Data Type: numeric

Aria_pagecache_read_requests

• Description: The number of requests to read something from the Aria page cache.
• Scope: Global
• Data Type: numeric

Aria_pagecache_reads

• Description: The number of Aria page cache read requests that caused a block to be read from the disk.
• Scope: Global
• Data Type: numeric

Aria_pagecache_write_requests

• Description: The number of requests to write a block to the Aria page cache.
• Scope: Global
• Data Type: numeric

Aria_pagecache_writes

• Description: The number of blocks written to disk from the Aria page cache.
• Scope: Global
• Data Type: numeric

Aria_transaction_log_syncs

• Description: The number of Aria log fsyncs.
• Scope: Global
• Data Type: numeric