mysql5.5.8

 OLTP test statistics: queries performed: read: 1400000 write: 500000 other: 200000 total: 2100000 transactions: 100000 (1090.30 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 1900000 (20715.67 per sec.) other operations: 200000 (2180.60 per sec.) Test execution summary: total time: 91.7180s total number of events: 100000 total time taken by event execution: 916.1272 per-request statistics: min: 5.28ms avg: 9.16ms max: 77.65ms approx. 95 percentile: 12.25ms Threads fairness: events (avg/stddev): 10000.0000/971.56 execution time (avg/stddev): 91.6127/0.01OLTP test statistics:
queries performed:
read: 1400000
write: 500000
other: 200000
total: 2100000
transactions: 100000 (1090.30 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 1900000 (20715.67 per sec.)
other operations: 200000 (2180.60 per sec.)

Test execution summary:
total time: 91.7180s
total number of events: 100000
total time taken by event execution: 916.1272
per-request statistics:
min: 5.28ms
avg: 9.16ms
max: 77.65ms
approx. 95 percentile: 12.25ms

Threads fairness:
events (avg/stddev): 10000.0000/971.56
execution time (avg/stddev): 91.6127/0.01

test for data

| 4412084 | mysql  | 192.168.1.23:59863 | dz_bbs     | Sleep       |    25 |                                                                | NULL             |
| 4412094 | mysql  | 192.168.1.23:59869 | dz_bbs     | Sleep       |    30 |                                                                | NULL             |
| 4412106 | mysql  | 192.168.1.23:59877 | dz_bbs     | Sleep       |    29 |                                                                | NULL             |
| 4412107 | mysql  | 192.168.1.23:59878 | dz_bbs     | Sleep       |    29 |                                                                | NULL             |
| 4412134 | mysql  | 192.168.1.23:59910 | dz_bbs     | Sleep       |    28 |                                                                | NULL             |
| 4412155 | mysql  | 192.168.1.23:59942 | dz_bbs     | Sleep       |    27 |                                                                | NULL             |
| 4412164 | mysql  | 192.168.1.23:59958 | dz_ucenter | Sleep       |    27 |                                                                | NULL             |
| 4412174 | mysql  | 192.168.1.23:59982 | dz_bbs     | Sleep       |    26 |                                                                | NULL             |
| 4412188 | mysql  | 192.168.1.23:59994 | dz_bbs     | Sleep       |    25 |                                                                | NULL             |
| 4412191 | mysql  | 192.168.1.23:59998 | dz_bbs     | Sleep       |    25 |                                                                | NULL             |
| 4412194 | mysql  | 192.168.1.23:60002 | dz_ucenter | Sleep       |    25 |                                                                | NULL             |
| 4412237 | mysql  | 192.168.1.23:60061 | dz_bbs     | Sleep       |    23 |                                                                | NULL             |
| 4412247 | mysql  | 192.168.1.23:60073 | dz_bbs     | Sleep       |    23 |                                                                | NULL             |
| 4412250 | mysql  | 192.168.1.23:60078 | dz_bbs     | Sleep       |    23 |                                                                | NULL             |
| 4412253 | mysql  | 192.168.1.23:60083 | dz_bbs     | Sleep       |    23 |                                                                | NULL             |
| 4412269 | mysql  | 192.168.1.23:60105 | dz_bbs     | Sleep       |    21 |                                                                | NULL             |
| 4412276 | mysql  | 192.168.1.23:60114 | dz_bbs     | Sleep       |    20 |                                                                | NULL             |
| 4412278 | mysql  | 192.168.1.23:60116 | dz_bbs     | Sleep       |    20 |                                                                | NULL             |
| 4412279 | mysql  | 192.168.1.23:60117 | dz_bbs     | Sleep       |    20 |                                                                | NULL             |
| 4412280 | mysql  | 192.168.1.23:60118 | dz_bbs     | Sleep       |    20 |                                                                | NULL             |
| 4412302 | mysql  | 192.168.1.23:60144 | dz_bbs     | Sleep       |    19 |                                                                | NULL             |
| 4412305 | mysql  | 192.168.1.23:60148 | dz_bbs     | Sleep       |    19 | 
 

Add comment

Welcome to The Website!

This particular one is just freshly installed or under heavy development. Want one too? Go to Sauropol.com and sign up for free website!

Are you the site owner? To log in, type /editor after the site URL or head to www.sauropol.com/login.