Tag - MySQL 5.6 Performance Schema

MySQL query digest with Performance Schema

Data Analysis

Query analysis is a fantastic path in the pursuit to achieve high performance. It’s also probably the most repeated part of a DBA’s daily adventure. For most of us, the weapon of choice is definitely pt-query-digest, which is one of the best tools for slow query analysis out there.
Why not use pt-query-digest? Well, sometimes […]

Read more

Capture database traffic using the Performance Schema

Capturing data is a critical part of performing a query analysis, or even just to have an idea of what’s going on inside the database.
There are several known ways to achieve this. For example:

Enable the General Log
Use the Slow Log with long_query_time = 0
Capture packets that go to MySQL from the network stream using TCPDUMP 
Use […]

Read more

Advanced MySQL Query Tuning (Aug. 6) and MySQL 5.6 Performance Schema (Aug. 13) webinars

I will be presenting two webinars in August:

Aug 6, 10 a.m. PDT: Advanced Query Tuning in MySQL 5.6 and Beyond
Aug 13, 10 a.m. PDT:  Using Performance Schema to Monitor and Troubleshoot MySQL 5.6

This Wednesday’s webinar on advanced MySQL query tuning will be focused on tuning the “usual suspects”: queries with “Group By”, “Order By” and […]

Read more