From: Michael Widenius Date: August 7 2010 1:47pm Subject: re: InnoDB Spin Stats Not Reported? List-Archive: http://lists.mysql.com/maria/473 Message-Id: <19549.25597.415317.833911@narttu.askmonty.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi! >>>>> "Time" == Time Less writes: Time> MariaDB [(none)]> status Time> ... Time> Server version: 5.1.44-MariaDB-mariadb75 <--not the newest, but... Time> MariaDB [(none)]> show innodb status; Time> ... Time> Mutex spin waits 68, rounds 1930, OS waits 64 <--something Time> MariaDB [(none)]> show global status like '%spin%'; Time> Empty set (0.00 sec) <--nothing?! Time> Why are InnoDB spin rounds, spin waits, OS waits not reported? I rewrote a Time> Ganglia plugin to graph stats and assumed I didn't need to parse "show Time> innodb status" anymore. Should I revisit my assumptions? The engine developers can themselves decide which status variables they export. In this case the InnoDB & XtraDB developers has decide it's not critical to show the above variables to the end user. In MySQL 5.5 (and MariaDB 5.5) we will have a new interface that allows one easily monitor mutex usage. http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html If you want something before that, you can alway submit a patch for XtraDB about adding the variables you deem critical to show status. Regards, Monty