On Tue, Aug 27, 2002 at 05:40:48PM -0400, Marc Prewitt wrote: > I'm trying to put together some statistics on our queries and am wondering > what percentage of our queries involve a full table scan. The variable > which kind of tracks this is Handler_read_rnd_next. However, since a > query may cause multiple Handler_read_rnd_next events to occur to get all > of it's data, I can't directly compare this to the Questions variable. > > However, if I knew how many total Handler_read requests are happening, I > could compare that to Handler_read_rnd_next to get the kind of information > I want. > > However, there is no Handler_read variable. > > Question: is Handler_read = Handler_read_first + Handler_read_key + > Handler_read_next + Handler_read_prev + Handler_read_rnd_next?
There's also a _read_last counter. It's not yet exposed in SHOW STATUS, but it's there. Hmm. Wonder if that's a simple bug or not. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 22 days, processed 469,822,571 queries (236/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
