File system for MySQL server on Ubuntu

[Gilles Gravier]

Hi, Alan!

On 22/02/2011 12:33, Alan Holt wrote:
> Hi,
>
> 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?
>
> Thank you!

Use MySQL 5.5 and use the InnoDB high performance transactional
datastore. Now that oracle owns MySQL and previously owned InnoDB, they
are now jointly bundled and integrated. Use it. :)

Gilles