From owner-freebsd-stable Mon Mar 11 17:16:38 2002 Delivered-To: freebsd-stable@freebsd.org Received: from mail.the-i-pa.com (mail.the-i-pa.com [151.201.71.132]) by hub.freebsd.org (Postfix) with SMTP id C236C37B41A for ; Mon, 11 Mar 2002 17:16:09 -0800 (PST) Received: (qmail 27092 invoked from network); 12 Mar 2002 01:18:04 -0000 Received: from unknown (HELO potentialtech.com) (151.201.71.209) by mail.the-i-pa.com with SMTP; 12 Mar 2002 01:18:04 -0000 Message-ID: <3C8D57E3.6050403@potentialtech.com> Date: Mon, 11 Mar 2002 20:20:35 -0500 From: Bill Moran Organization: Potential Technology User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:0.9.3) Gecko/20010914 X-Accept-Language: en-us MIME-Version: 1.0 To: Bob Kersten Cc: freebsd-stable@freebsd.org Subject: Re: crontab and mysql References: <001e01c1c942$d5f25ea0$0200000a@alpha> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Bob Kersten wrote: > Second question, my MySQL is extremely slow. I'm running FreeBSD >4.5-Stable on a Pentium-90Mhz with 64 mb ram, so that ought to be >enough, i would think. But when the database grows (like 300 entries >with text) it takes a few seconds for my PHP pages to load. I've seen >MySQL running amazingly fast on a machine far less than mine and >databases much bigger than the ones i use. Phpmyadmin is also pretty >slow and takes over 5 seconds to just show a simple table overview. >All these tests are done on the localhost, so the internet connection >is not an issue here. What is wrong here? > Gonna need some more info. Can you watch "top" and "systat" (the vmstat screen) while these delays are occurring? It will probably tell you where the bottleneck is. Simply the size of the db isn't enough to diagnose. Do you have it well indexed, and are you searching on indexed columns? Lots of factors that could affect this. Was php compiled into Apache statically or as a module? Lots of things to look at. -Bill To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message