In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
I was recently working on a high memory usage issue for one of our clients, and made some interesting discoveries: high memory usage with no bounds. It was really tricky to diagnose.
Below, I am going to show you how to identify that having thread_statistics enabled causes high memory usage on busy systems with many threads.
Part 1: Issue Background
I had a server with 55.0G of available memory. Percona Server for MySQL version:
Version | 5.6.35-80.0-log Percona Server (GPL), Release 80.0, Revision f113994f31
Built On | debian-linux-gnu x86_64
We have …
[Read more]