Where Can I Buy Replacement Jar Lids

Internet via WiFi from the street lamp

order to benchmark MySQL, there are many possibilities. One is the benchmark suite
SysBench
is in the package management of almost all Linux distributions is available. Since I can not remember the syntax I read it here on time:

SysBench - test = OLTP - OLTP-table-size = 2000000 - mysql-db = test - mysql-user = root - mysql -password =...

prepare

creates the necessary tables in the database test.

SysBench - Test = OLTP - OLTP-table-size = 2000000 - mysql-db = test - mysql-user = root - mysql-password =... - max-time = 180
- max-requests = 0 - num-threads = 8

can run the server 3 minutes rumeiern daurauf.

Here is the result of a 1 minute test of 64 HP Dual Xeon 3075 SAS machine with freshly installed Mysql 5.1 "out-of-the-box"

OLTP test statistics:

queries performed: read: 263 578 write: 94 135

other: 37 654 total: 395 367

transactions: 18 827 (313.13 per sec) deadlocks: 0 (0.00 per sec.) read/write requests: 357713 (5949.45 per sec.)
other operations: 37654 (626.26 per sec.)

Test execution summary:

total time: 60.1254s total number of events: 18827 total time taken by event execution: 480.2558
per-request statistics:
min: 3.11ms avg: 25.51ms max: 229.01ms approx. 95 percentile: 25.76ms
Threads fairness:
events (avg/stddev): 2353.3750/0.48
execution time (avg / stddev): 60.0320/0.05
for comparison on a same machine but with only 32 bit OS and SATA drives: OLTP test statistics: queries performed
:
read: 130 228
write: 46 510
other: 18 604
total: 195 342
transactions: 9302 (151.90 per sec)

deadlocks: 0 (0.00 per sec)

read / write requests: 176 738 (2886.15 per sec)
other operations: 18 604 (303.81 per sec)

Test execution summary: total time
: 61.2366s
total number of events: 9302
total time taken by event execution: 489.7876
per-request statistics: min
: 2.58ms avg
: 52.65ms
max: 2857.50ms
approx. 95 percentile: 80.98ms

Threads fairness:
events (avg / stddev): 1162.7500/116.67
execution time (avg / stddev): 61.2235/0.00





So there is a huge difference between 32/64 SAS SATA

Addendum: In Debian there are SysBench not in the repository but has to be compiled from source. For this purpose it is here

a good guide.

Another addendum: here the values of a Simplyroot.de vServer Silver

OLTP test statistics: queries performed
:
read: ; ; 267386
        write:                           95495
        other:                           38198
        total:                           401079
    transactions:                        19099  (106.09 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 362881 (2015.75 per sec.)
    other operations:                    38198  (212.18 per sec.)

Test execution summary:
    total time:                          180.0231s
    total number of events:              19099
    total time taken by event execution: 1439.9349
    per-request statistics:
         min:                                  2.40ms
         avg:                                 75.39ms
         max:                               1818.85ms
         approx.  95 percentile:             272.52ms

Threads fairness:
events (avg / stddev): 2387.3750/76.62
; execution time (avg / stddev): 179.9919/0.01