Hello! Tell me, please, is it possible to share in the database and tables such as MyISAM and InnoDB? Will there be any problems with this?
Can. Note that transactions and foreign key checks are not distributed to MyISAM.
Wishes from the Internet:
- Do not make joint requests for change. It is better to make a request to each type of table separately.
- Types of related fields must be completely identical.
- For backup use save to dump. No file copying is fraught with data corruption.
In addition, if there is at least one MyISAM table in the database, the main charm of InnoDB is lost: locks in rows, not in tables. Which significantly reduces the performance of the database as a whole.
If for you the speed of work is not critical and you can afford to make loki tables when reading, then only the above consequences. If you have a heavy load, you should think that InnoDB blocks only the row, and MyISAM - the entire table. Their mix leads to the loss of this refinement by InnoDB.