June 20, 2013

Comment: Should you have your swap file enabled while running MySQL ?

…_pool_size=31G): InnoDB: HugeTLB: Warning: Failed to allocate 33286012928 bytes. errno 12 InnoDB HugeTLB: Warning: Using conventional memory pool Warning: Failed to allocate 440401920 bytes from HugeTLB memory. errno 12 /proc/sys/vm/nr_hugepages is 25000 (which is what I set it to at…

Comment: Should you have your swap file enabled while running MySQL ?

… looks like this: # Memory optimization vm.nr_hugepages = 14336 vm.hugetlb_shm_group = 27 kernel.shmmax = 8589934592 kernel.shmall = 4194304 My… InnoDB: Initializing buffer pool, size = 4.0G InnoDB: HugeTLB: Warning: Failed to allocate 4412407808 bytes. errno 12 InnoDB HugeTLB: Warning: Using conventional memory pool Even though when I ps…