Re: Do not save tables in ram?

Matthew,

Say you have a table that uses 3 table spaces, the first 2 are full and you only care to see the percentage of the 3rd table filling up so you can create another table space before time runs out. How would you create a query that only shows the table spaces which are filling up (excluding ones that are already filled)?

Also, do undo files get filled up? I don't see in the information_schema files page examples on querying the size of undo files and not sure if we have to add undo files if the ones we created initially get filled up?

Btw, thanks so much for being patient with me and answering all my questions. I don't know what way to thank but I really do appreciate all the information you've given me and hopefully it will be useful to someone else as well :)

Thanks,
- Jake

On 10/1/07, Matthew Montgomery <mmontgomery@mysql.com> wrote:
> 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