How does Mysql select a file system? (Ext4vsext3vsjfsvsxfsvsreiserfs performance competition)

How does Mysql select a file system? (Ext4vsext3vsjfsvsxfsvsreiserfs performance competition) -- Linux Release Technology-Debian information. For more information, see the following.
How does Mysql select a file system? (Ext4 vs ext3 vs jfs vs xfs vs reiserfs performance competition): Donggang　

How to Improve mysql performance? Correct File System Selection is definitely an effective method. EXT4 has been around for a while. How does mysql perform in EXT4?

This article tests the performance of several common linux File Systems (ext4, jfs, reiserfs, xfs, ext3, and file system installation) in mysql.

1. Test with super-smack
Test method:
TimeSuper-smack-d mysql select-update.smack 10 50000 (50 10000,100 5000,200 2500 )
ReadSQL: SelectSQL _NO_CACHE *From TestWhere Id= 'Random ';
WriteSQL: update Test Set Id= Id+ 1 where Id= 'Random ';

Test result, completion time comparison:


(400) {this. resized = true; this. width = 400; this. alt = 'click here to open new window';} "onmouseover =" if (this. resized) this. style. cursor = 'hand'; "onclick =" window. open ('HTTP: // www.bigheaddba.net/wp-content/uploads/2009/06/mysql_test.gif'); ">
Comparison of execution times per second:


(400) {this. resized = true; this. width = 400; this. alt = 'click here to open new window';} "onmouseover =" if (this. resized) this. style. cursor = 'hand'; "onclick =" window. open ('HTTP: // www.bigheaddba.net/wp-content/uploads/2009/06/mysql_test3.gif'); ">

Ii. Test with mysqlslap

Test method:
/Usr / Local /Mysql /Bin /Mysqlslap-u root-p-h localhost-c 10,50, 100,200-I 1 \
-- Engine = myisam -- auto-generate-SQL-load- Type= Mixed -- number-of-queries = 50000 \
-- Number-char-cols = 5 -- number-int-cols = 5 -- auto-generate-SQL

Test results, compared by execution time:


(400) {this. resized = true; this. width = 400; this. alt = 'click here to open new window';} "onmouseover =" if (this. resized) this. style. cursor = 'hand'; "onclick =" window. open ('HTTP: // www.bigheaddba.net/wp-content/uploads/2009/06/mysql_test2.gif'); ">

From the test results, we can see that the performance of EXT4 is not as powerful as we can imagine. It is not as bad as XFS, JFS, and REISERFS, but JFS is unexpected. In the case of high concurrency, best performance. Check the JFS version, which is the new version.

Mkfs. jfs-V
Mkfs. jfs version 1.1.14, 06-Apr-2009

So how should we choose?

The EXT3 is too old. REISERFS is in jail because the author cannot guarantee updates, so PASS first. EXT4 is new after all, and the kernel needs to be upgraded after 2.6.28, let others eat crabs first. The remaining options are JFS and XFS. JFS is backed by IBM, and stability and subsequent BUG fixes are reliable. From the test, the performance is slightly better than XFS, so I think JFS should be the first choice, and then XFS.