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) 编辑 收藏 举报