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 <sureshkumar...@gmail.com>wrote: > 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 <adarsh.sha...@orkash.com > >wrote: > > > Dear all, > > > > I want to know how much time did it take to run a sample query. > > In postgresql, we enable timing by \timing command. > > > > Is there is any way to enable in Mysql > > > > Thanks > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql?** > > unsub=sureshkumar...@gmail.com< > http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com> > > > > > > > -- > Thanks > Suresh Kuna > MySQL DBA > -- Best Regards, Prabhat Kumar MySQL DBA My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat