FreeBSD 6.0 MySQL Performance
I use databases/mysql50-{client,server} and use benchmarks/super-smack to test. There are 3*2*2*2
- Compile options: none,
WITH_PROC_SCOPE_PTH=yes,WITH_LINUXTHREADS=yes /etc/libmap.conf: none (libpthread),libthrkern.timecounter.choice:ACPI-fast,TSC- kernel:
ULE+PREEMPTION,ULE
These benchmarking were tested on my laptop (IBM x31 2672-IQV, Pentium-M 1.5G with 512MB RAM), and powerd was disabled. Detail informations (dmesg, sysctl, and kernel config file) will post later.
The commands are:
for i in 1 2 3 4 5; do super-smack select-key.smack 10 1000 | grep select_index; done
for i in 1 2 3 4 5; do super-smack update-select.smack 10 1000 | grep select_index; done
mysql-linuxthreads-libpthread-acpifast-ule+pre.txt
select_index 20000 0 0 14097.47 select_index 20000 0 0 13741.43 select_index 20000 1 0 13704.01 select_index 20000 0 0 13626.05 select_index 20000 0 0 13769.32 select_index 10000 2 0 1891.63 select_index 10000 2 0 1758.65 select_index 10000 2 0 1836.00 select_index 10000 4 0 2058.71 select_index 10000 14 0 2050.05
mysql-linuxthreads-libpthread-acpifast-ule.txt
select_index 20000 1 0 12478.07 select_index 20000 0 0 13340.34 select_index 20000 1 0 13402.94 select_index 20000 0 0 13427.98 select_index 20000 0 0 13516.95 select_index 10000 2 0 3005.60 select_index 10000 2 0 3286.45 select_index 10000 2 0 3289.58 select_index 10000 3 0 3300.75 select_index 10000 3 0 3270.95
mysql-linuxthreads-libpthread-tsc-ule+pre.txt
select_index 20000 1 0 13638.09 select_index 20000 1 0 15204.89 select_index 20000 0 0 15126.16 select_index 20000 1 0 15199.22 select_index 20000 1 0 15111.09 select_index 10000 2 0 2079.97 select_index 10000 2 0 1914.26 select_index 10000 2 0 2154.83 select_index 10000 2 0 2089.02 select_index 10000 3 0 2151.76
mysql-linuxthreads-libpthread-tsc-ule.txt
select_index 20000 1 0 13799.12 select_index 20000 0 0 15007.75 select_index 20000 1 0 15016.11 select_index 20000 0 0 15021.71 select_index 20000 1 0 15034.78 select_index 10000 1 0 3561.01 select_index 10000 1 0 3554.91 select_index 10000 1 0 3554.55 select_index 10000 1 0 3563.48 select_index 10000 2 0 3521.84
mysql-linuxthreads-libthr-acpifast-ule+pre.txt
select_index 20000 0 0 12332.69 select_index 20000 0 0 13531.45 select_index 20000 1 0 13578.15 select_index 20000 0 0 13571.15 select_index 20000 1 0 13625.20 select_index 10000 2 0 1571.96 select_index 10000 2 0 2105.13 select_index 10000 3 0 2080.75 select_index 10000 3 0 2041.60 select_index 10000 3 0 2075.76
mysql-linuxthreads-libthr-acpifast-ule.txt
select_index 20000 1 0 12475.24 select_index 20000 1 0 13450.59 select_index 20000 1 0 13417.97 select_index 20000 1 0 13412.57 select_index 20000 2 0 13383.80 select_index 10000 2 0 3332.96 select_index 10000 2 0 3320.67 select_index 10000 1 0 3038.21 select_index 10000 2 0 3313.98 select_index 10000 1 0 3306.03
mysql-linuxthreads-libthr-tsc-ule+pre.txt
select_index 20000 0 0 13663.00 select_index 20000 0 0 15213.64 select_index 20000 1 0 15042.29 select_index 20000 1 0 15174.39 select_index 20000 1 0 15243.04 select_index 10000 32 0 1774.45 select_index 10000 2 0 2226.37 select_index 10000 1 0 2190.76 select_index 10000 2 0 1863.09 select_index 10000 3 0 2109.35
mysql-linuxthreads-libthr-tsc-ule.txt
select_index 20000 0 0 13818.04 select_index 20000 1 0 15044.14 select_index 20000 1 0 14952.98 select_index 20000 1 0 14997.97 select_index 20000 1 0 14994.28 select_index 10000 1 0 3559.50 select_index 10000 2 0 3555.00 select_index 10000 1 0 3551.69 select_index 10000 1 0 3544.28 select_index 10000 1 0 3558.09
mysql-none-libpthread-acpifast-ule+pre.txt
select_index 20000 1 0 12365.81 select_index 20000 0 0 13426.82 select_index 20000 0 0 13431.42 select_index 20000 1 0 13524.88 select_index 20000 1 0 13461.60 select_index 10000 3 0 2174.06 select_index 10000 1 0 2203.14 select_index 10000 6 0 1965.83 select_index 10000 2 0 1750.57 select_index 10000 2 0 2250.18
mysql-none-libpthread-acpifast-ule.txt
select_index 20000 1 0 12489.77 select_index 20000 1 0 13491.79 select_index 20000 0 0 13525.43 select_index 20000 0 0 13523.64 select_index 20000 1 0 13431.96 select_index 10000 2 0 3081.10 select_index 10000 1 0 3080.20 select_index 10000 3 0 3090.05 select_index 10000 1 0 3098.17 select_index 10000 2 0 3084.23
mysql-none-libpthread-tsc-ule+pre.txt
select_index 20000 1 0 13352.18 select_index 20000 1 0 14704.85 select_index 20000 1 0 14608.26 select_index 20000 1 0 14798.53 select_index 20000 0 0 14689.70 select_index 10000 0 0 2142.89 select_index 10000 1 0 2234.18 select_index 10000 1 0 2179.86 select_index 10000 2 0 2170.27 select_index 10000 1 0 2265.08
mysql-none-libpthread-tsc-ule.txt
select_index 20000 1 0 13656.62 select_index 20000 1 0 14898.67 select_index 20000 1 0 14752.02 select_index 20000 2 0 14852.14 select_index 20000 1 0 14837.82 select_index 10000 1 0 3007.47 select_index 10000 2 0 3229.50 select_index 10000 2 0 3224.31 select_index 10000 1 0 3231.67 select_index 10000 3 0 3227.73
mysql-none-libthr-acpifast-ule+pre.txt
select_index 20000 1 0 13554.22 select_index 20000 0 0 14843.70 select_index 20000 1 0 14866.88 select_index 20000 0 0 14887.39 select_index 20000 1 0 14928.93 select_index 10000 1 0 1629.05 select_index 10000 2 0 2236.91 select_index 10000 15 0 2309.37 select_index 10000 2 0 2165.72 select_index 10000 27 0 2159.57
mysql-none-libthr-acpifast-ule.txt
select_index 20000 1 0 13658.64 select_index 20000 1 0 14971.77 select_index 20000 1 0 14956.40 select_index 20000 0 0 14981.85 select_index 20000 1 0 14999.37 select_index 10000 2 0 3457.10 select_index 10000 2 0 3471.44 select_index 10000 1 0 3461.68 select_index 10000 1 0 3467.51 select_index 10000 1 0 3464.31
mysql-none-libthr-tsc-ule+pre.txt
select_index 20000 2 0 14777.00 select_index 20000 0 0 16435.89 select_index 20000 1 0 16594.25 select_index 20000 1 0 16396.86 select_index 20000 1 0 16459.05 select_index 10000 1 0 2231.66 select_index 10000 1 0 2167.76 select_index 10000 1 0 2196.55 select_index 10000 1 0 2206.77 select_index 10000 2 0 2339.63
mysql-none-libthr-tsc-ule.txt
select_index 20000 0 0 15248.38 select_index 20000 1 0 16618.56 select_index 20000 1 0 16648.67 select_index 20000 0 0 16538.45 select_index 20000 1 0 16674.13 select_index 10000 1 0 3666.43 select_index 10000 3 0 3674.07 select_index 10000 2 0 3686.61 select_index 10000 1 0 3677.49 select_index 10000 2 0 3675.10
mysql-pth-libpthread-acpifast-ule+pre.txt
select_index 20000 0 0 9851.83 select_index 20000 1 0 10051.59 select_index 20000 1 0 10078.66 select_index 20000 1 0 10004.09 select_index 20000 1 0 10079.65 select_index 10000 1 0 1666.05 select_index 10000 2 0 1984.58 select_index 10000 2 0 1898.87 select_index 10000 2 0 1966.90 select_index 10000 4 1 1874.67
mysql-pth-libpthread-acpifast-ule.txt
select_index 20000 1 0 9485.41 select_index 20000 1 0 10073.52 select_index 20000 1 0 10113.77 select_index 20000 1 0 10104.63 select_index 20000 2 0 10107.14 select_index 10000 2 0 2568.85 select_index 10000 1 0 2579.42 select_index 10000 2 0 2564.46 select_index 10000 1 0 2561.09 select_index 10000 1 0 2443.52
mysql-pth-libpthread-tsc-ule+pre.txt
select_index 20000 0 0 11129.51 select_index 20000 1 0 12125.62 select_index 20000 1 0 12108.58 select_index 20000 1 0 12148.99 select_index 20000 1 0 12142.83 select_index 10000 1 0 1769.50 select_index 10000 2 0 1961.15 select_index 10000 3 0 2132.04 select_index 10000 2 0 2175.26 select_index 10000 1 0 1964.11
mysql-pth-libpthread-tsc-ule.txt
select_index 20000 0 0 11282.64 select_index 20000 1 0 12221.35 select_index 20000 1 0 12176.64 select_index 20000 0 0 12207.59 select_index 20000 1 0 12196.39 select_index 10000 2 0 2850.48 select_index 10000 2 0 2847.16 select_index 10000 3 1 2839.71 select_index 10000 2 0 2846.03 select_index 10000 2 0 2854.38
mysql-pth-libthr-acpifast-ule+pre.txt
select_index 20000 1 0 13539.93 select_index 20000 1 0 14858.06 select_index 20000 1 0 15031.06 select_index 20000 0 0 14944.30 select_index 20000 1 0 14939.87 select_index 10000 1 0 1803.10 select_index 10000 1 0 2196.92 select_index 10000 1 0 2315.69 select_index 10000 1 0 2304.67 select_index 10000 6 0 2309.06
mysql-pth-libthr-acpifast-ule.txt
select_index 20000 1 0 13754.94 select_index 20000 1 0 14948.38 select_index 20000 1 0 15003.24 select_index 20000 1 0 14971.17 select_index 20000 0 0 14886.27 select_index 10000 1 0 3420.30 select_index 10000 1 0 3270.71 select_index 10000 2 0 3416.76 select_index 10000 2 0 3443.20 select_index 10000 2 0 3423.75
mysql-pth-libthr-tsc-ule+pre.txt
select_index 20000 0 0 14755.44 select_index 20000 0 0 16653.00 select_index 20000 1 0 16646.08 select_index 20000 1 0 16471.75 select_index 20000 1 0 16591.78 select_index 10000 1 0 2181.36 select_index 10000 1 0 2195.38 select_index 10000 1 0 2153.20 select_index 10000 1 0 2006.63 select_index 10000 2 0 2444.98
mysql-pth-libthr-tsc-ule.txt
select_index 20000 0 0 15189.03 select_index 20000 0 0 16818.74 select_index 20000 0 0 16624.18 select_index 20000 1 0 16792.51 select_index 20000 1 0 16731.49 select_index 10000 1 0 3652.88 select_index 10000 1 0 3685.77 select_index 10000 2 0 3670.86 select_index 10000 1 0 3665.19 select_index 10000 1 0 2843.89
posted by Gea-Suan Lin at
1:09 PM
