Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-io-global-by-file-by-bytes.html
These views summarize global I/O consumers to display amount of I/O, grouped by file. By default, rows are sorted by descending total I/O (bytes read and written). The io_global_by_file_by_bytes and x$io_global_by_file_by_bytes views have these ...
https://dev.mysql.com/doc/refman/8.4/en/sys-io-global-by-file-by-latency.html
These views summarize global I/O consumers to display time waiting for I/O, grouped by file. The io_global_by_file_by_latency and x$io_global_by_file_by_latency views have these columns: file The file path name. total_latency The total wait time of ...
https://dev.mysql.com/doc/refman/8.4/en/sys-io-global-by-wait-by-bytes.html
These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. By default, rows are sorted by descending total I/O (bytes read and written). The io_global_by_wait_by_bytes and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-io-global-by-wait-by-latency.html
These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. The io_global_by_wait_by_latency and x$io_global_by_wait_by_latency views have these columns: event_name The I/O event name, with the ...
https://dev.mysql.com/doc/refman/8.4/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).
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/sys-memory-by-thread-by-current-bytes.html
By default, rows are sorted by descending amount of memory used. The memory_by_thread_by_current_bytes and x$memory_by_thread_by_current_bytes views have these columns: thread_id The thread ID. current_count_used The current number of allocated ...
https://dev.mysql.com/doc/refman/8.4/en/sys-memory-by-user-by-current-bytes.html
By default, rows are sorted by descending amount of memory used. The memory_by_user_by_current_bytes and x$memory_by_user_by_current_bytes views have these columns: user The client user name. Rows for which the USER column in the underlying ...
https://dev.mysql.com/doc/refman/8.4/en/sys-memory-global-by-current-bytes.html
These views summarize memory use, grouped by allocation type (that is, by event). By default, rows are sorted by descending amount of memory used. The memory_global_by_current_bytes and x$memory_global_by_current_bytes views have these columns: ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-usage.html
Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ prefix. The view with the x$ prefix that displays the same values in raw form is intended more for use with other tools that perform ...