9 messages in com.mysql.lists.clusterRe: Do not save tables in ram?
FromSent OnAttachments
Jake Conk28 Sep 2007 18:15 
Matthew Montgomery28 Sep 2007 20:27 
Jake Conk01 Oct 2007 15:28 
Matthew Montgomery01 Oct 2007 18:35 
Jake Conk01 Oct 2007 19:24 
Matthew Montgomery01 Oct 2007 20:02 
Jake Conk01 Oct 2007 21:52 
Stewart Smith02 Oct 2007 20:31 
Matthew Montgomery02 Oct 2007 20:58 
Subject:Re: Do not save tables in ram?
From:Matthew Montgomery (mmon@mysql.com)
Date:10/01/2007 08:02:26 PM
List:com.mysql.lists.cluster

On Mon, 2007-10-01 at 19:25 -0700, Jake Conk wrote:

Matthew,

Ok so we have to keep adding more data files as the end of tablespace is reached.

Last 2 questions... When creating tablespaces. data files, log files, etc, are they automatically replicated on each data node or must you create them each individually on each node or do they only live on the node they are created?

These files are created on all data nodes. There are no table space data or log files on the SQL nodes.

... And lastly, is there something out there to warn you when your usage is almost up so you can add more data files etc so your cluster does not fail when users are trying to input data?

You can query the information schema to see how many free extents are in a data file.

mysql> select TABLESPACE_NAME, FILE_NAME, (FREE_EXTENTS/TOTAL_EXTENTS)*100 as PERCENT_FREE , EXTRA from information_schema.FILES where FILE_TYPE='DATAFILE'; +-----------------+-----------+--------------+----------------+ | TABLESPACE_NAME | FILE_NAME | PERCENT_FREE | EXTRA | +-----------------+-----------+--------------+----------------+ | ts_1 | ts_1.dat | 100.0000 | CLUSTER_NODE=3 | | ts_1 | ts_1.dat | 100.0000 | CLUSTER_NODE=4 | +-----------------+-----------+--------------+----------------+ 2 rows in set (0.00 sec)

By default you will have a 1MB extent size. So it will only be that precise.

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