- MySQL 8 for Big Data
- Shabbir Challawala Jaydip Lakhatariya Chintan Mehta Kandarp Patel
- 213字
- 2021-08-20 10:06:11
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.
- DevOps:軟件架構師行動指南
- WebAssembly實戰(zhàn)
- PyQt從入門到精通
- Python測試開發(fā)入門與實踐
- Network Automation Cookbook
- Python高效開發(fā)實戰(zhàn):Django、Tornado、Flask、Twisted(第2版)
- Raspberry Pi 2 Server Essentials
- 老“碼”識途
- C# and .NET Core Test Driven Development
- 小型編譯器設計實踐
- 計算機組裝與維護(第二版)
- SAS編程演義
- Internet of Things with Arduino Cookbook
- C++ Data Structures and Algorithm Design Principles
- Java Web程序開發(fā)參考手冊