SHOW Statements

  • Jesper Wisborg Krogh


The SHOW statements are the good old workhorse in MySQL for database administrators to obtain information about the schema objects and what happens on the system. While today most of the information can be found in the Information Schema or Performance Schema, the SHOW command is still very popular for interactive use due to its short syntax. This chapter starts out with an overview of how the SHOW statements match up with the Information Schema views and Performance Schema tables. The remainder of the chapter covers SHOW statements that do not have views or tables in the Information Schema and Performance Schema including obtaining engine status information with a little more in-depth view of the InnoDB monitor output provided by the SHOW ENGINE INNODB STATUS statement as well as getting replication and binary log information.

Copyright information

© Jesper Wisborg Krogh 2020

Authors and Affiliations

  • Jesper Wisborg Krogh
    • 1
  1. 1.HornsbyAustralia

Personalised recommendations