File system for MySQL server on Ubuntu

[Hal Burgiss]

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