2021-01-14 TiDB-4-1空间对比

2021-01-14 TiDB-4-1空间对比

(运输的货物体积明细)空间对比 -payable_ebs

 

背景:

对比Mysql和TiDB空间占比

 

产出:

MySQL 占用比例:

分别占用:(1.3T+1.3T+1.3T+1.3T)=5.2T

TiDB 占用比例: 1.5T

(TiDB = 1.5T)/(MySQL = 5.2T(未开启压缩))= 1:3.45 即 3.45TB Mysql 数据 TiDB需要 1TB

 

 

源数据库:

mysql-cn-north-1-74164b2b571c48a1.rds.jdcloud.com

mysql-cn-north-1-49497517d60b4c00.rds.jdcloud.com

mysql-cn-north-1-2f9661b9574c48f6.rds.jdcloud.com

mysql-cn-north-1-13aa8c8590d14712.rds.jdcloud.com

TiDB:

tidb:tidb-z770skbgxw-tidb.tidb-z770skbgxw-hb.jvessel2.jdcloud.com -P 4000

grafana:http://tidb-z770skbgxw-grafana.tidb-z770skbgxw-hb.jvessel2.jdcloud.com:3000

 

 

 

 

 

 

 

 

 

 

 

 

posted on 2021-04-27 07:16  Sunnynanbing  阅读(77)  评论(0编辑  收藏  举报

导航