Paip. mysql Performance Test report homeright_MySQL

Paip. mysql Performance Test report homeright bitsCN.com

Paip. mysql Performance Test report home right

Environment: xpsp3, mysql5.6.12

Hard disk information:

Serial: WD-WMAV29469153

Capacity: 160.0 gB (149.0 GB)

Cache size: 8192 KB

Large File Speed

8192 KB 96839 KB/second WR speed

Random speed IOPS

512 bytes 60 IOPS

16 Ms 0.029 MB/second

4 KB 56 IOPS 17 Ms 0.220 MB/second

64 KB 58 IOPS 17 Ms 3.637 MB/second

///////// Test write 60 SQL

"D: /MySQL56/bin/mysqlslap.exe "-- concurrency = 1 -- auto-generate-SQL-load-type = write -- engine = innodb -- number-of-queries = 60 -- port = 3306-uroot-p

Benchmark

Running for engine innodb

Average number of seconds to run all queries: 0.063 seconds

Minimum number of seconds to run all queries: 0.063 seconds

Maximum number of seconds to run all queries: 0.063 seconds

Number of clients running queries: 1

Average number of queries per client: 60

"D: /MySQL56/bin/mysqlslap.exe "-- concurrency = 1 -- auto-generate-SQL-load-type = write -- engine = innodb -- number-of-queries = 600 -- port = 3306-uroot-p

Enter password:

Benchmark

Running for engine innodb

Average number of seconds to run all queries: 0.578 seconds

Minimum number of seconds to run all queries: 0.578 seconds

Maximum number of seconds to run all queries: 0.578 seconds

Number of clients running queries: 1

Average number of queries per client: 600

"D: /MySQL56/bin/mysqlslap.exe "-- concurrency = 1 -- auto-generate-SQL-load-type = write -- engine = innodb -- number-of-queries = 1000 -- port = 3306-uroot-p

Benchmark

Running for engine innodb

Average number of seconds to run all queries: 1.953 seconds

Minimum number of seconds to run all queries: 1.953 seconds

Maximum number of seconds to run all queries: 1.953 seconds

Number of clients running queries: 1

Average number of queries per client: 1000

"D: /MySQL56/bin/mysqlslap.exe "-- concurrency = 1 -- auto-generate-SQL-load-type = write -- engine = innodb -- number-of-queries = 100 -- port = 3306-uroot-p

Benchmark

Running for engine innodb

Average number of seconds to run all queries: 0.094 seco

Minimum number of seconds to run all queries: 0.094 seco

Maximum number of seconds to run all queries: 0.094 seco

Number of clients running queries: 1

Average number of queries per client: 100

//// // Test the read speed

"D: /MySQL56/bin/mysqlslap.exe "-- concurrency = 1 -- auto-generate-SQL-load-type = read -- engine = innodb -- number-of-queries = 5000 -- port = 3306-uroot-p

Enter password:

Benchmark

Running for engine innodb

Average number of seconds to run all queries: 5.890 seconds

Minimum number of seconds to run all queries: 5.890 seconds

Maximum number of seconds to run all queries: 5.890 seconds

Number of clients running queries: 1

Average number of queries per client: 5000

"D: /MySQL56/bin/mysqlslap.exe "-- concurrency = 1 -- auto-generate-SQL-load-type = read -- engine = innodb -- number-of-queries = 2800 -- port = 3306-uroot-p

Benchmark

Running for engine innodb

Average number of seconds to run all queries: 3.734 seconds

Minimum number of seconds to run all queries: 3.734 seconds

Maximum number of seconds to run all queries: 3.734 seconds

Number of clients running queries: 1

Average number of queries per client: 2800

Hard disk information: by hdv4.01

HD Tune Pro: WDC WD1600AAJS-00B8D info

Firmware version: 05.04E05

Serial: WD-WMAV29469153

Capacity: 160.0 gB (149.0 GB)

Cache size: 8192 KB

Slice size: 512 bytes

Standard: ATA8-ACS-SATA II

Supported mode: UDMA mode 6

Current Mode: UDMA mode 6

Average speed: 84 MB/s

Disk Speed :-

S. M.A. R. T: Yes

48-bit addressing: Yes

Pre-read: Yes

Write cache: Yes

Primary protection area: Yes

Device Configuration overwrite: Yes

Firmware Upgrade: Yes

Automatic noise management: Yes

Power Management: Yes

Advanced Power Management: no

Interface Power Management: Yes

Standby power-on: no

Security mode: Yes

Native command sequence (NCQ): Yes

Volume: WINXP (C :)

Capacity: 38162 MB

Remaining: 19251 MB

Usage: 50%

File System: NTFS

Serial Number: 709F-B7E7

Capacity: 38162 MB

Remaining: 398 MB

Usage: 99%

File System: NTFS

Serial: A0BF-8CA2

Volume: softlib (E :)

Capacity: 38162 MB

Remaining: 29937 MB

Usage: 22%

File System: NTFS

Serial: A87A-40AE

Volume: bek (F :)

Capacity: 38138 MB

Remaining: 3364 MB

Usage: 91%

File System: NTFS

Serial: E89B-07A5

HD Tune Pro: WDC WD1600AAJS-00B8D file baseline

Drive C:

File size: 64 MB

Block size read speed

0.5 KB 4033 KB/second

1 KB 10852 KB/second

2 KB 14405 KB/second

4 KB 25124 KB/second

8 KB 40299 KB/second

16 KB 62719 KB/second

32 KB 81503 KB/second

64 KB 83055 KB/second

128 KB 77048 KB/second

256 KB 84426 KB/second

512 KB 90262 KB/second

1024 KB 93310 KB/second

2048 KB 91068 KB/second

4096 KB 93390 KB/second

8192 KB 96839 KB/second

Block size write speed

0.5 KB 5992 KB/second

1 KB 11367 KB/second

2 KB 23868 KB/second

4 KB 39383 KB/second

8 KB 62510 KB/second

16 KB 75495 KB/second

32 KB 83400 KB/second

64 KB 94038 KB/second

128 KB 94009 KB/second

256 KB 96669 KB/second

512 KB 98261 KB/second

1024 KB 91004 KB/second

2048 KB 68581 KB/second

4096 KB 98241 KB/second

8192 KB 98038 KB/second

HD Tune Pro: random access to WDC WD1600AAJS-00B8D

Test Capacity: all

Read test

Transfer data size operation/second

Average access time average speed

512 bytes 60 IOPS

16 Ms 0.029 MB/second

4 KB 56 IOPS 17 Ms 0.220 MB/second

64 KB 58 IOPS 17 Ms 3.637 MB/second

1 MB 34 IOPS 29 Ms 34.215 MB/second

Random

BitsCN.com