 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| • |
Fileysystem Issues
|
|
|
|
– |
Spread data among disks
|
|
|
|
• |
Put heavily used and lightly used databases together
|
|
|
|
• |
RAID-5 or
RAID-10 for data (w/batter-backed cache)
|
|
|
• |
RAID-1
for logs
|
|
|
|
• |
New CREATE
TABLE makes this
easier
|
|
|
|
– |
Logs separate from data
|
|
|
|
• |
Logs are mostly serialized writes
|
|
|
|
• |
Tables are updated and used in mostly random
fashion
|
|
|
|
– |
If you have a lot of tables in a database
|
|
|
|
• |
Use a filesystem designed to handle it
|
|
|
|
• |
ResiserFS is a good choice
|
|
|
|
– |
A journaling filesystem
|
|
|
|
• |
Makes crash recovery faster
|
|
|
|
• |
Better utilizes disk I/O (usually)
|
|