Hello.
A lot of statistics you could get from 'SHOW INNODB STATUS'. For example 'FILE I/O', 'INSERT BUFFER AND ADAPTIVE HASH INDEX', 'BUFFER POOL AND MEMORY' could be helpful. See: http://dev.mysql.com/doc/mysql/en/innodb-monitor.html Manoj <[EMAIL PROTECTED]> wrote: > Greetings, > I am using MySQL 4.0.24 and all my tables use InnoDB as default > engine. I was interested in finding out the performance of my Buffer > space. How can i do it?. If I were to use MyISQM tables, I could have > looked at the parameters Key_read_request & key_reads to find out the > hit rate but am not aware of how to do the same for Innodb hence any > help would be appreciated. > > Cheers > > Manoj > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
