There’s no such thing as a schemaless database. I know, lots of people want a schemaless database, and lots of companies are promoting their products as schemaless DBMSs. And schemaless…
If you’ve ever looked at the COM_XYZ status counters in MySQL’s SHOW STATUS output, you’ve probably seen Com_admin_commands. It’s not clear what this means, but it can be a major…
One of the interesting challenges in writing a system like SolarWinds® Database Performance Monitor (DPM) is writing a query digesting algorithm that deals with all of the technology-specific features, bugs,…
First things first: A big shout out to the engineers at Shopify who work on Sarama, the Go Client we use for Kafka – they do a great job on…
We often get questions about how we measure queries inside MySQL (and now PostgreSQL too). Many of these questions reveal assumptions about the metrics we provide and our methods for…
We create applications in an age of simple, powerful, flexible databases that do magic for us. There’s a large variety of modern databases that supply just what’s needed for lots…
Security is a top priority. Leading companies such as Zappos, Dyn, and Etsy use Database Performance Monitor (DPM), a cloud-based database performance management service to monitor MySQL in production designed…
This is a story of intermittent 500 Internal Server errors from APIs, that ended up being caused by a hardcoded constant in Go’s database/sql package. I’ll mostly spare you the…
VividCortex now supports per-user metrics in Top Queries, so you can monitor MySQL database user activity in detail. By changing the Rank menu from Queries to Users you can now…
Google released a new reCaptcha that is “tough on bots, easy on humans.” It is really simple to use, and it has greatly improved the security against robots and other…
