Re: Innodb as its default storage engine for Mysql 5.0 / 5.1
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 be due nowadays most of the application required fully ACID-compliant modes, self recovery from a crash, and many more features... 2011/5/25 Halász Sándor > 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=aim.prab...@gmail.com > > -- Best Regards, Prabhat Kumar MySQL DBA My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat
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=arch...@jab.org
Re: Innodb as its default storage engine for Mysql 5.0 / 5.1
Am 25.05.2011 10:35, schrieb Brent Clark: > 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? 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 = latin1 collation-server = latin1_german1_ci default-storage-engine = 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 signature.asc Description: OpenPGP digital signature
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=arch...@jab.org
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=arch...@jab.org