Re: [CentOS] mysql 5 for centos 5.2

2008-10-15 Thread Mark Quitoriano
On Tue, Oct 14, 2008 at 12:29 PM, John R Pierce [EMAIL PROTECTED] 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

Re: [CentOS] mysql 5 for centos 5.2

2008-10-15 Thread John R Pierce
Mark Quitoriano wrote: 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? you said you had 50-100 simultaneous connections to mysql? these are presumably issuing various

Re: [CentOS] mysql 5 for centos 5.2

2008-10-13 Thread Mark Quitoriano
On Sat, Oct 11, 2008 at 12:03 AM, John R Pierce [EMAIL PROTECTED] wrote: Mark Quitoriano wrote: HI, Does the mysql in centos compiled with multi processor support? i have a mysql in centos 5 running in a core2duo processor and it seems that it only uses 1 processor. how many connections

Re: [CentOS] mysql 5 for centos 5.2

2008-10-13 Thread Mark Quitoriano
On Sat, Oct 11, 2008 at 12:56 AM, Filipe Brandenburger [EMAIL PROTECTED] wrote: On Fri, Oct 10, 2008 at 11:50, Mark Quitoriano [EMAIL PROTECTED] wrote: Does the mysql in centos compiled with multi processor support? i have a mysql in centos 5 running in a core2duo processor and it seems that

Re: [CentOS] mysql 5 for centos 5.2

2008-10-13 Thread John R Pierce
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

[CentOS] mysql 5 for centos 5.2

2008-10-10 Thread Mark Quitoriano
HI, Does the mysql in centos compiled with multi processor support? i have a mysql in centos 5 running in a core2duo processor and it seems that it only uses 1 processor. -- Regards, Mark Quitoriano Blog | http://mark.quitoriano.org VicidialNOW! | http://www.vicidialnow.com APUG!

Re: [CentOS] mysql 5 for centos 5.2

2008-10-10 Thread John R Pierce
Mark Quitoriano wrote: HI, Does the mysql in centos compiled with multi processor support? i have a mysql in centos 5 running in a core2duo processor and it seems that it only uses 1 processor. how many connections are you making to mysql? ___

Re: [CentOS] mysql 5 for centos 5.2

2008-10-10 Thread Filipe Brandenburger
On Fri, Oct 10, 2008 at 11:50, Mark Quitoriano [EMAIL PROTECTED] wrote: Does the mysql in centos compiled with multi processor support? i have a mysql in centos 5 running in a core2duo processor and it seems that it only uses 1 processor. How many tables are you querying in MySQL? If you use