Bug #36705 key_buffer_size of >= 2G allocates all available virtual memory on 64-bit windo
| Submitted: | 14 May 2008 3:09 | Modified: | 22 May 2008 12:38 |
|---|---|---|---|
| Reporter: | Shane Bester (Platinum Quality Contributor) | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: MyISAM storage engine | Severity: | S2 (Serious) |
| Version: | 5.0.60-winx64 | OS: | Windows (64-bit) |
| Assigned to: | Alexey Botchkov | CPU Architecture: | Any |
| Tags: | key_buffer_size | ||
[14 May 2008 3:09]
Shane Bester
[14 May 2008 3:10]
Shane Bester
in the above description, --key_buffer_size=2048M caused over 9GB of virtual memory to be used up.
[14 May 2008 4:38]
Shane Bester
verified on 5.0.60-winx64
[17 May 2008 9:03]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/46799 ChangeSet@1.2630, 2008-05-17 12:53:47+05:00, holyfoot@mysql.com +1 -0 Bug #36705 key_buffer_size of >= 2G allocates all availabel virtual memory on 64-bit wondo. temporary variables of 'long' types were used to store ulong values, that causes init_key_cache to receive distorted parameters
[19 May 2008 8:24]
Bugs System
Pushed into 5.0.64
[19 May 2008 8:25]
Bugs System
Pushed into 5.1.25-rc
[20 May 2008 0:53]
Paul DuBois
Noted in 5.0.64, 5.1.25 changelogs. On WIndows 64-bit systems, temporary variables of long types were used to store ulong values, causing key cache initialization to receive distorted parameters. The effect was that setting key_buffer_size to values of 2GB or more caused memory exhaustion to due allocation of too much memory. Setting report to Need Doc Info pending push into 6.0.x.
[22 May 2008 9:49]
Bugs System
Pushed into 6.0.6-alpha
[22 May 2008 12:38]
Paul DuBois
Noted in 6.0.6 changelog.
[28 Jul 2008 13:50]
Bugs System
Pushed into 5.0.64 (revid:sp1r-holyfoot/hf@mysql.com/hfmain.(none)-20080517075347-24047) (pib:2) (Retry automatic marking, to ensure nothing is missed. cm01)
[28 Jul 2008 16:55]
Bugs System
Pushed into 5.1.25-rc (revid:sp1r-gkodinov/kgeorge@magare.gmz-20080518084255-27675) (version source revid:sp1r-gkodinov/kgeorge@magare.gmz-20080518084255-27675) (pib:3)
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.066 sec. using MySQL 8.4.7-u6-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.