Sys Schema Views
You are viewing an old version of this category. View
the current version here.
This article is currently incomplete.
-
host_summary and x$host_summary Sys Schema Views
Host activity information. -
host_summary_by_file_io and x$host_summary_by_file_io Sys Schema Views
Summarize file I/O, grouped by host, sorted by descending total file I/O latency by default. -
host_summary_by_file_io_type and x$host_summary_by_file_io_type Sys Schema Views
Summary of file I/O, grouped by host and event type. -
host_summary_by_stages and x$host_summary_by_stages Sys Schema Views
Statement stages summary, grouped by host. -
host_summary_by_statement_latency and x$host_summary_by_statement_latency Sys Schema Views
Summary of statement statistics, grouped by host, rows sorted by descending... -
host_summary_by_statement_type and x$host_summary_by_statement_type Sys Schema Views
Summary of executed statement information, grouped by host and statement type. -
innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Sys Schema Views
Information Schema INNODB_BUFFER_PAGE summary information, grouped by schema. -
innodb_buffer_stats_by_table and x$innodb_buffer_stats_by_table Sys Schema Views
Summary of Information Schema INNODB_BUFFER_PAGE information, grouped by schema and table. -
io_by_thread_by_latency and x$io_by_thread_by_latency Sys Schema Views
Summary of I/O consumers to display time waiting for I/O, grouped by thread. -
io_global_by_file_by_bytes and x$io_global_by_file_by_bytes Sys Schema Views
Summary of global I/O consumers showing I/O in bytes grouped by file. -
io_global_by_file_by_latency and x$io_global_by_file_by_latency Sys Schema Views
Summary of global I/O consumers to display time waiting for I/O, grouped by file. -
io_global_by_wait_by_bytes and x$io_global_by_wait_by_bytes Sys Schema Views
Summary of global I/O consumers, displaying amount of I/O and time waiting ... -
io_global_by_wait_by_latency and x$io_global_by_wait_by_latency Sys Schema Views
Summary of global I/O consumers, displaying I/O and time waiting for I/O, grouped by event. -
latest_file_io and x$latest_file_io Sys Schema Views
Summary of file I/O activity, grouped by file and thread. -
metrics Sys Schema View
Global status variables, InnoDB metrics, memory allocation and the current time. -
privileges_by_table_by_level Sys Schema View
Granted privileges broken down by table, level on which they were granted. -
schema_auto_increment_columns Sys Schema View
AUTO_INCREMENT info, sorted by descending usage ratio and maximum column value. -
schema_object_overview Sys Schema View
A count of the number of objects within each schema, sorted by schema and object.
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.