File systems and file sizes?

[Craig Warnholtz]

I have to split a 6GB database into multiple extents and was told the the size of the extents depends on the file system (vxfs, jfs, etc). My current extent sizes are 256M but was considering increasing that to 500M.

How do I determine the current files systems?

And what are the largest files sizes recommended on the different file systems?

Thanks
Craig

[harry d brown jr]

Craig,

What do you mean that your extent sizes are 256M?

Can you tell us what OS you are running?

What Release of the OS you are running?

The database?

The storage units?

live free or die
harry

[Craig Warnholtz]

To clarify,
My OS is HP-UX 11.0, my Database is PROGRESS.
An "extent" is a file containing a section of the database. For example, my current PROGRESS database is split in to 24 files of 256MB each. Alternatively, I could split the database into 12 files (extents) of 500MB or at the extreme, put the whole database into one file of 6GB.

The question for me is, what is the largest most efficient file size for a hp-ux file system type? And How do I determine my current file system?

Thanks,
Craig

[harry d brown jr]

Craig,

It depends upon WHAT your storage device is, not what the OS can "handle".

You need to look at storage:

(1) number of io paths
(2) number of spindles (disks)
(3) raid level - if any
(4) speed of disks
(5) speed of IO connectivity (scsi, fibre, ...)
...

then you need to look at what the database vendor suggests that the database be divided into.

live free or die
harry

[Craig Warnholtz]

Hi Harry,
Thanks for your help. I'll look into those other issues.

Would you happen to know a unix command that would tell me my current files system type (vxfs, jfs, etc)?

Craig

[Stefan Farrelly · Accepted solution]

simpy cat /etc/fstab to see the filesystem type for each.