Re: Do not save tables in ram?

On Mon, 2007-10-01 at 21:52 -0700, Jake Conk wrote:
> 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)?

Tables don't use more than one tablespace.

Each table (well..... in the future, a partition) is stored in a single tablespace.

A tablespace is made up of zero to many data files.

you can query the INFORMATION_SCHEMA.FILES table to show files with free extents. Although, there may be room inside these allocated extents, so this isn't entirely perfect.

> 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?

Yes, they can do.

You can query the total used undo in the logfile group from the INFORMATION_SCHEMA.FILES table.

-- 
Stewart Smith, Senior Software Engineer
MySQL AB, www.mysql.com
Office: +14082136540 Ext: 6616
VoIP: 6616@sip.us.mysql.com
Mobile: +61 4 3 8844 332

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html


application/pgp-signature attachment: This is a digitally signed message part

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek