MySQL Forums
Forum List  »  Install & Repo

Why does MYSQL crash when the key_buffer is set above 4096M on a AMD64 platform?
Posted by: Richard Simnett
Date: December 04, 2007 12:55AM

Hello,
Why does MySQL crash during a query execution when the key_buffer size in the my.cnf is set above 4096M. I am running a dual proc AMD 64 dual core system, with 32 gigs of ram. I am using MyISAM tables, and to performance tune have been trying to set the key_buffer size to roughly that of the .MYI files on disk. Everytime I attempt this at a key_buffer size above 4096M mysql crashes after allocating only about 2 gigs of ram to the query. Here is a link of the same question I posted on another IT help site:

http://www.experts-exchange.com/Database/MySQL/Q_22984336.html

Thanks,
Rick

Options: ReplyQuote


Subject
Written By
Posted
Why does MYSQL crash when the key_buffer is set above 4096M on a AMD64 platform?
December 04, 2007 12:55AM


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.