Mysql Query Optimization-Show command

Mysql Query Optimization-Show command we can view MySQL status and variables through the show command to find the System Bottleneck: mysql> show status -- display status information (Extended show status like 'xxx') Mysql> show variables -- display system variables (Extended show variables like 'xxx ') mysql> show innodb status -- display the InnoDB Storage engine status Mysql> show processlist -- view the current SQL Execution, shell> mysqladmin variables-u username-p password -- display system variable Shell> mysqladmin extended-status-u username-p password -- display status information