Hi...please enlighten my mind,what is the difference of this two engine InnoDB and MyISAM...when to use those engine?is it okay that all my table are set to MyISAM or InnoDB?
Thank you in advance.
you could start by reading the relevant page in da manual
Unlike InnoDb, MyIsam doesn'r support transactions. MyIsam is faster performance.
I probably wouldn5 use MyIsam today. If I needed faster storage where data integrity wasn't important I would probably use Memcached, Redis or MongoDB.