Re: Innodb Performance Measurement

2005-06-27 Thread Gleb Paharenko
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: > Greetin

Innodb Performance Measurement

2005-06-26 Thread Manoj
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 b