>Description:
After upgrading from OpenBSD 2.8 to 3.0 and upgrading MySQL from 3.23.27
to 3.23.42 from the OpenBSD ports tree the load mysql generates seems to
have roughly doubled, while the number of update/insert/select queries have
remained the same.
>How-To-Repeat:
Running approx 612 q/m generates a system load average of 5.25, while
previously the same query
would generate a load of approx 2.30
>Fix:
unknown
>Submitter-Id: shoeke
>Originator: Steffan Hoeke
>Organization:
N/A
>MySQL support: none
>Synopsis: MySQL generates "too high" a load compared to before upgrade
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.42 (Source distribution)
>Server: /usr/local/bin/mysqladmin Ver 8.21 Distrib 3.23.42, for unknown-openbsd3.0
>on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.42
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/mysql/mysql.sock
Uptime: 2 days 7 hours 6 min 30 sec
Threads: 22 Questions: 1081224 Slow queries: 3 Opens: 27 Flush tables: 1 Open
tables: 16 Queries per second avg: 5.450
>Environment:
Machine: i386
OS: OpenBSD
CPU: Pentium Pro 200
System: OpenBSD TheRookie 3.0 TheRookie#0 i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-unknown-openbsd3.0/2.95.3/specs
gcc version 2.95.3 20010125 (prerelease)
Compilation info: CC='cc' CFLAGS='-O2 ' CXX='c++' CXXFLAGS='-O2 '
LDFLAGS='-L/usr/local/lib/pth'
LIBC:
-r--r--r-- 1 root bin 729068 Oct 18 22:25 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 12 Mar 19 2001 /usr/lib/libc.so.23.1 -> libc.so.26.2
lrwxr-xr-x 1 root wheel 21 Mar 20 2001 /usr/lib/libc.so.24.4 ->
/usr/lib/libc.so.26.2
lrwxr-xr-x 1 root wheel 12 Mar 18 2001 /usr/lib/libc.so.25.0 -> libc.so.26.2
-r--r--r-- 1 root bin 589944 Mar 15 2001 /usr/lib/libc.so.26.2
-r--r--r-- 1 root bin 594173 Oct 18 22:25 /usr/lib/libc.so.28.0
Configure command: ./configure --enable-shared --enable-static
--localstatedir=/var/mysql --with-libwrap=/usr --with-mysqld-user=mysql
--with-unix-socket-path=/var/mysql/mysql.sock --without-perl --without-debug
--without-readline --without-bench --without-mit-threads --without-gemini
--without-berkeley-db --without-innodb --prefix=/usr/local --sysconfdir=/etc
---------------------------------------------------------------------
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
