Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks

MySQL 5.6 offers substantial improvements to Performance Schema. This provides even more insight into how MySQL executes queries, allowing us to identify and troubleshoot bottlenecks. In this webinar, we will look at using MySQL 5.6 performance schema for performance diagnostics and troubleshooting typical workload bottleneck issues, such as:

• Bottlenecks with Disk IO
• Problems with excessive temporary tables and external sorts
• Excessive internal mutex contention
• Slow queries due to waits on InnoDB locks and Meta Data locks