On Wed, 2005-01-12 at 07:24, Bas Meijer wrote:
> Hi,
>
> I ran three tests to compare the write speed of different Linux filesystems.
> XFS has significant better MySQL write performance than the ext3 which is
> default on
> RedHat Linux: 19%.
Thanks for Information. A lot of Information is missing however, for
example how many tables did you have - EXT3 is well known to perform
poor with a lot of tables.
You also do not mention storage engine used but I assume it is MyISAM.
>
> All tests were done on the same isolated hardware:
> Platform = linux
> Architecture = i386
> OsVersion = Fedora Core release 3 (Heidelberg)
> Kernel = Linux 2.6.10-335.1 #11 SMP Tue Jan 11 19:48:59 CET 2005
> Memory = 1519
> CPUType = Intel(R) Xeon(TM) CPU 3.06GHz
> CPUFrq = 3058.196
> CPUNo = 4
>
> I used mysql 3.23.51 to process a mysql.dump of 674Mbytes as to measure
> insertion speed, the resulting sizes reported by du differ very slightly:
> 684480 /xfs/
> 685128 /reiserfs/
> 685432 /ext3/
>
> The speed differences are significant
> time /opt/linux/mysql/3.23.51/bin/mysql perftest < mysql.dump
>
> xfs
> real 12m6.739s
> user 0m27.266s
> sys 0m40.777s
>
> reiserfs
> real 12m39.095s
> user 0m31.190s
> sys 0m41.344s
>
> ext3
> real 14m58.782s
> user 0m27.324s
> sys 0m41.614s
>
>
> Bas Meijer
--
Peter Zaitsev, Senior Support Engineer
MySQL AB, www.mysql.com
