From: Prabhat Kumar Date: August 1 2011 3:54pm Subject: Re: How to view Query Execution time List-Archive: http://lists.mysql.com/mysql/225457 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=bcaec51a8dfcdb5fd604a973a6d2 --bcaec51a8dfcdb5fd604a973a6d2 Content-Type: text/plain; charset=ISO-8859-1 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 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 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=sureshkumarilu@stripped< > http://lists.mysql.com/mysql?unsub=sureshkumarilu@stripped> > > > > > > > -- > 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 --bcaec51a8dfcdb5fd604a973a6d2--