Help ! I have try few question which is difficult for me....help.....

[Guest_imported]

1) As i know quota can work in ext2 but can quota work in FAT, UFS, XFS partition ?

2) if i my company have the large database as 1 terabytes, this database is use at the web enviroment, What database software should i use to inclese the best performmence ?(a/b/c/d) ??
-a)Put every field into a different table.
-b)Use mptools to set up massively parallel access to the data in the database.
-c)Use a Beowulf cluster with MySQL. MySQL automatically configures itself for use in a Beowulf environment. Index commonly used fields.
-d)Divide the database into n pieces. Put 1/n of the database on individual computers in a cluster. Index commonly used fields.

 

[meekrob]

XFS has Reiser support:

http://oss.sgi.com/projects/xfs/

For large databases you might look at Postgres:

http://www.postgresql.org/

 

[ifincham]

Hi,

1) Quota does work with XFS and UFS but I'm not sure about FAT which is a non-unix type filesystem anyway.

2) I'd say option 3. Seems MySql still is the best performing but version 3.x.x does not support quite a few SQL statements - such as subqueries and Unions - so can be tricky at times for complex manipulations. Version 4.x should resolve some of the shortcomings and is now in alpha.

Postgresql is, in my view, a superior product in the sense of looking for a true rdbms but it doesn't seem quite as fast unfortunately.

Hope this helps