We are using myisam primarily for full text on mysql 5.5 ,However as 5.6+ innodb supports full text i want to know any performance or other bottleneck ,Please suggest ,we have huge data set in millions and currently tables are mix of myisam and innodb.

| improve this question | | | | |

Oracle's goal seems to be to get rid of MyISAM. Version 5.7 has virtually all the improvements to eliminate the 'desire' to use MyISAM. The next version, 8.0, is attempting to finish the task -- including getting rid of the MyISAM tables from the mysql database. (cf "Data Dictionary").

The only thing that remains is disk space. Any InnoDB table will continue to take 2x-3x the disk space of a comparable MyISAM table. But disk space is cheap and SSDs are prevalent, so this is not a big deal.

I strongly encourage to make the shift. See my article for some rare gotchas that might bite you in the conversion. (Which reminds; I should update it to say more about the status of 8.0.)

| improve this answer | | | | |
  • Does v8 use myisam for temp tables? – Evan Carroll Sep 1 '17 at 2:03
  • Guess it does by default, "The internal_tmp_disk_storage_engine system variable determines which storage engine the server uses to manage on-disk internal temporary tables. Permitted values are INNODB (the default) and MYISAM." – Evan Carroll Sep 1 '17 at 2:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.