FUJITSU-RX600 测试报告
日期 | 版本 | 说明 | 作者 | 审阅 |
2012年8月21日 | V1.0 | liuyang | ||
目录
Physical IO 性能测试 (很小的db_cache_size + 很小的cpu_count)
2.1.1 TEST1 16 writes 0 readers
2.1.2 TEST2 32 writes 0 readers
2.1.3 TEST 128 writers 0 readers
Logical IO 测试 (需求较大的db_cache_size 保证read,write在cache中进行 本次测试为24G sga_target)
2.2.1 TEST4 16 readers 16 writers
2.2.2TEST5 32 readers 32writers
2.2.3 TEST6 64 writers 64 readers
- 测试概述
本次测试使用SLOB以及SwingBench工具进行测试，CPU,IO性能采用collectl工具收集。主要目的为对比rx600与Dell815性能，主要测试场景分为SLOB的CPU 、IOPS以及SwingBench的TPS测试。另外在对比Dell815时需要注意与本次测试配置参数保持一致。
本次测试富士通rx600配置为24core Intel(R) Xeon(R) CPU E7- 4807 @ 1.87GHz,32GB内存
Ref:
http://kevinclosson.wordpress.com/2012/02/06/introducing-slob-the-silly-little-oracle-benchmark/
http://dominicgiles.com/swingbench.html
http://collectl.sourceforge.net/
- SLOB测试性性能报告
Physical IO 性能测试 (很小的db_cache_size + 很小的cpu_count)
[root@FUJITSU-RX600 ~]# dmidecode -s system-product-name
PRIMERGY RX600 S6
[root@FUJITSU-RX600 ~]# dmidecode -s processor-version
Intel(R) Xeon(R) CPU E7- 4807 @ 1.87GHz
Intel(R) Xeon(R) CPU E7- 4807 @ 1.87GHz
Not Specified
Not Specified
InitSLOB.ora
[oracle@FUJITSU-RX600 dbs]$ cat initSLOB.ora
db_create_file_dest = '/u01/oracle/oradata/SLOB'
control_files=('/u01/oracle/oradata/SLOB/cntlSLOB.dbf')
db_name = SLOB
compatible = 11.2.0.2
UNDO_MANAGEMENT=AUTO
db_block_size = 8192
db_files = 300
processes = 100
memory_max_target = 2G
sga_target=1G
#shared_pool_size = 500M
filesystemio_options=setall
*._db_block_prefetch_limit=0
*._db_block_prefetch_quota=0
*._db_file_noncontig_mblock_read_count=0
*.cpu_count=1
*.processes=1000
*.db_cache_size=12M
*.shared_pool_size=600M
2.1.1 TEST1 16 writes 0 readers
waiting for 1 second sample...
# CPU[HYPER] SUMMARY (INTR, CTXSW & PROC /sec)
#Date Time User Nice Sys Wait IRQ Soft Steal Idle CPUs Intr Ctxsw Proc RunQ Run Avg1 Avg5 Avg15 RunT BlkT
20120820 15:14:19 6 0 4 28 0 1 0 59 24 14K 46K 0 583 8 0.25 0.24 0.96 7 6
20120820 15:14:20 5 0 3 28 0 0 0 60 24 12K 41K 0 583 2 0.25 0.24 0.96 10 7
20120820 15:14:21 6 0 3 30 0 0 0 58 24 14K 47K 0 583 4 0.25 0.24 0.96 5 10
20120820 15:14:22 5 0 3 29 0 0 0 61 24 13K 45K 0 583 6 1.51 0.50 1.04 6 2
20120820 15:14:23 6 0 3 29 0 0 0 58 24 14K 44K 0 583 8 1.51 0.50 1.04 9 6
20120820 15:14:24 5 0 3 29 0 0 0 60 24 13K 43K 0 583 0 1.51 0.50 1.04 0 14
20120820 15:14:25 5 0 3 30 0 0 0 58 24 14K 42K 0 583 6 1.51 0.50 1.04 13 8
20120820 15:14:26 6 0 3 27 0 0 0 61 24 15K 47K 0 583 0 1.51 0.50 1.04 0 17
20120820 15:14:27 5 0 3 30 0 0 0 58 24 13K 42K 0 583 3 2.75 0.77 1.13 0 14
20120820 15:14:28 5 0 3 36 0 0 0 53 24 12K 39K 0 583 12 2.75 0.77 1.13 3 14
20120820 15:14:29 7 0 3 33 0 0 0 54 24 15K 53K 0 583 6 2.75 0.77 1.13 8 9
20120820 15:14:30 6 0 3 33 0 0 0 54 24 15K 51K 0 583 0 2.75 0.77 1.13 0 17
20120820 15:14:31 5 0 3 35 0 0 0 54 24 12K 41K 0 583 0 2.75 0.77 1.13 0 17
20120820 15:14:32 7 0 4 32 0 1 0 54 24 16K 55K 0 583 0 3.89 1.04 1.21 0 17
20120820 15:14:33 7 0 3 35 0 1 0 52 24 13K 47K 0 583 2 3.89 1.04 1.21 0 17
20120820 15:14:34 6 0 3 33 0 1 0 54 24 14K 49K 0 583 10 3.89 1.04 1.21 4 13
20120820 15:14:35 6 0 3 34 0 1 0 54 24 15K 49K 0 583 1 3.89 1.04 1.21 1 16
20120820 15:14:36 6 0 3 37 0 1 0 51 24 12K 42K 0 583 0 3.89 1.04 1.21 0 17
20120820 15:14:37 6 0 3 36 0 1 0 51 24 14K 45K 0 583 3 4.86 1.29 1.29 5 9
20120820 15:14:38 6 0 3 36 0 1 0 52 24 13K 47K 0 583 4 4.86 1.29 1.29 11 2
20120820 15:14:39 7 0 4 33 0 1 0 53 24 16K 54K 0 583 2 4.86 1.29 1.29 9 9
20120820 15:14:40 6 0 3 36 0 1 0 51 24 14K 47K 0 583 1 4.86 1.29 1.29 1 16
20120820 15:14:41 6 0 3 35 0 1 0 53 24 14K 45K 0 583 1 4.86 1.29 1.29 1 17
20120820 15:14:42 6 0 3 37 0 1 0 52 24 13K 42K 0 583 7 5.75 1.54 1.37 2 3
20120820 15:14:43 6 0 3 37 0 1 0 50 24 13K 43K 0 583 9 5.75 1.54 1.37 0 17
20120820 15:14:44 6 0 3 36 0 1 0 51 24 15K 47K 0 583 5 5.75 1.54 1.37 1 17
20120820 15:14:45 7 0 3 35 0 1 0 52 24 15K 49K 0 583 0 5.75 1.54 1.37 0 17
20120820 15:14:46 6 0 3 35 0 1 0 53 24 13K 48K 0 583 9 5.75 1.54 1.37 1 17
20120820 15:14:47 7 0 3 34 0 1 0 52 24 15K 51K 0 583 0 6.57 1.77 1.45 0 18
20120820 15:14:48 5 0 3 37 0 0 0 52 24 11K 38K 0 583 1 6.57 1.77 1.45 3 15
20120820 15:14:49 7 0 4 32 0 1 0 54 24 16K 59K 0 583 6 6.57 1.77 1.45 2 10
20120820 15:14:50 5 0 3 37 0 1 0 52 24 12K 42K 0 583 7 6.57 1.77 1.45 9 2
20120820 15:14:51 7 0 3 35 0 1 0 51 24 15K 53K 0 583 8 6.57 1.77 1.45 8 5
20120820 15:14:52 7 0 3 34 0 1 0 52 24 15K 53K 2 583 4 7.33 2.01 1.53 7 13
20120820 15:14:53 6 0 3 34 0 1 0 54 24 14K 48K 0 583 0 7.33 2.01 1.53 1 17
20120820 15:14:54 7 0 4 33 0 1 0 53 24 17K 57K 0 583 2 7.33 2.01 1.53 1 16
20120820 15:14:55 6 0 3 37 0 1 0 51 24 12K 44K 0 583 4 7.33 2.01 1.53 1 16
20120820 15:14:56 8 0 4 31 0 1 0 54 24 16K 56K 0 583 1 7.33 2.01 1.53 1 11
20120820 15:14:57 5 0 2 37 0 0 0 53 24 10K 37K 0 583 0 8.10 2.26 1.61 1 17
20120820 15:14:58 7 0 4 35 0 1 0 51 24 16K 55K 0 583 1 8.10 2.26 1.61 10 12
20120820 15:14:59 6 0 3 33 0 1 0 54 24 15K 52K 0 583 3 8.10 2.26 1.61 9 4
20120820 15:15:00 6 0 3 36 0 1 0 52 24 13K 47K 0 583 8 8.10 2.26 1.61 1 11
20120820 15:15:01 6 0 3 35 0 1 0 52 24 15K 51K 0 583 2 8.10 2.26 1.61 0 17
20120820 15:15:02 7 0 3 37 0 1 0 50 24 14K 50K 0 583 2 8.81 2.50 1.69 2 15
20120820 15:15:03 7 0 4 34 0 1 0 53 24 16K 54K 0 583 2 8.81 2.50 1.69 2 9
20120820 15:15:04 6 0 3 36 0 1 0 51 24 13K 46K 0 583 0 8.81 2.50 1.69 0 17
20120820 15:15:05 6 0 3 35 0 1 0 53 24 13K 47K 0 583 3 8.81 2.50 1.69 4 14
20120820 15:15:06 6 0 3 36 0 1 0 51 24 15K 50K 0 583 1 8.81 2.50 1.69 5 13
20120820 15:15:07 6 0 3 37 0 1 0 51 24 13K 48K 0 583 5 9.39 2.73 1.77 3 13
20120820 15:15:08 7 0 4 33 0 1 0 52 24 16K 59K 0 583 3 9.39 2.73 1.77 4 12
20120820 15:15:09 6 0 3 38 0 1 0 50 24 14K 49K 0 583 1 9.39 2.73 1.77 2 16
20120820 15:15:10 6 0 3 38 0 1 0 49 24 14K 46K 0 583 6 9.39 2.73 1.77 9 6
20120820 15:15:11 7 0 3 35 0 1 0 51 24 16K 54K 0 583 2 9.39 2.73 1.77 1 14
20120820 15:15:12 6 0 3 35 0 1 0 53 24 13K 46K 0 583 6 10.00 2.96 1.85 1 12
20120820 15:15:13 7 0 3 34 0 1 0 53 24 16K 53K 0 583 10 10.00 2.96 1.85 1 12
20120820 15:15:14 6 0 3 36 0 1 0 51 24 14K 50K 0 583 0 10.00 2.96 1.85 0 18
20120820 15:15:15 6 0 3 37 0 1 0 51 24 14K 46K 0 583 9 10.00 2.96 1.85 3 2
20120820 15:15:16 6 0 3 38 0 1 0 50 24 12K 44K 0 583 1 10.00 2.96 1.85 4 13
20120820 15:15:17 6 0 3 36 0 1 0 52 24 13K 45K 0 583 2 10.56 3.20 1.93 6 5
20120820 15:15:18 6 0 3 33 0 1 0 54 24 15K 52K 0 583 5 10.56 3.20 1.93 2 7
20120820 15:15:19 6 0 3 36 0 1 0 52 24 13K 46K 0 583 0 10.56 3.20 1.93 1 14
20120820 15:15:20 7 0 4 36 0 1 0 50 24 16K 54K 0 583 7 10.56 3.20 1.93 9 1
20120820 15:15:21 6 0 3 35 0 1 0 52 24 14K 51K 0 583 9 10.56 3.20 1.93 2 11
20120820 15:15:22 6 0 3 36 0 1 0 50 24 15K 55K 0 583 8 11.07 3.43 2.01 3 0
20120820 15:15:23 5 0 3 36 0 0 0 53 24 13K 46K 0 583 4 11.07 3.43 2.01 4 2
20120820 15:15:24 7 0 4 34 0 1 0 52 24 17K 57K 0 583 6 11.07 3.43 2.01 11 7
20120820 15:15:25 5 0 3 36 0 1 0 53 24 13K 48K 0 583 6 11.07 3.43 2.01 7 4
20120820 15:15:26 6 0 3 34 0 1 0 54 24 14K 49K 0 583 4 11.07 3.43 2.01 8 8
20120820 15:15:27 6 0 3 36 0 1 0 52 24 14K 48K 0 583 6 11.55 3.65 2.09 7 13
20120820 15:15:28 5 0 3 37 0 0 0 52 24 12K 45K 0 583 9 11.55 3.65 2.09 13 10
20120820 15:15:29 7 0 4 34 0 1 0 52 24 16K 57K 0 583 0 11.55 3.65 2.09 6 6
20120820 15:15:30 5 0 3 39 0 0 0 51 24 12K 44K 0 583 4 11.55 3.65 2.09 1 6
20120820 15:15:31 6 0 3 36 0 1 0 51 24 15K 50K 0 583 2 11.55 3.65 2.09 1 16
20120820 15:15:32 5 0 3 36 0 0 0 52 24 14K 47K 0 583 1 11.90 3.86 2.17 9 10
20120820 15:15:33 5 0 3 36 0 1 0 53 24 13K 47K 0 583 0 11.90 3.86 2.17 0 17
20120820 15:15:34 6 0 3 34 0 1 0 54 24 15K 51K 0 583 2 11.90 3.86 2.17 7 2
20120820 15:15:35 5 0 3 36 0 1 0 52 24 13K 45K 0 583 0 11.90 3.86 2.17 1 16
20120820 15:15:36 6 0 3 38 0 1 0 50 24 15K 48K 0 583 0 11.90 3.86 2.17 0 17
20120820 15:15:37 7 0 3 35 0 1 0 51 24 15K 50K 0 583 8 12.39 4.09 2.25 4 9
20120820 15:15:38 6 0 3 36 0 0 0 52 24 13K 47K 0 582 1 12.39 4.09 2.25 11 1
20120820 15:15:39 7 0 4 34 0 0 0 53 24 16K 54K 0 582 6 12.39 4.09 2.25 7 3
20120820 15:15:40 6 0 3 36 0 0 0 52 24 13K 46K 0 582 10 12.39 4.09 2.25 0 17
20120820 15:15:41 7 0 4 34 0 1 0 52 24 17K 59K 1 582 1 12.39 4.09 2.25 1 16
20120820 15:15:42 6 0 3 36 0 1 0 51 24 13K 45K 0 582 6 12.76 4.30 2.33 9 6
20120820 15:15:43 6 0 3 37 0 1 0 51 24 14K 47K 0 582 1 12.76 4.30 2.33 2 15
20120820 15:15:44 6 0 3 36 0 1 0 51 24 15K 51K 0 582 9 12.76 4.30 2.33 11 7
20120820 15:15:45 6 0 3 35 0 1 0 54 24 13K 47K 0 582 7 12.76 4.30 2.33 5 6
20120820 15:15:46 7 0 4 33 0 1 0 53 24 17K 59K 0 582 5 12.76 4.30 2.33 3 8
20120820 15:15:47 6 0 3 35 0 1 0 53 24 14K 50K 0 582 2 13.10 4.51 2.41 0 17
20120820 15:15:48 7 0 3 35 0 1 0 51 24 17K 57K 0 582 6 13.10 4.51 2.41 2 16
20120820 15:15:49 6 0 3 33 0 1 0 55 24 13K 48K 0 582 0 13.10 4.51 2.41 11 4
20120820 15:15:50 6 0 3 35 0 1 0 52 24 16K 52K 1 582 2 13.10 4.51 2.41 4 0
20120820 15:15:51 5 0 3 39 0 1 0 49 24 11K 42K 0 582 1 13.10 4.51 2.41 1 11
20120820 15:15:52 6 0 3 36 0 1 0 52 24 14K 48K 0 582 3 13.41 4.72 2.49 9 8
20120820 15:15:53 6 0 3 37 0 1 0 51 24 14K 48K 0 582 1 13.41 4.72 2.49 2 16
20120820 15:15:54 6 0 3 37 0 1 0 50 24 14K 51K 0 582 0 13.41 4.72 2.49 0 18
20120820 15:15:55 7 0 4 32 0 1 0 53 24 17K 57K 0 582 0 13.41 4.72 2.49 0 17
20120820 15:15:56 6 0 3 37 0 1 0 51 24 12K 43K 0 582 1 13.41 4.72 2.49 7 4
20120820 15:15:57 6 0 3 37 0 1 0 50 24 15K 47K 0 582 1 13.62 4.91 2.56 1 10
20120820 15:15:58 7 0 3 36 0 1 0 51 24 14K 49K 0 582 2 13.62 4.91 2.56 2 16
20120820 15:15:59 6 0 3 37 0 1 0 51 24 13K 44K 0 582 2 13.62 4.91 2.56 2 16
20120820 15:16:00 6 0 3 34 0 1 0 53 24 14K 49K 0 582 1 13.62 4.91 2.56 4 15
20120820 15:16:01 6 0 3 36 0 1 0 52 24 13K 46K 0 582 5 13.62 4.91 2.56 6 8
20120820 15:16:02 7 0 3 37 0 1 0 49 24 13K 43K 46 583 4 13.81 5.09 2.63 2 16
20120820 15:16:03 7 0 3 37 0 1 0 50 24 14K 48K 0 583 1 13.81 5.09 2.63 15 12
IOPS:
KBPS:
2.1.2 TEST2 32 writes 0 readers
waiting for 1 second sample...
# CPU[HYPER] SUMMARY (INTR, CTXSW & PROC /sec)
#Date Time User Nice Sys Wait IRQ Soft Steal Idle CPUs Intr Ctxsw Proc RunQ Run Avg1 Avg5 Avg15 RunT BlkT
20120820 15:43:19 10 0 5 35 0 0 0 46 24 16K 70K 0 618 3 0.21 0.14 0.65 6 16
20120820 15:43:20 8 0 4 34 0 1 0 50 24 18K 65K 0 618 2 0.21 0.14 0.65 13 8
20120820 15:43:21 7 0 3 40 0 1 0 47 24 16K 52K 0 618 18 0.21 0.14 0.65 1 33
20120820 15:43:22 6 0 3 40 0 0 0 47 24 16K 50K 0 618 2 2.76 0.67 0.81 13 11
20120820 15:43:23 7 0 4 34 0 1 0 51 24 18K 57K 0 618 10 2.76 0.67 0.81 12 14
20120820 15:43:24 7 0 3 35 0 1 0 51 24 16K 54K 0 618 5 2.76 0.67 0.81 5 25
20120820 15:43:25 8 0 4 33 0 1 0 51 24 18K 62K 0 618 5 2.76 0.67 0.81 4 4
20120820 15:43:26 8 0 3 36 0 1 0 49 24 16K 57K 0 618 4 2.76 0.67 0.81 2 33
20120820 15:43:27 9 0 4 34 0 1 0 50 24 21K 68K 0 618 2 5.10 1.19 0.98 8 6
20120820 15:43:28 6 0 3 55 0 1 0 33 24 13K 44K 0 618 5 5.10 1.19 0.98 4 9
20120820 15:43:29 8 0 4 48 0 1 0 36 24 18K 58K 0 618 5 5.10 1.19 0.98 2 30
20120820 15:43:30 8 0 3 55 0 1 0 30 24 15K 54K 0 618 3 5.10 1.19 0.98 3 21
20120820 15:43:31 7 0 4 49 0 1 0 36 24 16K 55K 0 618 2 5.10 1.19 0.98 3 1
20120820 15:43:32 8 0 4 51 0 1 0 34 24 16K 56K 0 618 3 7.33 1.72 1.15 4 2
# CPU[HYPER] SUMMARY (INTR, CTXSW & PROC /sec)
#Date Time User Nice Sys Wait IRQ Soft Steal Idle CPUs Intr Ctxsw Proc RunQ Run Avg1 Avg5 Avg15 RunT BlkT
20120820 15:43:33 7 0 3 51 0 1 0 35 24 15K 54K 0 618 6 7.33 1.72 1.15 11 5
20120820 15:43:34 8 0 4 51 0 1 0 34 24 18K 60K 0 618 9 7.33 1.72 1.15 5 20
20120820 15:43:35 7 0 3 54 0 1 0 32 24 14K 52K 0 618 2 7.33 1.72 1.15 2 1
20120820 15:43:36 8 0 4 53 0 1 0 31 24 16K 59K 0 618 9 7.33 1.72 1.15 11 11
20120820 15:43:37 7 0 4 56 0 1 0 30 24 15K 52K 0 618 9 9.39 2.24 1.33 8 9
20120820 15:43:38 8 0 4 49 0 1 0 35 24 18K 65K 2 618 7 9.39 2.24 1.33 3 1
20120820 15:43:39 7 0 3 53 0 1 0 32 24 16K 54K 0 618 1 9.39 2.24 1.33 2 33
20120820 15:43:40 7 0 3 53 0 1 0 33 24 16K 55K 0 618 6 9.39 2.24 1.33 4 26
20120820 15:43:41 7 0 3 51 0 1 0 35 24 15K 54K 0 618 1 9.39 2.24 1.33 1 33
20120820 15:43:42 8 0 4 51 0 1 0 34 24 16K 57K 0 618 10 11.36 2.77 1.50 10 9
20120820 15:43:43 9 0 4 50 0 1 0 34 24 18K 64K 0 618 3 11.36 2.77 1.50 3 6
20120820 15:43:44 7 0 3 54 0 1 0 32 24 14K 50K 0 618 3 11.36 2.77 1.50 6 17
20120820 15:43:45 8 0 4 47 0 1 0 37 24 17K 63K 0 618 2 11.36 2.77 1.50 4 29
20120820 15:43:46 7 0 3 56 0 1 0 31 24 15K 51K 0 618 10 11.36 2.77 1.50 5 3
20120820 15:43:47 8 0 4 49 0 1 0 35 24 17K 58K 0 618 3 13.09 3.27 1.67 6 7
20120820 15:43:48 6 0 3 55 0 0 0 32 24 12K 44K 0 618 2 13.09 3.27 1.67 2 32
20120820 15:43:49 7 0 4 45 0 1 0 41 24 17K 54K 0 618 3 13.09 3.27 1.67 2 32
20120820 15:43:50 7 0 4 52 0 1 0 33 24 16K 58K 0 618 3 13.09 3.27 1.67 4 30
20120820 15:43:51 8 0 4 49 0 1 0 36 24 16K 58K 0 618 5 13.09 3.27 1.67 3 6
20120820 15:43:52 7 0 3 55 0 1 0 31 24 15K 54K 0 618 11 14.69 3.76 1.84 9 15
20120820 15:43:53 7 0 3 54 0 1 0 33 24 15K 52K 0 618 17 14.69 3.76 1.84 8 11
20120820 15:43:54 7 0 3 54 0 1 0 32 24 15K 54K 0 618 3 14.69 3.76 1.84 3 23
# CPU[HYPER] SUMMARY (INTR, CTXSW & PROC /sec)
#Date Time User Nice Sys Wait IRQ Soft Steal Idle CPUs Intr Ctxsw Proc RunQ Run Avg1 Avg5 Avg15 RunT BlkT
20120820 15:43:55 7 0 4 53 0 1 0 33 24 17K 55K 0 618 4 14.69 3.76 1.84 10 27
20120820 15:43:56 7 0 3 52 0 1 0 35 24 14K 50K 0 618 2 14.69 3.76 1.84 1 34
20120820 15:43:57 8 0 3 52 0 1 0 34 24 15K 54K 0 618 4 16.07 4.23 2.00 7 9
20120820 15:43:58 8 0 4 51 0 1 0 34 24 16K 57K 0 618 1 16.07 4.23 2.00 1 33
20120820 15:43:59 7 0 3 53 0 1 0 34 24 14K 48K 0 618 3 16.07 4.23 2.00 3 32
20120820 15:44:00 8 0 4 47 0 1 0 37 24 19K 65K 0 618 17 16.07 4.23 2.00 13 13
20120820 15:44:01 7 0 4 52 0 1 0 34 24 16K 52K 0 618 6 16.07 4.23 2.00 5 20
20120820 15:44:02 8 0 4 48 0 1 0 36 24 17K 58K 0 618 21 17.35 4.69 2.16 2 32
20120820 15:44:03 7 0 4 54 0 0 0 32 24 14K 51K 0 618 6 17.35 4.69 2.16 3 26
20120820 15:44:04 8 0 4 54 0 1 0 32 24 17K 55K 0 618 3 17.35 4.69 2.16 10 27
20120820 15:44:05 9 0 4 55 0 1 0 29 24 16K 59K 0 618 1 17.35 4.69 2.16 1 33
20120820 15:44:06 8 0 4 50 0 1 0 35 24 16K 55K 0 618 10 17.35 4.69 2.16 2 30
20120820 15:44:07 8 0 3 55 0 1 0 31 24 14K 52K 0 618 5 18.60 5.16 2.33 16 9
20120820 15:44:08 8 0 4 53 0 1 0 32 24 16K 54K 0 618 9 18.60 5.16 2.33 11 10
20120820 15:44:09 7 0 3 56 0 1 0 31 24 13K 47K 0 618 9 18.60 5.16 2.33 12 12
20120820 15:44:10 8 0 4 50 0 1 0 34 24 17K 59K 0 618 10 18.60 5.16 2.33 3 8
20120820 15:44:11 8 0 3 52 0 1 0 33 24 15K 54K 0 618 1 18.60 5.16 2.33 4 32
20120820 15:44:12 8 0 4 50 0 1 0 33 24 18K 62K 0 618 2 19.75 5.62 2.49 2 33
20120820 15:44:13 7 0 4 53 0 1 0 32 24 16K 51K 0 618 1 19.75 5.62 2.49 1 33
20120820 15:44:14 8 0 4 49 0 1 0 35 24 17K 64K 0 618 5 19.75 5.62 2.49 9 7
20120820 15:44:15 8 0 4 52 0 1 0 32 24 16K 58K 0 618 5 19.75 5.62 2.49 5 12
20120820 15:44:16 7 0 4 56 0 1 0 30 24 15K 53K 0 618 2 19.75 5.62 2.49 10 5
IOPS:
KBPS:
2.1.3 TEST 128 writers 0 readers
# CPU[HYPER] SUMMARY (INTR, CTXSW & PROC /sec)
#Date Time User Nice Sys Wait IRQ Soft Steal Idle CPUs Intr Ctxsw Proc RunQ Run Avg1 Avg5 Avg15 RunT BlkT
20120820 16:37:34 7 0 4 35 0 1 0 51 24 12K 67K 0 816 14 50.66 40.37 26.81 2 1
20120820 16:37:35 9 0 6 22 0 1 0 59 24 17K 89K 0 816 5 50.66 40.37 26.81 11 0
20120820 16:37:36 8 0 5 29 0 1 0 53 24 15K 78K 0 816 9 50.66 40.37 26.81 10 2
20120820 16:37:37 9 0 6 38 0 1 0 43 24 18K 90K 0 816 10 56.54 41.76 27.33 14 4
20120820 16:37:38 7 0 5 27 0 1 0 57 24 13K 73K 0 816 3 56.54 41.76 27.33 3 0
20120820 16:37:39 10 0 6 38 0 1 0 43 24 17K 93K 0 816 3 56.54 41.76 27.33 2 0
20120820 16:37:40 9 0 6 32 0 1 0 50 24 16K 78K 0 816 2 56.54 41.76 27.33 2 0
20120820 16:37:41 9 0 6 33 0 1 0 49 24 15K 86K 0 816 10 56.54 41.76 27.33 35 19
20120820 16:37:42 8 0 4 49 0 1 0 35 24 15K 74K 0 816 6 62.26 43.19 27.87 26 3
20120820 16:37:43 11 0 6 34 0 1 0 45 24 20K 98K 0 816 18 62.26 43.19 27.87 8 122
20120820 16:37:44 9 0 5 45 0 1 0 37 24 15K 74K 0 816 20 62.26 43.19 27.87 12 5
20120820 16:37:45 8 0 5 28 0 1 0 55 24 15K 74K 0 816 12 62.26 43.19 27.87 13 8
20120820 16:37:46 8 0 5 38 0 1 0 46 24 14K 74K 0 816 11 62.26 43.19 27.87 6 16
20120820 16:37:47 9 0 5 37 0 1 0 45 24 17K 82K 0 816 2 60.48 43.14 27.94 3 1
20120820 16:37:48 8 0 6 36 0 1 0 46 24 16K 82K 0 816 3 60.48 43.14 27.94 2 89
20120820 16:37:49 8 0 5 31 0 1 0 51 24 14K 78K 0 816 6 60.48 43.14 27.94 10 26
20120820 16:37:50 10 0 6 32 0 1 0 49 24 17K 87K 0 816 2 60.48 43.14 27.94 8 29
20120820 16:37:51 8 0 5 30 0 1 0 53 24 15K 78K 0 816 2 60.48 43.14 27.94 3 0
20120820 16:37:52 9 0 5 39 0 1 0 43 24 16K 83K 0 816 7 56.99 42.70 27.88 11 76
20120820 16:37:53 9 0 5 35 0 1 0 47 24 17K 81K 0 816 13 56.99 42.70 27.88 11 1
20120820 16:37:54 10 0 6 32 0 1 0 49 24 16K 85K 0 816 9 56.99 42.70 27.88 5 11
20120820 16:37:55 8 0 6 31 0 1 0 52 24 14K 75K 0 816 15 56.99 42.70 27.88 12 9
# CPU[HYPER] SUMMARY (INTR, CTXSW & PROC /sec)
#Date Time User Nice Sys Wait IRQ Soft Steal Idle CPUs Intr Ctxsw Proc RunQ Run Avg1 Avg5 Avg15 RunT BlkT
20120820 16:37:56 8 0 6 25 0 1 0 57 24 15K 81K 0 816 8 56.99 42.70 27.88 16 51
20120820 16:37:57 9 0 5 44 0 1 0 38 24 16K 79K 0 816 3 61.72 43.92 28.35 10 13
20120820 16:37:58 9 0 6 28 0 1 0 54 24 16K 85K 0 816 2 61.72 43.92 28.35 2 107
20120820 16:37:59 8 0 5 39 0 1 0 44 24 15K 80K 0 816 2 61.72 43.92 28.35 3 0
20120820 16:38:00 10 0 6 28 0 1 0 52 24 18K 92K 0 816 1 61.72 43.92 28.35 1 2
20120820 16:38:01 8 0 5 35 0 1 0 49 24 13K 67K 2 817 21 61.72 43.92 28.35 1 1
20120820 16:38:02 9 0 6 37 0 1 0 45 24 15K 80K 0 816 2 67.19 45.35 28.90 4 1
20120820 16:38:03 7 0 5 28 0 1 0 56 24 14K 73K 0 816 2 67.19 45.35 28.90 1 1
20120820 16:38:04 8 0 5 36 0 1 0 47 24 17K 85K 0 816 2 67.19 45.35 28.90 11 28
20120820 16:38:05 9 0 6 37 0 1 0 45 24 17K 85K 0 816 7 67.19 45.35 28.90 18 1
20120820 16:38:06 9 0 6 35 0 1 0 46 24 17K 86K 0 816 8 67.19 45.35 28.90 9 43
20120820 16:38:07 7 0 4 41 0 1 0 44 24 13K 70K 0 816 16 71.66 46.64 29.40 6 8
20120820 16:38:08 9 0 6 29 0 1 0 52 24 18K 88K 0 816 17 71.66 46.64 29.40 9 26
20120820 16:38:09 8 0 5 37 0 1 0 47 24 14K 79K 0 816 3 71.66 46.64 29.40 2 78
20120820 16:38:10 8 0 5 38 0 1 0 45 24 15K 75K 0 816 9 71.66 46.64 29.40 12 1
20120820 16:38:11 8 0 6 22 0 1 0 60 24 15K 77K 0 816 2 71.66 46.64 29.40 13 1
20120820 16:38:12 6 0 4 48 0 1 0 39 24 12K 61K 0 816 5 75.77 47.91 29.91 8 1
20120820 16:38:13 10 0 6 35 0 1 0 45 24 20K 95K 0 816 9 75.77 47.91 29.91 16 5
20120820 16:38:14 8 0 5 41 0 1 0 42 24 14K 75K 0 816 2 75.77 47.91 29.91 2 123
20120820 16:38:15 9 0 6 24 0 1 0 58 24 17K 87K 0 816 2 75.77 47.91 29.91 4 0
20120820 16:38:16 9 0 6 33 0 1 0 49 24 16K 82K 0 816 9 75.77 47.91 29.91 10 10
20120820 16:38:17 9 0 6 41 0 1 0 41 24 17K 91K 0 816 3 69.86 47.14 29.76 6 69
IOPS:
KBPS:
结论： 在writer达到128时 IO成为瓶颈 CPU已经开始等待IO队列，此时的IOPS较为稳定。
Logical IO 测试 (需求较大的db_cache_size 保证read,write在cache中进行 本次测试为24G sga_target)
initSLOB.ora
[oracle@FUJITSU-RX600 dbs]$ cat initSLOB.ora
SLOB.__db_cache_size=23689428992
SLOB.__java_pool_size=67108864
SLOB.__large_pool_size=67108864
SLOB.__oracle_base='/u01/oracle'#ORACLE_BASE set from environment
SLOB.__pga_aggregate_target=5167382528
SLOB.__sga_target=25769803776
SLOB.__shared_io_pool_size=0
SLOB.__shared_pool_size=1811939328
SLOB.__streams_pool_size=0
*._db_block_prefetch_limit=0
*._db_block_prefetch_quota=0
*._db_file_noncontig_mblock_read_count=0
*.compatible='11.2.0.2'
*.control_files='/u01/oracle/oradata/SLOB/cntlSLOB.dbf'
*.cpu_count=24
*.db_block_size=8192
*.db_cache_size=17179869184
*.db_create_file_dest='/u01/oracle/oradata/SLOB'
*.db_files=300
*.db_name='SLOB'
*.filesystemio_options='setall'
*.processes=1000
*.sga_max_size=25769803776
*.sga_target=25769803776
*.shared_pool_size=600M
*.UNDO_MANAGEMENT='AUTO'
2.2.1 TEST4 16 readers 16 writers
waiting for 1 second sample...
# CPU[HYPER] SUMMARY (INTR, CTXSW & PROC /sec)
#Date Time User Nice Sys Wait IRQ Soft Steal Idle CPUs Intr Ctxsw Proc RunQ Run Avg1 Avg5 Avg15 RunT BlkT
20120820 17:19:42 5 0 3 9 0 0 0 81 24 6836 24K 0 636 8 0.42 2.78 15.23 5 3
20120820 17:19:43 5 0 6 14 0 0 0 71 24 14K 54K 0 636 4 0.42 2.78 15.23 6 3
20120820 17:19:44 6 0 6 12 0 0 0 73 24 13K 54K 0 636 4 0.42 2.78 15.23 4 1
20120820 17:19:45 6 0 6 11 0 0 0 75 24 12K 49K 0 636 2 0.42 2.78 15.23 1 1
20120820 17:19:46 5 0 5 14 0 0 0 73 24 10K 45K 0 636 5 0.42 2.78 15.23 7 2
20120820 17:19:47 6 0 5 12 0 0 0 74 24 10K 45K 0 636 4 2.95 3.27 15.32 7 0
20120820 17:19:48 6 0 5 17 0 0 0 69 24 9889 42K 0 636 8 2.95 3.27 15.32 4 1
20120820 17:19:49 7 0 5 27 0 0 0 58 24 9174 40K 1 636 4 2.95 3.27 15.32 4 2
20120820 17:19:50 7 0 5 27 0 0 0 59 24 8367 35K 0 636 1 2.95 3.27 15.32 1 32
20120820 17:19:51 7 0 4 35 0 0 0 51 24 7841 32K 0 636 4 2.95 3.27 15.32 4 1
20120820 17:19:52 8 0 4 46 0 0 0 39 24 7005 27K 0 636 1 5.27 3.75 15.41 4 3
20120820 17:19:53 14 0 4 51 0 0 0 30 24 6329 22K 0 636 19 5.27 3.75 15.41 2 31
20120820 17:19:54 52 0 2 34 0 0 0 9 24 4146 9454 2 636 19 5.27 3.75 15.41 18 15
20120820 17:19:55 73 0 2 19 0 0 0 3 24 3438 5134 0 636 22 5.27 3.75 15.41 21 12
20120820 17:19:56 76 0 2 15 0 0 0 4 24 3871 4463 1 637 19 5.27 3.75 15.41 19 15
20120820 17:19:57 76 0 3 7 0 0 0 11 24 3450 4088 28 638 20 7.49 4.23 15.50 27 8
20120820 17:19:58 76 0 3 6 0 0 0 13 24 3390 3663 0 634 14 7.49 4.23 15.50 14 4
20120820 17:19:59 52 0 4 12 0 0 0 29 24 3806 4293 0 616 19 7.49 4.23 15.50 5 4
20120820 17:20:00 19 0 4 15 0 0 0 60 24 3434 4180 0 606 0 7.49 4.23 15.50 1 7
20120820 17:20:01 14 0 3 11 0 0 0 70 24 3319 3696 0 606 13 7.49 4.23 15.50 14 3
20120820 17:20:02 18 0 3 10 0 0 0 66 24 4106 4136 1 606 0 7.45 4.28 15.46 14 3
20120820 17:20:03 17 0 3 4 0 0 0 73 24 3727 3712 0 606 2 7.45 4.28 15.46 18 0
# CPU[HYPER] SUMMARY (INTR, CTXSW & PROC /sec)
#Date Time User Nice Sys Wait IRQ Soft Steal Idle CPUs Intr Ctxsw Proc RunQ Run Avg1 Avg5 Avg15 RunT BlkT
20120820 17:20:04 16 0 3 4 0 0 0 74 24 3274 3299 0 606 0 7.45 4.28 15.46 0 1
20120820 17:20:05 21 0 4 5 0 0 0 68 24 4848 4203 0 606 1 7.45 4.28 15.46 2 1
20120820 17:20:06 14 0 2 4 0 0 0 77 24 3133 3250 0 606 0 7.45 4.28 15.46 0 1
20120820 17:20:07 15 0 3 4 0 0 0 76 24 3630 3125 0 606 0 6.86 4.21 15.37 0 1
20120820 17:20:08 19 0 4 3 0 0 0 72 24 4779 4115 0 606 1 6.86 4.21 15.37 16 1
20120820 17:20:09 16 0 3 3 0 0 0 75 24 3831 3475 0 606 16 6.86 4.21 15.37 17 0
20120820 17:20:10 19 0 4 3 0 0 0 73 24 4384 3475 0 606 1 6.86 4.21 15.37 4 0
20120820 17:20:11 21 0 4 3 0 0 0 70 24 4535 4461 45 607 1 6.86 4.21 15.37 1 1
20120820 17:20:12 15 0 3 3 0 0 0 77 24 3253 3352 0 607 18 6.63 4.20 15.31 1 1
20120820 17:20:13 18 0 3 3 0 0 0 73 24 4079 3668 0 607 1 6.63 4.20 15.31 1 2
20120820 17:20:14 19 0 4 3 0 0 0 72 24 4407 3667 0 607 1 6.63 4.20 15.31 1 1
20120820 17:20:15 19 0 4 2 0 0 0 72 24 4554 3754 0 607 17 6.63 4.20 15.31 18 0
20120820 17:20:16 12 0 4 4 0 0 0 77 24 8221 17K 0 607 3 6.63 4.20 15.31 3 2
20120820 17:20:17 16 0 5 5 0 1 0 71 24 12K 20K 0 607 4 6.34 4.18 15.25 19 3
20120820 17:20:18 11 0 4 6 0 0 0 76 24 8819 18K 0 607 20 6.34 4.18 15.25 19 4
20120820 17:20:19 13 0 4 6 0 1 0 74 24 9329 20K 0 607 4 6.34 4.18 15.25 19 2
20120820 17:20:20 12 0 4 5 0 1 0 75 24 11K 20K 0 607 2 6.34 4.18 15.25 2 3
20120820 17:20:21 10 0 4 5 0 1 0 77 24 10K 22K 0 607 1 6.34 4.18 15.25 1 3
20120820 17:20:22 11 0 3 6 0 1 0 76 24 10K 17K 0 607 4 6.07 4.16 15.18 5 0
20120820 17:20:23 12 0 3 6 0 1 0 75 24 9776 18K 0 607 5 6.07 4.16 15.18 2 2
20120820 17:20:24 13 0 4 5 0 1 0 75 24 9453 19K 0 605 1 6.07 4.16 15.18 2 2
20120820 17:20:25 12 0 3 6 0 1 0 75 24 11K 19K 0 605 1 6.07 4.16 15.18 1 3
IOPS:
KBPS:
2.2.2TEST5 32 readers 32writers
waiting for 1 second sample...
# CPU[HYPER] SUMMARY (INTR, CTXSW & PROC /sec)
#Date Time User Nice Sys Wait IRQ Soft Steal Idle CPUs Intr Ctxsw Proc RunQ Run Avg1 Avg5 Avg15 RunT BlkT
20120820 17:56:02 71 0 26 0 0 0 0 1 24 4346 11K 1 709 45 5.78 1.47 2.12 44 2
20120820 17:56:03 91 0 7 0 0 0 0 0 24 9365 30K 1 709 40 5.78 1.47 2.12 39 10
20120820 17:56:04 93 0 6 0 0 0 0 0 24 8871 27K 1 710 41 5.78 1.47 2.12 43 5
20120820 17:56:05 92 0 6 0 0 0 0 0 24 8325 27K 2 707 35 5.78 1.47 2.12 38 4
20120820 17:56:06 92 0 6 0 0 0 0 0 24 8516 27K 0 707 35 5.78 1.47 2.12 38 6
20120820 17:56:07 93 0 5 0 0 0 0 0 24 7640 26K 0 707 35 10.52 2.53 2.46 34 5
20120820 17:56:08 93 0 5 0 0 0 0 0 24 7510 24K 0 707 39 10.52 2.53 2.46 43 6
20120820 17:56:09 93 0 6 0 0 0 0 0 24 7017 22K 2 696 28 10.52 2.53 2.46 28 32
20120820 17:56:10 89 0 6 2 0 0 0 1 24 6994 21K 0 683 39 10.52 2.53 2.46 21 32
20120820 17:56:11 52 0 7 22 0 0 0 16 24 7925 28K 0 649 4 10.52 2.53 2.46 5 32
20120820 17:56:12 10 0 5 38 0 0 0 45 24 8130 33K 0 643 4 12.32 3.03 2.62 6 6
20120820 17:56:13 7 0 5 42 0 0 0 45 24 7063 28K 0 643 4 12.32 3.03 2.62 2 32
20120820 17:56:14 6 0 4 50 0 0 0 38 24 5606 21K 0 643 6 12.32 3.03 2.62 18 7
20120820 17:56:15 7 0 4 50 0 0 0 37 24 5926 22K 0 643 9 12.32 3.03 2.62 8 21
20120820 17:56:16 9 0 4 58 0 0 0 26 24 5312 19K 0 643 24 12.32 3.03 2.62 1 32
# CPU[HYPER] SUMMARY (INTR, CTXSW & PROC /sec)
#Date Time User Nice Sys Wait IRQ Soft Steal Idle CPUs Intr Ctxsw Proc RunQ Run Avg1 Avg5 Avg15 RunT BlkT
20120820 17:56:17 9 0 4 61 0 0 0 24 24 5291 19K 0 643 1 13.89 3.51 2.78 1 33
20120820 17:56:18 11 0 3 64 0 0 0 20 24 4863 15K 0 643 13 13.89 3.51 2.78 15 3
20120820 17:56:19 12 0 3 63 0 0 0 20 24 4377 11K 0 643 11 13.89 3.51 2.78 3 31
20120820 17:56:20 13 0 3 49 0 0 0 33 24 4212 10K 0 643 2 13.89 3.51 2.78 15 10
20120820 17:56:21 14 0 4 40 0 0 0 40 24 3565 8265 0 643 2 13.89 3.51 2.78 2 0
20120820 17:56:22 16 0 5 37 0 0 0 40 24 3889 7119 0 643 13 15.42 4.00 2.94 26 2
20120820 17:56:23 18 0 4 36 0 0 0 40 24 3497 6701 0 643 1 15.42 4.00 2.94 1 5
20120820 17:56:24 17 0 4 30 0 0 0 47 24 3127 5515 0 643 1 15.42 4.00 2.94 1 8
20120820 17:56:25 21 0 5 27 0 0 0 44 24 3791 5894 0 643 1 15.42 4.00 2.94 13 21
20120820 17:56:26 17 0 4 22 0 0 0 53 24 3104 5049 0 643 2 15.42 4.00 2.94 2 6
20120820 17:56:27 20 0 5 19 0 0 0 53 24 3346 5345 0 643 3 16.83 4.48 3.10 1 12
20120820 17:56:28 22 0 6 17 0 0 0 52 24 4024 5456 0 643 1 16.83 4.48 3.10 1 1
20120820 17:56:29 20 0 5 11 0 0 0 62 24 3199 4806 0 643 1 16.83 4.48 3.10 26 8
20120820 17:56:30 22 0 6 8 0 0 0 62 24 3369 4680 0 643 1 16.83 4.48 3.10 29 6
20120820 17:56:31 22 0 5 8 0 0 0 62 24 3635 5050 0 643 1 16.83 4.48 3.10 2 2
20120820 17:56:32 21 0 5 6 0 0 0 66 24 3453 4404 0 643 1 17.89 4.91 3.25 2 3
20120820 17:56:33 22 0 6 6 0 0 0 64 24 3512 5087 0 643 1 17.89 4.91 3.25 1 3
20120820 17:56:34 21 0 5 5 0 0 0 67 24 3643 4805 0 643 1 17.89 4.91 3.25 27 7
20120820 17:56:35 23 0 6 5 0 0 0 65 24 3331 4452 0 643 2 17.89 4.91 3.25 4 1
20120820 17:56:36 22 0 7 5 0 0 0 64 24 3865 4667 0 643 1 17.89 4.91 3.25 1 2
20120820 17:56:37 20 0 5 4 0 0 0 68 24 3544 4506 0 643 29 16.53 4.84 3.23 1 1
20120820 17:56:38 21 0 7 4 0 0 0 66 24 6249 6831 0 643 20 16.53 4.84 3.23 31 0
# CPU[HYPER] SUMMARY (INTR, CTXSW & PROC /sec)
#Date Time User Nice Sys Wait IRQ Soft Steal Idle CPUs Intr Ctxsw Proc RunQ Run Avg1 Avg5 Avg15 RunT BlkT
20120820 17:56:39 16 0 6 6 0 1 0 69 24 10K 22K 0 643 2 16.53 4.84 3.23 3 3
20120820 17:56:40 12 0 5 5 0 1 0 75 24 11K 23K 0 643 1 16.53 4.84 3.23 1 2
20120820 17:56:41 14 0 5 6 0 1 0 71 24 9806 21K 0 643 4 16.53 4.84 3.23 6 1
20120820 17:56:42 13 0 5 5 0 1 0 74 24 10K 23K 0 643 36 15.45 4.81 3.23 1 3
20120820 17:56:43 16 0 6 6 0 1 0 69 24 10K 19K 0 643 1 15.45 4.81 3.23 2 3
20120820 17:56:44 14 0 6 6 0 1 0 71 24 10K 20K 4 645 2 15.45 4.81 3.23 2 5
20120820 17:56:45 14 0 6 5 0 1 0 72 24 9934 19K 3 643 1 15.45 4.81 3.23 1 3
20120820 17:56:46 13 0 6 5 0 1 0 73 24 9751 21K 0 643 1 15.45 4.81 3.23 1 2
20120820 17:56:47 14 0 7 5 0 1 0 71 24 10K 21K 0 643 6 14.45 4.78 3.23 4 1
20120820 17:56:48 12 0 5 6 0 1 0 73 24 10K 21K 0 643 1 14.45 4.78 3.23 1 3
20120820 17:56:49 14 0 5 5 0 1 0 73 24 12K 20K 0 643 2 14.45 4.78 3.23 2 3
20120820 17:56:50 13 0 5 5 0 1 0 74 24 11K 22K 0 643 4 14.45 4.78 3.23 3 3
20120820 17:56:51 12 0 5 5 0 1 0 74 24 8774 18K 0 643 2 14.45 4.78 3.23 6 0
20120820 17:56:52 15 0 5 5 0 1 0 72 24 9168 20K 0 643 8 13.53 4.75 3.23 22 0
20120820 17:56:53 13 0 5 5 0 1 0 73 24 11K 21K 0 643 2 13.53 4.75 3.23 3 2
20120820 17:56:54 13 0 4 5 0 1 0 75 24 12K 21K 0 643 1 13.53 4.75 3.23 1 2
20120820 17:56:55 12 0 5 5 0 1 0 75 24 10K 17K 0 643 1 13.53 4.75 3.23 1 2
20120820 17:56:56 12 0 5 6 0 1 0 74 24 9096 21K 0 643 3 13.53 4.75 3.23 2 2
20120820 17:56:57 5 0 2 3 0 1 0 86 24 18K 21K 0 643 4 12.77 4.74 3.23 4 2
20120820 17:56:58 5 0 2 4 0 1 0 85 24 13K 14K 0 643 3 12.77 4.74 3.23 4 1
20120820 17:56:59 8 0 2 1 0 1 0 86 24 17K 14K 0 643 4 12.77 4.74 3.23 4 0
20120820 17:57:00 17 0 4 3 0 0 0 73 24 6233 6973 7 643 1 12.77 4.74 3.23 1 2
IOPS:
KBPS:
2.2.3 TEST6 64 writers 64 readers
waiting for 1 second sample...
# CPU[HYPER] SUMMARY (INTR, CTXSW & PROC /sec)
#Date Time User Nice Sys Wait IRQ Soft Steal Idle CPUs Intr Ctxsw Proc RunQ Run Avg1 Avg5 Avg15 RunT BlkT
20120820 23:00:42 92 0 3 0 0 0 0 3 24 2466 3571 0 767 46 8.58 1.83 0.59 54 0
20120820 23:00:42 92 0 3 0 0 0 0 3 24 2468 3554 0 767 46 8.58 1.83 0.59 54 0
20120820 23:00:43 92 0 3 0 0 0 0 3 24 2449 3406 5 770 45 8.58 1.83 0.59 51 0
20120820 23:00:43 92 0 3 0 0 0 0 3 24 2498 3412 4 770 33 8.58 1.83 0.59 36 1
20120820 23:00:44 93 0 2 0 0 0 0 3 24 2145 3317 2 770 53 8.58 1.83 0.59 53 1
20120820 23:00:44 93 0 2 0 0 0 0 3 24 2173 3339 1 770 36 8.58 1.83 0.59 40 1
20120820 23:00:45 91 0 4 0 0 0 0 3 24 3091 3716 0 767 66 8.58 1.83 0.59 83 1
20120820 23:00:45 91 0 4 0 0 0 0 3 24 3009 3741 0 767 52 8.58 1.83 0.59 52 0
20120820 23:00:46 91 0 5 0 0 0 0 2 24 3431 4209 0 767 36 8.58 1.83 0.59 38 1
20120820 23:00:46 91 0 5 0 0 0 0 2 24 3489 4214 0 767 35 8.58 1.83 0.59 36 1
20120820 23:00:47 92 0 2 0 0 0 0 4 24 2187 3427 0 767 33 11.10 2.47 0.80 34 1
20120820 23:00:47 92 0 2 0 0 0 0 4 24 2193 3430 0 767 43 11.10 2.47 0.80 50 1
20120820 23:00:48 92 0 3 0 0 0 0 3 24 2948 4030 0 767 41 11.10 2.47 0.80 43 0
20120820 23:00:48 92 0 3 0 0 0 0 3 24 2995 4068 0 767 40 11.10 2.47 0.80 43 0
20120820 23:00:49 92 0 3 0 0 0 0 3 24 2681 3368 0 767 38 11.10 2.47 0.80 38 1
20120820 23:00:49 92 0 3 0 0 0 0 3 24 2674 3368 0 767 48 11.10 2.47 0.80 36 1
20120820 23:00:50 92 0 3 0 0 0 0 3 24 2498 3598 4 770 31 11.10 2.47 0.80 31 1
20120820 23:00:50 92 0 3 0 0 0 0 3 24 2486 3584 4 770 29 11.10 2.47 0.80 29 1
20120820 23:00:51 93 0 3 0 0 0 0 3 24 2595 3721 2 767 48 11.10 2.47 0.80 48 0
20120820 23:00:51 93 0 3 0 0 0 0 3 24 2592 3729 2 767 46 11.10 2.47 0.80 48 0
20120820 23:00:52 93 0 3 0 0 0 0 2 24 2697 3383 4 770 43 16.61 3.75 1.23 44 2
20120820 23:00:52 92 0 3 0 0 0 0 3 24 2651 3391 4 770 30 16.61 3.75 1.23 29 2
20120820 23:00:53 92 0 3 0 0 0 0 3 24 2636 3854 2 767 56 16.61 3.75 1.23 57 1
20120820 23:00:53 92 0 3 0 0 0 0 3 24 2657 3851 2 767 44 16.61 3.75 1.23 45 1
# CPU[HYPER] SUMMARY (INTR, CTXSW & PROC /sec)
#Date Time User Nice Sys Wait IRQ Soft Steal Idle CPUs Intr Ctxsw Proc RunQ Run Avg1 Avg5 Avg15 RunT BlkT
20120820 23:00:54 92 0 3 0 0 0 0 3 24 2699 3933 4 770 72 16.61 3.75 1.23 67 0
20120820 23:00:54 92 0 3 0 0 0 0 3 24 2664 3968 4 770 52 16.61 3.75 1.23 52 0
20120820 23:00:55 93 0 3 0 0 0 0 2 24 2881 3835 2 759 49 16.61 3.75 1.23 51 1
20120820 23:00:55 93 0 3 0 0 0 0 2 24 2882 3790 2 759 40 16.61 3.75 1.23 40 1
20120820 23:00:56 92 0 4 0 0 0 0 2 24 2984 3776 2 742 118 16.61 3.75 1.23 63 1
20120820 23:00:56 92 0 4 0 0 0 0 2 24 2961 3807 1 741 65 16.61 3.75 1.23 69 1
20120820 23:00:57 69 0 11 0 0 0 0 17 24 3527 6775 5 643 3 21.37 4.95 1.63 3 1
20120820 23:00:57 68 0 11 0 0 0 0 18 24 3555 6836 5 643 2 21.37 4.95 1.63 3 1
20120820 23:00:58 23 0 4 2 0 0 0 69 24 3524 6442 0 639 1 21.37 4.95 1.63 1 1
20120820 23:00:58 23 0 4 2 0 0 0 69 24 3524 6442 0 639 1 21.37 4.95 1.63 1 1
20120820 23:00:59 23 0 6 2 0 0 0 67 24 3448 7027 7 639 66 21.37 4.95 1.63 1 1
20120820 23:00:59 23 0 6 2 0 0 0 67 24 3448 7027 7 639 3 21.37 4.95 1.63 1 1
20120820 23:01:00 22 0 5 2 0 0 0 68 24 3553 6971 7 639 1 21.37 4.95 1.63 1 1
20120820 23:01:00 22 0 5 2 0 0 0 68 24 3553 6971 7 639 1 21.37 4.95 1.63 1 1
20120820 23:01:01 27 0 5 2 0 0 0 64 24 3273 7459 0 639 1 21.37 4.95 1.63 1 1
20120820 23:01:01 27 0 5 2 0 0 0 64 24 3273 7459 0 639 1 21.37 4.95 1.63 1 1
20120820 23:01:02 21 0 4 3 0 0 0 71 24 3286 6025 5 639 2 19.66 4.87 1.62 1 1
20120820 23:01:02 21 0 4 3 0 0 0 71 24 3286 6025 5 639 2 19.66 4.87 1.62 1 1
20120820 23:01:03 25 0 4 2 0 0 0 67 24 3680 7295 0 639 3 19.66 4.87 1.62 4 0
20120820 23:01:03 25 0 4 2 0 0 0 67 24 3680 7299 0 639 2 19.66 4.87 1.62 4 0
# CPU[HYPER] SUMMARY (INTR, CTXSW & PROC /sec)
20120820 23:01:04 23 0 4 2 0 0 0 69 24 3529 7477 0 639 1 19.66 4.87 1.62 1 1
#Date Time User Nice Sys Wait IRQ Soft Steal Idle CPUs Intr Ctxsw Proc RunQ Run Avg1 Avg5 Avg15 RunT BlkT
20120820 23:01:04 23 0 4 2 0 0 0 69 24 3532 7481 0 639 1 19.66 4.87 1.62 1 1
20120820 23:01:05 21 0 4 2 0 0 0 70 24 3528 6410 0 639 2 19.66 4.87 1.62 1 1
20120820 23:01:05 21 0 4 2 0 0 0 70 24 3532 6416 0 639 2 19.66 4.87 1.62 1 1
20120820 23:01:06 24 0 4 2 0 0 0 68 24 3766 6746 0 639 2 19.66 4.87 1.62 3 1
20120820 23:01:06 24 0 4 2 0 0 0 68 24 3766 6747 0 639 1 19.66 4.87 1.62 2 1
20120820 23:01:07 23 0 3 2 0 0 0 69 24 3199 6721 0 639 3 18.08 4.79 1.61 65 0
20120820 23:01:07 23 0 3 2 0 0 0 69 24 3202 6727 0 639 3 18.08 4.79 1.61 65 0
20120820 23:01:08 24 0 4 2 0 0 0 67 24 3456 7034 0 639 2 18.08 4.79 1.61 1 1
20120820 23:01:08 24 0 4 2 0 0 0 67 24 3459 7041 0 639 2 18.08 4.79 1.61 1 1
20120820 23:01:09 22 0 3 2 0 0 0 70 24 5920 6655 0 639 3 18.08 4.79 1.61 4 1
20120820 23:01:09 22 0 3 2 0 0 0 70 24 5920 6655 0 639 2 18.08 4.79 1.61 4 1
20120820 23:01:10 16 0 3 3 0 0 0 75 24 9044 12K 0 639 4 18.08 4.79 1.61 6 0
20120820 23:01:10 16 0 3 3 0 0 0 75 24 9044 12K 0 639 3 18.08 4.79 1.61 6 0
20120820 23:01:11 14 0 3 6 0 1 0 75 24 10K 19K 0 639 2 18.08 4.79 1.61 8 1
20120820 23:01:11 14 0 3 6 0 1 0 75 24 10K 19K 0 639 2 18.08 4.79 1.61 8 1
20120820 23:01:12 16 0 3 4 0 1 0 74 24 12K 23K 2 639 3 16.88 4.76 1.62 4 2
20120820 23:01:12 16 0 3 4 0 1 0 74 24 12K 23K 2 639 3 16.88 4.76 1.62 4 2
20120820 23:01:13 12 0 2 5 0 1 0 78 24 10K 20K 0 639 4 16.88 4.76 1.62 1 3
20120820 23:01:13 12 0 2 5 0 1 0 78 24 10K 20K 0 639 4 16.88 4.76 1.62 1 3
20120820 23:01:14 14 0 3 5 0 1 0 76 24 10K 21K 0 639 3 16.88 4.76 1.62 4 2
20120820 23:01:14 14 0 3 5 0 1 0 76 24 10K 21K 0 639 3 16.88 4.76 1.62 4 2
20120820 23:01:15 14 0 3 5 0 1 0 75 24 12K 22K 0 639 1 16.88 4.76 1.62 1 3
20120820 23:01:15 14 0 3 5 0 1 0 75 24 12K 22K 0 639 1 16.88 4.76 1.62 1 3
# CPU[HYPER] SUMMARY (INTR, CTXSW & PROC /sec)
#Date Time User Nice Sys Wait IRQ Soft Steal Idle CPUs Intr Ctxsw Proc RunQ Run Avg1 Avg5 Avg15 RunT BlkT
20120820 23:01:16 15 0 3 4 0 1 0 74 24 11K 23K 0 639 2 16.88 4.76 1.62 2 3
20120820 23:01:16 15 0 3 4 0 1 0 74 24 11K 23K 0 639 2 16.88 4.76 1.62 2 3
20120820 23:01:17 14 0 3 5 0 1 0 75 24 10K 21K 0 639 4 15.84 4.75 1.63 4 2
20120820 23:01:17 14 0 3 5 0 1 0 75 24 10K 21K 0 639 4 15.84 4.75 1.63 4 2
20120820 23:01:18 14 0 3 5 0 1 0 74 24 9105 18K 0 639 7 15.84 4.75 1.63 33 1
20120820 23:01:18 15 0 3 5 0 1 0 73 24 9082 18K 0 639 6 15.84 4.75 1.63 7 1
20120820 23:01:19 14 0 3 5 0 1 0 74 24 10K 22K 0 639 3 15.84 4.75 1.63 4 2
20120820 23:01:19 15 0 3 5 0 1 0 73 24 10K 22K 0 639 2 15.84 4.75 1.63 3 2
20120820 23:01:20 13 0 3 5 0 1 0 76 24 8125 22K 0 639 4 15.84 4.75 1.63 2 2
20120820 23:01:20 13 0 3 5 0 1 0 76 24 8125 22K 0 639 4 15.84 4.75 1.63 2 2
20120820 23:01:21 15 0 4 4 0 1 0 73 24 9959 23K 0 639 5 15.84 4.75 1.63 3 2
20120820 23:01:21 15 0 4 4 0 1 0 73 24 9959 23K 0 639 7 15.84 4.75 1.63 3 2
20120820 23:01:22 14 0 3 5 0 1 0 74 24 8916 19K 0 639 3 14.82 4.72 1.64 4 1
20120820 23:01:22 14 0 3 5 0 1 0 74 24 8916 19K 0 639 3 14.82 4.72 1.64 4 1
20120820 23:01:23 14 0 3 5 0 1 0 75 24 8800 19K 0 639 3 14.82 4.72 1.64 1 3
20120820 23:01:23 14 0 3 5 0 1 0 75 24 8800 19K 0 639 2 14.82 4.72 1.64 1 3
IOPS:
KBPS:
结论： 在混合读写logical IO时 出现了较大的IOPS波动，曲线抖动明显 ,整体IOPS高于physical IO 读写 CPU高于physical IO 读写。
- SwingBench 测试TPS
采用50 session Mix模式 60%写 40%读
TPM：
TPS：
结论：SwingBench 测试结果较为理想，不过考虑到基础数据为1G 所以不能真实的反映为线上情况，数值仅供参考。