#DBHangOps!

Talk shop and learn about MySQL and occasionally some other stores!

Topics and RecordingsLearn From Previous Discussions!

How to JoinSome simple setup help!

Follow Us On

Twitter

#DBHangOps 06/26/14 -- PERFORMANCE_SCHEMA in MySQL 5.7 and more!

Check out the recording below!

Hello everybody!

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!)
    • New instruments
    • How to use the instruments
    • Open questions!
  • 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!

Show notes

Semi-Sync replication

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
    • Metadata locks!
      • 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!