by Sveta Smirnova | Apr 4, 2018 | Insight for DBAs, MySQL
In this blog, I will provide answers to the Q & A for the Performance Schema for MySQL Troubleshooting webinar. First, I want to thank everybody for attending my March 1, 2018, webinar. The recording and slides for the webinar are available here. Below is the list...
by Sveta Smirnova | Mar 14, 2018 | MySQL, Webinars
In this blog, I will provide answers to the Q & A for the Basic Internal Troubleshooting Tools for MySQL Server webinar. First, I want to thank everybody for attending my February 15, 2018, webinar on troubleshooting tools for MySQL. The recording and slides for...
by Sveta Smirnova | Feb 28, 2018 | Insight for DBAs, MySQL, Webinars
Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents Performance Schema for MySQL Troubleshooting on Thursday, March 1, 2018, at 10:00 am PST (UTC-8) / 1:00 pm EST (UTC-5). Register Now Performance Schema, first introduced in version 5.5,...
by Sveta Smirnova | Jan 26, 2017 | MySQL, Open Source
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...
by David Ducos | Oct 21, 2016 | MySQL, Percona Software
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...
by Dave Avery | May 19, 2016 | Insight for DBAs, MongoDB
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...
by Dave Avery | Apr 19, 2016 | 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...
by Daniel Guzmán Burgos | Oct 20, 2015 | Insight for DBAs, MySQL
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...
by Daniel Guzmán Burgos | Oct 13, 2015 | Insight for DBAs
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...
by Daniel Guzmán Burgos | Oct 1, 2015 | Insight for DBAs, MySQL
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...
by Vadim Tkachenko | Sep 18, 2015 | 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...
by Daniel Guzmán Burgos | Sep 16, 2015 | Insight for DBAs, MySQL, Webinars
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...
by Jervin Real | Apr 16, 2015 | 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...
by Valerii Kravchuk | Apr 7, 2015 | Insight for DBAs, Insight for Developers, MySQL, Percona Live, Percona Services
Two years ago Ovais Tariq had explained in detail what kinds of problems existed before MySQL introduced metadata locks in 5.5.3 and how these locks help to prevent them. Still, some implications of metadata locking in MySQL remain unclear for users – DBAs and...
by Daniel Nichter | Mar 12, 2015 | MySQL, Percona Software
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...
by Miguel Angel Nieto | Nov 20, 2014 | Insight for DBAs, MySQL
Performance Schema (P_S) has been available since MySQL 5.5, more than 4 years ago. It is still difficult to see production servers with P_S enabled, even with MySQL 5.6 where the feature is enabled by default. There have been several complaints like the overhead,...
by Daniel Nichter | Aug 19, 2014 | Cloud, Insight for DBAs, MySQL, Percona Software
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...
by Alexander Rubin | Jun 9, 2014 | Insight for DBAs, MySQL
Hosting a shared MySQL instance for your internal or external clients (“multi-tenant”) was always a challenge. Multi-tenants approach or a “schema-per-customer” approach is pretty common nowadays to host multiple clients on the same MySQL...
by Peter Zaitsev | May 13, 2013 | MySQL, Webinars
This Wednesday, May 15 at 10 a.m. Pacific, I’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In this Webinar I will offer an overview of Performance Schema, focusing on new features...
