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:
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.comwrote:
Dear all,
I want to know
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
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 aim.prab...@gmail.comwrote:
you can also use EXPLAIN,
Hi,
When performing a SQL query like SELECT Name FROM Customers. How do I obtain
the time in which the query took to execute like 1.5 seconds etc
Thanks,
Neil
_
All new Live Search at Live.com
Greetings Niel,
Not much detail there (but I'll go off what you provided...). Some people
limit the actual MySQL system for times it TAKES MySQL to execute queries.
For THIS to be accomplished, MySQL has built-in functionality to measure the
time is takes queries to take place so it can ... limit
the query actually took or do I need to do this outside of my query.
Regards
Neil
Date: Wed, 14 May 2008 07:21:04 -0400From: [EMAIL PROTECTED]: [EMAIL
PROTECTED]: Re: Query execution time - MySQLCC: [EMAIL PROTECTED] Niel,Not much
detail there (but I'll go off what you provided...). Some people limit
actually took or do I need to do this outside of my query.
Regards
Neil
Date: Wed, 14 May 2008 07:21:04 -0400From: [EMAIL PROTECTED]: [EMAIL
PROTECTED]: Re: Query execution time - MySQLCC: [EMAIL PROTECTED] Niel,Not much
detail there (but I'll go off what you provided...). Some people limit
: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Query execution time - MySQL
If you using C++ then you can use this:
http://developer.gimp.org/api/2.0/glib/glib-Timers.html
I use this in my code, does an excelent job.
Also you
@lists.mysql.com Subject: Re: Query execution time -
MySQL Hi Neil, If your using Linux then you have to install the glib
RPM's in the usual way. I don't know about other platforms, but I am sure
there will be a version of glib out there... Also ensure the correct
include and link directives
Thanks for your help. In the end I've decided to use GetTickCount()
Neil
Date: Wed, 14 May 2008 13:44:22 +0100 From: [EMAIL PROTECTED] To: [EMAIL
PROTECTED] CC: mysql@lists.mysql.com Subject: Re: Query execution time -
MySQL Hi Neil, If your using Linux then you have to install
Neil Tompkins wrote:
Thanks for your help. In the end I've decided to use GetTickCount()
Neil
Date: Wed, 14 May 2008 13:44:22 +0100 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: Query execution time - MySQL Hi Neil, If your using Linux then you
joe mcguckin [EMAIL PROTECTED] wrote:
Does the mysql server return to the client (DBI in this case) the query
execution time? If so, how do I retrieve it?
my $_startTime = time;
$dbh-do(INSERT INTO dinner VALUES ('chicken','grille'));
print Execution time: .(time - $_startTime).\n;
Like
As far as I know there isn't a way, though ideally there should be to do so.
I would also look more for the answer and ask you to post it on the PER
DBI mailinglist.
Thanks
Aman Raheja
joe mcguckin wrote:
Does the mysql server return to the client (DBI in this case) the query
execution time
Does the mysql server return to the client (DBI in this case) the query
execution time? If so, how do I retrieve it?
Thanks,
Joe
--
Joe McGuckin
ViaNet Communications
994 San Antonio Road
Palo Alto, CA 94303
Phone: 650-213-1302
Cell: 650-207-0372
Fax: 650-969-2124
--
MySQL General
# [EMAIL PROTECTED] / 2003-06-24 20:32:48 -0700:
insert into table1 select * from table2;
Table2 has some 10,000 records while table1 has around
11,00,000 records. The time reqd. to execute the above
query is round about 80- 90 secs.
The table1 has 7 columns out of which 5 are composite
I think we need more info: Table definition, MySQL version etc..
Med venlig hilsen
Lars Geisler
-Original Message-
From: Roman Neuhauser [EMAIL PROTECTED]
To: Amit Lonkar [EMAIL PROTECTED]
CC: [EMAIL PROTECTED] [EMAIL PROTECTED]
Subject: Re: Query Execution Time in mysql
Sent
Message-
From: Amit Lonkar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 9:33 PM
To: [EMAIL PROTECTED]
Subject: Query Execution Time in mysql
Hi All,
I have 2 tables say table1 and table2 in the
database. I am using the following query to copy all
the data from table2
Hi All,
I have 2 tables say table1 and table2 in the
database. I am using the following query to copy all
the data from table2 to table1.
insert into table1 select * from table2;
Table2 has some 10,000 records while table1 has around
11,00,000 records. The time reqd. to execute the above
query
Hi.
How do I get the query execution time from Perl/DBD? MySQL client returns
this in the console window. Is this value available through the Perl DBD
interface?
Thanks.
Gordan
-
Before posting, please check:
http
not know. but in java it would be
long tb = System.currentTimeMillis();
// do the sql-statement
long diff = System.currentTimeMillis() - tb;
- Original Message -
From: Gordan Bobic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 21, 2001 12:49 PM
Subject: Query Execution Time
On Wednesday 21 Nov 2001 12:11, Christian Andersson wrote:
The obvious way to do this would be to get the time before and after the
execution and then make a simple diff (after - before) I guess that is how
the mysql client does it (butI'm not sure)
I do not think that mysql itself provides
Hi
Within mysql, all queries return the time taken to execute, ie
20 rows in set (0.77 sec)
35 rows in set (1.33 sec)
etc.
Is it possible within perl, or C for that matter, to get the time taken for the MySql
server to get the data ?
Thanx
Simon
--
Simon Windsor
CricInfo
hi there,
at the mysql prompt i can get the exact time taken to run each query.
how can i display this time in an HTML page via PHP. is there a function
which gives me this time
bye
Mathew
-
Before posting, please
Hi,
at the mysql prompt i can get the exact time taken to run each query.
how can i display this time in an HTML page via PHP. is there a function
which gives me this time
Unfortunately, no, there isn't a built-in function to do this. So, you'll
have to resort to some DIY. But, it's quite
25 matches
Mail list logo