[From nobody Tue Jul 21 15:41:07 2026
Received: (at submit) by bugs.debian.org; 28 Mar 2007 10:19:23 +0000
Return-path: <klar@mkm.de>
Received: from smtp.mkm.de ([194.15.190.5])
 by rietz.debian.org with esmtp (Exim 4.50) id 1HWV7X-0003AF-Oo
 for submit@bugs.debian.org; Wed, 28 Mar 2007 10:11:12 +0000
Received: from dbs.mkm.de (Debian-exim@dbs.mkm.de [172.24.1.99])
 by smtp.mkm.de (8.13.4/8.13.4/Debian-3sarge3) with ESMTP id l2SAB5hA015183
 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=NOT);
 Wed, 28 Mar 2007 12:11:09 +0200
Received: from root by dbs.mkm.de with local (Exim 4.63)
 (envelope-from <klar@mkm.de>)
 id 1HWV7P-0005wc-6h; Wed, 28 Mar 2007 12:11:03 +0200
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Ralf Thomas Klar <klar@mkm.de>
To: Debian Bug Tracking System <submit@bugs.debian.org>
Subject: mysql-server: Extremly poor MySQL performance due to scalability
 problems
Message-ID: <20070328101103.19395.98810.reportbug@dbs.mkm.de>
X-Mailer: reportbug 3.31
Date: Wed, 28 Mar 2007 12:11:03 +0200
Delivered-To: submit@bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 
 (1.212-2003-09-23-exp) on rietz.debian.org
X-Spam-Level: 
X-Spam-Status: No, hits=-9.0 required=4.0 tests=BAYES_00,HAS_PACKAGE 
 autolearn=ham version=2.60-bugs.debian.org_2005_01_02

Package: mysql-server
Version: 5.0.32-7etch1
Severity: normal


The problems named in http://ozlabs.org/~anton/linux/sysbench/ and
http://jeffr-tech.livejournal.com/6268.html#cutid1 are making the
mysql-server really slow. Jobs which should run in about 1 hour
need 4 hours. We could fix the problem using the ugly hack named
in http://ozlabs.org/~anton/linux/sysbench/ as advice: 

- compiling override_sched_setscheduler.c, but the name of the
  library has to start with "lib", for example liboverride.so
- backporting google-perftools-0.8 
- preloading mysql with liboverride.so and libtcmalloc.so



-- System Information:
Debian Release: 4.0
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-3-amd64
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)

Versions of packages mysql-server depends on:
ii  mysql-server-5.0           5.0.32-7etch1 mysql database server binaries

mysql-server recommends no packages.

-- no debconf information

]