MySQL Forums
Forum List  »  Memory Storage Engine

Re: Debugging Memory Engine Problem
Posted by: Rick James
Date: May 31, 2013 07:55PM

102268245 rows smells a lot like 4GB. However, I can find nothing in the online documentation that says there is a hard 4GB limit.

http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_max_heap_table_size
implies that there is a 4GB limit for a 32-bit build, but not for 64-bit. You do have a 32-bit version?
SHOW VARIABLES LIKE 'version%';
version_compile_machine = x86 would mean 32-bit.

This may be relevant:
http://bugs.mysql.com/bug.php?id=44138
(There are a lot of other bugs on this topic, some going back 8 years.)
Perhaps more telling...
http://lists.askmonty.org/pipermail/commits/2012-April/003198.html -- So it may be fixed in MariaDB? Give can't tell what version of MariaDB might have that fix. This says it has been "pushed":
https://bugs.launchpad.net/maria/+bug/794680
I would try the latest MariaDB 5.5.

Options: ReplyQuote


Subject
Views
Written By
Posted
5587
May 28, 2013 12:44PM
Re: Debugging Memory Engine Problem
2034
May 31, 2013 07:55PM


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.