Mysqld process's memory usage is very high

MySQL & MariaDB
1

Hello,everyone
I faced a puzzled issue that mysqld process’s memory usage is very high, the memory usage of mysqld process is 95% of operating system, and I don’t know where is the memory allocated, so I query the usage of mysqld memory via sys.memory_global_by_current_bytes view, but the i am confused by the result

what does the memory/innodb/memory event mean?why it’s high_alloc is 161.68 GiB ?
I did’t use any memory storage engine tables
mysql> select * from sys.memory_global_by_current_bytes limit 20;
±-----------------------------------------------------------------------------±--------------±--------------±------------------±-----------±-----------±---------------+
| event_name | current_count | current_alloc | current_avg_alloc | high_count | high_alloc | high_avg_alloc |
±-----------------------------------------------------------------------------±--------------±--------------±------------------±-----------±-----------±---------------+
| memory/innodb/buf_buf_pool | 80| 10.23 GiB | 131.00 MiB | 80| 10.23 GiB | 131.00 MiB |
| memory/innodb/memory | 667654| 736.94 MiB | 1.13KiB | 140786952| 161.68 GiB | 1.20 KiB |

extra information
mysql version:oracle mysql 8.0.19
operating system:red-hat 7.7
operating system physical memory:42G
innodb_buffer_pool_size:10G

I also hope to get some ways about how to accurately view MySQL memory allocation

2

Hi, the per-thread buffers can be contributing to high memory. I suggest you use this calculator to figure out what’s your potential max memory usage: https://www.mysqlcalculator.com/

1 Like