EmergencyEMERGENCY? Get 24/7 Help Now!

Performance Schema Benchmarks: OLTP RW

 | January 26, 2017 |  Posted In: MySQL, open source databases, OpenSource Databases on big machines

Performance Schema Benchmarks

In this blog post, we’ll look at Performance Schema benchmarks for OLTP Read/Write workloads. I am in love with Performance Schema and talk a lot about it. Performance Schema is a revolutionary MySQL troubleshooting instrument, but earlier versions had performance issues. Many of these issues are fixed now, and the default options work quickly and […]

Read More

Replication Triggers a Performance Schema Issue on Percona XtraDB Cluster

 | October 21, 2016 |  Posted In: MySQL, Percona XtraDB Cluster

wsrep-stages

In this blog post, we’ll look at how replication triggers a Performance Schema issue on Percona XtraDB Cluster. During an upgrade to Percona XtraDB Cluster 5.6, I faced an issue that I wanted to share. In this environment, we set up three Percona XtraDB Cluster nodes (mostly configured as default), copied from a production server. We […]

Read More

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

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

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

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

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