Table of contents

• Preamble
• Information Schema configuration
• Information Schema global status queries
  • Aborted clients
  • All clients traffic
  • Comparison of on-disk and memory temporary tables
  • Com_xxx and Handler_xxx variables
  • InnoDB free and dirty space and data read and written
  • InnoDB log buffer write rate
  • Query cache statistics
  • Tables joins performance
• Information Schema InnoDB queries
  • InnoDB buffer pool statistics
  • InnoDB locks
  • InnoDB metrics
• Information Schema remaining tables
  • Processlist
  • Routines
  • Users and Schemas privileges
  • System variables
• References