File system for MySQL server on Ubuntu

[Alan Holt-2]

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!

--

בברכה, 

אלכס ברבר

[phone]

www.linuxspace.org

--

Best regards.

Alex Berber

[phone]

www.linuxspace.org

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Alan Pope-3]

On 22 February 2011 17:33, Alan Holt <[hidden email]> wrote:
> What's your opinion ? Is Reiser the best or may it be ext3, ext4, xfs or
> another
> FS?

There's a nice answer to this (via google) at serverfault.

http://serverfault.com/questions/29193/what-is-the-best-linux-filesystem-for-mysql-innodb/29563#29563

Cheers,
Al.

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Gilles Gravier-2]

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

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Thibault DUPUIS]

ReiserFS or XFS were the best filesystem for MySQL

Le 22 févr. 2011 à 18:33, Alan Holt a écrit :

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!

--

בברכה, 

אלכס ברבר

[phone]

www.linuxspace.org

--

Best regards.

Alex Berber

[phone]

www.linuxspace.org

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Hal Burgiss]

On Tue, Feb 22, 2011 at 12:33 PM, Alan Holt <[e-mail]> 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

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Alan Holt-2]

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 =(

On Tue, Feb 22, 2011 at 8:13 PM, Hal Burgiss <[hidden email]> wrote:

On Tue, Feb 22, 2011 at 12:33 PM, Alan Holt <[e-mail]> 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

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

--

בברכה, 

אלכס ברבר

[phone]

www.linuxspace.org

--

Best regards.

Alex Berber

[phone]

www.linuxspace.org

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[MR ZenWiz]

On Tue, Feb 22, 2011 at 10:48 AM, Alan Holt <[hidden email]> 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 =(

1) Please do not top-post to this list.

2) In what way would you need to configure the filesystem other than
by using the defaults?

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Alan Holt-2]

>In what way would you need to configure the filesystem other than
>by using the defaults?

To make FS much faster for reading then for writing. 

--

בברכה, 

אלכס ברבר

[phone]

www.linuxspace.org

--

Best regards.

Alex Berber

[phone]

www.linuxspace.org

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Hal Burgiss]

On Tue, Feb 22, 2011 at 1:48 PM, Alan Holt <[e-mail]> 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
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

[Alan Holt-2]

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 <[hidden email]> wrote:

On Tue, Feb 22, 2011 at 1:48 PM, Alan Holt <[e-mail]> 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
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

--

בברכה, 

אלכס ברבר

[phone]

www.linuxspace.org

--

Best regards.

Alex Berber

[phone]

www.linuxspace.org

--
ubuntu-users mailing list
[hidden email]
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users