MySQL Forums
Forum List  »  InnoDB

Re: boot error
Posted by: Rick James
Date: January 30, 2015 12:08PM

> mysql v5.5.19 32bit

32bit is a hardware specification in the code/CPU. It means there is an unbreakable limit of 4GB (2**32) on memory addressability. That implies that the buffer_pool, plus other things that MySQL needs to allocate, must be less than 4G, and you really should not try to get even close to 3.9G.

That's a fact of hardware; a 32bit MySQL can't go beyond what 32bit allows.

Since you have 32GB of RAM (ignore the swap space -- don't plan of using it), switch to 64-bit mysql and set innodb_buffer_pool_size t- something like 21G.

Options: ReplyQuote


Subject
Views
Written By
Posted
2154
January 29, 2015 02:04PM
Re: boot error
957
January 30, 2015 12:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.