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

MySQL & MariaDB Percona Server for MySQL 8.0
1

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.

2

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

3

There are a lot of “memory” related views in the sys schema that you should look through to identify where the memory is being allocated.

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.