Re: measuring query time

2006-06-03 Thread Kyle 

On 6/1/06, Colin Charles [EMAIL PROTECTED] wrote:

Deniz Ersoz wrote:

 Is there a way to get the time spent in the server for each query? Write it
 in a log or append it to the result ???

Will what is in the slow query log help?


See the following:
http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: measuring query time

2006-06-02 Thread Colin Charles 

Deniz Ersoz wrote:
 
Is there a way to get the time spent in the server for each query? Write it

in a log or append it to the result ???


Will what is in the slow query log help?
--
Colin Charles, Community Engineer
MySQL AB, Melbourne, Australia, www.mysql.com
Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528
Mobile: +614 12 593 292 / Skype: colincharles

Using MySQL for a FLOSS application?
http://dev.mysql.com/doc/refman/5.0/en/mysql-floss-license-exception.html


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]