Not the answer you need?
Register and ask your own question!

MySQL RES memory showing very low after enabling HugeTLB

lijumathewlijulijumathewliju EntrantCurrent User Role Beginner
Hello

I have enabled HugeTLB in one the test server prior to analyse the performance improvement. This server has 16 core 48G, raid 5 array. I have set 38G for inoodb_buffer_pool_size and set 40G for MySQL SGA.

InnoDB buffer pool - 38G (/etc/my.cnf)
/etc/sysctl.conf
kernel.shmmax = 5200936960 ( 40x1024x1024x1024)
kernel.shmall = 1269760 a. vm.nr_hugepages= 20480
vm.hugetlb_shm_group=498


b. /etc/security/limits.conf
mysql soft memlock unlimited
mysql hard memlock unlimited

All looks good after restarting the MySQL service. it's occupy the memory as we decided. Top command showing that RES is consuming just 2G ram and VRTS is occupying 41.4G RAM. VRTS is denoted for virtual memory and I'm assuming that Physical memory is not been used by MySQL. So suspecting there is something wrong with our hugeTLB settings. Can anyone advise

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2444 root 20 0 493m 8580 3436 S 0.3 0.0 0:38.15 dsm_sa_snmpd
3388 mysql 20 0 41.4g 2.0g 5644 S 0.3 4.3 1:27.23 mysqld
8163 root 20 0 15164 1352 956 R 0.3 0.0 0:00.59 top

Pls advise

Thanks
Liju

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.