MySQL Forums
Forum List  »  NDB clusters

Re: Logfile group and tablespace file sizes
Posted by: Mikael Ronström
Date: July 13, 2006 12:57PM

Hi,


Jason Downing Wrote:
-------------------------------------------------------
> Supposing I want to bring a 5 Gb dataset into
> version 5.1.11, and I estimate that 4 Gb of it is
> not indexes and can be stored on disk. I also (if
> this is relevant, I'm not sure) will back up my
> database every hour, and will accumulate data at
> the the rate of 1 Gb per year. The dataset
> consists of 5 different databases.
>
> 1. What initial size should I make my undofile?

This is only related to the update speed. If you choose
a Gigabyte you should be very safe.

> 2. What size should I make my undo_buffer_size?

Again dependent on update speed so unless you have specific needs
use the default.

> 3. How many undofiles should I have?

1 is sufficient unless you want to use space from several partitions.

> 4. What should be the initial size of my
> datafile?

Given that data on disk still doesn't use true varchar you should expect
that the size on disk will be bigger than 4 GB. So to start with you can
set it to e.g. 10 GB. If it needs to grow you can add another file to a
tablespace. You can add files but you cannot extend a file.

> 5. How many datafiles should I have?

As few as possible to meet the needs of using your disks in a proper manner.

> 6. Do I need a separate datafile for each
> database?
> 7. Do I need a separate datafile for each table?

No, tablespaces can be one per table, one in the entire system and
anything in between. I would use only one tablespace and one file
unless I have reasons for managing my data or specific requirements
on the OS.

> 8. Are these questions already documented
> somewhere?
>

Some of them might be, however the answers are more suggestions
and not really suitable for a manual.

Rgrds Mikael

> Thanks very much

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog: http://mikaelronstrom.blogspot.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Logfile group and tablespace file sizes
962
July 13, 2006 12:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.