Analyzing Prepared Statement Performance
11/19/14 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 …
Back to all articles
Feed
SolarWinds Blog
1,888 articles · Page 154 of 158
SolarWinds Database Performance Monitor Now Supports Amazon RDS For MySQL
11/12/14 We are excited to announce that we now support monitoring Amazon RDS for MySQL. Previously we relied exclusively on deep packet inspection, but since customers can’t insta…
Inside Distributed Architectures: RT In-Flight Requests And Blockers
11/06/14 SolarWinds® Database Performance Monitor’s (DPM) SaaS backend is a service-oriented architecture, which means that in addition to our external APIs that our agents and web…
Using Netlink to Optimize Socket Statistics
09/22/14 This is a story of using low-level kernel interfaces to optimize an edge case one of our agents encountered in some servers. The TL;DR version is that accessing /proc/ can…
What Privileges Does EXPLAIN Require in MySQL?
07/28/14 Here’s a simple question that I wasn’t able to solve with Google or the MySQL documentation (which is normally excellent). Perhaps it’s mentioned somewhere, but I can’t fi…
Prepared Statement Samples
07/25/14 One of our most useful features is Top Queries, which allows users to examine various metrics for families of similar queries. Once a query family is selected, we can dril…
MySQL Type Conversion Rules
07/21/14 When you send a query to MySQL, you usually don’t need to think explicitly about the types of the expressions in your query. If you compare this to a lot of programming la…
4 Things To Know About MySQL Prepared Statements
07/10/14 While writing our TCP stream reassembly and MySQL protocol reverse-engineering algorithms, a few finer points of the MySQL protocol and internals came up. None of this is …
Composition Instead of Inheritance in Go
07/01/14 Looking back, I find object-oriented programming in languages like Java and C++ to be incredibly confusing. There are so many special rules and things to know. By contrast…
Discovering Query Bugs by TCP Inspection
06/23/14 The MySQL wire protocol includes useful result data and metadata, such as warnings and errors raised by the query. These often indicate bugs that will cause problems you m…
Adaptive Fault Detection Versus Anomaly Detection
04/24/14 We get a lot of questions about what our Adaptive Fault Detection algorithm really is and how it works. Although I can’t tell you exact details, I want to explain a few th…
Join Our Team! We’re Hiring!
04/24/14 We’re Hiring! VividCortex has several open positions, both technical and non-technical. All of these positions are fulltime, based in Charlottesville, VA or Montevideo, Ur…