Question: how do I know that one user is waiting for a lock and another user is burning CPU on MySQL?
i.e. how can I create active session history on MySQL like on Oracle?
Two simple cases I’m looking at
- session waiting on lock
- The wait event is ” wait/io/table/sql/handler” which happens for a number of potential reasons
- -> I can join to information_schema views INNODB_LOCK_WAITS & INNODB_TRX but this is heavy, and I’d rather only access those after I know there is a lock waiter.
- session burning CPU
- How do I know from performance schema views that the connection is active and burning CPU?
- It has a wait event that shows up wait/synch/mutex/sql/THD::LOCK_thd_data
- on Oracle to determine CPU, we …