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