Hi, You're probably right. All the status variables seem to start over after hitting 4,294,967,295. :-( I don't get why they're only using 32 bit integers for the variables that they know can go WAY over that amount. :-/
Matt ----- Original Message ----- From: "Mikhail Entaltsev" Sent: Friday, January 30, 2004 8:39 AM Subject: Re: key_reads > key_read_requests > Hi, > > I am not sure, but may be you had Key_read_requests overflow. > > Best regards, > Mikhail. > > > ----- Original Message ----- > From: "John David Duncan" > 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]
