From: Reindl Harald
Date: May 25 2011 8:53am
Subject: Re: Innodb as its default storage engine for Mysql 5.0 / 5.1
List-Archive: http://lists.mysql.com/mysql/225101
Message-Id: <4DDCC36F.8040903@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig661480ED485AA7C9096F43BE"

--------------enig661480ED485AA7C9096F43BE
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable


Am 25.05.2011 10:35, schrieb Brent Clark:
> Hiya
>=20
> I think I read somewhere that Mysql 5.5 is defaulting on Innodb as its =
default storage engine.
>=20
> The question I would like to ask is. For those still running Mysql 5.0 =
/ 5.1. Have any of you set the mysql default
> variable to be / use Innodb?

depends on the use

for dedicated dbmail-instaces, yes because there is only InnoDB/UTF8 used=


on all other machines independent of the mysql-version like below and i
am happy that i never use default-configs because the change in 5.5
would kill the mysqld if you disabeld innodb-storage-engine :-)

character-set-server   =3D latin1
collation-server       =3D latin1_german1_ci
default-storage-engine =3D myisam
__________________

summary:

if there is no good reason i will never enable innodb because
MyISAM is enough for most web-apps and "dirty things" like
stop the server and restore a database from a backup with
rsync the folder can not be done with InnoDB


--------------enig661480ED485AA7C9096F43BE
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk3cw28ACgkQhmBjz394AnlalACeIgKyVIp7EoWxtAhwDgY6Dby1
REUAoJOdz/65MCwSYAQEfiXqksvXoyyq
=oHWf
-----END PGP SIGNATURE-----

--------------enig661480ED485AA7C9096F43BE--