Hello,
We have dual PIII Xeon 700MB memory box for mysql database running Solaris8
x86 + mu3.
After upgrading from 3.23.33 to 3.23.35 *average* speed downed ~ 50% -60%.
Output from "sar" command shows heavy stress of I/O system.
I use word "average", because we have more than 30 databases with different
structure and lot of different kind of sql queries.
Mysql used for web projects (Queries per second avg: 35.859).
Both mysql-3.23.35 and mysql-3.23.33 compiled from sources using gcc-2.95.2
and configured with:
--
#!/usr/bin/sh
CC=gcc CFLAGS="-O6" \
CXX=gcc CXXFLAGS="-O6 -felide-constructors -fno-exceptions -fno-rtti" \
./configure --prefix=/vol3/mysql \
--with-charset=cp1251 \
--without-debug \
--with-tcp-port=3306 \
--with-unix-socket-path=/tmp/mysql.sock \
--with-named-z-libs=z
--
From /etc/my.cnf:
--
[mysqld]
socket = /tmp/mysql.sock
tmpdir = /tmp/
port = 3306
skip-name-resolve
skip-locking
skip-grant-tables
low-priority-updates
delay-key-write-for-all-tables
log-slow-queries
set-variable = long_query_time=5
set-variable = thread_concurrency=8
set-variable = back_log=50
set-variable = key_buffer=256M
set-variable = max_allowed_packet=1M
set-variable = table_cache=256
set-variable = sort_buffer=8M
set-variable = record_buffer=1M
set-variable = thread_cache=4
set-variable = myisam_sort_buffer_size=64M
set-variable = tmp_table_size=16M
--
PS
Thanks for Mysql team, great project.
Alexander.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php