#### **查询的是mysql的io操作** ***** ```sql show status like 'innodb_data_r%'; show status like 'innodb_data_w%'; show status like 'innodb_log_wrt%'; show status like 'innodb_db'; ``` #### **查询表索引使用的情况** ***** ```sql show indexes from table_name; ``` #### **查看数据库表的底层大小以及表结构** ***** ```sql show table status like 'table_name'; ``` #### **创建 MySQL 账号** ***** ```sql create user 'songshijie'@'%' identified by '123456'; ``` #### **查看 MySQL 系统变量** ***** ```sql show variables; ```