you can also use EXPLAIN, which will give you much more details.
On Sun, Jul 31, 2011 at 11:45 PM, Suresh Kuna <sureshkumarilu@stripped>wrote:
> Usually, at the end of the query running it displays the time how much it
> 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.sharma@stripped
> > 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<
> Suresh Kuna
> MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat