The MySQL sys schema was integrated fully into MySQL Server from version 5.7.7. Whether you are a DBA trying to determine where the resources are being used on your database instance and by whom, or a developer trying to figure out why your MySQL statements are running too slowly, the MySQL sys schema can help. Join this session to learn how to better use the MySQL sys schema to answer your day-to-day questions—from the original developer of the MySQL sys schema.
Mark Leith has worked on MySQL, Oracle, Sybase and SQL Server servers, and monitoring and management tools for these, for an extensive time. He joined MySQL in 2005 as a Support Engineer and is now Senior Software Development Manager in Oracle's MySQL Enterprise Tools group where he helps lead development of MySQL Enterprise Monitor, and works closely with the MySQL server team on the Performance Schema, and MySQL instrumentation in general. Mark is the original developer of the sys schema, a collection of views, procedures and functions, that can be used to help interpret Performance Schema data.
6:30 - 7:00 -- Doors open/general socializing & food provided by Percona
7:00 - 7:15 -- Intro/announcements
7:15 - 8:00(ish) -- Main presentation
8:00 - 8:30 -- General discussion/Q&A/networking/etc.
Percona (http://www.percona.com/) is the oldest and largest independent MySQL support and consulting company, with a global 24×7 staff of over 40 people serving more than 1000 customers (http://www.percona.com/about-us/customers/) in 50+ countries since 2006. Our clients achieve breakthrough results with MySQL: cost savings, faster time to market, higher system uptime, and long-term scalability. With Percona, you can execute with confidence and clarity. Anyone can claim expertise, but we show our abilities by creating open-source (http://www.percona.com/software/) software for MySQL users, writing industry-leading books (http://www.percona.com/about-us/books/), and publishing original research on the widely read MySQL Performance Blog (http://www.mysqlperformanceblog.com/). We also organize the Percona Live (http://www.percona.com/live/) series of conferences to share what we know.
AppDynamics (http://www.appdynamics.com/) is the next generation application performance management (http://www.appdynamics.com/product/product-features) solution that simplifies the management of complex, business-critical apps. No one can stand slow applications—not IT Ops and Dev teams, not the CIO, and definitely not end users. With AppDynamics, no one has to tolerate slow performing apps ever again. AppDynamics customers include Netflix, Priceline, TiVo, AMICA Insurance, Hotels.com, StubHub, Staples, Insight Technologies, and Cornell University. For more information, visitwww.appdynamics.com (http://www.appdynamics.com/).
Lithium (http://www.lithium.com/) helps companies unlock the passion of their customers. Lithium software powers amazing Social Customer Experiences for more than 400 iconic brands including AT&T, BT, Best Buy, Indosat, Sephora, and Telstra. Lithium helps companies grow brand advocacy, drive sales, reduce costs and accelerate innovation to create social communities that redefine the customer experience.
O'Reilly Media (http://oreilly.com/) spreads the knowledge of innovators through its books, online services, magazines, research, and conferences. Since 1978, O'Reilly has been a chronicler and catalyst of leading-edge development, homing in on the technology trends that really matter and galvanizing their adoption by amplifying "faint signals" from the alpha geeks who are creating the future. An active participant in the technology community, the company has a long history of advocacy, meme-making, and evangelism.