MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs

Appendix A: References

MySQL includes several views and tables in the Performance Schema, sys schema, and Information Schema that provide information that you can use when investigating issues. This appendix includes a quick reference to the resources most useful in connection with this book. For the object and lock types in the performance_schema.metadata_locks table, lists of possible values are also included. Finally, there is a brief description of each of the sections of the InnoDB monitor.

Tip

MySQL Workbench includes several performance reports that are based on the sys schema views. This allows you to use a graphical user interface to obtain the information discussed here. The interface also allows you to change the ordering of the rows. ...