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:[EMAIL PROTECTED] 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 [EMAIL PROTECTED]
______________________________________________________________________ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts.
-- -------------------------------------------------------------------------- Gustavo Baratto - Programming and Technical Support [EMAIL PROTECTED] * (604) 638-2525 ext. 408
Technical support web-site: http://support.superb.net Superb Internet Corp. "Ahead of the Rest" -------------------------------------------------------------------------
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
