[CentOS] mysql 5 for centos 5.2

On Sat, Oct 11, 2008 at 12:56 AM, Filipe Brandenburger
<filbranden at gmail.com> wrote:
> 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.
>

Hi,

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?

Thanks!