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 wrote:
> you can also use EXPLAIN, which will give you much
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
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 ta
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/my
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,
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,> >
]> CC: mysql@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
9:09 +0100
> From: [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
>
time 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...). S
e 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 pe
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
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
http://clk.atdmt.com/UKM/go/msnnkm
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')");
prin
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 tim
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
nal 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 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] / 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 comp
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
qu
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 provid
wrote:
>>- Original Message -
>>From: "Gordan Bobic" <[EMAIL PROTECTED]>
>>To: <[EMAIL PROTECTED]>
>>Sent: Wednesday, November 21, 2001 12:49 PM
>>Subject: Query Execution Time Perl/DBD
>>
>>
>>> Hi.
>>>
>
PM
Subject: Query Execution Time Perl/DBD
> 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
>
> --
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
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 http://www.crici
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
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 check:
26 matches
Mail list logo
