From owner-freebsd-amd64@FreeBSD.ORG Sat Jul 30 07:39:56 2005 Return-Path: X-Original-To: freebsd-amd64@freebsd.org Delivered-To: freebsd-amd64@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 71E8316A41F for ; Sat, 30 Jul 2005 07:39:56 +0000 (GMT) (envelope-from freebsd-amd64@molecon.ru) Received: from amd64.molecon.ru (amd64.molecon.ru [213.219.245.153]) by mx1.FreeBSD.org (Postfix) with ESMTP id F03E143D45 for ; Sat, 30 Jul 2005 07:39:53 +0000 (GMT) (envelope-from freebsd-amd64@molecon.ru) Received: from [194.154.84.49] (helo=[10.20.5.22]) by amd64.molecon.ru with esmtp (Exim 4.51 (FreeBSD)) id 1Dylwi-000ChB-7T for freebsd-amd64@freebsd.org; Sat, 30 Jul 2005 11:39:48 +0400 Date: Sat, 30 Jul 2005 11:39:27 +0400 From: Oleg Rusanov X-Mailer: The Bat! (v3.0) Professional Organization: Molecon X-Priority: 3 (Normal) Message-ID: <1812296880.20050730113927@molecon.ru> To: freebsd-amd64 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-PopBeforeSMTPSenders: freebsd-amd64@molecon.ru, freebsd-opennet@molecon.ru, freebsd-security@molecon.ru, info@molecon.ru, mysql@molecon.ru, oleg@molecon.ru X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - amd64.molecon.ru X-AntiAbuse: Original Domain - freebsd.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [26 6] X-AntiAbuse: Sender Address Domain - molecon.ru X-Source: X-Source-Args: X-Source-Dir: Subject: Mysql 4.1. my-large.cnf or my-medium.cnf? Dual Opteron web server 2gb memory X-BeenThere: freebsd-amd64@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Oleg Rusanov List-Id: Porting FreeBSD to the AMD64 platform List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 30 Jul 2005 07:39:56 -0000 Hello. my-large.cnf is twice quicklier, but the description from my-medium.cnf is approaches (such as a web server). It is necessary that Mysql worked twice more slowly on a web server? amd64# uname -r 5.4-STABLE make WITH_XCHARSET=all BUILD_OPTIMIZED=yes BUILD_STATIC=yes install --------------------------my-medium.cnf-------------------------------------- description: # This is for a system with little memory (32M - 64M) where MySQL plays # an important part, or systems up to 128M where MySQL is used together with # other programs (such as a web server) test: Query Barrel Report for client smacker1 connect: max=4ms min=2ms avg= 2ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 20000 0 0 11858.11 --------------------------/my-medium.cnf-------------------------------------- --------------------------my-large.cnf-------------------------------------- description: # This is for a large system with memory = 512M where the system runs mainly # MySQL. test: Query Barrel Report for client smacker1 connect: max=4ms min=2ms avg= 2ms from 10 clients Query_type num_queries max_time min_time q_per_s select_index 20000 0 0 21777.24 --------------------------/my-large.cnf-------------------------------------- -- Regards, Oleg Rusanov Molecon mailto:freebsd-amd64@molecon.ru