John Potocny

Recent Posts

Published by John Potocny on Feb 23, 2016 11:28:18 AM

Drinking from the Firehose: How VividCortex Compresses its Metrics

Sometimes, when working with a top-of-the-line monitoring tool, having access to the best possible visibility, granularity, and reliability is simply not enough. Sure, those features represent the ultimate goals in monitoring, but, in this case, the ends do not necessarily justify the means. What about costs? As we provide a tool that achieves ambitious bottom line functionality, we also need to pay close attention to any burden that VividCortex might impose on users’ systems. We need to mitigate and minimize those costs. And we need to make sure that VividCortex is as efficient as it is powerful... especially when the onrush of data gets intense.

Read More
Published by John Potocny on Jan 20, 2016 2:46:40 PM

Solving a Go Communications Issue with A VividCortex Agent

Back in September of last year, a customer brought to our attention an unusual behavior: they were seeing inexplicable alerts, reporting that a host was failing to send data for more than fifteen minutes. Yet when the customer checked the host a short while after, they saw that no data was actually missing. Strange, we thought, so we began to investigate.

Read More
Published by John Potocny on Feb 26, 2015 3:20:00 AM

See Connection Latency with VividCortex

Recently, one of our customers reached out to us about a problem they were having trouble diagnosing - they noticed that every once in a while, it took their MySQL server a few seconds to initialize a client connection. They had figured out that the issue was a missing hosts entry for one of their clients, but VividCortex didn’t have any measurements to show this issue to them.

Read More
Published by John Potocny on Nov 19, 2014 4:30:00 AM

Analyzing Prepared Statement Performance With VividCortex

Optimizing MySQL performance requires the ability to inspect production query traffic. If you’re not seeing your application’s production workload, you’re missing a vital part of the picture. In particular, there are lots of performance optimizations your systems might be doing that you’re not aware of. One of these is using prepared statements for queries.

Read More
Published by John Potocny on Oct 9, 2014 2:13:00 AM

Query Samples, Explained

The EXPLAIN command is one of MySQL’s most useful tools for understanding query performance. When you EXPLAIN a query, MySQL will return the plan created by the query optimizer. It also shows you how that query will be indexed and an estimate of how many rows are processed by that query. From this information, it is easy to see if your queries are taking advantage of table indexes or if you can change them for some extra performance. VividCortex provides a lot of information on query performance, including samples of the queries that are run against your database. Now, those samples will have EXPLAIN data for them too!

Read More

Subscribe to Email Updates

Posts by Topic

see all