latest_file_io and x$latest_file_io Sys Schema Views

These views display the most recent file I/O events, providing a real-time look at which files are being accessed by the server.

Sys Schema views are available from MariaDB 10.6.

Description

The latest_file_io and x$latest_file_io views summarize file I/O activity, grouped by file and thread. Rows are sorted by most recent I/O by default.

The latest_file_io view is intended to be easier for human reading, while the x$latest_file_io view provides the data in raw form, intended for tools that process the data.

They contain the following columns:

Column	Description
thread	Account associated with the thread for foreground threads (port number for TCP/IP connections), or thread name and thread ID for background threads.

total	Total number of occurrences of the I/O event.
file	File path name.
latency	Wait time of the file I/O event.
operation	Type of operation
requested	Number of bytes requested for the file I/O event.

_{This page is licensed: CC BY-SA / Gnu FDL}