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

**URL:** <https://forums.percona.com/t/creating-partitioned-tables-will-lead-to-a-rapid-increase-in-memory-utilization-of-mysqld-process/13248>\
**Category:** Percona Distribution for MySQL\
**Created:** [November 27, 2021, 2:54pm UTC](https://forums.percona.com/t/creating-partitioned-tables-will-lead-to-a-rapid-increase-in-memory-utilization-of-mysqld-process/13248 "2021-11-27T14:54:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![zhouke](https://avatars.discourse-cdn.com/v4/letter/z/3bc359/32.png) [@zhouke](https://forums.percona.com/u/zhouke)\
**Post date:** [November 27, 2021, 2:54pm UTC](https://forums.percona.com/t/creating-partitioned-tables-will-lead-to-a-rapid-increase-in-memory-utilization-of-mysqld-process/13248/1 "2021-11-27T14:54:40Z")

</div>

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](https://bugs.mysql.com/bug.php?id=105726)  
mysql version:oracle mysql 8.0.19  
operating system:red hat 7.5

---

<div class="post-metadata">

**Author:** ![svetasmirnova](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/svetasmirnova/32/21_2.png) [@svetasmirnova](https://forums.percona.com/u/svetasmirnova)\
**Post date:** [December 2, 2021, 10:31am UTC](https://forums.percona.com/t/creating-partitioned-tables-will-lead-to-a-rapid-increase-in-memory-utilization-of-mysqld-process/13248/2 "2021-12-02T10:31:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![svetasmirnova](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/svetasmirnova/32/21_2.png) [@svetasmirnova](https://forums.percona.com/u/svetasmirnova)\
**Post date:** [December 2, 2021, 10:32am UTC](https://forums.percona.com/t/creating-partitioned-tables-will-lead-to-a-rapid-increase-in-memory-utilization-of-mysqld-process/13248/3 "2021-12-02T10:32:57Z")

</div>

Please [Enabling jemalloc on Percona Server for MySQL 5.7 and 8.0 Series - Percona Database Performance Blog](https://www.percona.com/blog/2020/12/02/enabling-jemalloc-on-percona-server-for-mysql-5-7-and-8-0-series/) on how to enable jemalloc.

---

<div class="post-metadata">

**Author:** ![zhouke](https://avatars.discourse-cdn.com/v4/letter/z/3bc359/32.png) [@zhouke](https://forums.percona.com/u/zhouke)\
**Post date:** [December 20, 2021, 3:33am UTC](https://forums.percona.com/t/creating-partitioned-tables-will-lead-to-a-rapid-increase-in-memory-utilization-of-mysqld-process/13248/4 "2021-12-20T03:33:54Z")

</div>

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