//-------------------
< 1. InnoDB >
https://medium.com/naver-cloud-platform/%EC%9D%B4%EB%A0%87%EA%B2%8C-%EC%82%AC%EC%9A%A9%ED%95%98%EC%84%B8%EC%9A%94-mysql-8-0-%EA%B0%9C%EB%B0%9C%EC%9E%90%EB%A5%BC-%EC%9C%84%ED%95%9C-%EC%8B%A0%EA%B7%9C-%EA%B8%B0%EB%8A%A5-%EC%82%B4%ED%8E%B4%EB%B3%B4%EA%B8%B0-1-innodb-d638a3e4fde9

1, AUTO_INCREMENT 정보를 DB에 기록
- 이전은 메모리에 기록해서 재부팅하면 리셋

2. NOWAIT and SKIP LOCKED
- 정교한 잠금 처리 시나리오


//-------------------
< 2. SQL DDL >
https://medium.com/naver-cloud-platform/%EC%9D%B4%EB%A0%87%EA%B2%8C-%EC%82%AC%EC%9A%A9%ED%95%98%EC%84%B8%EC%9A%94-mysql-8-0-%EA%B0%9C%EB%B0%9C%EC%9E%90%EB%A5%BC-%EC%9C%84%ED%95%9C-%EC%8B%A0%EA%B7%9C-%EA%B8%B0%EB%8A%A5-%EC%82%B4%ED%8E%B4%EB%B3%B4%EA%B8%B0-5-sql-ddl-e912869e99c9

//-------------------
< 3. SQL DML >
https://medium.com/naver-cloud-platform/%EC%9D%B4%EB%A0%87%EA%B2%8C-%EC%82%AC%EC%9A%A9%ED%95%98%EC%84%B8%EC%9A%94-mysql-8-0-%EA%B0%9C%EB%B0%9C%EC%9E%90%EB%A5%BC-%EC%9C%84%ED%95%9C-%EC%8B%A0%EA%B7%9C-%EA%B8%B0%EB%8A%A5-%EC%82%B4%ED%8E%B4%EB%B3%B4%EA%B8%B0-2-sql-dml-1f3f7159a45f

1. Windows Functions
Windows Function은 집계 함수와 유사한 기능이지만 
연산 결과를 단일 출력 행으로 그룹화하지 않고, 
개별 행에 계속 액세스하면서 여러 행에 대한 집계 연산을 수행한다는 점에서 차이


2. CTE (Common Tables Expressions) (WITH 쿼리)
- 파생 테이블과 비슷
(1) Better Readability : 쿼리를 단순화하여 가독성이 높음
(2) Easier Channing : 파생 테이블과 다르게 이전에 정의한 CTE도 참조 가능
(3) Can be referenced multiple times : 한 번의 정의로 여러 번 참조 가능


//-------------------
< 4. Indexes >
https://medium.com/naver-cloud-platform/%EC%9D%B4%EB%A0%87%EA%B2%8C-%EC%82%AC%EC%9A%A9%ED%95%98%EC%84%B8%EC%9A%94-mysql-8-0-%EA%B0%9C%EB%B0%9C%EC%9E%90%EB%A5%BC-%EC%9C%84%ED%95%9C-%EC%8B%A0%EA%B7%9C-%EA%B8%B0%EB%8A%A5-%EC%82%B4%ED%8E%B4%EB%B3%B4%EA%B8%B0-3-indexes-e32249e2dae5
1. Descending Indexes
 역순으로 정렬된 인덱스

2. Invisible Indexes
인덱스의 존재 유무를 알려줄지 말지 결정

3. Functional Indexes
Functional key를 사용해 테이블에 직접 저장되지 않은 값을 인덱싱

//-------------------
< 5. JSON >
https://medium.com/naver-cloud-platform/%EC%9D%B4%EB%A0%87%EA%B2%8C-%EC%82%AC%EC%9A%A9%ED%95%98%EC%84%B8%EC%9A%94-mysql-8-0-%EA%B0%9C%EB%B0%9C%EC%9E%90%EB%A5%BC-%EC%9C%84%ED%95%9C-%EC%8B%A0%EA%B7%9C-%EA%B8%B0%EB%8A%A5-%EC%82%B4%ED%8E%B4%EB%B3%B4%EA%B8%B0-4-json-7ab2b40da57
1. JSON 함수 관련 변경/추가 사항
2. Faster Update
3. JSON 데이터를 관계형 데이터로 변환
4. Document Store Architecture

반응형
Posted by codens