Re: Possible Threading problem with -CURRENT / MySQL?

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