Had you not specified the tables types as InnoDB, the order would not have been important.
如果您将表的类型指定为InnoDB,那么这个顺序就不会那么重要。
You can think about it as about simplified form of versioning like in Innodb if it is closer to you.
你可以把它想象成为一个简单的版本管理形式,就像In nodb。
I have elected to use the InnoDB database engine to allow for later table joining and relationship creation.
我选择使用In noDB数据库引擎支持后面的表格连接和关系创建。
As you might know Innodb storage engines USES Fuzzy Checkpointing technique as part of it recovery strategy.
你可能知道,In nodb存储引擎使用模糊检查点技术作为其恢复策略的一部分。
It USES auto_increment primary key, which causes table-level locks in InnoDB for all MySQL versions prior to 5.1.21.
使用了auto_increment主键,对于MySQL5.1.21之前的版本都会导致in noDB使用表级锁。
For a transaction-safe storage engine, the InnoDB backup ibbackup is preferred. However, do take note of the compatibility issues listed as follows.
对于事务安全的存储引擎,In nodb备份工具ibbackup是首选的。
For a mixed MySQL database environment that comes with both MyISAM and InnoDB storage engines, perhaps a better choice to back up is to use innobackup.
对于具有MyISAM和in noDB存储引擎的混合式MySQL数据库环境,进行备份的更好的方法可能是使用innobackup。
This article focuses primarily on backup and restore using MyISAM and InnoDB storage engines, as they are the most commonly used engines in the MySQL world.
本文主要关注使用MyISAM和In noDB存储引擎进行备份和恢复,因为它们是MySQL中最常用的引擎。
I think it is really capitalizing on the move Oracle made a couple of years ago when they bought out the company that developed the main transactional database engine used in MySql: InnoDB.
我觉得它很好的利用了Oracle两年前买下MySQL的主要事务数据库引擎开发公司InnoDB的效应。
Configuring innodb_data_file_path like this, InnoDB can distribute the two datafiles to disk1 & disk2. The first file is fiexed size, 2GB. And the second file is auto extened, initial size id 2GB.
这样配置就把数据文件分散在了disk1和disk2两个路径下,第一个文件固定2G大小,第二个文件初始化2G,可以自增长。
Configuring innodb_data_file_path like this, InnoDB can distribute the two datafiles to disk1 & disk2. The first file is fiexed size, 2GB. And the second file is auto extened, initial size id 2GB.
这样配置就把数据文件分散在了disk1和disk2两个路径下,第一个文件固定2G大小,第二个文件初始化2G,可以自增长。
应用推荐