Hi!
>>>>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
<cut>
Peter> It's a pity what mysql misses something like PROFILE call for the
Peter> query so I could check how much time is spent for different phases of
Peter> query execution.
MW> Any suggestions for the output for this?
Peter> Well Yes. It should be the table with some columns - first name of
Peter> stage, second some additional info, and the last one the time taken.
Peter> The problem is some info can be collected only on client - i.e time
Peter> to send query and time to send resive all data. Also some interesting
Peter> indo may be printed about caches (misses/hits)
Peter> Totaly it would be nice to have something like
Peter> Send query to server
Peter> pharse query
Peter> open tables
Peter> make plan
Peter> Read keys 1024 512 Hits 512 Mises
Peter> Read rows 1012 1056 Fragments
Peter> Send result to client
Peter> So the idea is to get not only timings data on different stages, but
Peter> also some additional information from different stages for example
Peter> number of key cache misses and hits.
Peter> The other odea is to have an special compile option profile - so
Peter> information will be gathered and aviable via special interface after
Peter> each query so it can be processed on application special way.
We plan in 4.0 to add a 'show thread status' command to get status per
connection; This will make it much easier to do things like this.
<cut>
Regards,
Monty
---------------------------------------------------------------------
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
