freebsd mysql a 2 procesory

[Martin Zdrazil]

Dekuji za priklady a odpoved. Vyzkousim to.

Martin Zdrazil

Miroslav Lachman wrote:
> 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