Hi Mark, It makes sense. Thanks. Alex Em 04/04/2011, às 10:55, MARK CALLAGHAN escreveu:
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@knielsen-hq.org> wrote:
Alexandre Almeida <alexandre@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 mdcallag@gmail.com