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! | http://asterisk.org.ph
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?
On Fri, Oct 10, 2008 at 11:50, Mark Quitoriano <markquitoriano at gmail.com> 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 MyISAM tables (still the default), only one thread can access a table at a time, so you won't get more performance out of SMP to accesses to the same table. HTH, Filipe