https://www.percona.com/blog/webinar-introduction-mysql-sys-schema-follow-questions/
Webinar: Introduction to MySQL SYS Schema follow up questions - Percona
Mar 25, 2026 - Mysql Sys Schema, Performance Schema
introduction to mysqlsys schemafollow upwebinarquestions
https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views
Sys Schema Views | Server | MariaDB Documentation
Explore sys_schema views in MariaDB Server. These views offer simplified, aggregated insights into server performance, I/O, and memory usage, making...
sys schemaviewsservermariadbdocumentation
https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/innodb_lock_waits-and-xinnodb_lock_waits-sys-schema-views
innodb_lock_waits and x$innodb_lock_waits Sys Schema Views | Server | MariaDB Documentation
These views summarize lock wait information, linking waiting transactions to blocking transactions to help diagnose deadlocks and contention.
and xsys schemainnodblockwaits
https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/host_summary-and-xhost_summary-sys-schema-views
host_summary and x$host_summary Sys Schema Views | Server | MariaDB Documentation
The host_summary views provide a high-level overview of activity per client host, including statement counts, file I/O, and connection statistics.
host summaryand xsys schemaviewsserver
https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_sys_tables-table
Information Schema INNODB_SYS_TABLES Table | Server | MariaDB Documentation
The INNODB_SYS_TABLES table exposes the internal InnoDB data dictionary metadata for tables, including row formats and space IDs.
information schemainnodbsystablesserver
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
io_global_by_file_by_latency and x$io_global_by_file_by_latency Sys Schema Views | Server | MariaDB...
These views summarize global file I/O statistics grouped by file path, sorted by total latency to highlight slow I/O targets.
io globalby fileand x
https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/schema_auto_increment_columns-sys-schema-view
schema_auto_increment_columns Sys Schema View | Server | MariaDB Documentation
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.
auto incrementview serverschemacolumnssys