1

We would like to avoid using MyISAM tables because they don't support transactions. However, I've noticed that many internal tables in MySQL use MyISAM. I can get a list like this:

select table_name from information_schema.tables where engine = 'MyISAM';

Is it possible to set up MySQL in a way where none of its tables will use MyISAM? Can MySQL work properly in this way?

Nick Retallack
  • 2,086

1 Answers1

0

Yes, is it possible and desirable to run MySQL without any MyISAM tables.

Since I started using MySQL (V5.5 now 5.6) with all InnoDB type, I have found no issues.

Stephen Rauch
  • 3,296
tatskie
  • 109