[SOLVED] innoDB or MyISAM

[alain.roger]

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)

[vekia]

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

[mir-aus]

hi there, 

my website  use MySQL engine: InnoDB, can I change it to 

MyISAM?

[elvansopyan]

 

hi there, 

my website  use MySQL engine: InnoDB, can I change it to 

MyISAM?

 

 

Hi same problem here, can anybody help?

[musicmaster]

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)

[bellini13]

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