January 24, 2025
Graphing MySQL Query Histograms

One of the best features within MySQL performance schema is query histograms, and much like in photography, they provide a great deal of information that can be used to improve the effectiveness of optimization efforts. There is one problem though, the data is stored in a way that is hard to assess directly and needs to be transformed first.
The most effective transformation from the raw data stored in the two… Read More