MySQL innotop 설치 & 사용(OpenSUSE 11.2 or Fedora 14, MySQL 5.1.44~5.5.4m3)

MySQL InnoDB 사용자를 위한 모니터링 툴( http://code.google.com/p/innotop/ , http://code.google.com/p/innotop/wiki/Screenshots )

2010/11 에 새 버전이 나와서 update합니다.

* Run as superuser

# wget http://innotop.googlecode.com/files/innotop-1.7.2.tar.gz

# wget http://innotop.googlecode.com/files/innotop-1.8.0.tar.gz

# zypper install perl-DBD-mysql

[참고] # yum install perl-TermReadKey (Fedora의 경우, 빠져 있기 쉬운 패키지)

# tar xvzf innotop-1.8.0.tar.gz

# cd innotop-1.8.0

# perl Makefile.PL

# make install

* Run and enjoy

# innotop -uroot -prootpass --socket /tmp/mysql.sock (socket option 필요 없으면 제외)

* Thannks to aracine( http://code.google.com/u/aracine/ )