performance problems after 2 or 3 days

[Alex F]

Hi there,

I have troubles running MySQL 4.1.15.

The server and client is compiled by myself using Debian sarge. It runs very fast and stable. But only for bout 2-3 days. Then the Server produces high load (> 4.XX ) even if there are no/few connections.

I tried to compile 2 - 3 versions. everytime the same problem...


Anybody knows that problem? Waht am I doing wrong?




More Informations:

I compiled it using following configure Line:

CFLAGS="-O3 -mpentiumpro" CXX=gcc CXXFLAGS="-O3 -mpentiumpro \
-felide-constructors -fno-exceptions -fno-rtti" ./configure \
--prefix=/usr \
--enable-assembler \
--with-mysqld-ldflags=-all-static \
--with-client-ldflags=-all-static \
--sysconfdir=/etc \
--libexecdir=/usr/sbin \
--mandir=/usr/share/man \
--with-mysqld-user=mysql \
--without-debug \
--without-docs \
--without-bench


# mysqladmin version
mysqladmin Ver 8.41 Distrib 4.1.15, for pc-linux-gnu on i686
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 4.1.15
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 3 min 24 sec

Threads: 2 Questions: 160 Slow queries: 0 Opens: 44 Flush tables: 1 Open tables: 38 Queries per second avg: 0.784