]]>
]]>

Conclusion

Results

sysbench

/home/akuzminsky/benchwork/percona-benchwork/results/sysbench/3

1       "1"     273.7400        30.3675 449.2266        7.4928
2       "2"     413.6733        8.2355  804.9666        14.3943
3       "4"     544.1766        53.0525 1456.0500       9.2918
4       "8"     663.2833        63.8242 2309.7400       59.9575
5       "10"    687.4033        25.8889 2619.8800       39.1293
6       "12"    713.5000        .5082   2837.7500       59.8560
7       "14"    688.8833        83.8654 2988.6000       26.1054
8       "16"    689.0266        30.8142 3032.0800       44.6083
9       "18"    681.3300        20.0524 2951.3766       38.9443
10      "20"    693.2800        11.9436 2884.0133       92.6711
11      "22"    673.1233        98.8149 2787.2866       91.3195
12      "24"    716.2066        142.2834        2731.4600       4.7012
13      "26"    660.1733        29.8197 2613.5966       17.4021
14      "28"    686.9333        108.9876        2551.5966       74.1845
15      "30"    688.2566        35.6357 2498.1400       100.4849
16      "32"    687.6500        65.5629 2444.3400       68.3084
17      "64"    593.3066        103.6739        2011.0866       125.0946
18      "128"   282.2333        13.8332 1706.6133       31.5508
19      "256"   165.6150        31.9543 1152.6700       40.3957

1       "1"     110.7533        12.4554 171.6233        7.8198
2       "2"     128.2300        2.6454  232.8333        10.6004
3       "4"     137.1500        13.3724 291.6033        10.5315
4       "8"     156.1350        1.3315  316.9100        1.8558
5       "10"    151.9100        15.4228 308.2733        21.8596
6       "12"    149.8933        7.4790  307.6500        7.5530
7       "14"    148.0033        34.9709 311.5166        1.8520
8       "16"    149.4433        7.1094  318.0200        8.6158
9       "18"    142.5866        8.2497  315.2100        11.2050
10      "20"    139.2266        13.2601 315.2633        9.5070
11      "22"    141.6233        23.0158 317.3000        7.3077
12      "24"    138.0200        .1270   316.2000        10.6017
13      "26"    131.5866        8.0616  314.9650        .3100
14      "28"    136.4666        13.0927 318.1600        5.4759
15      "30"    135.4133        2.0301  320.5800        9.5462
16      "32"    136.2800        5.6300  322.4633        4.0336
17      "64"    113.2833        3.3460  328.5233        8.7049
18      "128"   87.5366 14.6357 323.3133        2.1768
19      "256"   60.7066 10.7876 289.6100        3.4548

Configuration

Hardware

Server: www.ibenia.com (R900)

CPU

$ cat /proc/cpuinfo
...

processor       : 15
vendor_id       : GenuineIntel
cpu family      : 6
model           : 15
model name      : Intel(R) Xeon(R) CPU           E7320  @ 2.13GHz
stepping        : 11
cpu MHz         : 2127.899
cache size      : 2048 KB
physical id     : 6
siblings        : 4
core id         : 3
cpu cores       : 4
apicid          : 27
initial apicid  : 27
fpu             : yes
fpu_exception   : yes
cpuid level     : 10
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 pbe m
bogomips        : 4255.91
clflush size    : 64
cache_alignment : 64
address sizes   : 40 bits physical, 48 bits virtual
power management:

RAM

$ cat /proc/meminfo
MemTotal:     32949480 kB
MemFree:       5465052 kB
Buffers:       2535556 kB
Cached:       23271008 kB
SwapCached:          0 kB
Active:       12183344 kB
Inactive:     13666092 kB
SwapTotal:     4194296 kB
SwapFree:      4191016 kB
Dirty:             804 kB
Writeback:           0 kB
AnonPages:       41984 kB
Mapped:           9632 kB
Slab:          1162048 kB
SReclaimable:   798068 kB
SUnreclaim:     363980 kB
PageTables:      37848 kB
NFS_Unstable:        0 kB
Bounce:              0 kB
WritebackTmp:        0 kB
CommitLimit:  20669036 kB
Committed_AS:    72164 kB
VmallocTotal: 34359738367 kB
VmallocUsed:    390740 kB
VmallocChunk: 34359324827 kB
HugePages_Total:     0
HugePages_Free:      0
HugePages_Rsvd:      0
HugePages_Surp:      0
Hugepagesize:     2048 kB
DirectMap4k:      6936 kB
DirectMap2M:  33542144 kB

HDD

$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/raid-root
                      9.7G  7.9G  1.4G  86% /
tmpfs                  16G     0   16G   0% /lib/init/rw
varrun                 16G   88K   16G   1% /var/run
varlock                16G     0   16G   0% /var/lock
udev                   16G  3.2M   16G   1% /dev
tmpfs                  16G     0   16G   0% /dev/shm
/dev/sda1             251M   53M  185M  23% /boot
/dev/mapper/raid-data
                      197G   97G   91G  52% /data
/dev/mapper/raid-lvol0
                       35G   24G  9.2G  73% /bench

Operating System

$ uname -a
Linux www.ibenia.com 2.6.27-7-server #1 SMP Tue Nov 4 20:16:57 UTC 2008 x86_64 GNU/Linux

MySQL

MySQL details

MySQL configuration

  • my.cnf
[mysqld]
#mysqld options in alphabetical order
default_table_type=MYISAM

innodb_buffer_pool_size=1G
innodb_data_file_path=ibdata1:10M:autoextend
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=8M
innodb_log_files_in_group=2
innodb_log_file_size=128M

pbxt_index_cache_size=1G
pbxt_record_cache_size=1G
pbxt_log_cache_size=512M

max_connections=3000
query_cache_size=0
skip-name-resolve

table_cache=2048
user=root
#log=/tmp/mysql.log

Benchwork configuration

sysbench

if test -d "$TOP_DIR/config.d"
then
        for c in "$TOP_DIR"/config.d/*.sh
        do
                source "$c"
        done
fi

#####################################################
# Benchmark part
#####################################################
#
# NOTE:
#       A list of parameters you may vary please find in config.d/*.sh files

benchmark="sysbench"
mysql_server="mysql-5.1.36-pbxt"
keep_state="YES"
mysql_datadir=/data/mysql
mysql_basedir=/usr/local/mysql



sb_test="oltp"
sb_mysql_engine_trx="yes"
sb_max_requests=0
sb_max_time=300

restart_mysqld="YES"
custom_query="SHOW CREATE TABLE sbtest.sbtest"
collect_custom_query="YES"
custom_query_interval=30


var1="sb_mysql_table_engine"
var1_range="pbxt,innodb"

var2="sb_oltp_table_size"               # You want to vary sb_oltp_table_size
var2_range="1000000,10000000"   # 10000, 100000 and 1000000 are sequential values for sb_oltp_table_size
var2_restart_mysqld="YES"       # Restart MySQL when var2 changes.
                                # Note: MySQL restarts with every varX change by default.
                                # So setting varX_restart_mysqld to YES is meaningful if restart_mysqld="NO"

var3="sb_num_threads"
var3_range="1,2,4,8,10,12,14,16,18,20,22,24,26,28,30,32,64,128,256"
var3_iterations="3"             # Run N times the test with the same set of parameters.
                                # 3 is reasonable minimum, 5 is recommended value
                                # 1 - if you don't care about random error
var3_warmup="NO"                # Before running a benchmark with values from varX_range run "warmup" test
var3_warmup_value="5"           # use var2_warmup_value for var2 when warming MySQL server up

# Results part
results_directory="$TOP_DIR/results"
results_prefix="$benchmark"
 
benchmark/pbxt_vs_innodb.txt · Last modified: 2011/07/17 21:05 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license:CC Attribution-Noncommercial-Share Alike 3.0 Unported
Contact Us 24 Hours A Day
SupportContact us 24×7
Emergency? Contact us for help now!
Sales North America(888) 316-9775 or
(208) 473-2904
Sales
Europe
+44-208-133-0309 (UK)
0-800-051-8984 (UK)
0-800-181-0665 (GER)
Training(855) 55TRAIN or
(925) 271-5054

 

Share This
]]> ]]>