Hi Brian

On 05/08/2009, at 4:16 AM, Brian Aker wrote:
Just put up a blog looking for feedback on performance schema info:
http://krow.livejournal.com/643607.html

Feedback is welcome.


Nothing wrong with that highlevel idea.

The issue in MySQL has been overhead of such instrumentation, particularly also when not used. Some cause 5-20% perf loss which is unacceptable.

And, when relating to indiv query execution, measuring sorts, tmp tables etc is perfect, as long as it can also be used in a non- aggregate way... e.g. query gets logged with some filter condition, etc.


Cheers,
Arjen.
--
Arjen Lentz, Director @ Open Query (http://openquery.com)
Exceptional Services for MySQL at a fixed budget.

Follow our blog at http://openquery.com/blog/
OurDelta: free enhanced builds for MySQL @ http://ourdelta.org


_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to