So we have seen until now different built-in ways to easily collect diagnostics information on MySQL server at different level (Instance/Thread/Statement) :
But what about analyzing database load ? Does MySQL has a build-in way to display Active Session History ?
We already have seen how to gather overall MySQL server diagnostics information and how to trace a specific thread activity. Let’s go to more granular level this time ! What about tracing a specific statement. Has MySQL a built-in way to do that ?
In my last blog post we have seen how we can easily collect general MySQL status information using the sys.diagnostics() procedure. What about a single session/thread ? Is there built-in way to easily trace a target thread/session activity (ex: transactions/ statements/stage/wait events) like using an oracle SQL trace ?
Has MySQL a built-in way to easily take a look at the overall server status without the need to execute many different custom query or program ? Maybe something similar to an oracle AWR report ?
Here is the event mapping files for the new oracle 19c
As usual this include new added/removed events :
19c on the left/18c on the right
As i showed in my previous blog post this event mapping files can be used in different use cases.Such as flame graph annotation :
Hatem Mahmoud's blog 