Re: how can I get performance statistics

2005-05-24 Thread Gleb Paharenko
"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 exec

Re: how can I get performance statistics

2005-05-24 Thread Gleb Paharenko
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 - EXPLAI

how can I get performance statistics

2005-05-24 Thread qin lei
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 as