measuring components of query execution time such disk io, processor time etc.?

[Rizwan Mian]

Hi Guys,

I am building a queuing network model of my MySQL database. And I need to determine service demands of different types of queries on MySQL. For that, I need to measure different components of execution time of a query. That is, execution time of a query broken down into its components such as processor time, disk io, memory io etc.

I know I can measure execution time of a query using the Query log, Query browser, or the benchmark factory. However, I need to measure the components of execution time. Is there a way for me to get that information out of MySQL please?

I have looked through MySQL forums, documentation and the web.

--
Rizwan Mian
Graduate Student
Computer Science
Queens University
http://ca.linkedin.com/in/rizwanmian