My Oracle Support Banner

The Sys Schema: Investigating I/O Issues (Doc ID 2042127.1)

Last updated on MARCH 24, 2020

Applies to:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.

Purpose

Learn how to use the sys schema to investigate I/O related issues.

Scope

Detailed general guidance for DBAs already familiar with the sys schema and Performance Schema seeking guidance how to use the sys schema to investigate what is causing I/O.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Overview
 Views
 host_summary_by_file_io
 host_summary_by_file_io_type
 io_by_thread_by_latency
 io_global_by_file_by_bytes
 io_global_by_file_by_latency
 io_global_by_wait_by_bytes
 io_global_by_wait_by_latency
 latest_file_io
 user_summary_by_file_io
 user_summary_by_file_io_type
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.