File system for MySQL server on Ubuntu

[Alan Holt]

Thank u, for your explanation, the primary role of my MySQL Ubuntu Server
will be storage with the big massive of static data.
Would be really important, it's searching. Like for example when you need to
find one specific file from the billions and you need to find this in fast
way.

Actually it's has to be DB storage.

I thought about XFS or EXT4, because ext4 filesystem can support volumes
with sizes up to 1 exabyte and files with sizes up to 16 terabytes.
It's exactly what I need, but I am not sure that I know how to configure
it's right =(

On Tue, Feb 22, 2011 at 8:13 PM, Hal Burgiss <hal at burgiss.net> wrote:

> On Tue, Feb 22, 2011 at 12:33 PM, Alan Holt <berber.it at gmail.com> wrote:
>
>> I wonder which is the best filesystem to use with MySQL (to increase
>> performances) for huge MySQL server.
>>
>> I believe that MySQL needs fast creating/deleting files operation during
>> temporary table creation by example but also needs fast reading when
>>  extracting lots of rows from a big table.
>>
>> What's your opinion ? Is Reiser the best or may it be ext3, ext4, xfs or
>> another
>> FS?
>>
>
> Do you know what the server will be doing as a primary role? I ask because
> things like temporary tables are somewhat application specific. That being
> said, if I were starting from scratch I'd get the fastest drives I could,
> investigate raid controllers performance, config your partitions conrectly
> (ie turn off atime type settings ), and make sure to have plenty of memory
> for table and query caching available, etc. I suspect those things might
> make more difference than the filesystem for most use cases.
>
> I personally use ext3, and worry about the other stuff I mentioned above.
> --
> Hal
>
> --
> ubuntu-users mailing list
> ubuntu-users at lists.ubuntu.com
> Modify settings or unsubscribe at:
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
>
>


-- 
*בברכה, *
*אלכס ברבר*
*+9 72 54 285 952 3
*
*www.linuxspace.org* <http://www.linuxspace.org>
*--*
*Best regards.*
*Alex Berber*
*+9 72 54 285 952 3*
*www.linuxspace.org* <http://www.linuxspace.org/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20110222/5459f2b5/attachment.html>