Использую FreeBSD больше 5 лет. Постоянно занят оптимизацией связки mysql/apache/php. Толька большая любовь к FreeBSD и уважение к команде разработчиков держит. Ловите мои тесты, делал 3 месяца назад, mysql 4.1.16 тогда была. Юзаю два года LINUXTHREADS. На больших нагрузках бывают сбои, система сейчас SMP (Intel).
root@shelter# uname -a
FreeBSD shelter 6.0-RELEASE-p3 FreeBSD 6.0-RELEASE-p3
make WITH_CHARSET=cp1251 WITH_XCHARSET=all WITH_PROC_SCOPE_PTH=yes BUILD_OPTIMIZED=yes BUILD_STATIC=yes WITHOUT_INNODB=yes
root@shelter# super-smack select-key.smack 10 1000
Query Barrel Report for client smacker1
connect: max=4ms min=1ms avg= 3ms from 10 clients
Query_type num_queries max_time min_time q_per_s
select_index 20000 3 0 5953.17
root@shelter# for i in 1 2 3 4 5; do super-smack select-key.smack 10 1000 | grep select_index; done
select_index 20000 3 0 5970.28
select_index 20000 1 0 6033.27
select_index 20000 2 0 5987.75
select_index 20000 1 0 5950.09
select_index 20000 1 0 6456.59
root@shelter# for i in 1 2 3 4 5; do super-smack update-select.smack 10 1000 | grep select_index; done
select_index 10000 1 0 2850.87
select_index 10000 2 0 2876.46
select_index 10000 2 0 2900.69
select_index 10000 1 0 2949.64
select_index 10000 1 0 2768.93
root@shelter# super-smack select-key.smack 10 10000
Query Barrel Report for client smacker1
connect: max=3ms min=2ms avg= 2ms from 10 clients
Query_type num_queries max_time min_time q_per_s
select_index 200000 1 0 6024.51
----------------------------------------------------------------
WITH_CHARSET=cp1251 WITH_XCHARSET=all WITH_LINUXTHREADS=yes WITH_PROC_SCOPE_PTH=yes BUILD_OPTIMIZED=yes BUILD_STATIC=yes WITHOUT_INNODB=yes
root@shelter# super-smack select-key.smack 10 1000
Query Barrel Report for client smacker1
connect: max=3ms min=1ms avg= 2ms from 10 clients
Query_type num_queries max_time min_time q_per_s
select_index 20000 0 0 12726.61
root@shelter# for i in 1 2 3 4 5; do super-smack select-key.smack 10 1000 | grep select_index; done
select_index 20000 0 0 12972.70
select_index 20000 1 0 13186.32
select_index 20000 0 0 12805.09
select_index 20000 0 0 12842.54
select_index 20000 0 0 13197.56
root@shelter# for i in 1 2 3 4 5; do super-smack update-select.smack 10 1000 | grep select_index; done
select_index 10000 2 0 4903.96
select_index 10000 1 0 4720.51
select_index 10000 1 0 4974.32
select_index 10000 2 0 4949.03
select_index 10000 1 0 4955.58
root@shelter# super-smack select-key.smack 10 10000
Query Barrel Report for client smacker1
connect: max=3ms min=1ms avg= 1ms from 10 clients
Query_type num_queries max_time min_time q_per_s
select_index 200000 0 0 12827.56
----------------------------------------------------------------
WITH_CHARSET=cp1251 WITH_XCHARSET=all WITH_LINUXTHREADS=yes BUILD_OPTIMIZED=yes BUILD_STATIC=yes WITHOUT_INNODB=yes
root@shelter# super-smack select-key.smack 10 1000
Query Barrel Report for client smacker1
connect: max=5ms min=2ms avg= 2ms from 10 clients
Query_type num_queries max_time min_time q_per_s
select_index 20000 0 0 12815.30
root@shelter# for i in 1 2 3 4 5; do super-smack select-key.smack 10 1000 | grep select_index; done
select_index 20000 0 0 12839.03
select_index 20000 1 0 12893.93
select_index 20000 1 0 12768.72
select_index 20000 0 0 12750.90
select_index 20000 0 0 12840.02
root@shelter# for i in 1 2 3 4 5; do super-smack update-select.smack 10 1000 | grep select_index; done
select_index 10000 1 0 4933.73
select_index 10000 1 0 4955.65
select_index 10000 1 0 4945.07
select_index 10000 1 0 4960.90
select_index 10000 1 0 4939.61
root@shelter# super-smack select-key.smack 10 10000
Query Barrel Report for client smacker1
connect: max=3ms min=1ms avg= 1ms from 10 clients
Query_type num_queries max_time min_time q_per_s
select_index 200000 0 0 12908.48