Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

Re: Do not save tables in ram?

From: Matthew Montgomery <mmontgomery(at)mysql.com>
Date: Fri Sep 28 2007 - 23:28:17 EDT


On Fri, 2007-09-28 at 18:16 -0700, Jake Conk wrote:
> Hello,
>
> I'm using MySQL 5.1 and I heard somewhere that the ndb cluster can be
> configured to not save your tables in RAM and instead just use disk.
> Does anyone know what configuration this is and is it possible to
> configure only certain nodes to store on disk and other nodes to store
> in ram?\
>

This is a bit of mis-information. NDB supports storing of non-indexed columns to an on-disk tablespace as of 5.1.6.

5.1 still uses a significant amount of memory for those indexed columns, and any tables not associated to a tablespace. But, obviously it is not nearly as much as 5.0 does.

See: http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-disk-data.html

-- 
Matthew Montgomery, Support Engineer
San Antonio, TX
MySQL Inc, www.mysql.com


-- 
MySQL Cluster Mailing List
For list archives: 
http://lists.mysql.com/cluster
To unsubscribe:    
http://lists.mysql.com/cluster?unsub=lists@pantek.com
Received on Fri Sep 28 23:28:54 2007

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 10:15:17 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library