Comments on: Troubleshooting MySQL Memory Usage

By: james

james — Thu, 10 May 2018 16:20:38 +0000

In my case, only if long stick queries are killed. Any one else has the same experience please?
I had asked here as well: https://forums.mysql.com/read.php?20,664418,664472

By: Jason_asia

Jason_asia — Sun, 30 Mar 2014 17:02:36 +0000

i met this problem too,it’s very hard to make sure what happened with the mysql server…

By: KRMR

KRMR — Sun, 07 Oct 2012 08:53:39 +0000

Thanks a lot for great explanation. I am seeing huge memory used by MySQL server when no access it. I did check all memory sizes, and every thing seems low except but still the total memory used is high. I am suspecting it could be a memory leak. I am using Amazon’s RDS, I dont have access to the VM where MySQL is running,so I can’t see if there is any swap files is existing and growing. Is there anything more we can debug from DB side about memory leak?

Thanks.

By: hickey.liu@gmail.com

hickey.liu@gmail.com — Tue, 18 Sep 2012 03:24:47 +0000

Thanks a lot for the summarize of the analyze methods, it helps me diagnose one bug of the servers keep increasing memory in product environment. Great trouble-shooting sharing on MySQL.

By: Cédric

Cédric — Tue, 27 Mar 2012 11:56:52 +0000

Thx for this useful post.
I like to use /proc/${PROCESS_NUMBER}/smaps for memory usage.

By: Przemek

Przemek — Thu, 22 Mar 2012 14:28:59 +0000

I think it’s worth to say here that the InnoDB team has already made some effort to address memory usage problems: http://blogs.innodb.com/wp/2011/12/improving-innodb-memory-usage-continued/ . Results seem very promising, and also maybe these fixes will allow more precise memory usage monitoring.

By: Art van Scheppingen

Art van Scheppingen — Wed, 21 Mar 2012 20:21:52 +0000

Thanks for the insights!
Wouldn’t it be an idea to add a couple of these to the Percona Monitoring templates? I mean: I can’t remember seeing the memory tables in the templates while it may be giving a lot of extra information.
I guess my working day will be quite occupied with some practice tomorrow. 😉