官术网_书友最值得收藏!

Merge

This storage engine is also known as a MRG_MyISAM storage engine. This storage engine merges a MyISAM table and creates it to be referred to a single view. For a merge table, all columns are listed in the same order. These tables are good for data warehousing environments.

The following example shows you how to create merge tables:

mysql> CREATE TABLE user1 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,name CHAR(20)) ENGINE=MyISAM;
mysql> CREATE TABLE user2 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,name CHAR(20)) ENGINE=MyISAM;
mysql> INSERT INTO user1 (name) VALUES ('abc'),('xyz');
mysql> INSERT INTO user2 (name) VALUES ('def'),('pqr');
mysql> CREATE TABLE user (id INT NOT NULL AUTO_INCREMENT,name CHAR(20), INDEX(id))ENGINE=MERGE UNION=(user1,user2);

The table is used to manage log-related tables, generally. You can create different months of logs in separate MyISAM tables and merge these tables using the merge storage engine.

MyISAM tables have storage limit for the operating system but a collection of MyISAM (merge) tables do not have storage limits. So using a merge table would allow you to split data into multiple MyISAM tables, which can help in overcoming storage limits.

With the MERGE table, it is difficult to do partitioning hence it is not supported by MERGE tables and we cannot implement partition on MERGE table or any MyISAM table.

主站蜘蛛池模板: 日土县| 郯城县| 舒兰市| 东莞市| 三原县| 诸暨市| 玉环县| 太仆寺旗| 依兰县| 彰武县| 桓仁| 雅江县| 吉水县| 鄂托克旗| 克什克腾旗| 太康县| 平乡县| 息烽县| 方城县| 乌兰察布市| 铁岭县| 牟定县| 绥中县| 梧州市| 家居| 通州市| 西充县| 财经| 南康市| 大方县| 乌什县| 宿州市| 建阳市| 璧山县| 绥德县| 安陆市| 南城县| 丰都县| 剑阁县| 融水| 冀州市|