Blog

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 Oct 27, 2016 6:26:42 PM

Webinar Recap: What's New in PostgreSQL 9.6 and MySQL 8.0?

Earlier this week, Baron Schwartz, VividCortex's CEO and author of High Performance MySQL, led a thorough webinar about the new and upcoming updates for a couple major databases: MySQL 8.0 and PostgreSQL 9.6. Attendees of the webinar had the opportunity to learn and ask questions about the most exciting, most impactful, and most overdue changes on offer in these latest iterations.

Read More
Published by Alex Slotnick on Sep 29, 2016 6:48:13 PM

Upcoming Database Updates: A Very Brief Pronunciation Guide

As many readers already know, it's update season for a couple key database systems. This morning the PostgreSQL Global Development Group released PostgreSQL 9.6 and published an announcement covering need-to-know details. Similarly, MySQL 8.0 is right around the corner, and as the full numeric uptick to 8.0 indicates, it's bound to contain some significant changes. This is major news for many users of these platforms. In recognition of these shifts in the database landscape, we'll be hosting a webinar on October 25, where Baron Schwartz will look at the changes these updates contain, discussing features such as replication capabilities; more extensibility; improved performance; broader SQL implementation; and more. 

In the meantime, we wanted to take a moment to help prep users in a different way: this blog post is a quick, pocket pronunciation and etymology guide that we hope will assist readers in uttering the vowel-phobic names of these systems with confidence.

Read More
Published by Alex Slotnick on Jul 28, 2016 4:02:59 PM

SQL Injection Detection and Alerting are Vital For Secure Data

The recent Mossack Fonesca “Panama Papers” hack is the latest security breach to drive home how much an impact an SQL injection can have on modern-day organizations. Though that hack ultimately revealed massive professional fraud by companies and governments around the world, it involved the exposure of 11.5 million confidential documents. The 2.6 terabytes of data stolen were a powerful reminder that the history of web-based business has been riddled with instances of SQL injections. They remain common and potentially devastating to organizations.

Read More
Published by Alex Slotnick on Jun 17, 2016 5:31:11 PM

Using VividCortex to Help Optimize MySQL Configuration

Many users new to MySQL will find themselves overwhelmed when tasked with configuring their system for best performance. It doesn't need to be intimidating, however. MySQL offers nearly 400 settings to consider, but a user should understand that most of the system's benefits can be achieved just by getting a few fundamental configurations right. The vast majority of optimizing configuration comes from selecting those very important options. Knowing where to look is the first step, and utilizing tools such as a monitoring product can be a huge boon.

Read More
Published by Preetam Jinka on May 4, 2016 1:44:52 PM

How VividCortex Uses the New Generated Virtual Columns Feature in MySQL

In an industry as fast-growing and interconnected as database technology’s, it’s exciting to track how innovations in one platform can ignite beneficial, rippling effects on other, surrounding systems. At VividCortex we frequently find ourselves faced with opportunities to improve our monitoring solutions based on how database technologies (such as MySQL, Redis, PostgreSQL, etc) develop and integrate new upgrades.

Read More
Published by Alex Slotnick on Mar 2, 2016 2:06:45 PM

Sometimes a Variety of Databases is THE Database You Need

We were just leafing through the 2015 edition of The DZone Guide to Database and Persistence Management, and we noticed some interesting stats in the guide's included survey, about which we'd like to share some observations. The survey is one of the ebook's central features, and it includes feedback from over 800 IT Professionals, with 63% of those respondents coming from companies with over 100 employees and 69% with over 10 years of experience -- they represent a significant and important cross-section of our industry.

Read More
Published by Baron Schwartz on Oct 26, 2015 3:38:27 PM

Beware of Database Tuning Advisors

One of the common questions we get during sales demos is “does VividCortex give advice on my database’s configuration?” The assumption is that since our product sees lots of information about the database, operating system, and current configuration, it can “optimize” the database configuration. Or, at least, point out really obviously bad things? Surely that is not too hard to do?

Read More

Subscribe to Email Updates

Posts by Topic

see all