Hello everyone, I have a few questions:

  1. How to find out from the command line what type of tables is used in the database? (MyISAM, InnoDB, BlackHole ...)

  2. Please give links to videos, articles about fine-tuning the MySQL server.

  3. If on production all the tables are stored in MyISAM, can I switch to InnoDB without serious consequences? Or is it better not to touch?

  • P.1 any specific table, or summary help? - alexlz

1 answer 1

1) It is possible through the show table status http://dev.mysql.com/doc/refman/5.6/en/show-table-status.html

3) If I am not mistaken, then there are 2 main points: - in innodb there are no full-text indexes; if you use match, it will not work. - for each table, you must create a primary key, because they are used to build indexes, if they are not created, then innodb itself will create a hidden primary key

And so there are several ways to go: - change the type of engine through alter table - create tables and transfer data to them

PS Of course, at first you need to understand is it necessary to change the engine