Hi Sven, yes - that's exactly what we found out, too. But with customers on managed servers it's not always that easy to have those settings changed ... - so before I start blaiming the hosters I'd rather like to know OXID's reasons for switching storage engines before. Cause I suspect that the gain of performance might be that small that a simple back-switch to MyISAM in most cases might be the easier and better way.
And for that reason I'd also like to know if there ar any other reasons apart from performance which make InnoDB eg. for oxarticles necessary. Beste Grüße aus Dortmund! Andreas Ziethen | Geschäftsführung -- anzido GmbH Kirchhörder Str. 12 44229 Dortmund Tel.: 0231 - 60 71 079 Fax.: 0231 - 60 71 081 Mobil:0176 - 8325 1488 Email: [email protected] Web: http://www.anzido.com ( http://www.anzido.com/ ) USt-ID: DE257982972 Geschäftsführung: Andreas Ziethen Amtsgericht Dortmund HRB 20883 -----Ursprüngliche Daten----- Datum: 11.05.2010 15:47:31 Von: Kliebenstein Sven <[email protected]> An: [email protected] <[email protected]> Betreff: Re: [oxid-dev-general] storage enginges Vorgang: T-W1V47SNBVS-96 > Hi, > > We have faced the same problem as you mentioned when using InnoDB tables in > OXID. If you're using a Not-InnoDB-Optimized-MySQL-Server, the default > settings are definitely not usable. The usage of InnoDB tables in an > non-optimized MySQL-Server makes things more worse than using standard MyISAM > tables. For us, we're always optimizing the settings of your servers before > installing the shop. You can get a list of all available InnoDB settings from > MySQL by executing this query: show variables like 'innodb%'; > The documentation for these options is available from the mysql website: > http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html > http://dev.mysql.com/doc/refman/5.0/en/innodb-buffer-pool.html > > There are also some tuning tools available, just have a look for: > - tuning-primer > - mysqltuner (http://mysqltuner.pl/mysqltuner.pl) > > > Just my 2 cents... > Sven > > > > > -----Ursprüngliche Nachricht----- > Von: [email protected] > [mailto:[email protected]] Im Auftrag von anzido GmbH > Gesendet: Dienstag, 11. Mai 2010 12:57 > An: [email protected] > Betreff: [oxid-dev-general] storage enginges [T-W1V47SNBVS-96] > > Hi, > > since a while I notice that OXID does change storage engines for more and > more tables from MyISAM to InnoDB. > I'd like to get some explanation why this is done, presumably due to > performance issues, I guess ... but some more detailed information would be > nice. > > I'd also like to know if and which tables really HAVE to be InnoDB - e. g. > for transaction reasons or whatever. > > The background for my question is that we discover more and more performance > problems with those InnoDB tables cause many hosters do use MyISAM optimized > MySQL-Settings which often lead to big problems on large InnoDB tables. > ProfiHost for example is one of those. > > Beste Grüße aus Dortmund! > Andreas Ziethen | Geschäftsführung > > -- > anzido GmbH > Kirchhörder Str. 12 > 44229 Dortmund > Tel.: 0231 - 60 71 079 > Fax.: 0231 - 60 71 081 > Mobil:0176 - 8325 1488 > Email: [email protected] > Web: http://www.anzido.com ( http://www.anzido.com/ ) > > USt-ID: DE257982972 > Geschäftsführung: Andreas Ziethen > Amtsgericht Dortmund HRB 20883 > _______________________________________________ > dev-general mailing list > [email protected] > http://dir.gmane.org/gmane.comp.php.oxid.general > _______________________________________________ > dev-general mailing list > [email protected] > http://dir.gmane.org/gmane.comp.php.oxid.general _______________________________________________ dev-general mailing list [email protected] http://dir.gmane.org/gmane.comp.php.oxid.general
