On Wed, 2005-04-06 at 12:46, Bas Meijer wrote:
> Dear Speedfreaks,
> Today I re-ran the filesystem tests on RehHat EL 4.
> To get accurate results I went for "ceteris paribus":
> same hardware, same disk sectors, same binaries, same config,
> same order of steps. Everything the same except filesystem for database,
> now on RHEL4.
> The testscript below was executed with the three filesystems available
> RedHat Enterprise 4 which was installed for this test. Each time a newly
> created filesystem was populated with a clean mysql database after that
> a sysbench test was run (first result were noted to eliminate cache
> CONCLUSION: RedHat does not offer the MySQL friendly journaling
> reiserfs, jfs, xfs; ext3's journaling is bad for mysql performance,
> tests on Suse showed that the other journaling filesystems perform
> RESULTS unit ext3 ext2 vfat average
> restore time secs 889.7 819.9 982.5 897.4
> create 2mln myisam secs 38.5 35.5 75.7 49.9
> create 1mln myisam secs 17.8 17.2 34.4 23.1
> create 1mln innodb secs 90.1 65.5 122.3 92.6
> create 1mln bdb secs 18.7 17.8 36.4 24.3
> overall write score 103.1% 113.8% 86.9%
This is very interesting. EXT3 on RedHat kernel is significantly faster
than one on SuSE, at least for restore. It goes more inline with
performance of reiserfs/XFS on SuSE.
What is about disk schedulers ? Are they the same in these case ?
Peter Zaitsev, Senior Performance Engineer
Come to hear my talk at MySQL UC 2005 http://www.mysqluc.com/
MySQL AB, www.mysql.com
|• ext3, ext2, vfat performance on RedHat Enterprise 4||Bas Meijer||6 Apr|
| • Re: ext3, ext2, vfat performance on RedHat Enterprise 4||Peter Zaitsev||6 Apr|
| • Re: ext3, ext2, vfat performance on RedHat Enterprise 4||Bas Meijer||7 Apr|
|• Re: ext3, ext2, vfat performance on RedHat Enterprise 4||Bas Meijer||7 Apr|
| • Re: ext3, ext2, vfat performance on RedHat Enterprise 4||Peter Zaitsev||8 Apr|