>Is it me or do these dual athlons seem rather responsive!
Yay!! I win (so far... heh)!
I ran it on one of our servers (not idle... running apache w/ CGIs and db calls ~ 140,000
We are using as many tricks as we can.
0. mysql 4.0 binary from mysql.com
1. we set the nice to -15 in safe_mysqld (good trick.. be must be carefull not to over do
set-variable = lower_case_table_names=1
set-variable = sort_buffer=50M
set-variable = record_buffer=2M
set-variable = key_buffer=64M
set-variable = query_cache_size=5M
set-variable = thread_stack=2K
set-variable = thread_cache=8
set-variable = thread_concurrency=4
3. Kernel is custom compiled with minimal drivers. Only
what hardware is on the system is compiled. No modules.
4. I think the Athlons just preform better too.
>I use mySQL 4.0.13 running on FreeBSD 4.8.
>Pentium 4 2.8Ghz
>1 row in set (0.7 sec) | (0.68 sec) | (0.68 sec)
> 1 row in set (0.54 sec)
> 2x Athlon2100
> 2GB Ram
> Linux 2.4.20
> pIII 500
> 1 row in set (2.59 sec)
> Jake Johnson