Satendra, Google "show profile" as it may give you all the information that you need. There is a lot more details in the performance_schema if you want to dig into it, but it can be quite difficult to get out. Here is one place to start if you want to pursue that angle: http://www.markleith.co.uk/2011/05/23/monitoring-mysql-io-latency-with-performance_schema/
keith On Mon, Jul 14, 2014 at 5:59 AM, Reindl Harald <h.rei...@thelounge.net> wrote: > > > Am 14.07.2014 12:48, schrieb Satendra: > > Hi there, I'm struggling to find the total time taken by a database query > > on the disk? As I understand when a database query start execution it > takes > > some time inside the database engine & some time to seek the result from > > disk (if that is not in cache/buffer) > > > > Can anybody from the group please suggest any clue about the execution > time > > on the disk? > > mysql can't know this in any useful way > > "disk" can be anyhting, real disk access, VFS and so cache > the application layer knows nothing about > > -- (c) 850-449-1912 (f) 423-930-8646