Creating partitioned tables will lead to a rapid increase in memory utilization of mysqld process

Hello,everyone
when MySQL keeps creating partition tables, the memory utilization rate of mysqld process will increase rapidly, and the memory utilization rate of mysqld will not decrease after creating partition tables. This makes me very confused. After I delete the partition table of MySQL, the memory utilization of mysqld process will not decrease.Is this a MySQL bug or its own mechanism?
i provided steps to repeat the situation I encountered, please see the link below
https://bugs.mysql.com/bug.php?id=105726
mysql version:oracle mysql 8.0.19
operating system:red hat 7.5

1 Like

Hi! Please try with the latest version and if you observe the same behavior try using jemalloc library instead of malloc.

1 Like

Please Enabling jemalloc on Percona Server for MySQL 5.7 and 8.0 Series - Percona Database Performance Blog on how to enable jemalloc.

1 Like

hi, thanks for your reply on time, your advice is very useful

1 Like