Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 15 Jun 2004 17:09:51 +0200 (CEST)
From:      Martin Blapp <mb@imp.ch>
To:        mike <mike@mike2k.com>
Cc:        freebsd-threads@freebsd.org
Subject:   Re: Possible Threading problem with -CURRENT / MySQL?
Message-ID:  <20040615170316.T84297@cvs.imp.ch>
In-Reply-To: <Pine.LNX.4.53.0406141119100.3417@sql01.internal.mikehost.net>
References:  <01c301c45239$940781f0$6401a8c0@animal> <Pine.LNX.4.53.0406141119100.3417@sql01.internal.mikehost.net>

next in thread | previous in thread | raw e-mail | index | archive | help

Hi all,

Just to list our working setup:

(I don't know if mysql is very fast, but since I rewrote all mysql queries to
use  LEFT/RIGHT JOIN and UNION and redesigned the databases, the mysql load is
not significant anymore)

Has someone a test database and e benchmark tool ?

- We use SCHED_4BSD.
- HTT is disabled in the BIOS
- WITNESS and INVARIANTS are turned off (important) !

uptime
5:07PM  up 35 days,  3:52, 9 users, load averages: 2.27, 1.70, 1.54

No hangs and crashes or lockups.

38073 idms      20  -15 55160K 17200K kserel 0  26:45  0.00%  0.00% mysqld

my.cnf config:

[mysqld]
skip-innodb
set-variable    = max_connections=1000
set-variable    = key_buffer_size=16M
set-variable    = table_cache=256
set-variable    = record_buffer=1M
set-variable    = sort_buffer=16M

CPU: Intel(R) Xeon(TM) CPU 3.06GHz (3059.98-MHz 686-class CPU)
  Origin = "GenuineIntel"  Id = 0xf27  Stepping = 7

Features=0xbfebfbff<FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CLFLUSH,DTS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE>
real memory  = 2147397632 (2047 MB)
avail memory = 2095964160 (1998 MB)
ACPI APIC Table: <IBM    SERONYXP>
FreeBSD/SMP: Multiprocessor System Detected: 2 CPUs
 cpu0 (BSP): APIC ID:  0
 cpu1 (AP): APIC ID:  6

Hope this helps anybody:
Martin



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040615170316.T84297>