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…
Back to all articles
Feed
SolarWinds Blog
1,919 articles · Page 157 of 160
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…
How to Fix Hangout Restrictions on Google Apps
04/16/14 We use Google Hangout all the time to conduct calls with employees, service providers, customers and pretty much anyone. It’s a great tool, and in our opinion more friendl…
VMDK versus RDM: Which One Do I Need for SQL Server?
03/26/14 When it comes to disk configuration options for virtualized servers running on VMware, you have two options: VMFS virtual file-based disk (VMDK) or a raw device mapping (R…
Multi-Threaded Replication in MySQL
03/17/14 For years, people lamented that MySQL’s replication was single-threaded. Peter, Vadim, and I griped about this in High Performance MySQL for two whole editions, as well as…
Performance Schema, Slow Query Log, and TCP Decoding
02/25/14 Peter Zaitsev posted Percona’s answer to the question, “why use the slow query log instead of the PERFORMANCESCHEMA tables to gather information about query execution and …
Hardware or Code? SQL Server Performance Examined
01/24/14 As DBAs with years of experience in a variety of environment between us, we each have seen that most database performance issues result not from lack of enough CPU power o…