Published by Baron Schwartz on Jan 11, 2017 10:44:00 AM

MySQL Query Performance Statistics In The Performance Schema

Updated 1/11/2017

Quite some time ago, when we added the ability to monitor MySQL query performance statistics from MySQL’s PERFORMANCE_SCHEMA, we learned a number of valuable lessons, still worth sharing. There are definitely right and wrong ways to do it. If you are looking to the P_S tables for monitoring MySQL query performance, this blog post might save you some time and mistakes.

Read More
Published by Alex Slotnick on Dec 19, 2016 6:02:58 PM

The Virtues of a Code Slush

People tend to look for sturdy, expansive safety nets when facing risky situations. In database management, organizations turn to the sweeping strategy of code freezes during times of hectic, peak activity. Most engineering teams have had to deploy code freezes during such times, with the noble intention of protecting the integrity of a system, using the logic that if nothing can touch it, nothing can break it.

Unfortunately, a code freeze is a flawed strategy.

Read More
Published by Alex Slotnick on Dec 9, 2016 6:23:11 PM

Everyday Profiling and Calculating Query CPU

When you find spikes in your database's CPU consumption, locating the cause behind those peaks can be a daunting task. Database server software doesn’t make it easy to precisely analyze what's taxing CPU and IO, and, due to the system's complexity, locating the source of the burden on system resources isn't just a matter of pulling metrics from the database and connecting the dots. These figures must be calculated.  

Read More
Published by Alex Slotnick on Nov 23, 2016 5:48:41 PM

Monitoring for Black Friday: Capacity Planning Techniques

In our latest webinar, Baron Schwartz talked about how to best prepare for potential traffic spikes during Black Friday and Cyber Monday. Although some organizations may not experience a seasonal peak during the holidays, there might be other times when traffic surges can be expected--we thought we’d use the occasion of Black Friday to share some techniques to help you prepare for times when your systems may be stressed.

Read More
Published by Preetam Jinka on Nov 9, 2016 10:15:00 AM

What is ACID and How Should I Think About It As a Developer?

For the average reader, the phrase “expert in ACID” most likely evokes a picture of either an eminent chemist or a jolly Deadhead. However, in the world of computer science, an understanding of "ACID" means something a bit different (though not mutually exclusive!). When dealing with relational databases, the term refers to a set of properties that describe certain characteristics of transactions.

Read More
Published by Alex Slotnick on Oct 31, 2016 4:48:45 PM

5 Questions Managers Should Ask Their DBAs Before Black Friday

Poorly performing sites can be costly. With Black Friday and Cyber Monday right around the corner, how can business leaders work with DBAs to ensure that their organizations and databases are properly prepared to deal with customers’ needs, so websites don’t malfunction? With five simple—but powerful—questions, managers can help their database teams get ready for the heaviest of shopping traffic.

Read More
Published by Baron Schwartz on Oct 28, 2016 10:43:44 AM

Everyone's Capable of a Performance Mindset

The other day I was speaking with someone who asked me a few times how we find and hire engineers who are capable of building performance/monitoring tools. I didn't have a great answer in the moment, but after the conversation was over, I realized it's because I fundamentally believe we all are capable of understanding and solving systems performance problems. We're all brainiacs, so to speak.

Read More
Published by Alex Slotnick on Oct 17, 2016 2:41:18 PM

Smart RBAC and SSO Implementation Improves Security, Management, Workflow, and More

VividCortex's recent introduction of two important product features—Role-Based Access Control (RBAC) and Single Sign-On (SSO)—gives us the opportunity to initiate a conversation about topics that are relatable to anybody at a modern-day company or organization: security, workflow, and effective management. How can a powerful monitoring solution improve the way an organization operates while also making the way it handles data safer?

Read More

Subscribe to Email Updates

Posts by Topic

see all