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
