Re: Filesystems comparison using sql-bench and mySQL

--=-T4coz4VlHtKtS3N2D4sL
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi,

I made new measurements according comments from Peter.
In this case, the table type is InnoDB. This type generates a lot of
I/O.

Results are here:

http://www.bullopensource.org/ext4/sqlbench/InnoDB/

Conclusion:

- Avoid JFS and XFS.
- Use ReiserFS
- but  patching ext3 could improve performance (compared to ext3 alone)

Regards,
Laurent

Le jeu 14/04/2005 =C3=A0 18:25, Laurent Vivier a =C3=A9crit :
> Hi,
>=20
> I've made some tests using sqlbench and mySQL to benchmark filesystems,
> results are here:
>=20
> http://www.bullopensource.org/ext4/sqlbench/
>=20
> Comments are welcome.
>=20
> Regards,
> Laurent
>=20
> (I "cc": [email protected] , because it should be interested
> for you too. Patches "extents", "delalloc" and "mballoc" are patches
> developed by Alex Tomas from clusterfs to improve ext2/ext3
> performance... see [email protected] archives for
> details)
--=20
------------------ Laurent Vivier -------------------
  mailto:[email protected] BULL/FREC:B1-226
    phone: (+33) 476 29 7213  Bullcom: 229-7213
------------------[ DT/OSwR&D/AIX ]------------------
"LINUX is obsolete"  Andrew S. Tanenbaum / 1992-01-29

--=-T4coz4VlHtKtS3N2D4sL
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: Ceci est une partie de message
	=?ISO-8859-1?Q?num=E9riquement?= =?ISO-8859-1?Q?_sign=E9e=2E?=

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQBCZSzg9Kffa9pFVzwRAuJDAJsGQLkJdAJfnP5DPTWXjckx7t0XTACfUq2j
wDzfpJLzY/6Sbmj9DWY+Ve4=
=vn+l
-----END PGP SIGNATURE-----

--=-T4coz4VlHtKtS3N2D4sL--



-------------------------------------------------------
This SF.Net email is sponsored by: New Crystal Reports XI.
Version 11 adds new functionality designed to reduce time involved in
creating, integrating, and deploying reporting solutions. Free runtime info,
new features, or free trial, at: http://www.businessobjects.com/devxi/728