EmergencyEMERGENCY? Get 24/7 Help Now!

Webinar Tuesday, May 24: Understanding how your MongoDB schema affects scaling, and when to consider sharding for help

 | May 19, 2016 |  Posted In: MongoDB, Performance Schema

mongodb-support-leaf

Please join David Murphy on Tuesday, May 24 at 10 am PDT (UTC-7) as he presents “Understanding how your MongoDB schema affects scaling, and when to consider sharding for help.” David will discuss the pros and cons of a few MongoDB schema design patterns on a stand-alone machine, and then will look at how sharding […]

Read More

Percona Live 2016: Let Robots Manage your Schema (without destroying all humans)!

 | April 19, 2016 |  Posted In: Percona Live

Yelp

We’re are rapidly moving through day one of the Percona Live Data Performance Conference, and I’m surrounded by incredibly smart people all discussing amazing database techniques and technology. The depth of solutions represented here, and the technical know-how needed to pull them off is astounding! This afternoon I was able to catch Jenni Snyder, MySQL DBA […]

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

VividCortex Agent Benchmark

 | September 18, 2015 |  Posted In: MySQL

Intro The purpose of this project was to measure the potential overhead of VividCortex Agent, which is used by VividCortex.com database monitoring system. This benchmark is part of a consulting engagement with VividCortex and paid by the customer. The assumption is that VividCortex agent uses CPU processing time, and we should see an impact on […]

Read More

Webinar: Introduction to MySQL SYS Schema follow up questions

 | September 16, 2015 |  Posted In: Insight for DBAs, MySQL, MySQL 5.7, MySQL Webinars, Performance Schema

Thanks to all who attended my webinar Introduction to MySQL SYS Schema. This blog is for me to address the extra questions I didn’t have time to answer on the stream. Can i have the performance_schema enabled in 5.6 and then install the sys schema? Or they are one and the same? You need to […]

Read More

Profiling MySQL queries from Performance Schema

 | April 16, 2015 |  Posted In: MySQL

When optimizing queries and investigating performance issues, MySQL comes with built in support for profiling queries aka SET profiling = 1; . This is already awesome and simple to use, but why the PERFORMANCE_SCHEMA alternative? Because profiling will be removed soon (already deprecated on MySQL 5.6 ad 5.7); the built-in profiling capability can only be enabled per session. This […]

Read More

Easy query metrics with MySQL Performance Schema

 | March 12, 2015 |  Posted In: MySQL, Percona Cloud Tools, Percona Server, Query Analytics

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

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.