| Bug #10204 | Memory DB: Restriction of 4 GB table size should not apply to 64-bit servers. | ||
|---|---|---|---|
| Submitted: | 27 Apr 2005 15:01 | Modified: | 14 Jun 2013 0:18 |
| Reporter: | Disha | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server | Severity: | S4 (Feature request) |
| Version: | 5.0.4 Beta | OS: | Linux (Linux 9.x) |
| Assigned to: | CPU Architecture: | Any | |
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.011 sec. using MySQL 8.0.36-u2-cloud
Timestamp references displayed by the system are UTC.
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.
© 2024, Oracle Corporation and/or its affiliates
Description: Memory DB Engine: Restriction of 4 GB table size should not apply to 64-bit servers. The MySQL restriction when creating tables with database engine set to 'Memory' is that table size cannot be greater than 4 GB. This restrication is applicable to 32-bit machines since they can address 4 GB of memory space. However, this is NOT true for 64-bit machines as they can address memory space of 17179869184 GB. How to repeat: On a 64-bit machine: 1. Select @@max_heap_table_size; This shows 16777216; #default heap size 2. Set @@max_heap_table_size = 5000000000; ##set to more than 4 GB. 3. Select @@max_heap_table_size ACTUAL The maximum heap size is set to 4294966272 (This is 4GB). EXPECTED On 64-bit servers, user should be able to set heap size to more tha 4GB, because it is possible to have memory tables larger than 4GB.