From owner-freebsd-stable@FreeBSD.ORG Fri Apr 24 19:19:16 2009 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 60287106564A for ; Fri, 24 Apr 2009 19:19:16 +0000 (UTC) (envelope-from karl@denninger.net) Received: from FS.denninger.net (wsip-70-169-168-7.pn.at.cox.net [70.169.168.7]) by mx1.freebsd.org (Postfix) with ESMTP id 05FFD8FC17 for ; Fri, 24 Apr 2009 19:19:15 +0000 (UTC) (envelope-from karl@denninger.net) Received: from [127.0.0.1] (localhost [127.0.0.1]) by FS.denninger.net (8.14.3/8.13.1) with SMTP id n3OJJFms029199 for ; Fri, 24 Apr 2009 14:19:15 -0500 (CDT) (envelope-from karl@denninger.net) Received: from [127.0.0.1] [192.168.1.40] by Spamblock-sys (LOCAL); Fri Apr 24 14:19:15 2009 Message-ID: <49F210B1.7070300@denninger.net> Date: Fri, 24 Apr 2009 14:19:13 -0500 From: Karl Denninger User-Agent: Thunderbird 2.0.0.21 (Windows/20090302) MIME-Version: 1.0 To: Ivan Voras References: In-Reply-To: Content-Type: multipart/mixed; boundary="------------070402040509060400070704" X-Antivirus: avast! (VPS 090423-0, 04/23/2009), Outbound message X-Antivirus-Status: Clean X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: freebsd-stable@freebsd.org Subject: Re: Evaluating the performance of a single FreeBSD server X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 24 Apr 2009 19:19:16 -0000 This is a multi-part message in MIME format. --------------070402040509060400070704 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit I agree. Beware high-volume DBMS transaction work. The structure of those SQL transactions is CRITICAL and that can easily be the bottleneck - especially if the indices and structure are poorly designed or simply won't fit in-core for most of the transactions. Ivan Voras wrote: > Michel Di Croci wrote: > > >> colocation environment) and use it as a starting server and runs an Apache + >> PHP + PostgreSQL (for a long run stable and expandable DB). If it starts to >> > > Even if we forget everything else you said, "Apache + PHP + PostgreSQL" > means you have at least ... BOTE calculation ... at least 24 different > combinations of how these components interact with each other and each > has different performance characteristics. > > You need to give us much more information before something meaningful > can be concluded. In general, 90% of your performance issues will be in > the application (PHP code, not PHP itself) and the database (structure, > indexes, etc.). Assuming you have a decent application architecture, > database schema and enough bandwidth, can you think of a similar already > existing web application so people can have a baseline when giving you > advice? (Don't think "Google" ... think of a smaller application which > can be compared in size to yours). > > > -- -- Karl Denninger karl@denninger.net --------------070402040509060400070704--