Olaf,
That's a very broad question depending upon your exact requirements
to be honest. So long as you've considered file size limitations and
you've opted for a decent RAID system there's not too much more to worry
about, try and buy the fastest disks possible obviously i.e. 15,000 RPM
ones that are specifically designed for RAID setups etc...
Regards,
Phil
There is a RAID now an there will definitely one in the new setup.
As far as the max file sizes from the file systems go I am not worried after
all I read. Thanks for those links btw.
Besides the size though, what should I pay attention to when selecting the
file system
Thanks
Olaf
On 12/29/06 11:31 AM, "Philip Mather" <[EMAIL PROTECTED]> wrote:
Olaf,
Thanks for the detailed answer.
So basically the limitations come from the OS and the file system used.
What is the best file system to use for mysql (not considering the filesize
limitations)?
Thanks
Olaf
The "best" is probably ZFS if you really are intent on make things huge,
http://en.wikipedia.org/wiki/Zettabyte_File_System but check out the
very useful http://en.wikipedia.org/wiki/Comparison_of_file_systems page
as well. Dunno about speed-wise, but you'd end up in an argument
centering around RAID probably?
Regards,
Phil
-------------------------
Olaf Stein
DBA
Center for Quantitative and Computational Biology
Columbus Children's Research Institute
700 Children's Drive
phone: 1-614-355-5685
cell: 1-614-843-0432
email: [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]