I have a need to find out how long each of the queries executed against a mysql server are taking.
I found this post, which indicates that this information can be found in the general query log: http://www.phpbuilder.com/mail/php-general/2002122/0876.php The manual note about it says the binary update log includes execution times for writes only, and if you want timing info for general queries, to use the general query log. However, the output in my general query log (v3.23.54) only has a timestamp, not an execution time. So, a few questions... 1) Has this changed in 4.0? 2) Are there options to get this info put in the log (in 3.23 or otherwise)? 3) Does anybody have a better way to get this info from a running instance (not necessarily in realtime)? -- - Adam ----- Adam Fields, Managing Partner, [EMAIL PROTECTED] Surgam, Inc. is a technology consulting firm with strong background in delivering scalable and robust enterprise web and IT applications. http://www.adamfields.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
