September 2023
Beginner to intermediate
732 pages
17h 24m
Korean
Content preview from 러닝 MySQL
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
489
10
장
백업 및 복구
$
ls -ld export
drwx... export-20210613-204512
$
ls -la export-20210613-204512
...
-rw... sakila.actor.sql
-rw... sakila.address-schema.sql
-rw... sakila.address.sql
-rw... sakila.category-schema.sql
-rw... sakila.category.sql
-rw... sakila.city-schema.sql
-rw... sakila.city.sql
...
병렬 덤핑과 복원 기능 외에
mydumper
에는 다음과 같은 고급 기능이 있습니다.
●
가벼운 백업 잠금
backup
lock
지원 : 퍼코나 서버는 퍼코나
XtraBackup
에서 사용할 가벼운 잠금 기능
몇 가지를 제공합니다.
mydumper
는 가능하면 기본적으로 이런 잠금을 사용합니다. 이 잠금은
InnoDB
테이블에 대한 동시 읽기와 쓰기를 차단하지 않지만 백업을 무효화할 수 있는
DDL
문을 차단합니다.
●
저장점
savepoint
사용 :
mydumper
는 트랜잭션 저장점을 사용해 메타데이터 잠금을 최소화합니다.
●
메타데이터 잠금 기간 제한: ‘
6
.
2
.
1
메타데이터 잠금’에서 설명한 지연된 메타데이터 잠금 문제를 해결
하기 위해
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.