# Memory usage high, 37 Gig for memory/innodb/memory

**URL:** <https://forums.percona.com/t/memory-usage-high-37-gig-for-memory-innodb-memory/25631>\
**Category:** Percona Server for MySQL 8.0\
**Tags:** mysql\
**Created:** [October 3, 2023, 2:27pm UTC](https://forums.percona.com/t/memory-usage-high-37-gig-for-memory-innodb-memory/25631 "2023-10-03T14:27:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![FrankD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/frankd/32/16105_2.png) [@FrankD](https://forums.percona.com/u/FrankD)\
**Post date:** [October 3, 2023, 2:27pm UTC](https://forums.percona.com/t/memory-usage-high-37-gig-for-memory-innodb-memory/25631/1 "2023-10-03T14:27:12Z")

</div>

performance\_schema.memory\_summary\_global\_by\_event\_name show 37 Gig for memory/innodb/memory. I m trying to figure out what takes that 37 Gig.  
Server has 128G memory total,  
SELECT event\_name,CURRENT\_NUMBER\_OF\_BYTES\_USED/1024/1024 meg FROM performance\_schema.memory\_summary\_global\_by\_event\_name order by 2 asc  
gives:  
…  
| memory/performance\_schema/table\_lock\_waits\_summary\_by\_table | 1005.12500000 |  
| memory/innodb/dict0dict | 1086.38256168 |  
| memory/innodb/std | 1098.37751007 |  
| memory/performance\_schema/table\_shares | 2992.00000000 |  
| memory/performance\_schema/table\_io\_waits\_summary\_by\_index\_usage | 3201.00000000 |  
| memory/innodb/os0event | 4183.55808258 |  
| memory/innodb/memory | 37803.52789307 |  
| memory/innodb/buf\_buf\_pool | 50257.50000000 |  
±-------------------------------------------------------------------------------±---------------+

So i have to keep innodb\_buffer\_pool at 48G on a 128G dedicated server so i do not start having memory issue.

---

<div class="post-metadata">

**Author:** ![FrankD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/frankd/32/16105_2.png) [@FrankD](https://forums.percona.com/u/FrankD)\
**Post date:** [October 3, 2023, 2:28pm UTC](https://forums.percona.com/t/memory-usage-high-37-gig-for-memory-innodb-memory/25631/2 "2023-10-03T14:28:23Z")

</div>

Trying to find what parameter impact memory/innodb/memory ?

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [October 3, 2023, 3:14pm UTC](https://forums.percona.com/t/memory-usage-high-37-gig-for-memory-innodb-memory/25631/3 "2023-10-03T15:14:48Z")

</div>

There are a lot of “memory” related views in the [sys schema](https://github.com/mysql/mysql-sys) that you should look through to identify where the memory is being allocated.

> [@FrankD](#):
>
> Trying to find what parameter impact memory/innodb/memory

This is probably a summation of several parts of memory. You would have to inspect the MySQL source code to find all the locations where this value is modified.