Learn How to Use Performance Schema in MySQL 5.7 Not Only the Basics
MySQL 5.7’s introduction of several new instruments in the Performance Schema and sys_tables can be overwhelming and intimidating for many administrators. Performance schema is instead a very powerful tool to integrate in historical monitoring, performance tuning and general observation. This tutorial will examine which instruments will really inform administrators so they can include them in the current and historical monitoring, allow them to make the right decisions and to keep their servers in good shape. Attendees will learn how to analyze the servers' status and behavior, tune properly according to traffic demands. 1) General definition 2) Implementation 3) Filtering 4) Performance impact 5) Tracing DDL, evaluate the application impact, and more. 6) Get help from Sys schema 7) How to use it and dig a. Latency b. Utilization c. Saturation 8) Memory utilization 9) Replication 10) Command reference and Steps
Principal Consultant , Percona
Marco Tusa had his own international practice for the past twenty seven years. His experience and expertise are in a wide variety of information technology and information management fields of application and cover research, development, analysis, quality control, project management and team management. Marco has move back to Percona in March 2016 as Manager HA, after being Principal consultant for Pythian for a brief period and manager of the Consulting Rapid Response Team in Percona from October 2013. Marco Tusa has moved from Italy to Ottawa in 2011 and had being working at Pythian as Cluster Technical Leader for the MySQL technology until September 2013. He has being working as employee the SUN Microsystems as MySQL Professional Service manager for South Europe., and previously in MySQL AB. He has worked with the Food and Agriculture Organization of the United Nation since 1994, leading the development of the Organization’s hyper textual environment.Team leader for the FAO corporate database support.