Mailinglist Archive: opensuse (4348 mails)

< Previous Next >
File system for SQL databases?
  • From: Alex Daniloff <alex@xxxxxxxxxxxx>
  • Date: Tue, 01 Oct 2002 14:49:02 -0700
  • Message-id: <200210012149.g91Ln2M05390@xxxxxxxxxxxxxxxxx>
Hello SuSE folkz,

Could somebody recommend me please what FS should be used for
SQL database partition. I want to run MySQL DB on my server and it has
following options:
1. MySQL database can handle a raw device partition to store and
organize the data.
2. MySQL can store InnoDB table data in a large data files on the top
of existing FS.

Which method is more preferable and what journaling FS is more
suitable to handle datafiles of 500 MB each?

Thank you in advance

Alex

< Previous Next >
References