From owner-freebsd-performance@FreeBSD.ORG Fri May 11 16:15:05 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 716EC16A409 for ; Fri, 11 May 2007 16:15:04 +0000 (UTC) (envelope-from tasev@otel.net) Received: from admin.magstudio.eu (admin.magstudio.eu [85.14.38.18]) by mx1.freebsd.org (Postfix) with ESMTP id 2CCED13C465 for ; Fri, 11 May 2007 16:15:04 +0000 (UTC) (envelope-from tasev@otel.net) Received: from [212.73.129.82] (helo=hades.office.net) by admin.magstudio.eu with esmtpa (Exim 4.63) (envelope-from ) id 1HmQz3-0006XL-H1 for freebsd-performance@freebsd.org; Fri, 11 May 2007 12:00:21 +0300 Message-ID: <46443103.9010008@otel.net> Date: Fri, 11 May 2007 12:01:55 +0300 From: ivo tasev User-Agent: Thunderbird 2.0.0.0 (X11/20070424) MIME-Version: 1.0 To: freebsd-performance@freebsd.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Antivirus-Scanner: Clean mail though you should still use an Antivirus X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - admin.magstudio.eu X-AntiAbuse: Original Domain - freebsd.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - otel.net X-Source: X-Source-Args: X-Source-Dir: X-Mailman-Approved-At: Fri, 11 May 2007 16:30:20 +0000 Subject: 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: Fri, 11 May 2007 16:15:06 -0000 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:) best regards taseff