Date: Fri, 11 May 2007 13:41:11 +0200 From: Gabor MICSKO <gmicsko@gmail.com> To: Abdullah Ibn Hamad Al-Marri <almarrie@gmail.com> Cc: freebsd-current@freebsd.org, FreeBSD Questions <freebsd-questions@freebsd.org> Subject: Re: MySQL slowness in SMP Message-ID: <1178883671.6053.10.camel@localhost.localdomain> In-Reply-To: <499c70c0705110107u77f96543le8e2017cda71b67a@mail.gmail.com> References: <499c70c0705110107u77f96543le8e2017cda71b67a@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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@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@szintezis.hu
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1178883671.6053.10.camel>