#DBHangOps 06/26/14 -- PERFORMANCE_SCHEMA in MySQL 5.7 and more!
Check out the recording below!
Join in #DBHangOps this Thursday,
June, 26, 2014 at 11:00am pacific (18:00 GMT), to participate in the discussion about:
MySQL 5.7 Semi-sync replication (Morgan Tocker)
MySQL 5.7 PERFORMANCE_SCHEMA (from Mark Leith!)
How to use the instruments
Any other MySQL 5.7 discussion!
Be sure to check out the
#DBHangOps twitter search, the @DBHangOps twitter feed, or this blog post to get a link for the google hangout on Thursday!
See all of you on Thursday!
MySQL 5.7 PERFORMANCE_SCHEMA
PSHelper has been forked into SYS to provide more than just performance_schema helpers
SYS provides new views:
X$ views are the same as ps_helper views, just with raw data
SYS is also now packaged with MySQL Workbench. There's some good integrations here:
New instruments in 5.7 PERFORMANCE_SCHEMA
Lots of instruments around transactions: events_transactions_*
events_transactions_current will give you the state of currently executing transactions on the server
The NESTING_* fields are used to run hierarchical queries
events_transactions_history_long will show the last 10000 transactions run on the server
Memory instruments: memory_summary_*
In MySQL 5.7.4 the memory instruments don't capture information from the InnoDB storage engine. There's work being done on this for a future release
You can track metadata locks at any level on the server (global, table, etc.)
Identify the owners and sessions of the locks
Can PERFORMANCE_SCHEMA be extended to add instruments for other storage engines?
You can potentially patch your own instruments in
Feel free to file bugs on the MySQL bug tracker for instruments you'd like to see!