# Sys Schema Views - [host\_summary and x$host\_summary Sys Schema Views](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/host_summary-and-xhost_summary-sys-schema-views.md): The host\_summary views provide a high-level overview of activity per client host, including statement counts, file I/O, and connection statistics. - [host\_summary\_by\_file\_io and x$host\_summary\_by\_file\_io Sys Schema Views](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/host_summary_by_file_io-and-xhost_summary_by_file_io-sys-schema-views.md): These views summarize file I/O events grouped by client host, detailing total I/O counts and latency to identify hosts generating heavy disk traffic. - [host\_summary\_by\_file\_io\_type and x$host\_summary\_by\_file\_io\_type Sys Schema Views](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/host_summary_by_file_io_type-and-xhost_summary_by_file_io_type-sys-schema-v.md): These views provide a breakdown of file I/O events by event type (e.g., read, write) for each host, helping to characterize the I/O workload. - [host\_summary\_by\_stages and x$host\_summary\_by\_stages Sys Schema Views](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/host_summary_by_stages-and-xhost_summary_by_stages-sys-schema-views.md): These views summarize statement execution stages grouped by host, showing where threads spend the most time during query processing. - [host\_summary\_by\_statement\_type and x$host\_summary\_by\_statement\_type Sys Schema Views](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/host_summary_by_statement_type-and-xhost_summary_by_statement_type-sys-sche.md): These views aggregate executed statements by type (e.g., SELECT, INSERT) and host, providing statistics on frequency and latency. - [host\_summary\_by\_statement\_latency and x$host\_summary\_by\_statement\_latency Sys Schema Views](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/sys-schema-views-host_summary_by_statement_latency-and-xhost_summary_by_sta.md): These views summarize statement statistics grouped by host, sorted by total latency, helping to identify hosts running the most time-consuming queries. - [innodb\_buffer\_stats\_by\_schema and x$innodb\_buffer\_stats\_by\_schema Sys Schema Views](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/innodb_buffer_stats_by_schema-and-xinnodb_buffer_stats_by_schema-sys-schema.md): These views summarize InnoDB buffer pool usage, showing the amount of memory and number of pages allocated to each database schema. - [innodb\_buffer\_stats\_by\_table and x$innodb\_buffer\_stats\_by\_table Sys Schema Views](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/innodb_buffer_stats_by_table-and-xinnodb_buffer_stats_by_table-sys-schema-v.md): These views provide a granular breakdown of InnoDB buffer pool usage by individual tables, sorted by buffer allocation size. - [innodb\_lock\_waits and x$innodb\_lock\_waits Sys Schema Views](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/innodb_lock_waits-and-xinnodb_lock_waits-sys-schema-views.md): These views summarize lock wait information, linking waiting transactions to blocking transactions to help diagnose deadlocks and contention. - [io\_by\_thread\_by\_latency and x$io\_by\_thread\_by\_latency Sys Schema Views](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/io_by_thread_by_latency-and-xio_by_thread_by_latency-sys-schema-views.md): These views rank threads by I/O latency, making it easier to identify specific threads that are consuming the most disk resources. - [io\_global\_by\_file\_by\_bytes and x$io\_global\_by\_file\_by\_bytes Sys Schema Views](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/io_global_by_file_by_bytes-and-xio_global_by_file_by_bytes-sys-schema-views.md): These views summarize global file I/O statistics grouped by file path, sorted by total bytes read and written. - [io\_global\_by\_file\_by\_latency and x$io\_global\_by\_file\_by\_latency Sys Schema Views](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/io_global_by_file_by_latency-and-xio_global_by_file_by_latency-sys-schema-v.md): These views summarize global file I/O statistics grouped by file path, sorted by total latency to highlight slow I/O targets. - [io\_global\_by\_wait\_by\_bytes and x$io\_global\_by\_wait\_by\_bytes Sys Schema Views](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/io_global_by_wait_by_bytes-and-xio_global_by_wait_by_bytes-sys-schema-views.md): These views summarize global I/O consumers by event name, displaying total bytes read and written to identify high-throughput events. - [io\_global\_by\_wait\_by\_latency and x$io\_global\_by\_wait\_by\_latency Sys Schema Views](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/io_global_by_wait_by_latency-and-xio_global_by_wait_by_latency-sys-schema-v.md): These views summarize global I/O consumers by event name, sorted by total latency, helping to pinpoint slow I/O event types. - [latest\_file\_io and x$latest\_file\_io Sys Schema Views](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/latest_file_io-and-xlatest_file_io-sys-schema-views.md): These views display the most recent file I/O events, providing a real-time look at which files are being accessed by the server. - [memory\_by\_host\_by\_current\_bytes and x$memory\_by\_host\_by\_current\_bytes Views](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/memory_by_host_by_current_bytes-and-xmemory_by_host_by_current_bytes-views.md): These views summarize current memory usage grouped by client host, enabling administrators to track memory consumption per connected host. - [metrics Sys Schema View](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/metrics-sys-schema-view.md): The metrics view consolidates key performance metrics from Global Status, InnoDB Metrics, and memory summaries into a single unified table. - [privileges\_by\_table\_by\_level Sys Schema View](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/privileges_by_table_by_level-sys-schema-view.md): The privileges\_by\_table\_by\_level view lists granted privileges broken down by table and the level (Global, Schema, or Table) at which they were granted. - [schema\_auto\_increment\_columns Sys Schema View](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/schema_auto_increment_columns-sys-schema-view.md): The schema\_auto\_increment\_columns view lists tables with AUTO\_INCREMENT columns, showing the current value and the maximum allowed value for the column type. - [schema\_object\_overview Sys Schema View](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/schema_object_overview-sys-schema-view.md): The schema\_object\_overview view provides a count of different database objects (such as tables, views, and routines) within each schema on the server. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.