freebsd mysql a 2 procesory

[Miroslav Lachman]

Martin Zdrazil wrote:
[...]
> Ano, je to tak. (pasuji se za trotla dnesniho dne), kolega me nyni 
> ubezpecil, ze to jsou opravdu jednoprocesorove kompy s HTT, nevim proc 
> jsem si dodnes myslel ze jsou tam 2 procaky. Diky za nakopnuti.

Kdyby to byly dva fyzicke procesory a navic s podporou HTT (zapnutou v 
BIOSu, ale vypnutou v systemu - defaultne je HTT v systemu vypnute), tak 
by to naslo 4 CPU, jako je tomu tady (2x Xeon):
ACPI APIC Table: <IBM    SERONYXP>
Timecounter "i8254" frequency 1193182 Hz quality 0
CPU: Intel(R) Xeon(TM) CPU 3.00GHz (3000.13-MHz 686-class CPU)
   Origin = "GenuineIntel"  Id = 0xf41  Stepping = 1
 
Features=0xbfebfbff<FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,P
AT,PSE36,CLFLUSH,DTS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE>
   Features2=0x641d<SSE3,RSVD2,MON,DS_CPL,CNTX-ID,CX16,<b14>>
   AMD Features=0x20000000<LM>
   Hyperthreading: 2 logical CPUs
real memory  = 2147467264 (2047 MB)
avail memory = 2096533504 (1999 MB)
FreeBSD/SMP: Multiprocessor System Detected: 4 CPUs
  cpu0 (BSP): APIC ID:  0
  cpu1 (AP): APIC ID:  1
  cpu2 (AP): APIC ID:  6
  cpu3 (AP): APIC ID:  7

HTT se da pres sysctl zapinat/vypinat za behu systemu.

System s jednim fyzickym CPU, ale dvema jadry se pak hlasi takhle (1x 
Pentium D)

MPTable: <Intel    P5MT-R      >
Timecounter "i8254" frequency 1193182 Hz quality 0
CPU: Intel(R) Pentium(R) D CPU 3.00GHz (3000.12-MHz 686-class CPU)
   Origin = "GenuineIntel"  Id = 0xf62  Stepping = 2
 
Features=0xbfebfbff<FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,P
AT,PSE36,CLFLUSH,DTS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE>
   Features2=0xe43d<SSE3,RSVD2,MON,DS_CPL,VMX,CNTX-ID,CX16,<b14>,<b15>>
   AMD Features=0x20100000<NX,LM>
   AMD Features2=0x1<LAHF>
   Cores per package: 2
real memory  = 536739840 (511 MB)
avail memory = 515739648 (491 MB)
FreeBSD/SMP: Multiprocessor System Detected: 2 CPUs
  cpu0 (BSP): APIC ID:  0
  cpu1 (AP): APIC ID:  1


Takze tim je vysvetlen vas problem se 100% idle CPU, resenim je tedy bud 
vypnout HTT i v BIOSu, cimz mozna system prestane detekovat druhy CPU 
(to jsem nikdy nezkousel, tak to nemam overene) a nebo zapnout podporu 
HTT v systemu sysctl machdep.hyperthreading_allowed=1

Pokud je MySQL zkompilovano dynamicky a pouzije se libmap.conf jak jsem 
predtim uvedl, tak by HTT mel mirne zlepsit vykon MySQL, pokud se 
pouzije vychozi libpthread.so, tak je HTT spise zpomalenim (alespon dle 
mych zkusenosti)... a jak se s HTT vyporadaji ostatni aplikace na tom 
serveru, to uz vubec netusim.

Miroslav Lachman