Possible Threading problem with -CURRENT / MySQL?

Martin Blapp mb at imp.ch
Tue Jun 15 15:10:37 GMT 2004

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) !

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:

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

real memory  = 2147397632 (2047 MB)
avail memory = 2095964160 (1998 MB)
FreeBSD/SMP: Multiprocessor System Detected: 2 CPUs
 cpu0 (BSP): APIC ID:  0
 cpu1 (AP): APIC ID:  6

Hope this helps anybody:

More information about the freebsd-current mailing list