Re: Do not save tables in ram?

From: Matthew Montgomery <mmontgomery(at)mysql.com>
Date: Mon Oct 01 2007 - 23:02:49 EDT

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


-- 
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 Mon Oct 1 23:03:56 2007