alain.roger Posted April 10, 2013 Share Posted April 10, 2013 (edited) Hi, I'm brand new to Prestashop and i wanted to know what type of MySQL engine is the best for Prestashop ? in fact does prestashop support stored procedures and primary/foreign key ? if yes than it should be innoDB as engine. Am I right ? thx. Edited April 10, 2013 by alain.roger (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted April 10, 2013 Share Posted April 10, 2013 Yes you are. innoDB is the best choice, because prestashop uses primary / foregin keys. you can check how it looks like: http://www.daveegert...-prestashop.png this is old version, but primary / foregin keys appear there Link to comment Share on other sites More sharing options...
mir-aus Posted June 6, 2014 Share Posted June 6, 2014 hi there, my website use MySQL engine: InnoDB, can I change it to MyISAM? Link to comment Share on other sites More sharing options...
elvansopyan Posted December 31, 2014 Share Posted December 31, 2014 hi there, my website use MySQL engine: InnoDB, can I change it to MyISAM? Hi same problem here, can anybody help? Link to comment Share on other sites More sharing options...
musicmaster Posted December 31, 2014 Share Posted December 31, 2014 (edited) See here: http://serverfault.com/questions/245761/simpler-way-to-convert-all-tables-from-innodb-to-myisam The question is why you want to use MyIsam. If you want separate files for each table you can also achieve that with InnoDb. See http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-tablespaces.html. Be careful to make backups when you are experimenting with these kinds of instructions! Edited December 31, 2014 by musicmaster (see edit history) Link to comment Share on other sites More sharing options...
bellini13 Posted December 31, 2014 Share Posted December 31, 2014 Yes you are. innoDB is the best choice, because prestashop uses primary / foregin keys. Prestashop does not use foreign keys, it also does not include any stored procedures. Prestashop does use primary keys and indexes, which Myisam supports very well. Prestashop also does not use transaction commits and/or rollbacks, which would make InnoDB required, so there isn't a strong reason to use InnoDB 1 Link to comment Share on other sites More sharing options...
Recommended Posts