ÀÌÇØ¸¦ Á» ´Þ¸®ÇØ¾ß ÇÒ°Í °°½À´Ï´Ù. ¾Æ·¡ ³»¿ëÀ» Âü°í ÇϽðí, ´Ù½Ã ¸Þ´º¾óÀ» º¸½Ã´Â °ÍÀÌ µµ¿òÀÌ µÉ µí ½Í³×¿ä.
mysql> CREATE TABLE t1 (
> c1 INT NOT NULL PRIMARY KEY,
> c2 VARCHAR(30)
> )
> TABLESPACE ts1 STORAGE DISK
> ENGINE NDBCLUSTER;
Query OK, 0 rows affected (1.73 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> ALTER ONLINE TABLE t1 ADD COLUMN c3 INT COLUMN_FORMAT DYNAMIC STORAGE MEMORY;
Query OK, 0 rows affected (1.25 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> ALTER ONLINE TABLE t1 ADD COLUMN c4 INT STORAGE MEMORY;
Query OK, 0 rows affected, 1 warning (1.17 sec)
Records: 0 Duplicates: 0 Warnings: 0
À§ Å×À̺íÀº disk ·Î ÀúÀåÇÏ´Â Å×À̺íÀ»¸¸´À´À°ÅÀݾƿä
c1Àº À妽º´Ï ¸Þ¸ð¸®·Î ÀúÀåµÇ°í, c2´Â µ¥ÀÌÅÍ´Ï µð½ºÅ©¿¡ ÀúÀåµÇ°í
¿©±â¼ alter ±¸¹®À¸·Î c3 ¿Í c4¸¦ Ãß°¡Ç޴µ¥
1. µÎ°³´Ù À妽º°¡ ¾Æ´Ñµ¥. ¸Þ¸ð¸® ÀúÀåÇϱâÀ§ÇÑ ±¸¹®Àΰ¡¿ä?? Á¦°¡»ý°¢ÇÑ°Ô ¸Â³ª¿ä?
2. dynamic storage memory ¿Í storage memoryÀÇ Â÷ÀÌÁ¡À½ ¹«¾ùÀΰ¡¿ä?