Hi, I am not sure, but may be you had Key_read_requests overflow.
Best regards, Mikhail. ----- Original Message ----- From: "John David Duncan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 29, 2004 11:40 PM Subject: key_reads > key_read_requests > Hi, > > key_reads is usually a small fraction of key_read_requests, > but in the case of the server below, key_reads is actually > GREATER than key_read_requests. Can anyone explain what would > cause that to happen? > > - JD > > mysql> show status like 'key%'; > +--------------------+-----------+ > | Variable_name | Value | > +--------------------+-----------+ > | Key_blocks_used | 997521 | > | Key_read_requests | 42804277 | > | Key_reads | 70150022 | > | Key_write_requests | 236384514 | > | Key_writes | 130961162 | > +--------------------+-----------+ > 5 rows in set (0.00 sec) > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]