Thanks Marco Is there away to go arround this, perhaps not the most intelligent way but how about running multiple mysql servers in one server?
Do you know if postgresql behaves the same way as to the kernel resources and its cores? Thank you Andres On Wed, Apr 7, 2010 at 3:28 PM, Marco Peereboom <[email protected]> wrote: > No because mysql uses stupid threads instead of forking. > > On Wed, Apr 07, 2010 at 03:09:14PM -0600, Andres Salazar wrote: >> Greetings, >> >> Iam suing amd64 with generic.mp kernel, a quadcore processor and >> mysql from the multi threaded default compiled mysql from ports. Iam >> using sysbench-mysql to send 16 threads to mysql-server however iam >> observing that top always displays 1 core at 100% and the other cores >> basically idle. >> >> I have explored threat_concurrency in my.cnf however from what I >> understand this only helps when using more then one cpu. >> >> Is there a way to take advantage of all cores in OBSD, or is there a >> kernel limit that sees mysql as one single process and thus uses only >> a maximum of one core? >> >> Thank you >> >> Andres >> >
