Tag: mysql

reporting vs analysis difference



MySQL Query Performance Statistics In The Performance Schema

January 12, 2020

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 …


SolarWinds Lab Episode 35: MySQL Database Monitoring With DPA

May 15, 2018

The new version of SolarWinds® Database Performance Analyzer is hitting the streets, and there’s a new member of the family – MySQL! Join Head Geeks Leon Adato and Thomas LaRock, along with guest Senior Technical Product Marketing Manager Janis Griffin as they show off …


Database Security

How We Encrypt Data in MySQL With Go

July 31, 2017

A SaaS product needs to use security measures you might not ordinarily use in an on-premises solution. In particular, it’s important for all sensitive data to be secured. Encryption plays an important role in information security. We encrypt data in-flight and at-rest, so your …



JSON Support in PostgreSQL, MySQL, MongoDB, and SQL Server

February 10, 2017

If you’ve been watching the evolution of database technologies over the past few years, you’ve seen how quickly JSON has quickly cemented its position in major database servers. Due to its use in the web front-end, JSON has overtaken XML in APIs, and it’s spread through all the …



Three Things That Differentiate Amazon Aurora From MySQL

January 27, 2017

It’s not always obvious what makes one database type distinct from another. What are the most significant ways Amazon Aurora is different from MySQL? Clear separators aren’t always featured or widely known, but even slight variables between two databases can prove valuable in choosing …



Analyzing Prepared Statement Performance

November 19, 2014

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 …