MySQL Forums
Forum List  »  MyISAM

myisam_data_pointer_size
Posted by: dryaf carol
Date: January 12, 2010 08:41PM

Hello

My Mysql database is on a 64 bit operating system which is a Debian Lenny and I uses default settings I uses also MiIsam storage engine. I am confusing about the limit that Myisam has on the tables size, I read that for 32 operating system it is limited to 4Gb I ask if this issue is solved once we use a 64 bit operating system ? or should I setup the global variable myisam_data_pointer_size in my.cnf to a value to increase the table capacity ? if yes which is the value to set to this variable to have a table size up to 20 Gb ?

Thank you and hop to find an answer.

Options: ReplyQuote


Subject
Views
Written By
Posted
myisam_data_pointer_size
5668
January 12, 2010 08:41PM
2601
January 14, 2010 12:02AM


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.