Want to ask, what's the problem with mixing MyISAM and innodb in a deployment environment?

Source: Internet
Author: User
This is the way it is.

Using the Laravel framework, the repository is MyISAM.

But citing some of the repositories, the self-generated table of some INNODB structures.

So I want to ask:

  1. What's the problem with this mix?
  2. Laravel there any way to force the MyISAM?

Reply content:

This is the way it is.

Using the Laravel framework, the repository is MyISAM.

But citing some of the repositories, the self-generated table of some INNODB structures.

So I want to ask:

  1. What's the problem with this mix?
  2. Laravel there any way to force the MyISAM?

1, can be mixed, because the database design, it is necessary to consider their own needs of the table engine to make the appropriate choice, a library using multiple storage engines is normal, the only thing to note is that when the transaction needs to operate MyISAM and InnoDB, MyISAM it is best to operate before the transaction or after the transaction has completed.
2, not recommended to turn, perhaps you those libraries are using the InnoDB features, if you confirm that the library does not use the InnoDB feature, consider turning it.

To this day, do not think, MyISAM and InnoDB than no advantage,

  • Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.