내블로그
1. 기본 테이블 크기 확인 SELECT table_name, table_rows, round(data_length/(1024*1024),2) as 'DATA_SIZE(MB)', round(index_length/(1024*1024),2) as 'INDEX_SIZE(MB)'FROM information_schema.TABLESWHERE table_schema = '데이타베이스명'; 2. 파티셔닝된 테이블 파티션별 크기 확인SELECT table_name , partition_name , round(data_length/(1024*1024),2) as 'DATA_SIZE(MB)' , round(index_length/(1024*1024),2) as 'INDEX_SIZE(MB)'FROM INFORMATION..
1. CREATE TABLE CREATE TABLE `data_table` ( `idnr` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'idnr', `send_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`idnr`, `send_time`),)COLLATE='utf8_general_ci'ENGINE=InnoDB DEFAULT CHARSET=utf8PARTITION BY RANGE (YEAR(`send_time`)*100+MONTH(`send_time`))( PARTITION p201611 VALUES LESS THAN (201611) ENGINE = InnoDB, PARTITION p201612 VAL..
1. 테이블 생성 CREATE TABLE `json` (`json` BLOB NULL)COLLATE='utf8_general_ci'ENGINE=InoDB; 2. 데이터 삽입(COLUMN_CREATE)INSERT INTO json VALUES (COLUMN_CREATE('age', 22, 'name', 'kim'));INSERT INTO json VALUES (COLUMN_CREATE('age', 11, 'name', 'heo'));INSERT INTO json VALUES (COLUMN_CREATE('color', 'blue', 'size', 'XL'));INSERT INTO json VALUES (COLUMN_CREATE('color', 'black', 'price', 500)); 3. 데이터 가져오기..