89549

The merge Storage Engine

The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical My ISAM

tables that can be used as one. “Identical" means that all tables have identical column and index

information. You cannot merge My ISAM tables in which the columns are listed in a different order, do

not have exactly the same columns, or have the indexes in different order. However, any or all of the

MylSAM tables can be compressed with myisampack. See Section 4.6.5,

“myisampack —Generate

Compressed, Read-Only MylSAM Tables”. Differences in table options such as

AVG_ROW_LENGTH,

MAX_ROWS, or PACK_KEYS do not matter.

An alternative to a MERGE table is a partitioned table. which Stores partitions of a single table in

separate files. Partitioning enables some operations to be performed morę efficiently and is not limited

to the MylSAM storage engine. For morę information, see Chapter 18, Partitioning. When you create a MERGE table, MySQL creates two files on disk. The files have names that begin with

the table name and have an extension to indicate the file type. An . f rm file Stores the table format,

and an . MRG file contains the names of the underlying MylSAM tables that should be used as one. The

tables do not have to be in the same database as the MERGE table.

You can use SELECT, DELETE, UPDATE, and INSERT on MERGE tables. You must have SELECT [775],

DELETE [774], and UPDATE [776] privileges on the MylSAM tables that you map to a MERGE table.

Wyszukiwarka

Podobne podstrony:
judge on the planet Lyshriol (also known as Skyfall). His spcctacular voice is legendary among his p
2.2 SS7 Network The SS7 network [15] is a collection of protocols which are used in telecom-municati
00125 ?550c009f0c2a895872fcea22e14617 126 Simpson & Keats Yj T s k c the CUSUM value (xj - T)/s
2. Fili in the blanks. a.    An atom is built of three types
11 13 Controlling the stage fright before the presentation •    Stage fright is a sig
OUILLING ... This ancient craft, dating back to the I5th cen tury, is also known as paper fifigrce.
21vel03 Program Manager 1 File Options Window Help § ± ii Print Manager ♦ The printer on LPT1 is out
Open interfaces of GSMMobile Station (MS) The MS (Mobile Station) is a combination of terminal equip
writing wczesnoszkolna19 COMIC STRIPS The Wrong Spell , The Werewolf and The Runaway-bride Tbiś is
mysąid— The MySQL Server mysqld, also known as MySQL Server, is the main program that does most of t
The Gramniar-Translation Method (Classical Method) The grammar-translation method is a method of for
surplus work to the state because it is a question of principle. There has even been formed a specia
82 8 Easer Parać* (1959)*971 Shown orły « the 1959 booklet ihs is ono of the three rrost de* Sirabće
96 (36) u e $ lFLORENTINE FLOWER BOX The Florentine Flower Box is a festival of vibrant and spirited

więcej podobnych podstron