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
