Thank you for the great lecture.

It was filled with great content that is useful in practice, such as things to pay attention to when writing queries rather than basic concepts, and things to pay attention to in order to improve performance, so I felt that my thinking has broadened.

tussle

We covered the concepts considered while migrating 20 billion data items managed through the existing MongoDB to MySQL.

july

Concepts and tuning methods considered when migrating 20 billion data to MySQL

The lecture itself focused on writing queries in MySQL. As the data increases, there are many cases where this part is overlooked and problems cannot be solved. ㅠㅠ

I hope that my lecture will help you feel more interested in DB and learn more. Thank you!

하루 3시간! 하룻밤 만에 성장할 수 있는 강의만 모았어요!

3시간 만에 완강할 수 있는 강의 ⏰

마이그레이션

既存のMongoDBを通じて管理する200億件のデータをMySQLに移転しながら考慮した概念について取り上げました。

July

입문

초급

중급이상

MySQL

mysql-workbench

mysql-query

몽고DB

MongoDB

200億件のデータをMySQLに移行する際に考慮した概念とチューニング方法

最初のセクションのタイトルを入力してください。

Multi Column Index

Covering Index & RDB vs ElasticSearch Index Diff

ORDER BY

INSERT

AUTO_INCREMENT LOCK

Index Dive Using In Query

Prefix Index

MySQLロックタイプ

DeadLock Case

NoOffset For Query Tuning

Skip Locked For Session