MySQL slowness in SMP

[Gabor MICSKO]

On Fri, 2007-05-11 at 11:07 +0300, Abdullah Ibn Hamad Al-Marri wrote:
> Hello,

Hi!

I had the same problem, but i found this blog entry from Jeremy Zawodny:

http://jeremy.zawodny.com/blog/archives/000173.html

After i adjusted the wait_timeout and thread_cache_size, the problem is
gone. CPU utilization dropped significantly.

HTH

> I have dual xeon server with 2 GB of ram.
> 
> FreeBSD 6.2-STABLE #0: Tue Apr 24 11:32:50 GMT 2007
> arabian at noc:/usr/obj/usr/src/sys/NOC  i386
> 
> Which runs heavily MySQL with MyISAM, the problem I have it maxes out
> one cpu, and doesn't use the other one.
> 
> Could someone tell me what shall I do to make MySQL runs faster? it
> already uses libthr, cache beside MySQL optimized, I would like to use
> the power of both cpus.

> last pid: 79040;  load averages:  1.00,  1.01,  1.00
>                                     up 16+16:54:20  08:04:55
> 39 processes:  2 running, 37 sleeping
> CPU states: 26.9% user,  0.0% nice, 23.3% system,  0.0% interrupt,
> 49.8% idle
> Mem: 556M Active, 1154M Inact, 198M Wired, 93M Cache, 112M Buf, 3072K
> Free
> Swap: 5120M Total, 16K Used, 5120M Free
> 
>   PID USERNAME    THR PRI NICE   SIZE    RES STATE  C   TIME   WCPU
> COMMAND
> 90293 mysql        19 100    0   434M   187M ucond  1 176.6H 95.95%
> mysqld

-- 
Micskó Gábor
HP APS, AIS, ASE
Szintézis Zrt.
H-9023 Győr, Tihanyi Á. u. 2.
Tel: +36 96 502 216
Fax: +36 96 318 658
E-mail: gmicsko at szintezis.hu