Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I will fire a select query. I want to know how many disk seeks does that query take. mysql documentation has given formula for full table scan. http://dev.mysql.com/doc/refman/5.1/en/estimating-performance.html

share|improve this question
    
Not sure I get your point very well, but aren't you answering your own question? Quote from the link "For small tables, you can usually find a row in one disk seek (because the index is probably cached). For bigger tables, you can estimate that, using B-tree indexes, you need this many seeks to find a row". It's not talking about full table scan. –  Marian Apr 2 '13 at 10:11
    
The link you posted only discusses indexed scenarios, not full table scans. Are you asking whether MySQL has a way to tell you, for a specific query, how many disk seeks were actually required? The question is unclear. –  Michael - sqlbot Apr 3 '13 at 19:34
    
Are you asking whether MySQL has a way to tell you, for a specific query, how many disk seeks were actually required? Yes. how many disk seeks were made to get the query o/p. –  Karthik Appigatla Apr 5 '13 at 12:24
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.