Re: How to view Query Execution time

2011-08-01 Thread Jon Siebert
http://dev.mysql.com/doc/refman/5.1/en/query-log.html information on query log may become useful for you in the future. Also, search the slow query log, which also may help you in the future On Mon, Aug 1, 2011 at 11:54 AM, Prabhat Kumar wrote: > you can also use EXPLAIN, which will give you much

Re: How to view Query Execution time

2011-08-01 Thread Prabhat Kumar
you can also use EXPLAIN, which will give you much more details. http://dev.mysql.com/doc/refman/5.5/en/execution-plan-information.html http://www.techiequest.com/mysql-visual-explain-hierarchical-view-of-query-execution-plan/ On Sun, Jul 31, 2011 at 11:45 PM, Suresh Kuna wrote: > Usually, at the

Re: How to view Query Execution time

2011-07-31 Thread Suresh Kuna
Usually, at the end of the query running it displays the time how much it took. Or else enable the profiling and run the query to check the exact time it took for execution at all levels. On Mon, Aug 1, 2011 at 12:11 PM, Adarsh Sharma wrote: > Dear all, > > I want to know how much time did it ta