From owner-freebsd-performance@FreeBSD.ORG Mon May 14 14:10:12 2007 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id A276D16A403 for ; Mon, 14 May 2007 14:10:12 +0000 (UTC) (envelope-from gofp-freebsd-performance@m.gmane.org) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mx1.freebsd.org (Postfix) with ESMTP id 3202B13C4AD for ; Mon, 14 May 2007 14:10:11 +0000 (UTC) (envelope-from gofp-freebsd-performance@m.gmane.org) Received: from root by ciao.gmane.org with local (Exim 4.43) id 1HnbFS-0004kH-Qk for freebsd-performance@freebsd.org; Mon, 14 May 2007 16:10:02 +0200 Received: from synergetica.dn.ua ([82.207.115.117]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 14 May 2007 16:10:02 +0200 Received: from c.kworr by synergetica.dn.ua with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 14 May 2007 16:10:02 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-performance@freebsd.org From: Volodymyr Kostyrko Date: Mon, 14 May 2007 16:19:29 +0300 Lines: 54 Message-ID: References: <46443103.9010008@otel.net> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: synergetica.dn.ua User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; ru-RU; rv:1.8.1.2) Gecko/20070302 SeaMonkey/1.1.1 In-Reply-To: <46443103.9010008@otel.net> Sender: news X-Mailman-Approved-At: Mon, 14 May 2007 16:05:40 +0000 Subject: Re: 6.2 Stable + Mysql 5.0 poor performance X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 14 May 2007 14:10:12 -0000 ivo tasev wrote: > Hi all, > i have machine with 2 x Quad Core Xeon cpu`s 2G ram and 4 3ware disks in > raid10. There is 6.2 Stable on it and mysql 5.0 from the ports. > > The mysql is installed with the following build options: > WITH_XCHARSET=all WITH_OPENSSL=yes BUILD_OPTIMIZED=yes WITH_ARCHIVE=yes > WITH_FEDERATED=yes WITH_NDB=yes > > I`m using libmap.conf with this in it: > > [mysqld] > libpthread.so.2 libthr.so.2 > > This is what I have in my.cnf : > > set-variable = key_buffer=1024M > set-variable = max_allowed_packet=64M > set-variable = thread_stack=1024K > set-variable = read_buffer_size=2M > set-variable = read_buffer_size=2M > > set-variable = max_connections=350 > set-variable = interactive_timeout=100 > set-variable = wait_timeout=120 > set-variable = max_user_connections=340 > > set-variable = query_cache_limit=1M > set-variable = query_cache_size=32M > set-variable = query_cache_type=1 > > set-variable = table_cache=1024 > set-variable = thread_cache=128 > set-variable = thread_cache_size=40 > set-variable = thread_concurrency=16 > > I`m performing the following test with super-smack: > :~# time super-smack -d mysql > /usr/local/share/super-smack/select-key.smack 10 10000 > > the results are:Query Barrel Report for client smacker1 > connect: max=1ms min=0ms avg= 0ms from 10 clients > Query_type num_queries max_time min_time q_per_s > select_index 200000 0 0 18599.71 > > I can achieve better performance even on my colleague`s notebook with > 6.2 stable !? > > I`ll be very thankful if someone can give me any ideas:) Try looking at hard drive usage. -- Sphinx of black quartz judge my vow!