oracle orion 壓測磁碟效能raid10 raid5 raid50 資料
一
磁碟效能3個指標：
二 壓測機器 dell r730
三 場景先用oltp 壓測一下效能，接著用dss 看下
磁碟效能 SEAGATE 12 Gbps
磁碟是SEAGATE 12 Gbps SAS 15000轉 900G 8塊盤組成raid10
raid10 小檔案8k混合讀寫iops為2214，從8k到1M的檔案讀寫吞吐量為396MBPS，延遲為4ms。下面是具體的測試過程，資料。 [root@pro-pnh-310-db-tidb-mp-45 orion]# ./orion_linux_x86-64 -run oltp -verbose ORION: ORacle IO Numbers -- Version 11.1.0.7.0 orion_20221118_1035 Test will take approximately 22 minutes Larger caches may take longer Name: /dev/sda3 Size: 3579645526016 1 FILEs found. TEST START ---------------------------------------------- Running point: Small=1, Large=0 Point 1 out of 21 Valid Running point: Small=2, Large=0 Point 2 out of 21 Valid Running point: Small=3, Large=0 Point 3 out of 21 Valid Running point: Small=4, Large=0 Point 4 out of 21 Valid Running point: Small=5, Large=0 Point 5 out of 21 Valid Running point: Small=6, Large=0 Point 6 out of 21 Valid Running point: Small=7, Large=0 Point 7 out of 21 Valid Running point: Small=8, Large=0 Point 8 out of 21 Valid Running point: Small=9, Large=0 Point 9 out of 21 Valid Running point: Small=10, Large=0 Point 10 out of 21 Valid Running point: Small=11, Large=0 Point 11 out of 21 Valid Running point: Small=12, Large=0 Point 12 out of 21 Valid Running point: Small=13, Large=0 Point 13 out of 21 Valid Running point: Small=14, Large=0 Point 14 out of 21 Valid Running point: Small=15, Large=0 Point 15 out of 21 Valid Running point: Small=16, Large=0 Point 16 out of 21 Valid Running point: Small=17, Large=0 Point 17 out of 21 Valid Running point: Small=18, Large=0 Point 18 out of 21 Valid Running point: Small=19, Large=0 Point 19 out of 21 Valid Running point: Small=20, Large=0 Point 20 out of 21 Valid ---------------------------------------------- TEST END [root@pro-pnh-310-db-tidb-mp-45 orion]# cat orion_20221118_1035_summary.txt ORION VERSION 11.1.0.7.0 Commandline: -run oltp -verbose This maps to this test: Test: orion Small IO size: 8 KB Large IO size: 1024 KB IO Types: Small Random IOs, Large Random IOs Simulated Array Type: CONCAT Write: 0% Cache Size: Not Entered Duration for each Data Point: 60 seconds Small Columns:, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20 Large Columns:, 0 Total Data Points: 21 Name: /dev/sda3 Size: 3579645526016 1 FILEs found. Maximum Small IOPS=2214 @ Small=20 and Large=0 Minimum Small Latency=4.92 @ Small=3 and Large=0 [root@pro-pnh-310-db-tidb-mp-45 orion]# cat orion_20221118_1035_iops.csv Large/Small, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20 0, 49, 375, 609, 782, 942, 1073, 1199, 1317, 1419, 1525, 1609, 1696, 1781, 1850, 1916, 1983, 2057, 2109, 2165, 2214 測試下dss 結果： [root@pro-pnh-310-db-tidb-mp-45 orion]# cat orion_20221118_1300_summary.txt ORION VERSION 11.1.0.7.0 Commandline: -run dss -verbose This maps to this test: Test: orion Small IO size: 8 KB Large IO size: 1024 KB IO Types: Small Random IOs, Large Random IOs Simulated Array Type: CONCAT Write: 0% Cache Size: Not Entered Duration for each Data Point: 240 seconds Small Columns:, 0 Large Columns:, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15 Total Data Points: 16 Name: /dev/sda3 Size: 3579645526016 1 FILEs found. Maximum Large MBPS=396.02 @ Small=0 and Large=15 [root@pro-pnh-310-db-tidb-mp-45 orion]# cat orion_20221118_1300_mbps.csv Large/Small, 0 1, 146.48 2, 227.38 3, 281.95 4, 305.21 5, 322.75 6, 337.09 7, 348.53 8, 357.27 9, 364.86 10, 371.70 11, 378.25 12, 382.90 13, 388.28 14, 393.15 15, 396.02 iostat -xt 5 ,看到100%全部利用率 Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util sda 0.00 0.00 1225.20 3.20 313651.20 22.40 510.70 14.42 11.74 11.77 0.19 0.81 100.00 scd0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11/18/2022 01:14:52 PM avg-cpu: %user %nice %system %iowait %steal %idle 1.90 0.00 0.60 0.00 0.00 97.49 Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util sda 0.00 0.00 1210.80 3.80 309964.80 18.70 510.43 14.26 11.76 11.80 0.05 0.82 100.00 scd0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11/18/2022 01:14:57 PM avg-cpu: %user %nice %system %iowait %steal %idle 1.78 0.00 0.47 0.00 0.00 97.75 Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util sda 0.00 2.00 1214.00 8.40 310784.00 91.80 508.63 14.41 11.79 11.87 0.05 0.82 100.00 scd0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11/18/2022 01:15:02 PM avg-cpu: %user %nice %system %iowait %steal %idle 1.73 0.00 0.51 0.00 0.00 97.75 Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util sda 0.00 0.00 1236.00 4.80 316416.00 23.20 510.06 14.41 11.63 11.67 0.21 0.81 100.00 scd0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11/18/2022 01:15:07 PM avg-cpu: %user %nice %system %iowait %steal %idle 2.32 0.00 0.70 0.00 0.00 96.98
四、 場景 raid5 磁碟SEAGATE 12 Gbps 900G SAS 15000轉 ，6塊盤組成raid5
[root@localhost ~]# cat orion_20221118_1626_summary.txt ORION VERSION 11.1.0.7.0 Commandline: -run normal -verbose This maps to this test: Test: orion Small IO size: 8 KB Large IO size: 1024 KB IO Types: Small Random IOs, Large Random IOs Simulated Array Type: CONCAT Write: 0% Cache Size: Not Entered Duration for each Data Point: 60 seconds Small Columns:, 0, 1, 2, 3, 4, 5 Large Columns:, 0, 1, 2 Total Data Points: 18 Name: /dev/sda1 Size: 899526164480 1 FILEs found. Maximum Large MBPS=207.50 @ Small=0 and Large=2 Maximum Small IOPS=987 @ Small=5 and Large=0 Minimum Small Latency=4.00 @ Small=1 and Large=0 [root@pro-pnh-310-db-tidb-mp-45 ~]# cat orion_20221122_1038_summary.txt ORION VERSION 11.1.0.7.0 Commandline: -run dss -verbose This maps to this test: Test: orion Small IO size: 8 KB Large IO size: 1024 KB IO Types: Small Random IOs, Large Random IOs Simulated Array Type: CONCAT Write: 0% Cache Size: Not Entered Duration for each Data Point: 240 seconds Small Columns:, 0 Large Columns:, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15 Total Data Points: 16 Name: /dev/sda1 Size: 4497633968128 1 FILEs found. Maximum Large MBPS=260.26 @ Small=0 and Large=15 [root@pro-pnh-310-db-tidb-mp-45 ~]# cat orion_20221122_1013_summary.txt ORION VERSION 11.1.0.7.0 Commandline: -run oltp -verbose This maps to this test: Test: orion Small IO size: 8 KB Large IO size: 1024 KB IO Types: Small Random IOs, Large Random IOs Simulated Array Type: CONCAT Write: 0% Cache Size: Not Entered Duration for each Data Point: 60 seconds Small Columns:, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20 Large Columns:, 0 Total Data Points: 21 Name: /dev/sda1 Size: 4497633968128 1 FILEs found. Maximum Small IOPS=1750 @ Small=20 and Large=0 Minimum Small Latency=4.54 @ Small=1 and Large=0
五 場景 raid50 磁碟SEAGATE 12 Gbps 900G SAS 15000轉 ，6塊盤組成raid50
[root@pro-pnh-310-db-tidb-mp-45 ~]# cat orion_20221121_1542_summary.txt ORION VERSION 11.1.0.7.0 Commandline: -run oltp -verbose This maps to this test: Test: orion Small IO size: 8 KB Large IO size: 1024 KB IO Types: Small Random IOs, Large Random IOs Simulated Array Type: CONCAT Write: 0% Cache Size: Not Entered Duration for each Data Point: 60 seconds Small Columns:, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20 Large Columns:, 0 Total Data Points: 21 Name: /dev/sda1 Size: 719620931584 1 FILEs found. Maximum Small IOPS=2129 @ Small=20 and Large=0 Minimum Small Latency=4.20 @ Small=2 and Large=0 [root@pro-pnh-310-db-tidb-mp-45 ~]# cat orion_20221121_1429_summary.txt ORION VERSION 11.1.0.7.0 Commandline: -run dss -verbose This maps to this test: Test: orion Small IO size: 8 KB Large IO size: 1024 KB IO Types: Small Random IOs, Large Random IOs Simulated Array Type: CONCAT Write: 0% Cache Size: Not Entered Duration for each Data Point: 240 seconds Small Columns:, 0 Large Columns:, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15 Total Data Points: 16 Name: /dev/sda1 Size: 719620931584 1 FILEs found. Maximum Large MBPS=281.95 @ Small=0 and Large=15
六 總結
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/30393770/viewspace-2924034/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 資料庫壓力測試工具tiobench,orion,lmbench,netperf資料庫
- Orion - oracle提供的測試io效能的工具Oracle
- 【轉】Orion - oracle提供的測試io效能的工具Oracle
- Oracle ORION模擬Database負載測試儲存效能OracleDatabase負載
- [zt]磁碟 RAID10 / RAID5 配置下的IOPS對比AI
- RAID5和RAID10在磁碟讀寫選擇對比AI
- Oracle ORION IO 測試工具Oracle
- sysbench fileio 壓測磁碟raid 5 raid 1 raid10 raid 50 情況AI
- ORION可以模式Oracle資料庫的IO測試IOPS,MBPS模式Oracle資料庫
- Mysql效能壓測、Binlog恢復資料MySql
- 磁碟排序對Oracle資料庫效能的影響排序Oracle資料庫
- 磁碟陣列關於Raid0,Raid1,Raid5,Raid10陣列AI
- 磁碟排序對Oracle資料庫效能的影響PT排序Oracle資料庫
- mysqlslap 效能壓測MySql
- mysqlslap效能壓測MySql
- ORACLE ORION介紹Oracle
- RAID10與RAID5的異同比較AI
- Oracle資料壓縮Oracle
- 關於RAID10和RAID5的認識AI
- 效能壓測工具 —— wrk
- Oracle Orion Calibration ToolOracle
- 【伺服器資料恢復】raid5磁碟陣列磁碟出現故障離線的資料恢復案例伺服器資料恢復AI陣列
- 壓縮工具效能測試
- Oracle的壓測Oracle
- Raid5磁碟陣列資料恢復成功案例/伺服器資料恢復方案AI陣列資料恢復伺服器
- 伺服器資料恢復—xfs下Raid5磁碟陣列資料恢復案例伺服器資料恢復AI陣列
- 【工具】ORION I/O 測試工具
- Oracle資料庫效能Oracle資料庫
- oracle 資料庫磁碟組屬性Oracle資料庫
- oracle 資料庫磁碟組屬性Oracle資料庫
- 壓測和效能分析方法論
- 容量預估/效能壓測思考
- Jmeter效能測試 —— 壓力模式JMeter模式
- Taurus.MVC 效能壓力測試（ap 壓測 和 linux 下wrk 壓測）：.NET 版本MVCLinux
- ORACLE壓力測試Oracle
- raid5磁碟陣列2塊硬碟離線資料恢復過程AI陣列硬碟資料恢復
- 【GoldenGate】Oracle GoldenGate(四) 壓力測試同步百萬行資料GoOracle
- 【伺服器資料恢復】HP伺服器Raid5磁碟陣列資料恢復案例伺服器資料恢復AI陣列