MySQL Forums
Forum List  »  NDB clusters

Logfile group and tablespace file sizes
Posted by: Jason Downing
Date: July 05, 2006 09:33PM

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?
2. What size should I make my undo_buffer_size?
3. How many undofiles should I have?
4. What should be the initial size of my datafile?
5. How many datafiles should I have?
6. Do I need a separate datafile for each database?
7. Do I need a separate datafile for each table?
8. Are these questions already documented somewhere?

Thanks very much

Options: ReplyQuote


Subject
Views
Written By
Posted
Logfile group and tablespace file sizes
1612
July 05, 2006 09:33PM


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.