Re: mysql 5 for centos 5.2

["Mark Quitoriano" <markquitoriano@xxxxxxxxx>]

On Tue, Oct 14, 2008 at 12:29 PM, John R Pierce <pierce@xxxxxxxxxxxx> wrote:
> Mark Quitoriano wrote:
>>
>> What do you recommend me to do so i can optimize my database on a
>> multi-core processor? and i haven't got an answer for the mysql
>> package for centos 5 is the multi-threading supported?
>>
>
> each connection to mysql spawns a thread, however under various conditions
> the threads can block each other, including if they are stacking up on table
> locks to update the same table.
>
> otherwise, yes, mysql is fully multithreaded, as long as you're making
> multiple queries concurrently via different connections

oh ok got it. But as i can see that with my database server it only
eats up 1 core of my core2quad processor. how can i optimize mysql to
use all 4 core of my processor?


thanks again for the answers
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos