Low perf with smp

[Mark Kirkwood]

Eric wrote:
> I know Pete but I downgrad because when installing 6.0 performance was 
> half than with 4.11.
> I done tests and tests but still have very low perfs. I then downdgrad 
> to 4.11 to see if it came from hardware or software.
> Conclusion is that my test wich is consist of loop of mysql query done 
> by a php script take :
> 
>             - 32 sec with 4.11 without SMP
>            - 54 sec with 4.11 with SMP
>            - 62 sec with 6.0 or 6.1 beta 4
> 
> That's why actually I'm with 4.11.
> 
> If you have any idea how improve perfs with 6.0 it will be a pleasure.
> Hardware is new dell 1850 with bi-xeon dualcore 2.8Ghz and scsi 15.000t 
> HDD on raid1 perc4si 256Mo  controller.

If you could post, or link to your mysql query and php script, then I 
(or in fact anyone) could try to reproduce this (I've got two almost 
identical machines running 6.0, so could downgrade one to 4.x.).

In addition, what versions of php and mysql are you using?

Cheers

Mark