MYSQL常用命令

SHOW INNODB ENGINE STATUS\G;

SHOW VARIABLES LIKE 'innodb_version'\G;

show variables like 'innodb _%io_threads'\G;

show variables like 'innodb_buffer_pool_size'\G;

show vaiables like 'innodb_log_buffer_size'\G;

show variables like 'innodb_additional_mem_pool_size'\G;

innodb memory:

log_buffer

innodb_buffer_pool

innodb_additional_mem_pool_size

查看索引：

show index from table\G;

验证SQL:

FLUSH STATUS;

SELECT ...

SHOW SESSION STATUS LIKE '%sort%';

查看session信息：

show session status like .............;