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) !
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
More information about the freebsd-current
mailing list