30.2 Database File I/O and Lock Waits

30.2.1 sys Schema
30.2.2 Database File I/O Graphs and Reports
30.2.3 Lock Waits Report

This chapter describes the Database File I/O and Lock Waits reports. These reports identify I/O hot spots and lock wait contention in your application using the sys schema, thereby enabling you to tune the performance of your queries.

Important

The Database File I/O requires the MySQL sys schema, which is supported on MySQL 5.6 and 5.7, only.

Note

This graph is displayed only if a MySQL instance is selected in the All Targets drop-down menu.