Nov 10, 2018

Optimization tools of MySQL Workbench

  • The Performance Dashboard in the MySQL Workbench provides at-a-glance views of key metrics of network traffic, server activity, and InnoDB storage. 
  • Performance Reports for analyzing IO hotspots, high-cost SQL statements, Wait statistics, and InnoDB engine metrics; 
  • Visual Explain Plans that offer graphical views of SQL statement execution; 
  • Query Statistics that report on client timing, network latency, server execution timing, index use, rows scanned, joins, temporary storage use, and other operations.