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=gcdmg-mysql-2@m.gmane.org
--20cf305643b9a9b8df04a96bfa07
Content-Type: text/plain; charset=ISO-8859-1
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
> 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@gmail.com
>
>
--
Thanks
Suresh Kuna
MySQL DBA
--20cf305643b9a9b8df04a96bfa07--
--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-inform ation.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
> 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
>
> > 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@gmail.com<
> http://lists.mysql.com/mysql?unsub=sureshkumarilu@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
--bcaec51a8dfcdb5fd604a973a6d2--
--f46d04389287699bdb04a975d773
Content-Type: text/plain; charset=ISO-8859-1
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
> you can also use EXPLAIN, which will give you much more details.
> http://dev.mysql.com/doc/refman/5.5/en/execution-plan-inform ation.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
>
> > 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
> >
> > > 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@gmail.com<
> > http://lists.mysql.com/mysql?unsub=sureshkumarilu@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
>
--f46d04389287699bdb04a975d773--