MySQL allows for different databases to be governed by different engines. Two of the most popular is
MyISAM and INNODB. To bottom line the difference is that MyISAM does not support transactions,
while INNODB does. The performance difference between the two engines is just a couple of
percentage points, one way or the other based on my simple benchmarks that I have performed. There
are other benchmark statistics performed by far smarter and qualified people than myself, so run some
tests before you get started.
Remember that XAMPP has the INNODB engine turned off by default. A quick edit to my.cnf will add
it back in after a restart.
No comments:
Post a Comment