# Sys Schema Views

- [host\_summary and x$host\_summary Sys Schema Views](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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](/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.