List:General Discussion« Previous MessageNext Message »
From:Christopher Knight Date:July 23 2003 6:45pm
Subject:RE: What is a good benchmark?
View as plain text  
>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
scripts/day )
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
it)
	2. my.cnf
		skip-locking
		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
>2GB DDR400
>1 row in set (0.7 sec) | (0.68 sec) | (0.68 sec)
>Andrew.

> 1 row in set (0.54 sec)
> 2x Athlon2100
> 2GB Ram
> Linux 2.4.20
> Chris

> pIII 500
> 1 row in set (2.59 sec)
> Jake Johnson

Thread
What is a good benchmark?Jake Johnson23 Jul
  • RE: What is a good benchmark?Bryan Koenig23 Jul
    • Re: What is a good benchmark?Yves Goergen23 Jul
    • RES: What is a good benchmark?julio23 Jul
      • RES: What is a good benchmark?julio23 Jul
      • Re: RES: What is a good benchmark?NTLUG23 Jul
  • RE: What is a good benchmark?artem23 Jul
  • RE: What is a good benchmark?Christopher Knight23 Jul
    • Re: What is a good benchmark?Andrew Edwards23 Jul
      • RE: What is a good benchmark?Christopher Knight23 Jul
        • RE: What is a good benchmark?mos23 Jul
          • RE: What is a good benchmark?Jeff Shapiro26 Jul
    • Re: What is a good benchmark?David Griffiths23 Jul
RE: What is a good benchmark?John Griffin23 Jul
RE: What is a good benchmark?Dan Hubbard23 Jul
  • Re: What is a good benchmark?Jim Dickenson23 Jul
    • Re: What is a good benchmark?Chris Knipe23 Jul
    • EXPLAIN - Question..Tom O'Neill \(MySQL User\)23 Jul
RE: What is a good benchmark?John May23 Jul
  • RE: What is a good benchmark?Asif Iqbal29 Jul
    • Re: What is a good benchmark?Jeremy Zawodny29 Jul
      • Re: What is a good benchmark?daniel29 Jul
    • Re: What is a good benchmark?Dan Nelson29 Jul
      • Re: What is a good benchmark?Asif Iqbal29 Jul
        • Re: What is a good benchmark?Dan Nelson29 Jul
          • Re: What is a good benchmark?Asif Iqbal29 Jul
            • Re: What is a good benchmark?Dan Nelson29 Jul
RE: What is a good benchmark?Mark Graves23 Jul
RE: What is a good benchmark?Andrew Braithwaite23 Jul
  • Re-attaching DB to mysqlHenrik Schmiediche23 Jul
    • Re: Re-attaching DB to mysqlEgor Egorov24 Jul
  • Re: What is a good benchmark?Gustavo A. Baratto23 Jul
RE: Re-attaching DB to mysqlAndrew Braithwaite23 Jul
  • RE: Re-attaching DB to mysqlHenrik Schmiediche23 Jul
    • Re: Re-attaching DB to mysqlNils Valentin24 Jul
RE: Re-attaching DB to mysqlAndrew Braithwaite23 Jul
  • RE: Re-attaching DB to mysqlHenrik Schmiediche23 Jul
RE: Re-attaching DB to mysqlAndrew Braithwaite23 Jul
RE: Re-attaching DB to mysqlAndrew Braithwaite23 Jul
RE: RES: What is a good benchmark?Ow Mun Heng24 Jul
RE: RES: What is a good benchmark?Ow Mun Heng24 Jul
Re: Re-attaching DB to mysqlNils Valentin24 Jul