Tag - MySQL slow logs

Analyzing Amazon Aurora Slow Logs with pt-query-digest

Amazon Aurora MySQL slow query logs with pt-query-digest slow

In this blog post we shall discuss how you can analyze slow query logs from Amazon Aurora for MySQL, (referred to as Amazon Aurora in the remaining blog). The tools and techniques explained here apply to the other MySQL compatible services available under Amazon Aurora. However, we’ll focus specially on analyzing slow logs from […]

Read more

Easy query metrics with MySQL Performance Schema

The MySQL Performance Schema exposes so much data that it’s not trivial to learn, configure, and use. With recently released Percona Agent 1.0.11 you can get query metrics – like min, max, and average query execution time – with a few clicks:

Click “Apply” and about two minutes later you’ll have query metrics from Performance Schema, collected and […]

Read more

Rotating MySQL Slow Logs Safely

mysql

This blog post is part two of two. Like part one, published Wednesday, this is a cross-post from long_query_time set to 0. Here are a some lessons we learned when logging a high volume of queries to the slow log.
Do not use copytruncate
bug 65481 explains that the HUP signal also flushes tables in addition […]

Read more