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