Large Heap Tables - Limits on 64bit Systems?

[LucL]

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.

 

[ingresman]

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.

 

[LucL]

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.