注:下面有可能是缩写,都是从资料中找出来的,所以请好好回忆一下!
SHOW_NDBCLUSTER_STATUS;
SHOW_MUTEX_STATUS;
ASSIGN_TO_KEYCACHE;
PRELOAD_KEYS;
SHOW_BINLOGS;
HA_OPEN;
HA_CLOSE;
HA_READ;
DELETE_MULTI;
UPDATE_MULTI;
CREATE_SPFUNCTION;
补充:我想问下SHOW_PROFILE和SHOW_PROFILES有什么区别?
SHOW_NDBCLUSTER_STATUS;
SHOW_MUTEX_STATUS;
ASSIGN_TO_KEYCACHE;
PRELOAD_KEYS;
SHOW_BINLOGS;
HA_OPEN;
HA_CLOSE;
HA_READ;
DELETE_MULTI;
UPDATE_MULTI;
CREATE_SPFUNCTION;
补充:我想问下SHOW_PROFILE和SHOW_PROFILES有什么区别?
Empty set (0.00 sec)mysql> use test;
Database changed
mysql> show profiles;
Empty set (0.00 sec)mysql> select @@profiling;
+-------------+
| @@profiling |
+-------------+
| 0 |
+-------------+
1 row in set (0.00 sec)mysql> set profiling =1;
Query OK, 0 rows affected (0.01 sec)mysql> show profile;
Empty set (0.01 sec)mysql> show profiles;
Empty set (0.00 sec)mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| jifen_table |
| musicbean |
| t1 |
| test2 |
| test_datetime |
+----------------+
5 rows in set (0.11 sec)mysql> create table student(id int,name char(20),birthday timestamp);
Query OK, 0 rows affected (0.08 sec)mysql> show profile;
+----------------------+----------+
| Status | Duration |
+----------------------+----------+
| starting | 0.019191 |
| checking permissions | 0.000139 |
| creating table | 0.058486 |
| After create | 0.000008 |
| query end | 0.000009 |
| freeing items | 0.000034 |
| logging slow query | 0.000001 |
| cleaning up | 0.000002 |
+----------------------+----------+
8 rows in set (0.00 sec)
第二个是关于InnoDB互斥量的信息
第五个和mysqlbinlog类似,用来显示二进制日志里的事件
第六个到第八个用来操纵HANDLER,较底层操纵数据的方式
其他的我也没见过~
show profile是显示最近一次语句执行的情况;加s显示一个语句列表,通过这个列表可以看到各个语句的query_id,show profile可以使用这个id来定位某个语句。列表的长度由一个系统变量控制~