Skip to content

Instantly share code, notes, and snippets.

@bluerabbit

bluerabbit/gist:7762553

Created December 3, 2013 01:48
Show Gist options
  • Save bluerabbit/7762553 to your computer and use it in GitHub Desktop.
Save bluerabbit/7762553 to your computer and use it in GitHub Desktop.
Download ZIP
innodb_monitor, innodb_lock_monitorを有効にする
Raw
gistfile1.md

有効にする

CREATE TABLE innodb_monitor (a INT) ENGINE=INNODB;
CREATE TABLE innodb_lock_monitor (a INT) ENGINE=INNODB;

確認する

select @@datadir

@@datadirディレクトリにある{コンピュータ名}.errに数秒おきにログが出力される

無効にする

drop table innodb_monitor;
drop table innodb_lock_monitor;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment