# For Percona MySQL which is preferred the file system

**URL:** <https://forums.percona.com/t/for-percona-mysql-which-is-preferred-the-file-system/6489>\
**Category:** General Questions\
**Created:** [August 2, 2018, 10:48pm UTC](https://forums.percona.com/t/for-percona-mysql-which-is-preferred-the-file-system/6489 "2018-08-02T22:48:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![johnsonmjacobs](https://avatars.discourse-cdn.com/v4/letter/j/8dc957/32.png) [@johnsonmjacobs](https://forums.percona.com/u/johnsonmjacobs)\
**Post date:** [August 2, 2018, 10:48pm UTC](https://forums.percona.com/t/for-percona-mysql-which-is-preferred-the-file-system/6489/1 "2018-08-02T22:48:47Z")

</div>

Hi All,

Currently we are running on Ext4 file system but we can see the journal (jdb2) process is adding significant CPU. Also we can experience high IO on the system. We are planning to move to SSD with Percona MySQL 5.6.40 (innodb engine) and would like to know which file system is best suited for a busy server with 1.6 TB of data and an average data growth of 2 GB per day (high read and write).

Regards,  
Johnson

---

<div class="post-metadata">

**Author:** ![vadimtk](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadimtk/32/9528_2.png) [@vadimtk](https://forums.percona.com/u/vadimtk)\
**Post date:** [August 3, 2018, 12:13am UTC](https://forums.percona.com/t/for-percona-mysql-which-is-preferred-the-file-system/6489/2 "2018-08-03T00:13:36Z")

</div>

You should be fine with Ext4, but some may prefer XFS for heavy loaded systems

---

<div class="post-metadata">

**Author:** ![johnsonmjacobs](https://avatars.discourse-cdn.com/v4/letter/j/8dc957/32.png) [@johnsonmjacobs](https://forums.percona.com/u/johnsonmjacobs)\
**Post date:** [August 3, 2018, 1:13am UTC](https://forums.percona.com/t/for-percona-mysql-which-is-preferred-the-file-system/6489/3 "2018-08-03T01:13:41Z")

</div>

Vadimtk, Thanks for the reply.

If I am going with Ext4 do I need to add any option in the file system for better performance. I am using the default now.

/dev/mapper/applvg-xxxx /var/opt/data/xxx ext4 defaults 1 2

Also for minimizing the IO do I need to consider the below parameters.

sync\_binlog = 1 (1 → 0)  
innodb\_adaptive\_flushing = 1  
innodb\_flush\_log\_at\_trx\_commit = 1 ( 1–\> 2 )  
innodb\_flush\_method = O\_DIRECT

Regards,  
Johnson

---

<div class="post-metadata">

**Author:** ![vadimtk](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadimtk/32/9528_2.png) [@vadimtk](https://forums.percona.com/u/vadimtk)\
**Post date:** [August 3, 2018, 1:07pm UTC](https://forums.percona.com/t/for-percona-mysql-which-is-preferred-the-file-system/6489/4 "2018-08-03T13:07:12Z")

</div>

For ext4 - if you are running of physical SSD, I’d recommend to use discard option to format and mount ext4 filesystem.

For InnoDB - set innodb\_io\_capacity to 2500 and innodb\_io\_capacity\_max to 4500

as for sync\_binlog=0 and innodb\_flush\_log\_at\_trx\_commit = 2 - you can do that, but you risk your database durability. if you are fine with that, you can make these changes.  
But really the best what else you could do is to upgrade from 5.6 to 5.7

---

<div class="post-metadata">

**Author:** ![johnsonmjacobs](https://avatars.discourse-cdn.com/v4/letter/j/8dc957/32.png) [@johnsonmjacobs](https://forums.percona.com/u/johnsonmjacobs)\
**Post date:** [August 5, 2018, 1:22am UTC](https://forums.percona.com/t/for-percona-mysql-which-is-preferred-the-file-system/6489/5 "2018-08-05T01:22:41Z")

</div>

Thank you for your detailed reply.

​​​​​​What I can gain by upgrading to 5.7 from. 5.6 in terms of disk performance and overall performance

Regards,  
Johnson