达梦数据库集群节点磁盘性能测试

最新推荐文章于 2023-09-15 13:44:57 发布
最新推荐文章于 2023-09-15 13:44:57 发布
阅读量1k 收藏 2
点赞数
文章标签： 数据库 oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/YanXundJiMo/article/details/120143341
版权

达梦数据库集群节点磁盘性能测试

1、本次测试磁盘

IP共享数据盘非共享挂载盘
192.168.157.100/dev/pbdx15/dmarch
192.168.157.101/dev/pbdx15/dmarch

说明：本次测试各取两套集群节点中的一个节点进行磁盘性能测试，包含共享数据盘与非共享挂载盘测试

2、测试模式

测试方式测试模式
DD8k、16k、32k、64k、
FIOread、write、randread、randwrite

3、测试命令

3.1、DD测试命令

sudo dd if=/dev/zero of=/dev/pbdx15 bs=8k count=4k oflag=dsync

sudo dd if=/dev/zero of=/dev/pbdx15 bs=16k count=4k oflag=dsync

sudo dd if=/dev/zero of=/dev/pbdx15 bs=32k count=4k oflag=dsync

sudo dd if=/dev/zero of=/dev/pbdx15 bs=64k count=4k oflag=dsync

3.2、FIO测试命令

read:

[global]

ioengine=libaio

iodepth=8

size=500g

direct=1

runtime=300

time_based

numjobs=1

group_reporting=1

rw=read

bs=1024k

[job1]

filename=/dev/dm_data008

write:

[

global]

ioengine=libaio

iodepth=8

size=500g

direct=1

runtime=100

time_based

numjobs=1

group_reporting=1

rw=write

bs=1024k

[job1]

filename=/dev/dm_data008

randread:

global]

ioengine=libaio

iodepth=8

size=500g

direct=1

runtime=300

time_based

numjobs=1

group_reporting=1

rw=randread

bs=1024k

[job1]

filename=/dev/dm_data008

randwrite:

[global]

ioengine=libaio

iodepth=8

size=500g

direct=1

runtime=100

time_based

numjobs=1

group_reporting=1

rw=write

bs=1024k

[job1]

filename=/dev/dm_data008

4、测试过程记录

磁盘测试：
DD模式

**DSC1**
命令：

共享盘

sudo dd if=/dev/zero of=/dev/pbdx15 bs=8k count=4k oflag=dsync


[spuser@sds-part-dmdb01 ~]$ sudo dd if=/dev/zero of=/dev/pbdx15 bs=8k count=1024 oflag=direct
1024+0 records in
1024+0 records out
8388608 bytes (8.4 MB) copied, 0.575566 s, 14.6 MB/s
[spuser@sds-part-dmdb01 ~]$ sudo dd if=/dev/zero of=/dev/pbdx14 bs=8k count=1024 oflag=direct 
1024+0 records in
1024+0 records out
8388608 bytes (8.4 MB) copied, 0.371611 s, 22.6 MB/s

[spuser@sds-part-dmdb01 ~]$ sudo dd if=/dev/zero of=/dev/pbdx15 bs=8k count=4k oflag=dsync
4096+0 records in
4096+0 records out
33554432 bytes (34 MB) copied, 1.12952 s, 29.7 MB/s


[spuser@sds-part-dmdb01 dmarch]$ sudo dd if=/dev/zero of=/dev/pbdx15 bs=16k count=4k oflag=dsync
4096+0 records in
4096+0 records out
67108864 bytes (67 MB) copied, 2.14398 s, 31.3 MB/s
[spuser@sds-part-dmdb01 dmarch]$ sudo dd if=/dev/zero of=/dev/pbdx15 bs=32k count=4k oflag=dsync  
4096+0 records in
4096+0 records out
134217728 bytes (134 MB) copied, 1.40846 s, 95.3 MB/s
[spuser@sds-part-dmdb01 dmarch]$ sudo dd if=/dev/zero of=/dev/pbdx15 bs=64k count=4k oflag=dsync  
4096+0 records in
4096+0 records out
268435456 bytes (268 MB) copied, 1.5298 s, 175 MB/s

非共享：

sudo dd if=/dev/zero of=/dmarch bs=8k count=4k oflag=dsync


[spuser@sds-part-dmdb01 ~]$ sudo dd if=/dev/zero of=/dmarch/test bs=8k count=4k oflag=dsync
4096+0 records in
4096+0 records out
33554432 bytes (34 MB) copied, 3.24571 s, 10.3 MB/s


[spuser@sds-part-dmdb01 dmarch]$ sudo dd if=/dev/zero of=/dmarch/test bs=16k count=4k oflag=dsync
4096+0 records in
4096+0 records out
67108864 bytes (67 MB) copied, 2.13993 s, 31.4 MB/s
[spuser@sds-part-dmdb01 dmarch]$ sudo dd if=/dev/zero of=/dmarch/test bs=32k count=4k oflag=dsync  
4096+0 records in
4096+0 records out
134217728 bytes (134 MB) copied, 2.49752 s, 53.7 MB/s
[spuser@sds-part-dmdb01 dmarch]$ sudo dd if=/dev/zero of=/dmarch/test bs=64k count=4k oflag=dsync  
4096+0 records in
4096+0 records out
268435456 bytes (268 MB) copied, 2.67437 s, 100 MB/s


**DSC2:**

共享盘
[spuser@sds-part-dmdb03 ~]$ sudo dd if=/dev/zero of=/dev/pbdx15 bs=8k count=4k oflag=dsync  
4096+0 records in
4096+0 records out
33554432 bytes (34 MB) copied, 1.51813 s, 22.1 MB/s
[spuser@sds-part-dmdb03 ~]$ sudo dd if=/dev/zero of=/dev/pbdx15 bs=16k count=4k oflag=dsync 
4096+0 records in
4096+0 records out
67108864 bytes (67 MB) copied, 1.16933 s, 57.4 MB/s
[spuser@sds-part-dmdb03 ~]$ sudo dd if=/dev/zero of=/dev/pbdx15 bs=32k count=4k oflag=dsync  
4096+0 records in
4096+0 records out
134217728 bytes (134 MB) copied, 1.32171 s, 102 MB/s
[spuser@sds-part-dmdb03 ~]$ sudo dd if=/dev/zero of=/dev/pbdx15 bs=64k count=4k oflag=dsync  
4096+0 records in
4096+0 records out
268435456 bytes (268 MB) copied, 1.714 s, 157 MB/s

非共享：
[spuser@sds-part-dmdb03 ~]$ sudo dd if=/dev/zero of=/dmarch/test bs=8k count=4k oflag=dsync
4096+0 records in
4096+0 records out
33554432 bytes (34 MB) copied, 2.1815 s, 15.4 MB/s
[spuser@sds-part-dmdb03 ~]$ sudo dd if=/dev/zero of=/dmarch/test bs=16k count=4k oflag=dsync 
4096+0 records in
4096+0 records out
67108864 bytes (67 MB) copied, 2.23666 s, 30.0 MB/s
[spuser@sds-part-dmdb03 ~]$ sudo dd if=/dev/zero of=/dmarch/test bs=32k count=4k oflag=dsync  
4096+0 records in
4096+0 records out
134217728 bytes (134 MB) copied, 2.58909 s, 51.8 MB/s
[spuser@sds-part-dmdb03 ~]$ sudo dd if=/dev/zero of=/dmarch/test bs=64k count=4k oflag=dsync  
4096+0 records in
4096+0 records out
268435456 bytes (268 MB) copied, 2.86282 s, 93.8 MB/s
[spuser@sds-part-dmdb03 ~]$ sudo dd if=/dev/zero of=/dmarch/test bs=1024k count=4k oflag=dsync  
4096+0 records in
4096+0 records out
4294967296 bytes (4.3 GB) copied, 23.5047 s, 183 MB/s


=======================================================================

FIO 模式测试：

DSC01

read:

Run status group 0 (all jobs):
[spuser@sds-part-dmdb03 scripts]$ sudo fio read 
job1: (g=0): rw=read, bs=(R) 1024KiB-1024KiB, (W) 1024KiB-1024KiB, (T) 1024KiB-1024KiB, ioengine=libaio, iodepth=8
fio-3.7
Starting 1 process
Jobs: 1 (f=1): [R(1)][100.0%][r=386MiB/s,w=0KiB/s][r=386,w=0 IOPS][eta 00m:00s]
job1: (groupid=0, jobs=1): err= 0: pid=2422092: Tue Aug 24 16:44:56 2021
   read: IOPS=359, BW=360MiB/s (377MB/s)(35.1GiB/100028msec)
    slat (usec): min=40, max=2869, avg=97.45, stdev=32.08
    clat (msec): min=2, max=185, avg=22.13, stdev=10.18
     lat (msec): min=2, max=186, avg=22.23, stdev=10.18
    clat percentiles (msec):
     |  1.00th=[    8],  5.00th=[   10], 10.00th=[   12], 20.00th=[   14],
     | 30.00th=[   16], 40.00th=[   18], 50.00th=[   21], 60.00th=[   23],
     | 70.00th=[   26], 80.00th=[   30], 90.00th=[   36], 95.00th=[   42],
     | 99.00th=[   54], 99.50th=[   61], 99.90th=[   78], 99.95th=[   83],
     | 99.99th=[  104]
   bw (  KiB/s): min=299008, max=421888, per=99.99%, avg=368413.80, stdev=20676.16, samples=200
   iops        : min=  292, max=  412, avg=359.76, stdev=20.19, samples=200
  lat (msec)   : 4=0.14%, 10=6.77%, 20=42.00%, 50=49.66%, 100=1.42%
  lat (msec)   : 250=0.01%
  cpu          : usr=0.25%, sys=3.85%, ctx=34715, majf=0, minf=546
  IO depths    : 1=0.1%, 2=0.1%, 4=0.1%, 8=100.0%, 16=0.0%, 32=0.0%, >=64=0.0%
     submit    : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     complete  : 0=0.0%, 4=100.0%, 8=0.1%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     issued rwts: total=35991,0,0,0 short=0,0,0,0 dropped=0,0,0,0
     latency   : target=0, window=0, percentile=100.00%, depth=8

Run status group 0 (all jobs):
   READ: bw=360MiB/s (377MB/s), 360MiB/s-360MiB/s (377MB/s-377MB/s), io=35.1GiB (37.7GB), run=100028-100028msec
   
   

write:

[spuser@sds-part-dmdb03 scripts]$ sudo fio write 
job1: (g=0): rw=write, bs=(R) 1024KiB-1024KiB, (W) 1024KiB-1024KiB, (T) 1024KiB-1024KiB, ioengine=libaio, iodepth=8
fio-3.7
Starting 1 process
Jobs: 1 (f=1): [W(1)][100.0%][r=0KiB/s,w=927MiB/s][r=0,w=927 IOPS][eta 00m:00s] 
job1: (groupid=0, jobs=1): err= 0: pid=2424522: Tue Aug 24 16:51:28 2021
  write: IOPS=1668, BW=1668MiB/s (1749MB/s)(489GiB/300007msec)
    slat (usec): min=43, max=13254, avg=153.23, stdev=64.90
    clat (usec): min=862, max=36350, avg=4634.60, stdev=2052.50
     lat (usec): min=970, max=36560, avg=4789.65, stdev=2056.08
    clat percentiles (usec):
     |  1.00th=[ 1614],  5.00th=[ 2442], 10.00th=[ 2900], 20.00th=[ 3458],
     | 30.00th=[ 3851], 40.00th=[ 4146], 50.00th=[ 4359], 60.00th=[ 4621],
     | 70.00th=[ 4883], 80.00th=[ 5276], 90.00th=[ 6128], 95.00th=[ 8586],
     | 99.00th=[10552], 99.50th=[15270], 99.90th=[26608], 99.95th=[28181],
     | 99.99th=[31327]
   bw (  MiB/s): min=  870, max= 1982, per=99.99%, avg=1668.04, stdev=290.64, samples=600
   iops        : min=  870, max= 1982, avg=1668.00, stdev=290.64, samples=600
  lat (usec)   : 1000=0.05%
  lat (msec)   : 2=2.41%, 4=32.43%, 10=63.82%, 20=0.97%, 50=0.32%
  cpu          : usr=9.42%, sys=18.60%, ctx=299353, majf=0, minf=28
  IO depths    : 1=0.1%, 2=0.1%, 4=0.1%, 8=100.0%, 16=0.0%, 32=0.0%, >=64=0.0%
     submit    : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     complete  : 0=0.0%, 4=100.0%, 8=0.1%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     issued rwts: total=0,500496,0,0 short=0,0,0,0 dropped=0,0,0,0
     latency   : target=0, window=0, percentile=100.00%, depth=8

Run status group 0 (all jobs):
  WRITE: bw=1668MiB/s (1749MB/s), 1668MiB/s-1668MiB/s (1749MB/s-1749MB/s), io=489GiB (525GB), run=300007-300007msec



randread:

[spuser@sds-part-dmdb03 scripts]$ sudo fio randread 
job1: (g=0): rw=randread, bs=(R) 8192B-8192B, (W) 8192B-8192B, (T) 8192B-8192B, ioengine=libaio, iodepth=8
...
fio-3.7
Starting 2 processes
Jobs: 2 (f=2): [r(2)][100.0%][r=11.1MiB/s,w=0KiB/s][r=1424,w=0 IOPS][eta 00m:00s]
job1: (groupid=0, jobs=2): err= 0: pid=2433118: Tue Aug 24 17:02:56 2021
   read: IOPS=1448, BW=11.3MiB/s (11.9MB/s)(3395MiB/300021msec)
    slat (usec): min=6, max=4793, avg=13.50, stdev=12.98
    clat (usec): min=136, max=95286, avg=11022.92, stdev=5025.96
     lat (usec): min=152, max=95301, avg=11038.21, stdev=5026.00
    clat percentiles (usec):
     |  1.00th=[  347],  5.00th=[ 4752], 10.00th=[ 5800], 20.00th=[ 7242],
     | 30.00th=[ 8356], 40.00th=[ 9372], 50.00th=[10421], 60.00th=[11469],
     | 70.00th=[12518], 80.00th=[13960], 90.00th=[16909], 95.00th=[20055],
     | 99.00th=[28181], 99.50th=[32375], 99.90th=[42206], 99.95th=[46400],
     | 99.99th=[59507]
   bw (  KiB/s): min= 5200, max= 7024, per=50.00%, avg=5793.91, stdev=273.59, samples=1200
   iops        : min=  650, max=  878, avg=724.21, stdev=34.20, samples=1200
  lat (usec)   : 250=0.20%, 500=0.99%, 750=0.02%, 1000=0.01%
  lat (msec)   : 2=0.06%, 4=1.63%, 10=43.03%, 20=49.07%, 50=4.96%
  lat (msec)   : 100=0.03%
  cpu          : usr=0.60%, sys=1.64%, ctx=419848, majf=0, minf=98
  IO depths    : 1=0.1%, 2=0.1%, 4=0.1%, 8=100.0%, 16=0.0%, 32=0.0%, >=64=0.0%
     submit    : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     complete  : 0=0.0%, 4=100.0%, 8=0.1%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     issued rwts: total=434607,0,0,0 short=0,0,0,0 dropped=0,0,0,0
     latency   : target=0, window=0, percentile=100.00%, depth=8

Run status group 0 (all jobs):
   READ: bw=11.3MiB/s (11.9MB/s), 11.3MiB/s-11.3MiB/s (11.9MB/s-11.9MB/s), io=3395MiB (3560MB), run=300021-300021msec
   
   
   
 randwrite:
 [spuser@sds-part-dmdb03 scripts]$ sudo fio  randwrite 
job1: (g=0): rw=randwrite, bs=(R) 8192B-8192B, (W) 8192B-8192B, (T) 8192B-8192B, ioengine=libaio, iodepth=8
...
fio-3.7
Starting 2 processes
Jobs: 2 (f=2): [w(2)][100.0%][r=0KiB/s,w=279MiB/s][r=0,w=35.7k IOPS][eta 00m:00s]
job1: (groupid=0, jobs=2): err= 0: pid=2440970: Tue Aug 24 17:12:47 2021
  write: IOPS=33.1k, BW=259MiB/s (271MB/s)(75.8GiB/300003msec)
    slat (usec): min=6, max=27353, avg=12.43, stdev=14.95
    clat (usec): min=57, max=36696, avg=462.83, stdev=655.56
     lat (usec): min=128, max=36708, avg=477.05, stdev=656.03
    clat percentiles (usec):
     |  1.00th=[  192],  5.00th=[  227], 10.00th=[  253], 20.00th=[  293],
     | 30.00th=[  330], 40.00th=[  359], 50.00th=[  392], 60.00th=[  433],
     | 70.00th=[  478], 80.00th=[  537], 90.00th=[  627], 95.00th=[  725],
     | 99.00th=[ 1565], 99.50th=[ 2737], 99.90th=[ 9896], 99.95th=[16712],
     | 99.99th=[24773]
   bw (  KiB/s): min=11376, max=171904, per=49.99%, avg=132486.38, stdev=20787.03, samples=1199
   iops        : min= 1422, max=21488, avg=16560.77, stdev=2598.38, samples=1199
  lat (usec)   : 100=0.01%, 250=9.41%, 500=64.97%, 750=21.22%, 1000=2.57%
  lat (msec)   : 2=1.08%, 4=0.45%, 10=0.21%, 20=0.07%, 50=0.03%
  cpu          : usr=12.07%, sys=30.47%, ctx=3074478, majf=0, minf=61
  IO depths    : 1=0.1%, 2=0.1%, 4=0.1%, 8=100.0%, 16=0.0%, 32=0.0%, >=64=0.0%
     submit    : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     complete  : 0=0.0%, 4=100.0%, 8=0.1%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     issued rwts: total=0,9937848,0,0 short=0,0,0,0 dropped=0,0,0,0
     latency   : target=0, window=0, percentile=100.00%, depth=8

Run status group 0 (all jobs):
  WRITE: bw=259MiB/s (271MB/s), 259MiB/s-259MiB/s (271MB/s-271MB/s), io=75.8GiB (81.4GB), run=300003-300003msec
  
  
   **DSC02**
read：
[spuser@sds-part-dmdb01 scripts]$ sudo fio read
job1: (g=0): rw=read, bs=(R) 1024KiB-1024KiB, (W) 1024KiB-1024KiB, (T) 1024KiB-1024KiB, ioengine=libaio, iodepth=8
fio-3.7
Starting 1 process
Jobs: 1 (f=1): [R(1)][100.0%][r=367MiB/s,w=0KiB/s][r=367,w=0 IOPS][eta 00m:00s]
job1: (groupid=0, jobs=1): err= 0: pid=1777295: Tue Aug 24 16:48:19 2021
   read: IOPS=354, BW=354MiB/s (371MB/s)(34.6GiB/100021msec)
    slat (usec): min=40, max=3181, avg=97.09, stdev=39.34
    clat (msec): min=2, max=133, avg=22.49, stdev=10.34
     lat (msec): min=2, max=133, avg=22.59, stdev=10.34
    clat percentiles (usec):
     |  1.00th=[ 7242],  5.00th=[ 9241], 10.00th=[11338], 20.00th=[14091],
     | 30.00th=[16057], 40.00th=[18220], 50.00th=[20579], 60.00th=[23200],
     | 70.00th=[26084], 80.00th=[29492], 90.00th=[36439], 95.00th=[41157],
     | 99.00th=[55837], 99.50th=[63701], 99.90th=[79168], 99.95th=[86508],
     | 99.99th=[98042]
   bw (  KiB/s): min=290816, max=409600, per=99.99%, avg=362487.25, stdev=19190.00, samples=200
   iops        : min=  284, max=  400, avg=353.98, stdev=18.75, samples=200
  lat (msec)   : 4=0.14%, 10=6.44%, 20=40.56%, 50=51.24%, 100=1.62%
  lat (msec)   : 250=0.01%
  cpu          : usr=0.27%, sys=3.75%, ctx=34231, majf=0, minf=546
  IO depths    : 1=0.1%, 2=0.1%, 4=0.1%, 8=100.0%, 16=0.0%, 32=0.0%, >=64=0.0%
     submit    : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     complete  : 0=0.0%, 4=100.0%, 8=0.1%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     issued rwts: total=35411,0,0,0 short=0,0,0,0 dropped=0,0,0,0
     latency   : target=0, window=0, percentile=100.00%, depth=8

Run status group 0 (all jobs):
   READ: bw=354MiB/s (371MB/s), 354MiB/s-354MiB/s (371MB/s-371MB/s), io=34.6GiB (37.1GB), run=100021-100021msec
   
   
write:

[spuser@sds-part-dmdb01 scripts]$ sudo fio write
job1: (g=0): rw=write, bs=(R) 1024KiB-1024KiB, (W) 1024KiB-1024KiB, (T) 1024KiB-1024KiB, ioengine=libaio, iodepth=8
fio-3.7
Starting 1 process
Jobs: 1 (f=1): [W(1)][100.0%][r=0KiB/s,w=1864MiB/s][r=0,w=1864 IOPS][eta 00m:00s]
job1: (groupid=0, jobs=1): err= 0: pid=1780148: Tue Aug 24 16:55:49 2021
  write: IOPS=1725, BW=1726MiB/s (1810MB/s)(506GiB/300003msec)
    slat (usec): min=43, max=11581, avg=150.14, stdev=60.01
    clat (usec): min=852, max=48276, avg=4477.38, stdev=1833.67
     lat (usec): min=922, max=48494, avg=4629.38, stdev=1837.96
    clat percentiles (usec):
     |  1.00th=[ 1565],  5.00th=[ 2343], 10.00th=[ 2769], 20.00th=[ 3294],
     | 30.00th=[ 3720], 40.00th=[ 4015], 50.00th=[ 4293], 60.00th=[ 4555],
     | 70.00th=[ 4817], 80.00th=[ 5145], 90.00th=[ 5932], 95.00th=[ 8160],
     | 99.00th=[10028], 99.50th=[11600], 99.90th=[22938], 99.95th=[26346],
     | 99.99th=[31065]
   bw (  MiB/s): min=  730, max= 2002, per=99.99%, avg=1725.71, stdev=310.14, samples=600
   iops        : min=  730, max= 2002, avg=1725.68, stdev=310.14, samples=600
  lat (usec)   : 1000=0.06%
  lat (msec)   : 2=2.73%, 4=36.44%, 10=59.74%, 20=0.87%, 50=0.14%
  cpu          : usr=9.62%, sys=18.87%, ctx=308078, majf=0, minf=28
  IO depths    : 1=0.1%, 2=0.1%, 4=0.1%, 8=100.0%, 16=0.0%, 32=0.0%, >=64=0.0%
     submit    : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     complete  : 0=0.0%, 4=100.0%, 8=0.1%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     issued rwts: total=0,517785,0,0 short=0,0,0,0 dropped=0,0,0,0
     latency   : target=0, window=0, percentile=100.00%, depth=8

Run status group 0 (all jobs):
  WRITE: bw=1726MiB/s (1810MB/s), 1726MiB/s-1726MiB/s (1810MB/s-1810MB/s), io=506GiB (543GB), run=300003-300003msec



randread:

[spuser@sds-part-dmdb01 scripts]$ sudo fio randread 
job1: (g=0): rw=randread, bs=(R) 8192B-8192B, (W) 8192B-8192B, (T) 8192B-8192B, ioengine=libaio, iodepth=8
...
fio-3.7
Starting 2 processes
Jobs: 2 (f=2): [r(2)][100.0%][r=13.5MiB/s,w=0KiB/s][r=1728,w=0 IOPS][eta 00m:00s]
job1: (groupid=0, jobs=2): err= 0: pid=1786220: Tue Aug 24 17:03:24 2021
   read: IOPS=1451, BW=11.3MiB/s (11.9MB/s)(3403MiB/300010msec)
    slat (usec): min=6, max=5212, avg=13.62, stdev=12.49
    clat (usec): min=172, max=91185, avg=10998.20, stdev=4967.85
     lat (usec): min=183, max=91202, avg=11013.62, stdev=4967.89
    clat percentiles (usec):
     |  1.00th=[  351],  5.00th=[ 4752], 10.00th=[ 5800], 20.00th=[ 7242],
     | 30.00th=[ 8356], 40.00th=[ 9372], 50.00th=[10421], 60.00th=[11338],
     | 70.00th=[12518], 80.00th=[13960], 90.00th=[16712], 95.00th=[19792],
     | 99.00th=[27919], 99.50th=[32113], 99.90th=[41681], 99.95th=[46400],
     | 99.99th=[56886]
   bw (  KiB/s): min= 5136, max= 7216, per=49.99%, avg=5806.06, stdev=347.09, samples=1200
   iops        : min=  642, max=  902, avg=725.70, stdev=43.40, samples=1200
  lat (usec)   : 250=0.15%, 500=1.05%, 750=0.01%, 1000=0.01%
  lat (msec)   : 2=0.01%, 4=1.51%, 10=43.22%, 20=49.21%, 50=4.80%
  lat (msec)   : 100=0.03%
  cpu          : usr=0.59%, sys=1.66%, ctx=420895, majf=0, minf=98
  IO depths    : 1=0.1%, 2=0.1%, 4=0.1%, 8=100.0%, 16=0.0%, 32=0.0%, >=64=0.0%
     submit    : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     complete  : 0=0.0%, 4=100.0%, 8=0.1%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     issued rwts: total=435571,0,0,0 short=0,0,0,0 dropped=0,0,0,0
     latency   : target=0, window=0, percentile=100.00%, depth=8

Run status group 0 (all jobs):
   READ: bw=11.3MiB/s (11.9MB/s), 11.3MiB/s-11.3MiB/s (11.9MB/s-11.9MB/s), io=3403MiB (3568MB), run=300010-300010msec
   
   
 randwrite:
 
 
 [spuser@sds-part-dmdb01 scripts]$ sudo fio randwrite 
job1: (g=0): rw=randwrite, bs=(R) 8192B-8192B, (W) 8192B-8192B, (T) 8192B-8192B, ioengine=libaio, iodepth=8
...
fio-3.7
Starting 2 processes
Jobs: 2 (f=2): [w(2)][100.0%][r=0KiB/s,w=285MiB/s][r=0,w=36.4k IOPS][eta 00m:00s]
job1: (groupid=0, jobs=2): err= 0: pid=1791799: Tue Aug 24 17:10:25 2021
  write: IOPS=32.6k, BW=255MiB/s (267MB/s)(74.7GiB/300007msec)
    slat (usec): min=6, max=7129, avg=12.16, stdev=10.98
    clat (usec): min=90, max=40011, avg=470.58, stdev=656.06
     lat (usec): min=139, max=40020, avg=484.52, stdev=656.47
    clat percentiles (usec):
     |  1.00th=[  194],  5.00th=[  229], 10.00th=[  255], 20.00th=[  297],
     | 30.00th=[  334], 40.00th=[  367], 50.00th=[  400], 60.00th=[  441],
     | 70.00th=[  490], 80.00th=[  545], 90.00th=[  635], 95.00th=[  734],
     | 99.00th=[ 1663], 99.50th=[ 2835], 99.90th=[ 9503], 99.95th=[16450],
     | 99.99th=[25297]
   bw (  KiB/s): min=17536, max=163824, per=49.99%, avg=130438.77, stdev=22081.36, samples=1199
   iops        : min= 2192, max=20478, avg=16304.82, stdev=2760.18, samples=1199
  lat (usec)   : 100=0.01%, 250=8.90%, 500=63.40%, 750=23.06%, 1000=2.78%
  lat (msec)   : 2=1.07%, 4=0.49%, 10=0.22%, 20=0.06%, 50=0.03%
  cpu          : usr=11.72%, sys=29.98%, ctx=3162186, majf=0, minf=59
  IO depths    : 1=0.1%, 2=0.1%, 4=0.1%, 8=100.0%, 16=0.0%, 32=0.0%, >=64=0.0%
     submit    : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     complete  : 0=0.0%, 4=100.0%, 8=0.1%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     issued rwts: total=0,9785386,0,0 short=0,0,0,0 dropped=0,0,0,0
     latency   : target=0, window=0, percentile=100.00%, depth=8

Run status group 0 (all jobs):
  WRITE: bw=255MiB/s (267MB/s), 255MiB/s-255MiB/s (267MB/s-267MB/s), io=74.7GiB (80.2GB), run=300007-300007msec
 
 mix：

5、测试结果汇总

5.1 DD模式测试结果

IP模式共享盘（pbdx15）非共享（/dmarch）
192.168.157.100(dsc1)8K1.12952 s, 29.7 MB/s3.24571 s, 10.3 MB/s
16K2.14398 s, 31.3 MB/s2.13993 s, 31.4 MB/s
32K1.40846 s, 95.3 MB/s2.49752 s, 53.7 MB/s
64K1.5298 s, 175 MB/s2.67437 s, 100 MB/s
192.168.157.101(dsc3)8K1.51813 s, 22.1 MB/s2.1815 s, 15.4 MB/s
16K1.16933 s, 57.4 MB/s2.23666 s, 30.0 MB/s
32K1.32171 s, 102 MB/s2.58909 s, 51.8 MB/s
64K1.714 s, 157 MB/s2.86282 s, 93.8 MB/s

更多资讯请上达梦技术社区了解： https://eco.dameng.com

YanXundJiMo
关注
  • 0
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
达梦数据性能诊断与优化
zjshaha的博客
09-25 655
达梦数据库性能诊断与优化
DMDSC集群测试 ASM 环境下磁盘的读写速度
cainiao_2018的博客
08-11 513
DMDSC集群测试 ASM 环境下磁盘的读写速度
达梦数据库性能检测与提升总结
weixin_40212662的博客
09-09 2503
本篇为学习整理资料，汇集了网络平台上关于达梦数据库性能相关的文章链接，以及自己的一些知识、经验总结。目的是能够在学习、工作中进行参照。数据库运行参数相关配置的正确性：需要结合硬件运行环境做调整，如CPU和数据库并行线程等信息的调整；操作系统层面的，如文件打开数，IO调度、虚拟内存以及最大线程数等；sql执行是否高效：结构设计、sql设计、统计信息的及时更新；等待事件：锁表、io等待等。
达梦数据库TPCC性能测试
qq_38113458的博客
06-03 278
数据库压力测试
达梦数据库测试案例—基于EntityFrameworkCore 6.x
juanhuge的专栏
09-15 917
这两年国内的数据库产品如异军突起，保持了非常良好的发展势头，如达梦，人大金仓，神通，南大通用GBase，以及基于ServerLess形态的TDSQL等，今天以为例，聊一下基于EFCore组件接入达梦数据库的案例。
Linux磁盘/硬盘测速,dd命令,测试顺序读写,测试4K性能
Franciz777的博客
09-09 4645
这条命令每次读取64k后就要先把这64k写入磁盘，然后再读取下面这64k，一共重复4k即4000次。64k=128M数据到内存并写入到磁盘上所需的时间，这样算出来的时间才是比较符合实际使用结果的。比如此时测试sdb硬盘下sdb1分区的读写速度,进入到对应分区的挂载目录,然后执行测试命令。if=/dev/zero（产生字符）不产生IO，因此可以用来测试纯写速度；bs是每次读或写的大小，即一个块的大小，count是读写块的数量。if=/dev/zero不产生IO，因此可以用来测试纯写速度；
达梦数据库2节点集群搭建与测试
01-27
达梦数据库2节点集群搭建与测试
达梦数据库三节点读写分离集群部署文档
最新发布
06-06
达梦数据库三节点读写分离集群部署文档 通过项目实战详细记录部署过程及关键点，适用于研究达梦集群的人群使用
nacos-server-2.1.1 适配达梦数据库
09-29
该版本根据nacos源码调整后适配达梦数据库 ，支持windows linux 支持多数据源配置，默认连接mysql。如果需要连接oracle、dm8 等，需要更改配置文件 打开\nacos\conf\application.properties,修改如下： spring....
nacos2.2.1达梦数据库版
06-08
支持达梦数据库配置持久化带数据库初始化sql脚本，原nacos版本只支持mysql与derby数据库配置持久化，不支持达梦数据库配置持久化。在原有的开源nacos上进行了源码更改，解决了网上教程的一些坑，测试持久化成功后...
nacos适配dm达梦数据库
01-28
1.nacos服务，适配dm达梦数据库。 2.提供nacos，dm达梦的创建nacos数据库脚本。 3.nacos-dm/conf/nacos-dm.sql文件。
达梦数据库性能分析
BShu666的博客
07-04 930
'阻塞信息',s.sess_id SId,t.wait_for_id ZSTId,s.sql_text ZSSql,s.user_name ZSUser,s.clnt_host,s.appname,s.clnt_ip,'被阻塞信息',s2.sess_id SId,t.id BZSId,s2.sql_text BZSSql,s2.user_name BZSUser,s2.clnt_host,s2.appname,s2.clnt_ip。开启：SP_SET_PARA_VALUE(1,'SVR_LOG',1);
达梦数据库主备集群节点故障模拟
qq_38482387的博客
06-09 735
达梦主备集群故障模拟
达梦故障排除与性能优化
zjshaha的博客
09-25 1759
达梦数据库优化相关
达梦数据库表简单测试
Mrkill123的博客
06-04 1673
DM8 表简单测试 本篇内容仅为在学习过程中，做的简单测试的相关记录。 非完全的功能性测试。 1、普通表简单测试 功能上和其他关系型数据库表功能一样。 ----创建测试表包含常用数据类型、自增列、检查约束、非空约束、缺省值列 create table "TEST"."TAB2" ( "ID" INT not null , "NAME" VARCHAR2(50) not null , "AGE" NUMBER(22, 6) check(age>=18) not null , "JOB" VARC
达梦数据库批量插入方法性能比较
龙山溪笔记
04-07 8680
达梦数据库各种批量插入方式性能比较
达梦数据库飞腾2000+单表插入性能测试
龙山溪笔记
03-16 1210
飞腾2000+单表插入性能测试 CREATE TABLE t_data_metric_20200316 ( c_inst_id INT NOT NULL , c_sub_inst_id INT NOT NULL , c_task_time INT NOT NULL , c_insert_time TIMESTAMP NOT NULL DEFAULT CURRENT_TI...
达梦数据库8 做TPCC测试
qq_33637320的博客
06-10 1712
一.知识准备 TPC-C是专门针对联机交易处理系统（OLTP系统）的规范，一般情况下我们也把这类系统称为业务处理系统。TPC-C测试用到的模型是一个大型的商品批发销售公司，它拥有若干个分布在不同区域的商品仓库。当业务扩展的时候，公司将添加新的仓库。每个仓库负责为10个销售点供货，其中每个销售点为3000个客户提供服务，每个客户提交的订单中，平均每个订单有10项产品，所有订单中约1%的产品在其直接所属的仓库中没有存货，必须由其他区域的仓库来供货。同时，每个仓库都要维护公司销售的100000种商品的库存.
达梦(DaMeng)数据库
CPU1994GHz的博客
06-15 2929
简介 武汉达梦，国产数据库。 常用SQL 版本查询：select * from v$version
达梦数据库集群 文峰 pdf
11-26
达梦数据库集群是一种高可用性、高性能的数据库解决方案。它能够将多个数据库节点组成一个集群，实现数据库的分布式管理和数据的共享。达梦数据库集群的设计理念是以可靠性、可扩展性和可管理性为核心，为用户提供稳定高效的数据库服务。 在达梦数据库集群中，各个数据库节点之间通过网络连接，并通过共享存储设备实现数据的共享。每个节点都可以独立执行读写操作，并且能够自动将数据同步到其他节点，以实现数据的一致性和高可用性。当其中一个节点故障时，系统会自动将该节点上的数据库服务切换到其他正常节点上，以确保数据库的持续可用。 另外，达梦数据库集群还提供了负载均衡功能，可以根据实际需求将请求分发到不同的节点上，以提高数据库的整体性能。它还具备自动故障检测和恢复功能，能够在节点故障时及时发现并进行处理。 综上所述，达梦数据库集群是一种可靠、高性能的数据库解决方案，能够满足企业对大规模数据存储和处理的需求。它提供了高可用性、负载均衡和自动故障恢复等功能，能够有效提高数据库的稳定性和性能，并为用户提供稳定可靠的数据库服务。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值