File system for MySQL server on Ubuntu

[Hal Burgiss]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20110222/c207f031/attachment.html>