您何时应该选择在MySQL中使用InnoDB? [英] When should you choose to use InnoDB in MySQL?

问题描述

此处让我感到困惑. >

I am rather confused by the hurt-mongering here.

我知道该怎么做，见下文，但不知道为什么?他们是干什么的?

I know how to do them, see below, but no idea why? What are they for?

create table orders (order_no int not null auto_increment, FK_cust_no int not null, 
foreign key(FK_cust_no) references customer(cust_no), primary key(order_no)) type=InnoDB;


create table orders (order_no int not null auto_increment, FK_cust_no int not null, 
foreign key(FK_cust_no) references customer(cust_no), primary key(order_no));

推荐答案

InnoDB是 MySQL中的存储引擎.其中有很多，而且各有优缺点. InnoDB的最大优势是:

InnoDB is a storage engine in MySQL. There are quite a few of them, and they all have their pros and cons. InnoDB's greatest strengths are:

• 支持交易(为您提供 ACID 属性的支持).
• 行级锁定.与例如 MyISAM .
• 外键约束.允许您让数据库确保数据库状态以及表之间关系的完整性.

• Support for transactions (giving you support for the ACID property).
• Row-level locking. Having a more fine grained locking-mechanism gives you higher concurrency compared to, for instance, MyISAM.
• Foreign key constraints. Allowing you to let the database ensure the integrity of the state of the database, and the relationships between tables.

这篇关于您何时应该选择在MySQL中使用InnoDB?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！