Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Large Heap Tables - Limits on 64bit Systems?

Status
Not open for further replies.

LucL

Programmer
Jan 23, 2006
117
US
Hey guys,

I'm looking to store large tables in memory for quick access. I've done this before on standard 32bit systems running mysql/linux but there is a 4GB heap table limit.

I'm looking to store memory tables that are 32GB-128GB in size on a 64bit system running latest mysql and linux and I'm wondering if anyone has any experience with MySQL and tables of that big.

I'm particularly interested in any limitations mysql may place (ex: maybe you can't have heap tables that are 64GB) and performance reviews.

Thanks!
Luc L.
 
I think your best bet would be to try it out.
Going out on a limb here but most MySQL systems are probabbly web based with much smaller data sets that your talking about.
I'd be interested in your results though.
 
Cool, thanks.

The only reason I've been delaying the server purchase is because I'm not sure if I should spend the few extra grand on memory or not. A server with 64GB of ram will run a few thousand and would be a waste for my needs if mysql didn't support that for memory tables.

I'll give it a shot in about a month and update this thread with the results.

Luc L.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top