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