Gea-Suan Lin's BLOG

Monday, December 12, 2005

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), libthr
  • kern.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 

Links to this post:

Create a Link

<< Home