# vim my.load
LOAD DATABASE
FROM mysql://root:123.123@192.168.1.125:3307/demo_db?useSSL=false
INTO postgresql://postgres:123123@@123@192.168.1.125:5432/postgres?demo_db
with prefetch rows = 500
WITH include drop, create tables, create indexes, workers = 1, concurrency = 1
;
# 运行
- pdmaner, 蓝奏云下载
- dbeaver(推荐,可以连接很多数据库)
- navicate (可以比对数据库结构)
- DbVisualizer (还没咋使用)
- heidisql (小巧)
- 优化select (*) 速度。 来源:percona blog, mysql bug
set innodb_parallel_read_threads=1
NewerOlder