From owner-freebsd-isp@FreeBSD.ORG Tue Aug 2 14:24:10 2005 Return-Path: X-Original-To: freebsd-isp@freebsd.org Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 31DD516A41F for ; Tue, 2 Aug 2005 14:24:10 +0000 (GMT) (envelope-from troy@psknet.com) Received: from psknet.com (kennedy.psknet.com [63.171.251.9]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9206243D6B for ; Tue, 2 Aug 2005 14:24:07 +0000 (GMT) (envelope-from troy@psknet.com) Received: from pool-70-110-6-88.roa.east.verizon.net ([70.110.6.88] helo=[192.168.1.102]) by psknet.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.43 (FreeBSD)) id 1Dzxgc-0005WV-GU for freebsd-isp@freebsd.org; Tue, 02 Aug 2005 10:24:06 -0400 Message-ID: <42EF8206.5000505@psknet.com> Date: Tue, 02 Aug 2005 10:24:06 -0400 From: Troy Settle User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050723) X-Accept-Language: en-us, en MIME-Version: 1.0 To: freebsd-isp@freebsd.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: MySQL Performance X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 02 Aug 2005 14:24:10 -0000 I've a 4-STABLE box on a Dual Xeon w/4GB and U320 RAID: 4.11-STABLE FreeBSD 4.11-STABLE #7: Fri Mar 11 20:24:25 EST 2005 10:05AM up 55 days, 14:38, 3 users, load averages: 1.07, 1.10, 1.13 Running on this box, is MySQL 4.0.23a (a little outdated, I know). This MySQL server seems to run fine as long as I watch it, but as soon as I turn my head for a moment, it jumps up to ~97% CPU usage: 508 mysql 63 0 99M 51660K CPU0 0 306.9H 97.46% 97.46% mysqld It doesn't appear to be an IO issue, 300 samples from iostat show a max of 0.31 MB/s. It also doesn't appear to be a memory issue: 867M Active, 2354M Inact, 320M Wired, 192M Cache, 199M Buf, 40M Free Swap: 4096M Total, 16K Used, 4096M Free Through a number of samples from sockstat(1), I see ~20 connections to mysql at any given time. 5 for Courier's authdaemon, 3 for Exim, and ~12 for Apache/PHP. There are intermitant connections from Windows clients using MyODBC, but none are persistant. Restarting any/all of these processes does not cause mysql to ease up on the CPU. Only restarting MySQL will buy releif, but after a few weeks, it's right back to 97% CPU usage. The machine itself is completely responsive, mysql is completely responsive. The tables in question are flat, with only a few thousand entries in the largest. Queries range from simple to semi-complex. I can't identify the source of the load. Can anyone help? What should I be looking at? Thanks, -- Troy Settle Pulaski Networks http://www.psknet.com 866.477.5638 From owner-freebsd-isp@FreeBSD.ORG Tue Aug 2 14:37:25 2005 Return-Path: X-Original-To: freebsd-isp@freebsd.org Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 133D416A41F for ; Tue, 2 Aug 2005 14:37:25 +0000 (GMT) (envelope-from steve.rieger@tbwachiat.com) Received: from mail83-red-R.bigfish.com (mail-red.bigfish.com [216.148.222.61]) by mx1.FreeBSD.org (Postfix) with ESMTP id ACEFB43D4C for ; Tue, 2 Aug 2005 14:37:24 +0000 (GMT) (envelope-from steve.rieger@tbwachiat.com) Received: from mail83-red.bigfish.com (localhost.localdomain [127.0.0.1]) by mail83-red-R.bigfish.com (Postfix) with ESMTP id 7AD8F3C47E8 for ; Tue, 2 Aug 2005 14:37:24 +0000 (UTC) X-BigFish: VP Received: by mail83-red.bigfish.com (MessageSwitch) id 1122993443987058_26364; Tue, 2 Aug 2005 14:37:23 +0000 (UCT) Received: from tbwachiat.com (unknown [208.244.203.7]) (using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits)) (No client certificate requested) by mail83-red.bigfish.com (Postfix) with ESMTP id BB48F3C450E for ; Tue, 2 Aug 2005 14:37:23 +0000 (UTC) Received: from [10.20.4.247] steve_rieger [10.20.4.247] by tbwachiat.com with NetMail SMTP Agent $Revision: 3.22.1.16 $ on Novell NetWare via secured & encrypted transport (TLS); Tue, 02 Aug 2005 10:37:22 -0400 In-Reply-To: <42EF8206.5000505@psknet.com> References: <42EF8206.5000505@psknet.com> Mime-Version: 1.0 (Apple Message framework v733) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: Steve Rieger Date: Tue, 2 Aug 2005 10:37:23 -0400 To: Troy Settle X-Mailer: Apple Mail (2.733) Cc: freebsd-isp@freebsd.org, Steve Rieger Subject: Re: MySQL Performance X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 02 Aug 2005 14:37:25 -0000 are you logging if so how large are your log files -- Steve Rieger AIM chozrim ICQ 53956607 Cell 646 335 8915 steve.rieger@tbwachiat.com On Aug 2, 2005, at 10:24 AM, Troy Settle wrote: > > I've a 4-STABLE box on a Dual Xeon w/4GB and U320 RAID: > > 4.11-STABLE FreeBSD 4.11-STABLE #7: Fri Mar 11 20:24:25 EST 2005 > 10:05AM up 55 days, 14:38, 3 users, load averages: 1.07, 1.10, 1.13 > > Running on this box, is MySQL 4.0.23a (a little outdated, I know). > This MySQL server seems to run fine as long as I watch it, but as > soon as I turn my head for a moment, it jumps up to ~97% CPU usage: > > 508 mysql 63 0 99M 51660K CPU0 0 306.9H 97.46% 97.46% > mysqld > > It doesn't appear to be an IO issue, 300 samples from iostat show a > max of 0.31 MB/s. > > It also doesn't appear to be a memory issue: > > 867M Active, 2354M Inact, 320M Wired, 192M Cache, 199M Buf, 40M Free > Swap: 4096M Total, 16K Used, 4096M Free > > Through a number of samples from sockstat(1), I see ~20 connections > to mysql at any given time. 5 for Courier's authdaemon, 3 for > Exim, and ~12 for Apache/PHP. There are intermitant connections > from Windows clients using MyODBC, but none are persistant. > Restarting any/all of these processes does not cause mysql to ease > up on the CPU. Only restarting MySQL will buy releif, but after a > few weeks, it's right back to 97% CPU usage. > > The machine itself is completely responsive, mysql is completely > responsive. The tables in question are flat, with only a few > thousand entries in the largest. Queries range from simple to semi- > complex. > > I can't identify the source of the load. Can anyone help? What > should I be looking at? > > Thanks, > > -- > Troy Settle > Pulaski Networks > http://www.psknet.com > 866.477.5638 > _______________________________________________ > freebsd-isp@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-isp > To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org" > > > This e-mail is intended only for the named person or entity to which it is addressed and contains valuable business information that is privileged, confidential and/or otherwise protected from disclosure. Dissemination, distribution or copying of this e-mail or the information herein by anyone other than the intended recipient, or an employee or agent responsible for delivering the message to the intended recipient, is strictly prohibited. All contents are the copyright property of TBWA\Chiat\Day, its agencies or a client of such agencies. If you are not the intended recipient, you are nevertheless bound to respect the worldwide legal rights of TBWA\Chiat\Day, its agencies and its clients. We require that unintended recipients delete the e-mail and destroy all electronic copies in their system, retaining no copies in any media. If you have received this e-mail in error, please immediately notify us via e-mail to disclaimer@tbwachiat.com. We appreciate your cooperation. We make no warranties as to the accuracy or completeness of this e-mail and accept no liability for its content or use. Any opinions expressed in this e-mail are those of the author and do not necessarily reflect the opinions of TBWA\Chiat\Day or any of its agencies or affiliates. From owner-freebsd-isp@FreeBSD.ORG Tue Aug 2 14:39:39 2005 Return-Path: X-Original-To: freebsd-isp@freebsd.org Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id B6E0916A41F for ; Tue, 2 Aug 2005 14:39:39 +0000 (GMT) (envelope-from volfman@keystreams.com) Received: from mailbox.keystreams.com (mailbox.keystreams.com [207.158.28.37]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5E9FA43D5C for ; Tue, 2 Aug 2005 14:39:39 +0000 (GMT) (envelope-from volfman@keystreams.com) Received: (qmail 84179 invoked by uid 1012); 2 Aug 2005 07:35:24 -0700 Received: from 10.8.0.6 by mail.keystreams.com (envelope-from , uid 1009) with qmail-scanner-1.25-st-qms (ClamAV 0.86.1. spamassassin: 3.0.4. perlscan: 1.25-st-qms. Clear:RC:0(10.8.0.6):SA:0(-5.9/5.0):. Processed in 3.072924 secs); 02 Aug 2005 14:35:24 -0000 X-Spam-Status: No, hits=-5.9 required=5.0 X-Antivirus-Keystreams-Mail-From: volfman@keystreams.com via mail.keystreams.com X-Antivirus-Keystreams: 1.25-st-qms (Clear:RC:0(10.8.0.6):SA:0(-5.9/5.0):. Processed in 3.072924 secs Process 84168) Received: from unknown (HELO ?10.8.0.6?) (volfman@keystreams.com@10.8.0.6) by mailbox.keystreams.com with AES256-SHA encrypted SMTP; 2 Aug 2005 07:35:20 -0700 Message-ID: <42EF85A7.2000103@keystreams.com> Date: Tue, 02 Aug 2005 07:39:35 -0700 From: Roman Volf User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Troy Settle , freebsd-isp@freebsd.org References: <42EF8206.5000505@psknet.com> In-Reply-To: <42EF8206.5000505@psknet.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: Subject: Re: MySQL Performance X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 02 Aug 2005 14:39:39 -0000 Troy Settle wrote: > > I've a 4-STABLE box on a Dual Xeon w/4GB and U320 RAID: > > 4.11-STABLE FreeBSD 4.11-STABLE #7: Fri Mar 11 20:24:25 EST 2005 > 10:05AM up 55 days, 14:38, 3 users, load averages: 1.07, 1.10, 1.13 > > Running on this box, is MySQL 4.0.23a (a little outdated, I know). > This MySQL server seems to run fine as long as I watch it, but as soon > as I turn my head for a moment, it jumps up to ~97% CPU usage: > > 508 mysql 63 0 99M 51660K CPU0 0 306.9H 97.46% 97.46% mysqld > > It doesn't appear to be an IO issue, 300 samples from iostat show a > max of 0.31 MB/s. > > It also doesn't appear to be a memory issue: > > 867M Active, 2354M Inact, 320M Wired, 192M Cache, 199M Buf, 40M Free > Swap: 4096M Total, 16K Used, 4096M Free > > Through a number of samples from sockstat(1), I see ~20 connections to > mysql at any given time. 5 for Courier's authdaemon, 3 for Exim, and > ~12 for Apache/PHP. There are intermitant connections from Windows > clients using MyODBC, but none are persistant. Restarting any/all of > these processes does not cause mysql to ease up on the CPU. Only > restarting MySQL will buy releif, but after a few weeks, it's right > back to 97% CPU usage. > > The machine itself is completely responsive, mysql is completely > responsive. The tables in question are flat, with only a few thousand > entries in the largest. Queries range from simple to semi-complex. > > I can't identify the source of the load. Can anyone help? What > should I be looking at? > > Thanks, > > -- > Troy Settle > Pulaski Networks > http://www.psknet.com > 866.477.5638 > _______________________________________________ > freebsd-isp@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-isp > To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org" Have you tried compiling WITH_LINUXTHREADS=yes BUILD_OPTIMIZED=yes BUILD_STATIC=yes (if you are compiling from ports). I had similar issues on FreeBSD 5.3 and this helped alot. Also, are you logging slow queries? Maybe there is a single query causing the problem? -- Roman Volf Keystreams Internet Solutions volfman@keystreams.com From owner-freebsd-isp@FreeBSD.ORG Tue Aug 2 14:46:08 2005 Return-Path: X-Original-To: freebsd-isp@freebsd.org Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 84D6716A41F for ; Tue, 2 Aug 2005 14:46:08 +0000 (GMT) (envelope-from james@jpri.com) Received: from gandalf.jpri.com (gandalf.jpri.com [69.57.152.82]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2F32843D53 for ; Tue, 2 Aug 2005 14:46:03 +0000 (GMT) (envelope-from james@jpri.com) Received: (qmail 3153 invoked by uid 89); 3 Aug 2005 05:13:56 -0000 Received: from cpe240.txcyber.com (HELO ?192.168.0.155?) (james@jpri.com@208.21.199.240) by gandalf.jpri.com with SMTP; 3 Aug 2005 05:13:56 -0000 Message-ID: <42EF8714.9020409@jpri.com> Date: Tue, 02 Aug 2005 09:45:40 -0500 From: James Ryan User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: freebsd-isp@freebsd.org References: <42EF8206.5000505@psknet.com> In-Reply-To: <42EF8206.5000505@psknet.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: MySQL Performance X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 02 Aug 2005 14:46:08 -0000 Try enabling slow query logging, as well as maybe try to isolate if the load is coming from any particular query... If you are performing joins on the 1k+ rows table, maybe MySQL has ran out of memory and is copying the query results to a tmp table on the disk. Sometimes this can cause a jump in CPU usage... You can determine if this is the case by mysqladmin processlist; it will say something like "Copying to tmp table". Check for slow queries though... Cheers, James Troy Settle wrote: > > I've a 4-STABLE box on a Dual Xeon w/4GB and U320 RAID: > > 4.11-STABLE FreeBSD 4.11-STABLE #7: Fri Mar 11 20:24:25 EST 2005 > 10:05AM up 55 days, 14:38, 3 users, load averages: 1.07, 1.10, 1.13 > > Running on this box, is MySQL 4.0.23a (a little outdated, I know). This > MySQL server seems to run fine as long as I watch it, but as soon as I > turn my head for a moment, it jumps up to ~97% CPU usage: > > 508 mysql 63 0 99M 51660K CPU0 0 306.9H 97.46% 97.46% mysqld > > It doesn't appear to be an IO issue, 300 samples from iostat show a max > of 0.31 MB/s. > > It also doesn't appear to be a memory issue: > > 867M Active, 2354M Inact, 320M Wired, 192M Cache, 199M Buf, 40M Free > Swap: 4096M Total, 16K Used, 4096M Free > > Through a number of samples from sockstat(1), I see ~20 connections to > mysql at any given time. 5 for Courier's authdaemon, 3 for Exim, and > ~12 for Apache/PHP. There are intermitant connections from Windows > clients using MyODBC, but none are persistant. Restarting any/all of > these processes does not cause mysql to ease up on the CPU. Only > restarting MySQL will buy releif, but after a few weeks, it's right back > to 97% CPU usage. > > The machine itself is completely responsive, mysql is completely > responsive. The tables in question are flat, with only a few thousand > entries in the largest. Queries range from simple to semi-complex. > > I can't identify the source of the load. Can anyone help? What should > I be looking at? > > Thanks, > > -- > Troy Settle > Pulaski Networks > http://www.psknet.com > 866.477.5638 > _______________________________________________ > freebsd-isp@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-isp > To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org" From owner-freebsd-isp@FreeBSD.ORG Tue Aug 2 16:43:43 2005 Return-Path: X-Original-To: freebsd-isp@freebsd.org Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 15ADD16A41F for ; Tue, 2 Aug 2005 16:43:43 +0000 (GMT) (envelope-from troy@psknet.com) Received: from psknet.com (kennedy.psknet.com [63.171.251.9]) by mx1.FreeBSD.org (Postfix) with ESMTP id AD35843D45 for ; Tue, 2 Aug 2005 16:43:42 +0000 (GMT) (envelope-from troy@psknet.com) Received: from pool-70-110-6-88.roa.east.verizon.net ([70.110.6.88] helo=[192.168.1.102]) by psknet.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.43 (FreeBSD)) id 1Dzzrh-000Eth-6G for freebsd-isp@freebsd.org; Tue, 02 Aug 2005 12:43:41 -0400 Message-ID: <42EFA2BC.4060808@psknet.com> Date: Tue, 02 Aug 2005 12:43:40 -0400 From: Troy Settle User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050723) X-Accept-Language: en-us, en MIME-Version: 1.0 To: freebsd-isp@freebsd.org References: <42EF8206.5000505@psknet.com> <42EF8714.9020409@jpri.com> In-Reply-To: <42EF8714.9020409@jpri.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: MySQL Performance X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 02 Aug 2005 16:43:43 -0000 Thanks to all for the feedback. Looking at the status, there were 7 slow queries. I've enabled logging and re-started the server. Now I wait a few weeks to see what, if anything, happens. Of course, by that time, I hope to have a dedicated MySQL server up and running, though I'm not sure I'll want to run my mail server off a remote database. Thanks again, -- Troy Settle Pulaski Networks http://www.psknet.com 866.477.5638 James Ryan wrote: > Try enabling slow query logging, as well as maybe try to isolate if the > load is coming from any particular query... > > If you are performing joins on the 1k+ rows table, maybe MySQL has ran > out of memory and is copying the query results to a tmp table on the > disk. Sometimes this can cause a jump in CPU usage... You can > determine if this is the case by mysqladmin processlist; it will say > something like "Copying to tmp table". > > Check for slow queries though... > > Cheers, > James > > Troy Settle wrote: > >> >> I've a 4-STABLE box on a Dual Xeon w/4GB and U320 RAID: >> >> 4.11-STABLE FreeBSD 4.11-STABLE #7: Fri Mar 11 20:24:25 EST 2005 >> 10:05AM up 55 days, 14:38, 3 users, load averages: 1.07, 1.10, 1.13 >> >> Running on this box, is MySQL 4.0.23a (a little outdated, I know). >> This MySQL server seems to run fine as long as I watch it, but as soon >> as I turn my head for a moment, it jumps up to ~97% CPU usage: >> >> 508 mysql 63 0 99M 51660K CPU0 0 306.9H 97.46% 97.46% mysqld >> >> It doesn't appear to be an IO issue, 300 samples from iostat show a >> max of 0.31 MB/s. >> >> It also doesn't appear to be a memory issue: >> >> 867M Active, 2354M Inact, 320M Wired, 192M Cache, 199M Buf, 40M Free >> Swap: 4096M Total, 16K Used, 4096M Free >> >> Through a number of samples from sockstat(1), I see ~20 connections to >> mysql at any given time. 5 for Courier's authdaemon, 3 for Exim, and >> ~12 for Apache/PHP. There are intermitant connections from Windows >> clients using MyODBC, but none are persistant. Restarting any/all of >> these processes does not cause mysql to ease up on the CPU. Only >> restarting MySQL will buy releif, but after a few weeks, it's right >> back to 97% CPU usage. >> >> The machine itself is completely responsive, mysql is completely >> responsive. The tables in question are flat, with only a few thousand >> entries in the largest. Queries range from simple to semi-complex. >> >> I can't identify the source of the load. Can anyone help? What >> should I be looking at? >> >> Thanks, >> >> -- >> Troy Settle >> Pulaski Networks >> http://www.psknet.com >> 866.477.5638 >> _______________________________________________ >> freebsd-isp@freebsd.org mailing list >> http://lists.freebsd.org/mailman/listinfo/freebsd-isp >> To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org" > > > _______________________________________________ > freebsd-isp@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-isp > To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org" From owner-freebsd-isp@FreeBSD.ORG Tue Aug 2 18:27:38 2005 Return-Path: X-Original-To: freebsd-isp@freebsd.org Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 08C8516A41F for ; Tue, 2 Aug 2005 18:27:38 +0000 (GMT) (envelope-from te@domecon.de) Received: from tartaros.domecon.de (tartaros.domecon.de [80.237.209.74]) by mx1.FreeBSD.org (Postfix) with ESMTP id B8C0E43D49 for ; Tue, 2 Aug 2005 18:27:36 +0000 (GMT) (envelope-from te@domecon.de) Received: (qmail 75574 invoked by uid 89); 2 Aug 2005 18:27:02 -0000 Received: from 84.155.74.113 by tartaros.domecon.de (envelope-from , uid 89) with qmail-scanner-1.25 (clamdscan: 0.83/705. spamassassin: 3.0.2. Clear:RC:0(84.155.74.113):SA:0(2.2/6.0):. Processed in 4.340142 secs); 02 Aug 2005 18:27:02 -0000 X-Spam-Status: No, hits=2.2 required=6.0 X-Spam-Level: ++ X-Qmail-Scanner-Mail-From: te@domecon.de via tartaros.domecon.de X-Qmail-Scanner: 1.25 (Clear:RC:0(84.155.74.113):SA:0(2.2/6.0):. Processed in 4.340142 secs) Received: from unknown (HELO fnord) (thomas.eisenbarth@domecon.de@84.155.74.113) by tartaros.domecon.de with AES256-SHA encrypted SMTP; 2 Aug 2005 18:26:58 -0000 Date: Tue, 2 Aug 2005 20:27:28 +0200 From: Thomas Eisenbarth To: Troy Settle Message-ID: <20050802202728.07748587@fnord> In-Reply-To: <42EFA2BC.4060808@psknet.com> References: <42EF8206.5000505@psknet.com> <42EF8714.9020409@jpri.com> <42EFA2BC.4060808@psknet.com> Organization: Donau-Ries Media-Consulting DoMeCon X-Mailer: Sylpheed-Claws 1.9.11 (GTK+ 2.6.8; i386-portbld-freebsd5.4) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Cc: freebsd-isp@freebsd.org, wertejuk@mwcis.com Subject: Re: MySQL Performance X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 02 Aug 2005 18:27:38 -0000 Hi there, On Tue, 02 Aug 2005 12:43:40 -0400 Troy Settle wrote: > that time, I hope to have a dedicated MySQL server up and running, > though I'm not sure I'll want to run my mail server off a remote > database. Well, you definitively don't want to run a webserver, a mta and the database on a host having such a load. ;-) I always try to avoid situation where a service depends on a single-point-of-failure-service like mysql. Don't understand me wrong, mysql is stable for most of the time, but if you want to offer reliable high availability e-mail you at least need a mysql-cluster. (and please remember that maybe ldap fits your meets much better ;-)) The next question is if you have mailbox/account- checking on your mta at smtp-session to (try to) avoid spam and if you want to have a secondary mail exchange. (which then needs access to you mysql oder ldap-service) As you can see, it's not a simple question. But as a good friend of mine always says: "If it would be easy, someone else would do it" ;-) Greetings from Germany -- Thomas Eisenbarth, Donau-Ries Media-Consulting, DoMeCon web: http://www.domecon.de email: info@domecon.de tel/fax: 0700 03 66 32 66