MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

Re: key_buffer_size > 4GB
Posted by: KimSeong Loh
Date: March 15, 2006 07:19PM

It is possible to have more than 4GB in total, you can have multiple key buffer in version 4.1 onwards, and the 4GB limit is on each key buffer.

Extract from http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html
=========================
As of MySQL 4.1, it is possible to create multiple MyISAM key caches. The size limit of 4GB applies to each cache individually, not as a group. See Section 7.4.6, “The MyISAM Key Cache”.
=========================
See http://dev.mysql.com/doc/refman/4.1/en/myisam-key-cache.html

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
key_buffer_size > 4GB
5088
Saar Barhoom
March 15, 2006 07:18AM
Re: key_buffer_size > 4GB
2059
Ingo Strüwing
March 15, 2006 09:14AM
Re: key_buffer_size > 4GB
2407
KimSeong Loh
March 15, 2006 07:19PM
Re: key_buffer_size > 4GB
2070
Saar Barhoom
March 16, 2006 01:43AM
Re: key_buffer_size > 4GB
2038
Ingo Strüwing
March 17, 2006 10:17AM


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.