innodb存儲(chǔ)引擎監(jiān)控

     innodb存儲(chǔ)引擎監(jiān)控分為四種,表監(jiān)控,表空間監(jiān)控,鎖監(jiān)控,狀態(tài)監(jiān)控.可以在mysql客戶端開(kāi)啟監(jiān)控選項(xiàng),然后信息將會(huì)輸出在mysql的錯(cuò)誤日志內(nèi).innodb_monitor和innodb_lock_monitor會(huì)每隔15秒會(huì)向錯(cuò)誤日志中記錄InnoDB監(jiān)控信息,innodb_table_monitor和innodb_tablespace_monitor是每隔64秒.

1.對(duì)innodb狀態(tài)監(jiān)控

create table innodb_monitor (a int) engine=innodb;   --開(kāi)啟監(jiān)控

drop table innodb_monitor;          --關(guān)閉監(jiān)控

2.對(duì)innodb鎖監(jiān)控

create table innodb_lock_monitor (a int) engine=innodb;   --開(kāi)啟監(jiān)控

drop table innodb_lock_monitor;      --關(guān)閉監(jiān)控

3.對(duì)innodb的表監(jiān)控

create table innodb_table_monitor(a int) engine=innodb;    --開(kāi)啟監(jiān)控

drop tables innodb_table_monitor;     --關(guān)閉監(jiān)控

4.對(duì)innodb表空間監(jiān)控

create table innodb_tablespace_monitor (a int) engine=innodb;   --開(kāi)啟監(jiān)控

drop table innodb_tablespace_monitor;        --關(guān)閉監(jiān)控