This is a read-only copy of the MariaDB Knowledgebase generated on 2024-12-22. For the latest, interactive version please visit https://mariadb.com/kb/.

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

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.