[CentOS] mysql 5 for centos 5.2

[Filipe Brandenburger]

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