Comments on: What To Do When MySQL Runs Out of Memory https://www.percona.com/blog/what-to-do-when-mysql-runs-out-of-memory-troubleshooting-guide/ Tue, 13 Feb 2024 18:47:23 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Andre https://www.percona.com/blog/what-to-do-when-mysql-runs-out-of-memory-troubleshooting-guide/#comment-10971929 Sun, 15 Mar 2020 06:49:20 +0000 https://www.percona.com/blog/?p=50495#comment-10971929 Hi,

according to the sentence “The largest chunk of RAM is usually the buffer pool but ~3G in stored procedures seems to be too high.”

How can I find the cause of the high memory usage of stored procedures?

Greetings
Andre

]]> By: doublemarket https://www.percona.com/blog/what-to-do-when-mysql-runs-out-of-memory-troubleshooting-guide/#comment-10969355 Fri, 06 Jul 2018 00:03:53 +0000 https://www.percona.com/blog/?p=50495#comment-10969355 Hello, thanks for the useful post about how we should start investigating memory issues!

Since this is nice, I’ve translated this into Japanese and posted it on my site yakst.com/ja/posts/5212

If it’s a problem, please let me know!

]]> By: Peter Zaitsev https://www.percona.com/blog/what-to-do-when-mysql-runs-out-of-memory-troubleshooting-guide/#comment-10969331 Fri, 29 Jun 2018 16:11:34 +0000 https://www.percona.com/blog/?p=50495#comment-10969331 If you ever wondered if it is MySQL which consumed a lot of memory consider looking at Per Process Memory Usage as described in this blog post https://www.percona.com/blog/2018/05/21/capturing-per-process-metrics-with-percona-monitoring-and-management-pmm/

I’ve seen many times when other processes were consuming a lot of memory but MySQL got blamed.

]]>