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? Thanks, Marc --------------------------------------------------------------------- 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