how can I get performance statistics
I need know the execution time of a query. And how many times the I/O operation are involved for the query. How can I get this kind of infomation? Are there some ways to add these info into the logfile? Thank you. I am a rookie for Mysql and for this mial-list system. If I broke the rule of asking a queation, please let me know. Victo _ MSN Messenger: http://messenger.msn.com/cn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how can I get performance statistics
Hello. Usually the execution time is measured on the client side (you may implement it in your application). I don't know how to measure the number of I/O operations involved by a single query. There is only a global statistics reported by SHOW STATUS. There is a handy tool in MySQL - EXPLAIN statement. See: http://dev.mysql.com/doc/mysql/en/show-status.html http://dev.mysql.com/doc/mysql/en/explain.html qin lei [EMAIL PROTECTED] wrote: I need know the execution time of a query. And how many times the I/O operation are involved for the query. How can I get this kind of infomation? Are there some ways to add these info into the logfile? Thank you. I am a rookie for Mysql and for this mial-list system. If I broke the rule of asking a queation, please let me know. Victo _ $$ MSN Messenger: http://messenger.msn.com/cn -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how can I get performance statistics
qin lei [EMAIL PROTECTED] wrote: I don't know how to implement this on the server side. Please, next time answer to the list as well. Hi, Thank you for your reply. In my project, I need to know the prapagation time and execution time respectively. So I can not measure the execution time on the client side. Is there any way to do this on the server side? _ $$ MSN Messenger: http://messenger.msn.com/cn -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]