Not Able to Increase InnoDB Buffer Pool Size in Mysql
0
votes
1
answer
1761
views
I am facing a very rare problem with my DB. I have Windows Server with 64 GB RAM but I am not able to increase innodb buffer pool size in mysql.
Current InnoDb buffer pool Size : 1.6G
When I increase it and restart Mysql then it throws Error :
161026 0:52:30 [Note] Plugin 'FEDERATED' is disabled.
161026 0:52:31 InnoDB: Initializing buffer pool, size = 2.6G
161026 0:52:31 InnoDB: Error: cannot allocate 2816491520 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 22604620 bytes. Operating system errno: 8
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
InnoDB: On FreeBSD check you have compiled the OS with
InnoDB: a big enough maximum process size.
InnoDB: Note that in most 32-bit computers the process
InnoDB: memory space is limited to 2 GB or 4 GB.
InnoDB: We keep retrying the allocation for 60 seconds...
161026 0:53:31InnoDB: Fatal error: cannot allocate the memory for the buffer pool
161026 0:53:31 [ERROR] Plugin 'InnoDB' init function returned error.
161026 0:53:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
161026 0:53:31 [ERROR] Unknown/unsupported table type: INNODB
161026 0:53:31 [ERROR] Aborting
I dont have 32 bit OS **but my MYSQL is 32 bit .** I have 64 bit OS on my Windows server.
Memory space is limited to 2 GB or 4 GB. For 32 bit Mysql but I am not able to make it 2 GB, my Innodb is only 1.6 GB .
Increasing size of Innodb is very necessary because i am getting following error in my error log :
MySql.Data.MySqlClient.MySqlException: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
What I have Already Tried :
1. I confirmed that My my.ini has no issue .
2. I restrted My mysql many times but innodb size not increasing.
At last I got from somewhere that Memory allocation to Mysql in my OS is very less thats why OS is not increasing its innodb size.
3. **I increased virtual memory of windows. It was 8GB before and I increased to to 16 GB. ( Did this change just now and dont know its result because it requires server restart and before 7 hours I cant restart my Server) - Do you think this can solve my problem ?**
MySQL Version : 5.1
If anyone know the solution then let me know, i will be very thank ful to you.
Asked by Mahesh Vema
(3 rep)
Oct 27, 2016, 11:38 AM
Last activity: Oct 27, 2016, 11:58 AM
Last activity: Oct 27, 2016, 11:58 AM