<br><div class="gmail_quote">On Tue, Feb 22, 2011 at 1:48 PM, Alan Holt <span dir="ltr"><<a href="http://berber.it">berber.it</a>@<a href="http://gmail.com">gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div dir="ltr">Thank u, for your explanation, the primary role of my MySQL Ubuntu Server will be storage with the big massive of static data. <div>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. </div>
<div><br></div><div>Actually it's has to be DB storage. </div><div><br></div><div>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. </div>
<div>It's exactly what I need, but I am not sure that I know how to configure it's right =(</div><div><br></div></div></blockquote><div><br></div><div>I think google is using ext4 now, so its probably safe for the rest of us.</div>
<div><br></div><div>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. </div>
<div><br></div><div>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 :/</div>
<div><br></div><div><br></div><div> </div></div><br>-- <br>Hal<br>