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]