MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 661 to 670 of 679 total results

30.4.3.2 The host_summary_by_file_io and x$host_summary_by_file_io Views

https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-file-io.html

By default, rows are sorted by descending total file I/O latency. The host_summary_by_file_io and x$host_summary_by_file_io views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying ...

30.4.3.4 The host_summary_by_stages and x$host_summary_by_stages Views

https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-stages.html

By default, rows are sorted by host and descending total latency. The host_summary_by_stages and x$host_summary_by_stages views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying ...

30.4.3.5 The host_summary_by_statement_latency and x$host_summary_by_statement_latency Views

https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-statement-latency.html

The host_summary_by_statement_latency and x$host_summary_by_statement_latency views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to ...

30.4.3.6 The host_summary_by_statement_type and x$host_summary_by_statement_type Views

https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-statement-type.html

These views summarize information about statements executed, grouped by host and statement type. By default, rows are sorted by host and descending total latency. The host_summary_by_statement_type and x$host_summary_by_statement_type views have ...

30.4.3.15 The latest_file_io and x$latest_file_io Views

https://dev.mysql.com/doc/refman/8.0/en/sys-latest-file-io.html

These views summarize file I/O activity, grouped by file and thread. The latest_file_io and x$latest_file_io views have these columns: thread For foreground threads, the account associated with the thread (and port number for TCP/IP connections).

30.4.3.16 The memory_by_host_by_current_bytes and x$memory_by_host_by_current_bytes Views

https://dev.mysql.com/doc/refman/8.0/en/sys-memory-by-host-by-current-bytes.html

By default, rows are sorted by descending amount of memory used. The memory_by_host_by_current_bytes and x$memory_by_host_by_current_bytes views have these columns: host The host from which the client connected. Rows for which the HOST column in the ...

30.4.3.22 The processlist and x$processlist Views

https://dev.mysql.com/doc/refman/8.0/en/sys-processlist.html

The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. They provide more complete information than the SHOW PROCESSLIST statement and the INFORMATION_SCHEMA PROCESSLIST table, ...

30.4.3.50 The waits_by_host_by_latency and x$waits_by_host_by_latency Views

https://dev.mysql.com/doc/refman/8.0/en/sys-waits-by-host-by-latency.html

These views summarize wait events, grouped by host and event. By default, rows are sorted by host and descending total latency. The waits_by_host_by_latency and x$waits_by_host_by_latency views have these columns: host The host from which the ...

30.4.3.51 The waits_by_user_by_latency and x$waits_by_user_by_latency Views

https://dev.mysql.com/doc/refman/8.0/en/sys-waits-by-user-by-latency.html

These views summarize wait events, grouped by user and event. By default, rows are sorted by user and descending total latency. The waits_by_user_by_latency and x$waits_by_user_by_latency views have these columns: user The user associated with the ...

7.3 The mysql System Schema

https://dev.mysql.com/doc/refman/8.0/en/system-schema.html

It contains tables that store information required by the MySQL server as it runs. A broad categorization is that the mysql schema contains data dictionary tables that store database object metadata, and system tables used for other operational ...

Displaying 661 to 670 of 679 total results