Linux file system for MySQL

1152330 pts.
Tags:
File System
Linux
MySQL
What would be the best Linux file system for MySQL? My database is a web-based OLTP (and 90% read). Any help would be appreciated. I'm leaning towards XFS.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Check out this documentation

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • AjitK29
    You should have a look at :
    http://serverfault.com/questions/29193/what-is-the-best-linux-filesystem-for-mysql-innodb
    2,545 pointsBadges:
    report
  • TheRealRaven
    As is almost always true, there is no "best" unless you're thinking about best for you. We don't know what's best for you because we don't know your experience, we don't know your staff, we don't know your environment, we don't know the customers of your database.

    Before choosing a filesystem, you should first ensure that your hardware/network is appropriate (faster HDDs, disk controllers, RAM, etc.). Those areas can have much more impact in almost every aspect of "best" than the filesystem will. And some elements of those might affect which filesystem is "best" for you.

    Also, it may depend on whether you use MyISAM over InnoDB for any of your tables. It can be beneficial for some tables to be created under MyISAM, and for those circumstances, the filesystem can make a real difference.

    In general, choice is probably between ext4 and xfs for now. Various benchmarks can be found, such as Filesystems comparison using sql-bench and mySQL. Comparing benchmarks from different sources is difficult since "environment" and "staff" can have large impacts. One change in tuning parameters can make a big difference, as can different hardware.

    In short, you have to determine what "best" means for you. You can then seek out benchmarks (or better, run your own) and compare for elements that are important for you.
    36,320 pointsBadges:
    report
  • Elizine
    Hi,

    XFS features - 

    • screams with enormous files, fast recovery time
    • very fast directory search
    • Primitives for freezing and unfreezing the filesystem for dumping
    1,145 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: