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 <kniel...@knielsen-hq.org> wrote: > Alexandre Almeida <alexan...@hti.com.br> 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@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > -- Mark Callaghan mdcal...@gmail.com _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
