Re: Question related to MySQL and Threads and "Context_voluntary"

Mariella Petrini wrote:
> The same problem happens with only MyISAM table
> storage engine as well.
>
> The same problem occurs with 5.0.41 (32 bits compiled)
> and 5.1.20 (64 bits compiled)
>
>
> The platform is the following:
> Mac Pro (MacPro2,1)
> Quad-Core Intel Xeon, 3GHz and 2 processors.
> Total number of cores: 8
> L2 Cache (per processor): 8 MB
> Memory: 8 GB
> Bus Speed: 1.33 GHz
> Boot ROM Version: MP21.007F.B02
>
> (Kernel: 8.10.1 Darwin Kernel Version 8.10.1: Wed May
> 23 16:33:00 PDT 2007; root:xnu-792.22.5~1/RELEASE_I386
> i386 i386)
>
>
> The high increase in number of voluntary context
> switches and messages exchanged when the parallel
> increases might might be a clue multicore could not be
> exploited properly.
>

You may want to then try disabling cores and/or binding process to a core/processor and see if that improves performance. If it does, you can try tuning the OS thread scheduler and/or using processor-set/ process binding.
-Darpan
>
> Thanks in advance for your help,
>
> Mariella
>
>

-- 
MySQL Server Benchmarks Mailing List
For list archives: 
http://lists.mysql.com/benchmarks
To unsubscribe:    
http://lists.mysql.com/benchmarks?unsub=lists@pantek.com