by Yunus Shaikh | Dec 5, 2022 | MySQL, ProxySQL
ProxySQL is a very useful tool for gaining high availability, load balancing, query routing, query caching, query rewriting, multiplexing, and data masking. It is a proven tool and is used largely in production. There can be an instance of ProxySQL using a lot of...
by Sveta Smirnova | May 2, 2019 | MySQL, Percona Services, Percona Software
When users experience memory usage issues with any software, including MySQL®, their first response is to think that it’s a symptom of a memory leak. As this story will show, this is not always the case. This story is about a bug. All Percona Support customers...
by Spyros Voultepsis | Jul 3, 2018 | Insight for DBAs, MySQL, Percona Software
In this post, we will review the most important settings for Linux performance tuning to adjust for optimization of a MySQL database server. We’ll note how some of the Linux parameter settings used OS tuning may vary according to different system types:...
by Alexander Rubin | Jun 28, 2018 | MySQL, Percona Software
Troubleshooting crashes is never a fun task, especially if MySQL does not report the cause of the crash. For example, when a MySQL memory issue shows up. Peter Zaitsev wrote a blog post in 2012: Troubleshooting MySQL Memory Usage with lots of useful tips. With the new...
by David Ducos | Jun 19, 2018 | Insight for DBAs, MySQL
Since MySQL 5.7.5, we have been able to resize dynamically the InnoDB Buffer Pool. This new feature also introduced a new variable — innodb_buffer_pool_chunk_size — which defines the chunk size by which the buffer pool is enlarged or reduced. This variable is not...
by Alex Poritskiy | Jul 11, 2017 | MySQL, Open Source, Percona Software
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...
by Sveta Smirnova | Jun 15, 2016 | MySQL, Webinars
In this blog, I provide answers to the Q & A for the Troubleshooting hardware resource usage webinar. First, I want to thank everybody who attended the May 26 webinar. The recording and slides for the webinar are available here. Below is the list of your questions...
by Ovais Tariq | Apr 28, 2014 | Insight for DBAs, MySQL
I have recently been involved in diagnosing the reasons behind OOM invocation that would kill the MySQL server process. Of course these servers were primarily running MySQL. As such the MySQL server process was the one with the largest amount of memory allocated. But...
