资料来源:tecmint
- 查看占用
free -mh
vmstat -s -S M
- 查看每个进程占用内存情况
## 安装
sudo apt install smem # Ubuntu/Debian
free -mh
vmstat -s -S M
## 安装
sudo apt install smem # Ubuntu/Debian
mydumper -h 11.22.33.44 -u root -P3307 -p pAssw0rd -B myschema -t 4 -o myschema_dump/
myloader -h <cluster_dns_endpoint> -u master -p pAssw0rd -P 3307 -B myschema -t 4 -d myschema_dump
# vim my.load
LOAD DATABASE
FROM mysql://root:[email protected]:3307/demo_db?useSSL=false
INTO postgresql://postgres:123123@@[email protected]:5432/postgres?demo_db
with prefetch rows = 500
WITH include drop, create tables, create indexes, workers = 1, concurrency = 1
;
# 运行