EmergencyEMERGENCY? Get 24/7 Help Now!

Tired of MySQL Making You Wait? Webinar: Questions and Answers

 | January 21, 2016 |  Posted In: MySQL, Query Analytics

We’d like to thank everybody for joining us on January 7th for our “Tired of MySQL Making You Wait?” webinar with Percona’s Alexander Rubin, Principal Consultant and SolarWinds’ Janis Griffin, Database Evangelist. Too often developers and DBAs struggle to pinpoint the root cause of performance issues and then spend too much time in trying to […]

Read More

Slow query graphs using Performance Schema and Graphite

 | October 20, 2015 |  Posted In: Graphite, Insight for DBAs, MySQL, Performance Schema, Query Analytics

Grpahite Slow log compiled

I love graphs. They just make things easier when it comes to finding patterns. I also love visibility. Having the ability to known what is going on inside the database is priceless. How about having visibility of the slow queries execution time on a graph? Let’s do it. We’ve already described how to get query […]

Read More

MySQL query digest with Performance Schema

 | October 13, 2015 |  Posted In: Insight for DBAs, Performance Schema, Query Analytics

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

Faster fingerprints and Go packages for MySQL

 | February 2, 2015 |  Posted In: MySQL, Percona Cloud Tools, Query Analytics

I’m happy to announce Go packages for MySQL. Particularly exciting is a new query fingerprint function which is very fast and efficient, but I’ll talk about that later. First, go-mysql is currently three simple Go packages for parsing and aggregating MySQL slow logs. If you’ve been following Percona development, you’ve no doubt heard of Percona Cloud Tools (PCT), a […]

Read More

5 great new features from Percona Cloud Tools for MySQL

 | August 19, 2014 |  Posted In: Cloud and NoSQL, Insight for DBAs, MySQL, Percona Cloud Tools, Query Analytics

It’s been three months since we announced anything for Percona Cloud Tools, not because we’ve been idle but because we’ve been so busy the time flew by!  Here’s the TL;DR to pique your interest: EXPLAIN queries in real-time through the web app Query Analytics for Performance Schema Dashboards: customizable, shared groups of charts Install and […]

Read More

MySQL Slow Query Log: Tools and Tips

 | March 14, 2014 |  Posted In: Insight for DBAs, MySQL

MySQL has a nice feature: MySQL slow query log, which allows you to log all queries that exceed a predefined about of time to execute. Peter Zaitsev first wrote about this back in 2006 – there have been a few other posts here on the MySQL Performance Blog since then (check this and this, too) […]

Read More

Quick installation guide for Percona Cloud Tools for MySQL

 | February 3, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Cloud Tools

Here in Percona Support, we’re receiving several requests per day for help with Percona Cloud Tools installation steps. So I decided to prepare a step-by-step example of the installation process with some comments based on experience.  Percona Cloud Tools is a hosted service providing access to query performance insights for all MySQL uses. After a […]

Read More

Analyzing WordPress MySQL queries with Query Analytics

 | January 16, 2014 |  Posted In: MySQL, MySQL Webinars, Percona Cloud Tools, Percona Software

This blog, MySQLPerformanceBlog.com, is powered by WordPress, but we never really looked into what kind of queries to MySQL are used by WordPress. So for couple months we ran a Query Analytics (part of Percona Cloud Tools) agent there, and now it is interesting to take a look on queries. Query Analytics uses reports produced […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.