File system for MySQL server on Ubuntu

[Alan Holt]

Thank u for yours advices,
what I do right now, it's reading man page for ext4, like MR ZenWizYou told.
it's a lot of information there.
Also I'll try to use Hal Burgiss advice about to tweak MySQL.
It's a lot of work there, thank u guys for advices. Now I know where to
look...

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

>
> On Tue, Feb 22, 2011 at 1:48 PM, Alan Holt <berber.it at gmail.com> wrote:
>
>> 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 =(
>>
>>
> I think google is using ext4 now, so its probably safe for the rest of us.
>
> But I honestly think from pure performance standpoint, you will better
> spend your time configuring mysql probably, tweaking whatever filesystem you
> do use, buying your hardware right for the task at hand, and optimizing your
> sql queries.
>
> I'd also suggest finding a mysql specific developers forum, since this is
> getting pretty far afield for this list. Not a users forum, but people who
> do high end mysql work. Like the guys at facebook :/
>
>
>
>
> --
> 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/ec5b2f79/attachment.html>