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>