|
Can't able to allocate the large pages in the mysql instance
Hi all,
i having issue on the largepage size .. like.I am totally strucked in this error .. and donno how to fix the issue ..
error msg :
Warning: Failed to allocate 331350016 bytes from HugeTLB memory. errno 12
Warning: Using conventional memory pool
090708 16:43:45 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45-log' socket: '/var/run/mysqld/mysql1.sock' port: 3306 Source distribution
Following are my server configurations:
mysql> show variables like '%large%';
+---------------------+---------+
| Variable_name | Value |
+---------------------+---------+
| large_files_support | ON |
| large_page_size | 2097152 |
| large_pages | ON |
+---------------------+---------+
3 rows in set (0.00 sec)
/etc/sysctl.conf
# shmem allowed per segment (12G in this case)
kernel.shmmax = 1560281088
# total shared memory (4KB/page = 16GB)
kernel.shmall = 4194304
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
/etc/security/limits.conf
mysql soft memlock 5242880
mysql hard memlock unlimited
/proc/meminfo
HugePages_Total: 20
HugePages_Free: 20
HugePages_Rsvd: 0
Hugepagesize: 2048 kB
[root@atzsdbal009 mysql1]# id mysql
uid=201(mysql) gid=200(mysql) groups=200(mysql)
[root@atzsdbal009 mysql1]# cat /proc/sys/vm/hugetlb_shm_group
200
[root@atzsdbal009 mysql1]# cat /proc/sys/vm/nr_hugepages
20
[root@atzsdbal009 mysql1]# free -m
total used free shared buffers cached
Mem: 64443 1321 63122 0 192 626
-/+ buffers/cache: 502 63940
Swap: 8191 0 8191
[root@atzsdbal009 mysql1]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.2 (Tikanga)
[root@atzsdbal009 mysql1]# uname -a
Linux 2.6.18-128.1.6.el5 #1 SMP Tue Mar 24 12:05:57 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
Please any having any idea on this issue share with me .. Thanks !!
-- Kamalakkannan
|