Re: What is a good benchmark?

[Gustavo A. Baratto]

I got disappointing results  compared with the ones posted here:with a 
dual xeon 2Ghz, 2GB ram, freebsd 5.1, mysql

mysql> SELECT BENCHMARK(1000000,ENCODE("hello","goodbye"));
+----------------------------------------------+
| BENCHMARK(1000000,ENCODE("hello","goodbye")) |
+----------------------------------------------+
|                                            0 |
+----------------------------------------------+
1 row in set (1.10 sec)

Any idea how to improve it? The cpu is 90% idle average. following 
my.cnf and configure options...

my.cnf
------------------
[mysqld]
log-bin
set-variable = max_connections=700
set-variable = max_connect_errors=100
safe-show-database
set-variable = wait_timeout=120
set-variable = interactive_timeout=120
set-variable = myisam-recover=BACKUP,FORCE
set-variable = key_buffer_size=500MB
set-variable = sort_buffer_size=5M
set-variable = read_buffer_size=2M
set-variable = table_cache=512
set-variable = max_delayed_threads=0
set-variable = max_user_connections=25
set-variable = query_cache_size=50M
set-variable = thread_cache_size=100

# INNODB
innodb_data_home_dir = /var/mysql/data/INNODB
innodb_buffer_pool_size = 80M
innodb_additional_mem_pool_size = 5M
innodb_log_buffer_size = 20M
----------------------

configure:
./configure \
--enable-static \
--with-innodb \
--without-berkeley-db \
--with-mysqld-user="mysql" \
--without-debug \
--without-docs \
--without-gemini \
--without-mit-threads \
--without-perl \
--without-readline \
--without-docs \
--with-mysqld-ldflags=-all-static \
--enable-thread-safe-client \
--enable-local-infile \
--enable-assembler \
--with-extra-charsets=complex \
--with-named-thread-libs='-DHAVE_GLIBC2_STYLE_GETHOSTBYNAME_R 
-D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads 
-L/usr/local/lib -llthread -llgcc_r -llstdc++ -llsupc++' \
--with-comment='Superb Mysql Server' \
--localstatedir="/var/mysql/data" \
--prefix=/var/mysql/mysql-4.0.13-2003-jul-08


Thanks for any hint...

Andrew Braithwaite wrote:
> I get the following on dual Athlon MP 1666MHz 1GB RAM which is 40% cpu
> loaded
> 
> mysql> SELECT BENCHMARK(1000000,ENCODE("hello","goodbye"));
> +----------------------------------------------+
> | BENCHMARK(1000000,ENCODE("hello","goodbye")) |
> +----------------------------------------------+
> |                                            0 |
> +----------------------------------------------+
> 1 row in set (0.64 sec)
> 
> This result doesn't take into account disk speed I/O etc - so this test will
> only be relevent for cpu speed.
> 
> However, If you're worried about performance and want to speed it up a bit,
> use abbreviated english in your queries like this:
> 
> mysql> SELECT BENCHMARK(1000000,ENCODE("hi","bye"));
> +---------------------------------------+
> | BENCHMARK(1000000,ENCODE("hi","bye")) |
> +---------------------------------------+
> |                                     0 |
> +---------------------------------------+
> 1 row in set (0.32 sec)
> 
> Only kidding about the abbreviations ;)
> 
> Andrew
> 
> -----Original Message-----
> From: Jake Johnson [mailto:jake@stripped] 
> Sent: Wednesday 23 July 2003 15:34
> To: Mysql
> Subject: What is a good benchmark? 
> 
> 
> I ran this benchmark on my pIII 500 and was wondering what everyone else was
> getting?
> 
> mysql> SELECT BENCHMARK(1000000,ENCODE("hello","goodbye"));
> 
> +----------------------------------------------+
> | BENCHMARK(1000000,ENCODE("hello","goodbye")) |
> +----------------------------------------------+
> |                                            0 |
> +----------------------------------------------+
> 1 row in set (2.59 sec)
> 
> 
> Regards,
> Jake Johnson
> jake@stripped
> 
> ______________________________________________________________________
> Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims,
> Car Audio, and Performance Parts.
> 
> 

-- 
  --------------------------------------------------------------------------
  Gustavo Baratto - Programming and Technical Support
  GBaratto@stripped * [phone] ext. 408

  Technical support web-site: http://support.superb.net
  Superb Internet Corp. "Ahead of the Rest"
  -------------------------------------------------------------------------