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-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? >>

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 thre

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

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

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

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? ___ C

[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!