Greenplum主节点与数据节点硬件详细信息

最新推荐文章于 2022-05-04 14:30:43 发布

盒马coding

最新推荐文章于 2022-05-04 14:30:43 发布

阅读量2.2k

点赞数 1

分类专栏： GreenPlum

本文链接：https://blog.csdn.net/xfg0218/article/details/82785196

版权

GreenPlum 专栏收录该内容

108 篇文章 39 订阅

订阅专栏

主节点信息

IP地址

192.168.*****

物理内存

$ free -h
total used free shared buff/cache available
Mem: 125G 6.1G 355M 230M 119G 118G
Swap: 15G 0B 15G

CPU详细信息

$ cat /proc/cpuinfo|grep cpu
cpu family : 6
cpu MHz : 1248.503
cpu cores : 6
cpuid level : 20

cpu family : 6
cpu MHz : 1500.050
cpu cores : 6
cpuid level : 20

cpu family : 6
cpu MHz : 1436.898
cpu cores : 6
cpuid level : 20

cpu family : 6
cpu MHz : 1438.027
cpu cores : 6
cpuid level : 20

cpu family : 6
cpu MHz : 1538.035
cpu cores : 6
cpuid level : 20

cpu family : 6
cpu MHz : 1538.898
cpu cores : 6
cpuid level : 20

cpu family : 6
cpu MHz : 1317.898
cpu cores : 6
cpuid level : 20

cpu family : 6
cpu MHz : 1590.097
cpu cores : 6
cpuid level : 20

cpu family : 6
cpu MHz : 1286.488
cpu cores : 6
cpuid level : 20

cpu family : 6
cpu MHz : 1375.671
cpu cores : 6
cpuid level : 20

cpu family : 6
cpu MHz : 1211.714
cpu cores : 6
cpuid level : 20

cpu family : 6
cpu MHz : 1322.546
cpu cores : 6
cpuid level : 20

从以上的信息可以看出一共12颗CPU，每个CPU的核数是6

磁盘的大小

[gpadmin@gpmdw /home/xiaoxu/oracle-export-gp]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/centos-root 300G 252G 49G 84% /
devtmpfs 63G 0 63G 0% /dev
tmpfs 63G 0 63G 0% /dev/shm
tmpfs 63G 26M 63G 1% /run
tmpfs 63G 0 63G 0% /sys/fs/cgroup
/dev/sda2 1014M 137M 878M 14% /boot
/dev/sda1 1022M 9.5M 1013M 1% /boot/efi
/dev/mapper/centos-data 576G 143G 434G 25% /greenplum
tmpfs 13G 0 13G 0% /run/user/0
tmpfs 13G 0 13G 0% /run/user/3000

标红的为挂在盘用于运算数据

网卡的详细信息

$ ethtool bond0
Settings for bond0:
Supported ports: [ ]
Supported link modes: Not reported
Supported pause frame use: No
Supports auto-negotiation: No
Advertised link modes: Not reported
Advertised pause frame use: No
Advertised auto-negotiation: No
Speed: 4000Mb/s
Duplex: Full
Port: Other
PHYAD: 0
Transceiver: internal
Auto-negotiation: off
Cannot get wake-on-lan settings: Operation not permitted
Link detected: yes

可以看出网卡是4000Mb/s

磁盘的读写性能

磁盘的读的性能测试

# cat dist-read.sh

#!bin/sh

for((i=1;i<=10;i++));do
echo -e "第" $i "次 \n"

echo "不加缓存的读的速度"
hdparm -t --direct /dev/mapper/centos-data

echo "加缓存的读的速度"
hdparm -tT /dev/mapper/centos-data

done

# sh dist-read.sh

第 1 次

不加缓存的读的速度

/dev/mapper/centos-data:
Timing O_DIRECT disk reads: 1494 MB in 3.00 seconds = 497.94 MB/sec
加缓存的读的速度

/dev/mapper/centos-data:
Timing cached reads: 7904 MB in 2.00 seconds = 3960.63 MB/sec
Timing buffered disk reads: 2454 MB in 3.00 seconds = 817.80 MB/sec
第 2 次

不加缓存的读的速度

/dev/mapper/centos-data:
Timing O_DIRECT disk reads: 1490 MB in 3.00 seconds = 496.44 MB/sec
加缓存的读的速度

/dev/mapper/centos-data:
Timing cached reads: 13988 MB in 1.99 seconds = 7022.36 MB/sec
Timing buffered disk reads: 2266 MB in 3.00 seconds = 754.39 MB/sec
第 3 次

不加缓存的读的速度

/dev/mapper/centos-data:
Timing O_DIRECT disk reads: 1504 MB in 3.00 seconds = 501.14 MB/sec
加缓存的读的速度

/dev/mapper/centos-data:
Timing cached reads: 7166 MB in 2.00 seconds = 3590.37 MB/sec
Timing buffered disk reads: 2466 MB in 3.00 seconds = 821.22 MB/sec
第 4 次

不加缓存的读的速度

/dev/mapper/centos-data:
Timing O_DIRECT disk reads: 1502 MB in 3.00 seconds = 500.16 MB/sec
加缓存的读的速度

/dev/mapper/centos-data:
Timing cached reads: 6128 MB in 2.00 seconds = 3068.84 MB/sec
Timing buffered disk reads: 2458 MB in 3.00 seconds = 818.49 MB/sec
第 5 次

不加缓存的读的速度

/dev/mapper/centos-data:
Timing O_DIRECT disk reads: 1520 MB in 3.00 seconds = 506.21 MB/sec
加缓存的读的速度

/dev/mapper/centos-data:
Timing cached reads: 13962 MB in 1.99 seconds = 7008.67 MB/sec
Timing buffered disk reads: 1922 MB in 3.00 seconds = 640.63 MB/sec
第 6 次

不加缓存的读的速度

/dev/mapper/centos-data:
Timing O_DIRECT disk reads: 1518 MB in 3.00 seconds = 505.60 MB/sec
加缓存的读的速度

/dev/mapper/centos-data:
Timing cached reads: 13844 MB in 1.99 seconds = 6948.62 MB/sec
Timing buffered disk reads: 2354 MB in 3.05 seconds = 771.04 MB/sec
第 7 次

不加缓存的读的速度

/dev/mapper/centos-data:
Timing O_DIRECT disk reads: 1448 MB in 3.01 seconds = 481.53 MB/sec
加缓存的读的速度

/dev/mapper/centos-data:
Timing cached reads: 13922 MB in 1.99 seconds = 6988.16 MB/sec
Timing buffered disk reads: 2514 MB in 3.00 seconds = 837.32 MB/sec
第 8 次

不加缓存的读的速度

/dev/mapper/centos-data:
Timing O_DIRECT disk reads: 1518 MB in 3.00 seconds = 505.98 MB/sec
加缓存的读的速度

/dev/mapper/centos-data:
Timing cached reads: 13428 MB in 1.99 seconds = 6739.53 MB/sec
Timing buffered disk reads: 2502 MB in 3.11 seconds = 804.66 MB/sec
第 9 次

不加缓存的读的速度

/dev/mapper/centos-data:
Timing O_DIRECT disk reads: 1518 MB in 3.00 seconds = 505.83 MB/sec
加缓存的读的速度

/dev/mapper/centos-data:
Timing cached reads: 13960 MB in 1.99 seconds = 7007.73 MB/sec
Timing buffered disk reads: 2524 MB in 3.00 seconds = 841.22 MB/sec
第 10 次

不加缓存的读的速度

/dev/mapper/centos-data:
Timing O_DIRECT disk reads: 1496 MB in 3.00 seconds = 498.17 MB/sec
加缓存的读的速度

/dev/mapper/centos-data:
Timing cached reads: 8316 MB in 2.00 seconds = 4167.40 MB/sec
Timing buffered disk reads: 2438 MB in 3.00 seconds = 811.96 MB/sec

磁盘的读的性能测试总结

查看以上的结果可以看出不加缓存的性能大概为492.75 MB/sec

查看以上的结果可以看出加缓存的性能大概为811.96 MB/sec

磁盘的写的性能测试

#cat dist-write.sh

# cat dist-write.sh
#!bin/sh

for((i=1;i<=10;i++));do
echo -e "第" $i "次 \n"

time dd if=/dev/mapper/centos-data bs=1024 count=1000000 of=/greenplum/xiaoxu/$iGb.file

done

# sh dist-write.sh
第 1 次

1000000+0 records in
1000000+0 records out
1024000000 bytes (1.0 GB) copied, 3.29012 s, 311 MB/s

real 0m3.291s
user 0m0.365s
sys 0m2.924s
第 2 次

1000000+0 records in
1000000+0 records out
1024000000 bytes (1.0 GB) copied, 3.17714 s, 322 MB/s

real 0m3.406s
user 0m0.382s
sys 0m3.023s
第 3 次

1000000+0 records in
1000000+0 records out
1024000000 bytes (1.0 GB) copied, 3.10169 s, 330 MB/s

real 0m3.331s
user 0m0.377s
sys 0m2.953s
第 4 次

1000000+0 records in
1000000+0 records out
1024000000 bytes (1.0 GB) copied, 5.04957 s, 203 MB/s

real 0m5.284s
user 0m0.351s
sys 0m3.148s
第 5 次

1000000+0 records in
1000000+0 records out
1024000000 bytes (1.0 GB) copied, 5.10719 s, 201 MB/s

real 0m5.488s
user 0m0.390s
sys 0m3.253s
第 6 次

1000000+0 records in
1000000+0 records out
1024000000 bytes (1.0 GB) copied, 5.0344 s, 203 MB/s

real 0m5.369s
user 0m0.334s
sys 0m3.207s
第 7 次

1000000+0 records in
1000000+0 records out
1024000000 bytes (1.0 GB) copied, 5.12343 s, 200 MB/s

real 0m5.480s
user 0m0.349s
sys 0m3.298s
第 8 次

1000000+0 records in
1000000+0 records out
1024000000 bytes (1.0 GB) copied, 5.01695 s, 204 MB/s

real 0m5.351s
user 0m0.372s
sys 0m3.149s
第 9 次

1000000+0 records in
1000000+0 records out
1024000000 bytes (1.0 GB) copied, 3.16025 s, 324 MB/s

real 0m3.511s
user 0m0.396s
sys 0m3.068s
第 10 次

1000000+0 records in
1000000+0 records out
1024000000 bytes (1.0 GB) copied, 5.11053 s, 200 MB/s

real 0m5.345s
user 0m0.351s
sys 0m3.218s

磁盘的写的性能测试总结

磁盘的写的性能大概为200 MB/s

数据节点信息

数据节点(192.168.****)

IP地址

192.168.****

物理内存

# free -h
total used free shared buff/cache available
Mem: 346G 3.5G 33G 7.2G 309G 334G
Swap: 15G 4K 15G

内存的大小为:346G

CPU 详细信息

# cat /proc/cpuinfo|grep cpu
cpu family : 6
cpu MHz : 1200.035
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.609
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.035
cpu cores : 18
cpuid level : 20
cpu family : 6
cpu MHz : 1200.527
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1199.953
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.199
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.117
cpu cores : 18
cpuid level : 20
cpu family : 6
cpu MHz : 1200.035
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.117
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.199
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.035
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.199
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.937
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.281
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.117
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.199
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.773
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.199
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.035
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.281
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.035
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.199
cpu cores : 18
cpuid level : 20

cpu family : 6
cpu MHz : 1200.363
cpu cores : 18
cpuid level : 20