Innodb as its default storage engine for Mysql 5.0 / 5.1

Hiya

I think I read somewhere that Mysql 5.5 is defaulting on Innodb as its
default storage engine.

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?

Regards
Brent Clark

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Innodb as its default storage engine for Mysql 5.0 / 5.1

On 2011-05-25 10:35:45 Brent Clark wrote:
> I think I read somewhere that Mysql 5.5 is defaulting on Innodb as its
> default storage engine.
>
> 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?

Yes, I have, it's one of the first things I usually do/did in a new 5.0/1
setup, and it works out OK, allthough there are major improvements in 5.5 for
InnoDB, so an upgrade from 5.0/1 to 5.5 may result in a lot less resource
usage.

It's just a setting, can be set globally or in a session:
http://dev.mysql.com/doc/refman/5.1/en/server-
options.html#option_mysqld_default-storage-engine
--
Rik Wasmus

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Innodb as its default storage engine for Mysql 5.0 / 5.1

--------------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/

iEYEARECAAYFAk3cw28ACgkQhmBjz394AnlalACeIgKyVIp7EoWxtAhwDgY6 Dby1
REUAoJOdz/65MCwSYAQEfiXqksvXoyyq
=oHWf
-----END PGP SIGNATURE-----

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

Re: Innodb as its default storage engine for Mysql 5.0 / 5.1

>>>> 2011/05/25 10:53 +0200, Reindl Harald >>>>
if there is no good reason i will never enable innodb because
MyISAM is enough for most web-apps
<<<<<<<<
And also MyISAM supports auto-increment in a lesser part of a primary key and InnoDB not--but although it is of interest, I have not tryed it.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Innodb as its default storage engine for Mysql 5.0 / 5.1

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

Yes, InnoDB is the default storage engine for MySQL as of MySQL 5.5.MyISAM
and InnoDB has its own features.
InnoDB probably the best RDBMS out there. InnoDB is default engine might b=
e
due nowadays most of the application required fully ACID-compliant modes,
self recovery from a crash, and many more features...

2011/5/25 Hal=E1sz S=E1ndor

> >>>> 2011/05/25 10:53 +0200, Reindl Harald >>>>
> if there is no good reason i will never enable innodb because
> MyISAM is enough for most web-apps
> <<<<<<<<
> And also MyISAM supports auto-increment in a lesser part of a primary key
> and InnoDB not--but although it is of interest, I have not tryed it.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=3Daim.prabhat@gmail.com
>
>


--=20
Best Regards,

Prabhat Kumar
MySQL DBA

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

--bcaec5014ba9b23b0f04a432b31c--