Jump to content

Prestashop performance MyISAM Vs InnoDB


Recommended Posts


MyISAM tables are far more faster than InnoDB for read only queries.

but for intensive writes operation it is preferable to use InnoDB which use row level locking for write operation (MyISAM uses table level locking).

So my suggestion (I do not test anything) is to use InnoDB for "statistics" tables like ps_connections_source.

Any comments ? Any cons&pros;about using innoDB tables?


Share this post

Link to post
Share on other sites

  • 1 month later...


You are correct that MyISAM tables are faster than compared to InnoDB and I won't get into the technical reasons why.

However, if you want the database to handle Foreign Key constraints automatically that functionality will only work with an InnoDB configuration.

So it is not always appropriate to use MyISAM in all tables.

You COULD write the code to handle it foreign keys yourself but since InnoDB does this for you and has been time tested the tradeoff is in speed.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More