show engine innodb status \G;
\G:表示将查询结果进行按列打印,横向表格纵向输出,可以使每个字段打印到单独的行
注意:第三方工具(如:Navicat)执行此语句会报错:1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\G' at line 1