MySQL Benchmarks – MySQL 5.0.92 vs 5.1.55 vs 5.5.10 vs Percona 5.1.55 vs Percona 5.5.8 vs MariaDB 5.2.5

by eva2000 · Published April 6, 2011 · Updated March 5, 2017

Sysbench Bash Shell Script

I used the below script to run Sysbench benchmarks.

For MyISAM

Prepare table

./mysqlbench.sh roprepare

MyISAM read only tests

./mysqlbench.sh rorun

MyISAM read/write tests

./mysqlbench.sh rooffrun

Cleanup table

./mysqlbench.sh rocleanup

For InnoDB

Prepare table

./mysqlbench.sh roiprepare

InnoDB read only tests

./mysqlbench.sh roirun

InnoDB read/write tests

./mysqlbench.sh roioffrun

Cleanup table

./mysqlbench.sh roicleanup

#!/bin/bash
###############################
# Sysbench v0.4.12 shell script
# for vbtechsupport.com benchmarks
# http://vbtechsupport.com/606/
# George Liu (eva2000)
# April 6th, 2011
###############################
 
case "$1" in
roprepare)
 
sysbench --test=oltp --mysql-table-engine=myisam --oltp-table-size=10000000 \
--mysql-user=mysqlusername --mysql-password=mysqluserpassword \
--mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=1 --max-requests=100000 \
--myisam-max-rows=1000000000 \
--oltp-read-only --oltp-dist-type=uniform prepare
;;
rorun)
 
for i in 1 2 4 8 12 16 24 32 48 64
do
sysbench --test=oltp --oltp-table-size=10000000 --mysql-user=mysqlusername --mysql-password=mysqluserpassword \
--mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=$i --max-requests=100000 \
--oltp-read-only --oltp-dist-type=uniform run
done
 
;;
rooffrun)
 
for i in 1 2 4 8 12 16 24 32 48 64
do
sysbench --test=oltp --oltp-table-size=10000000 --mysql-user=mysqlusername --mysql-password=mysqluserpassword \
--mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=$i --max-requests=100000 \
--oltp-read-only=off --oltp-dist-type=uniform run
done
 
;;
rocleanup)
 
sysbench --test=oltp --mysql-table-engine=myisam --oltp-table-size=10000000 \
--mysql-user=mysqlusername --mysql-password=mysqluserpassword \
--mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=1 --max-requests=100000 \
--oltp-read-only --oltp-dist-type=uniform cleanup
 
;;
roiprepare)
 
sysbench --test=oltp --mysql-table-engine=innodb --oltp-table-size=10000000 \
--mysql-user=mysqlusername --mysql-password=mysqluserpassword \
--mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=1 --max-requests=100000 \
--myisam-max-rows=1000000000 \
--oltp-read-only --oltp-dist-type=uniform prepare
;;
roirun)
 
for i in 1 2 4 8 12 16 24 32 48 64
do
sysbench --test=oltp --oltp-table-size=10000000 --mysql-user=mysqlusername --mysql-password=mysqluserpassword \
--mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=$i --max-requests=100000 \
--oltp-read-only --oltp-dist-type=uniform run
done
 
;;
roioffrun)
 
for i in 1 2 4 8 12 16 24 32 48 64
do
sysbench --test=oltp --oltp-table-size=10000000 --mysql-user=mysqlusername --mysql-password=mysqluserpassword \
--mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=$i --max-requests=100000 \
--oltp-read-only=off --oltp-dist-type=uniform run
done
 
;;
roicleanup)
 
sysbench --test=oltp --mysql-table-engine=innodb --oltp-table-size=10000000 \
--mysql-user=mysqlusername --mysql-password=mysqluserpassword \
--mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=1 --max-requests=100000 \
--oltp-read-only --oltp-dist-type=uniform cleanup
 
;;
roaprepare)
 
sysbench --test=oltp --mysql-table-engine=aria --oltp-table-size=10000000 \
--mysql-user=mysqlusername --mysql-password=mysqluserpassword \
--mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=1 --max-requests=100000 \
--myisam-max-rows=1000000000 \
--oltp-read-only --oltp-dist-type=uniform --mysql-engine-trx=yes prepare
;;
roarun)
 
for i in 1 2 4 8 12 16 24 32 48 64
do
sysbench --test=oltp --mysql-table-engine=aria --oltp-table-size=10000000 --mysql-user=mysqlusername --mysql-password=mysqluserpassword \
--mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=$i --max-requests=100000 \
--oltp-read-only --oltp-dist-type=uniform --mysql-engine-trx=yes run
done
 
;;
roaoffrun)
 
for i in 1 2 4 8 12 16 24 32 48 64
do
sysbench --test=oltp --mysql-table-engine=aria --oltp-table-size=10000000 --mysql-user=mysqlusername --mysql-password=mysqluserpassword \
--mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=$i --max-requests=100000 \
--oltp-read-only=off --oltp-dist-type=uniform --mysql-engine-trx=yes run
done
 
;;
roacleanup)
 
sysbench --test=oltp --mysql-table-engine=aria--oltp-table-size=10000000 \
--mysql-user=mysqlusername --mysql-password=mysqluserpassword \
--mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=1 --max-requests=100000 \
--oltp-read-only --oltp-dist-type=uniform --mysql-engine-trx=yes cleanup
 
;;
esac

#!/bin/bash ############################### # Sysbench v0.4.12 shell script # for vbtechsupport.com benchmarks # http://vbtechsupport.com/606/ # George Liu (eva2000) # April 6th, 2011 ############################### case "$1" in roprepare) sysbench --test=oltp --mysql-table-engine=myisam --oltp-table-size=10000000 \ --mysql-user=mysqlusername --mysql-password=mysqluserpassword \ --mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=1 --max-requests=100000 \ --myisam-max-rows=1000000000 \ --oltp-read-only --oltp-dist-type=uniform prepare ;; rorun) for i in 1 2 4 8 12 16 24 32 48 64 do sysbench --test=oltp --oltp-table-size=10000000 --mysql-user=mysqlusername --mysql-password=mysqluserpassword \ --mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=$i --max-requests=100000 \ --oltp-read-only --oltp-dist-type=uniform run done ;; rooffrun) for i in 1 2 4 8 12 16 24 32 48 64 do sysbench --test=oltp --oltp-table-size=10000000 --mysql-user=mysqlusername --mysql-password=mysqluserpassword \ --mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=$i --max-requests=100000 \ --oltp-read-only=off --oltp-dist-type=uniform run done ;; rocleanup) sysbench --test=oltp --mysql-table-engine=myisam --oltp-table-size=10000000 \ --mysql-user=mysqlusername --mysql-password=mysqluserpassword \ --mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=1 --max-requests=100000 \ --oltp-read-only --oltp-dist-type=uniform cleanup ;; roiprepare) sysbench --test=oltp --mysql-table-engine=innodb --oltp-table-size=10000000 \ --mysql-user=mysqlusername --mysql-password=mysqluserpassword \ --mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=1 --max-requests=100000 \ --myisam-max-rows=1000000000 \ --oltp-read-only --oltp-dist-type=uniform prepare ;; roirun) for i in 1 2 4 8 12 16 24 32 48 64 do sysbench --test=oltp --oltp-table-size=10000000 --mysql-user=mysqlusername --mysql-password=mysqluserpassword \ --mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=$i --max-requests=100000 \ --oltp-read-only --oltp-dist-type=uniform run done ;; roioffrun) for i in 1 2 4 8 12 16 24 32 48 64 do sysbench --test=oltp --oltp-table-size=10000000 --mysql-user=mysqlusername --mysql-password=mysqluserpassword \ --mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=$i --max-requests=100000 \ --oltp-read-only=off --oltp-dist-type=uniform run done ;; roicleanup) sysbench --test=oltp --mysql-table-engine=innodb --oltp-table-size=10000000 \ --mysql-user=mysqlusername --mysql-password=mysqluserpassword \ --mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=1 --max-requests=100000 \ --oltp-read-only --oltp-dist-type=uniform cleanup ;; roaprepare) sysbench --test=oltp --mysql-table-engine=aria --oltp-table-size=10000000 \ --mysql-user=mysqlusername --mysql-password=mysqluserpassword \ --mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=1 --max-requests=100000 \ --myisam-max-rows=1000000000 \ --oltp-read-only --oltp-dist-type=uniform --mysql-engine-trx=yes prepare ;; roarun) for i in 1 2 4 8 12 16 24 32 48 64 do sysbench --test=oltp --mysql-table-engine=aria --oltp-table-size=10000000 --mysql-user=mysqlusername --mysql-password=mysqluserpassword \ --mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=$i --max-requests=100000 \ --oltp-read-only --oltp-dist-type=uniform --mysql-engine-trx=yes run done ;; roaoffrun) for i in 1 2 4 8 12 16 24 32 48 64 do sysbench --test=oltp --mysql-table-engine=aria --oltp-table-size=10000000 --mysql-user=mysqlusername --mysql-password=mysqluserpassword \ --mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=$i --max-requests=100000 \ --oltp-read-only=off --oltp-dist-type=uniform --mysql-engine-trx=yes run done ;; roacleanup) sysbench --test=oltp --mysql-table-engine=aria--oltp-table-size=10000000 \ --mysql-user=mysqlusername --mysql-password=mysqluserpassword \ --mysql-socket=/var/lib/mysql/mysql.sock --init-rng=1 --num-threads=1 --max-requests=100000 \ --oltp-read-only --oltp-dist-type=uniform --mysql-engine-trx=yes cleanup ;; esac

Quad Intel Xeon L7555 1.86Ghz Nehalem-EX Octo-Core 64 cpu cores

top - 14:38:12 up 1 day,  8:24,  1 user,  load average: 0.00, 0.00, 0.00
Tasks: 881 total,   1 running, 880 sleeping,   0 stopped,   0 zombie
Cpu0  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu1  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu2  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu3  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu4  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu5  :  0.3%us,  0.3%sy,  0.0%ni, 99.3%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu6  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu7  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu8  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu9  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu10 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu11 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu12 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu13 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu14 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu15 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu16 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu17 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu18 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu19 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu20 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu21 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu22 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu23 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu24 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu25 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu26 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu27 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu28 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu29 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu30 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu31 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu32 :  0.0%us,  0.0%sy,  0.0%ni, 99.7%id,  0.0%wa,  0.0%hi,  0.3%si,  0.0%st
Cpu33 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu34 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu35 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu36 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu37 :  0.3%us,  0.0%sy,  0.0%ni, 99.7%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu38 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu39 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu40 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu41 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu42 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu43 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu44 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu45 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu46 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu47 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu48 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu49 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu50 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu51 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu52 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu53 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu54 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu55 :  1.6%us,  0.0%sy,  0.0%ni, 98.4%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu56 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu57 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu58 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu59 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu60 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu61 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu62 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu63 :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:  65980808k total,  1767176k used, 64213632k free,   314848k buffers
Swap:        0k total,        0k used,        0k free,   654396k cached

top - 14:38:12 up 1 day, 8:24, 1 user, load average: 0.00, 0.00, 0.00 Tasks: 881 total, 1 running, 880 sleeping, 0 stopped, 0 zombie Cpu0 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu1 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu2 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu3 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu4 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu5 : 0.3%us, 0.3%sy, 0.0%ni, 99.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu6 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu7 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu8 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu9 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu10 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu11 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu12 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu13 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu14 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu15 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu16 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu17 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu18 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu19 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu20 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu21 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu22 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu23 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu24 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu25 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu26 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu27 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu28 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu29 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu30 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu31 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu32 : 0.0%us, 0.0%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.3%si, 0.0%st Cpu33 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu34 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu35 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu36 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu37 : 0.3%us, 0.0%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu38 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu39 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu40 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu41 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu42 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu43 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu44 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu45 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu46 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu47 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu48 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu49 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu50 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu51 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu52 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu53 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu54 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu55 : 1.6%us, 0.0%sy, 0.0%ni, 98.4%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu56 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu57 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu58 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu59 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu60 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu61 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu62 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu63 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 65980808k total, 1767176k used, 64213632k free, 314848k buffers Swap: 0k total, 0k used, 0k free, 654396k cached

Snipped some of the cpu listings.

processor       : 0
vendor_id       : GenuineIntel
cpu family      : 6
model           : 46
model name      : Intel(R) Xeon(R) CPU           L7555  @ 1.87GHz
stepping        : 6
cpu MHz         : 1067.000
cache size      : 24576 KB
physical id     : 0
siblings        : 16
core id         : 0
cpu cores       : 8
apicid          : 0
fpu             : yes
fpu_exception   : yes
cpuid level     : 11
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx rdtscp lm constant_tsc ida nonstop_tsc pni monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr sse4_1 sse4_2 popcnt lahf_lm
bogomips        : 3733.54
clflush size    : 64
cache_alignment : 64
address sizes   : 44 bits physical, 48 bits virtual
power management: [8]
 
....
 
processor       : 63
vendor_id       : GenuineIntel
cpu family      : 6
model           : 46
model name      : Intel(R) Xeon(R) CPU           L7555  @ 1.87GHz
stepping        : 6
cpu MHz         : 1067.000
cache size      : 24576 KB
physical id     : 3
siblings        : 16
core id         : 11
cpu cores       : 8
apicid          : 119
fpu             : yes
fpu_exception   : yes
cpuid level     : 11
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx rdtscp lm constant_tsc ida nonstop_tsc pni monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr sse4_1 sse4_2 popcnt lahf_lm
bogomips        : 3732.98
clflush size    : 64
cache_alignment : 64
address sizes   : 44 bits physical, 48 bits virtual
power management: [8]

MySQL Benchmarks – MySQL 5.0.92 vs 5.1.55 vs 5.5.10 vs Percona 5.1.55 vs Percona 5.5.8 vs MariaDB 5.2.5

You may also like...

About Me

My Projects

Post Archives

MySQL Benchmarks – MySQL 5.0.92 vs 5.1.55 vs 5.5.10 vs Percona 5.1.55 vs Percona 5.5.8 vs MariaDB 5.2.5

Sysbench Bash Shell Script

You may also like...

MariaDB 5.1.60 and MariaDB 5.2.10 MySQL Server released

Percona Server 5.5.19-24.0 Released

mysqlmymonlite.sh – gather MySQL & Apache, Nginx web server information stats in less than 12 seconds !

About Me

My Projects

Post Archives