InnoDB Performance Monitoring with innotop

Man­u­ally extract­ing rel­e­vant infor­ma­tion from repeated incan­ta­tions of SHOW ENGINE INNODB STATUS while try­ing to fig­ure out what Inn­oDB is doing is not only error prone, it’s just plain hard to do. And since MySQL doesn’t expose the data you really want in an INFORMATION_SCHEMA table (yet?), the option is use an exter­nal pro­gram to help: innotop.