maria-discuss team mailing list archive

[MARK CALLAGHAN <mdcallag@xxxxxxxxx>]

And then because this is Sun CoolThread hardware, each connection runs
on really, really slow CPUs. And 48 threads running concurrently will
get a lot of mutex contention from MySQL so maybe running 4 copies of
mysqld with each instance locked down to 12 CoolThread CPUs will help.

On Sun, Apr 3, 2011 at 11:07 PM, Kristian Nielsen
<knielsen@xxxxxxxxxxxxxxx> wrote:
> Alexandre Almeida <alexandre@xxxxxxxxxx> writes:
>
>>       As far as I can see MariaDB stay locked/running on a single
>> virtual  CPU and MariaDB doesn't take advantage of CoolThread/CMT
>> technologies,  I mean it can not run on more than one virtual CPU same
>> time. Result:  poor performance.
>>
>>       Anybody knows if there is something can I do to spread ;-)
>> MariaDB  all over cpus? Am I missing something?
>
> Each client connection will run on its own cpu. So to use all cpus your
> application needs to run many queries in parallel.
>
>  - Kristian.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Mark Callaghan
mdcallag@xxxxxxxxx