RE: How to log the execution time of each query

I would like to log the execution time for each query in my MySQL server .Is there any possible way? If you are using MySQL to serve an application, then it is advisable to do the logging through the application scripts. For in most cases, you might require more information other than time

Re: How to log the execution time of each query

Saha, Mukul (Cognizant) schrieb: Hi, I would like to log the execution time for each query in my MySQL server .Is there any possible way? Please not that, the - log-slow-queries option will not suffice for my requirement. Thanks Regards Mukul Saha Hi, Well there is no option for

Re: How to log the execution time of each query

Actually, you can log every query, with the general query log: http://dev.mysql.com/doc/refman/5.0/en/query-log.html be warned that enabling this is a good way to fill up your disks though since it logs inserts and updates complete with data. The general query log does not appear to log

How to log the execution time of each query

Hi, I would like to log the execution time for each query in my MySQL server .Is there any possible way? Please not that, the - log-slow-queries option will not suffice for my requirement. Thanks Regards Mukul Saha ___ Cognizant Technology