Published by Alex Slotnick on Jan 19, 2017 4:43:46 PM

5 Tips for DBAs on Working Remotely

For many professionals who've never had the chance to try it, full-time remote work might seem like pure upsideeven luxurious. On days when rush hour commutes, shared fridge space, and raucous office mates threaten to overwhelm, who wouldn't prefer the option of settling into a spacious, at-home desk, with the family dog snoozing at one's heels?

But like any logistical detail of a job, working remotely comes with its own unexpected challenges. This is especially true for people whose roles are highly variable, sensitive, and central to an organization's ability to function, such as database administrators'.

Read More
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 31, 2016 10:58:49 AM

2016: VividCortex's Exciting Year in Review

As New Year's festivities start up around the world, VividCortex has many reasons to join the celebration. We're exhilarated and grateful to think back on how far we've come over the past 12 months. This has been a year of non-stop progress for our team and in what we've seen VividCortex's users accomplish.

Read More
Published by Alex Slotnick on Dec 22, 2016 4:13:19 PM

Mystery: Constant Query Time Despite Varying Loads

A little while awhile ago VividCortex's engineering team encountered a minor mystery when observing some trends in time_us metrics in a MongoDB database. While the conclusion of our investigation was a kind of combination of "D'oh!" and "Ah ha!," we thought our considerations along the way were interesting and involved a few valuable questions worth sharing.

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 Dec 2, 2016 3:57:58 PM

VividCortex Newsletter: November 2016

The November 2016 edition of the VividCortex newsletter includes our Database Performance Monitoring Buyer's Guide; PayLease's video case study about their experience with VividCortex; a recording of our "Five Things to Monitor After Black Friday and Cyber Monday" webinar; a free Square Root Staffing Law workbook; and more.

Read More
Published by Alex Slotnick on Dec 1, 2016 3:12:01 PM

Webinar Recap: Five Things to Monitor After Black Friday and Cyber Monday

If you missed this week's broadcast of "Five Things to Monitor After Black Friday and Cyber Monday," a recording is now available for on-demand access. Why's it important to carry your monitoring principles beyond Black Friday weekend? Even though the holiday shopping spree has slowed down, organizations can continue to monitor their databases wisely. Don't be fooled: database monitoring is vital year-round, and retail organizations should be prepared to deal with critical activity--even during periods unrelated to the typical holiday surges.

Read More
Published by Alex Slotnick on Nov 28, 2016 5:22:23 PM

AWS re:Invent 2016 Survival Guide

AWS re:Invent 2016 kicked off this morning, and attendees of the conference are in for a week overflowing with breakout sessions, workshops, entertainment, and cloud computing innovation, all at the heart of the Las Vegas Strip. We know from firsthand experience that conferences like AWS can be exhausting even as they're exhilarating, and attendees will absolutely benefit from some smart planning and preparation, to ensure that they get the most for their time, without feeling they missed anything major. So what does it take to make sure AWS delivers as much as possible? We present this brief—but useful!—survival guide to help you navigate this year's schedule and events.

Read More

Subscribe to Email Updates

Posts by Topic

see all