KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm building some profile information for a home grown app. I'd like the debug page to show the query sent along with how many rows were examined without assuming that slow_log is turned on, let alone parsing it. Back in 2006, what I wanted was not possible . Is that still true today? I see Peter Zaitsev has a technique where you: Run FLUSH STATUS; Run the query. Run SHOW STATUS LIKE "Handler%"; and then in the output: Handler_read_next =42250 means 42250 rows were analyzed during this scan which sounds like if MySQL is only examining indexes, it should give you the number. But are there a set of status vars you can poll, add up and find out how many rows examined? Any other ideas?
Tags (comma-separated)
Save Edits
Cancel