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'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.