From owner-freebsd-questions Fri Sep 27 3:32:18 2002 Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id C587B37B401 for ; Fri, 27 Sep 2002 03:32:15 -0700 (PDT) Received: from mail.broadpark.no (mail.broadpark.no [217.13.4.2]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1C40143E75 for ; Fri, 27 Sep 2002 03:32:15 -0700 (PDT) (envelope-from johann@broadpark.no) Received: from aegis.terrabionic.lan (ninja.terrabionic.com [217.13.29.51]) by mail.broadpark.no (Postfix) with SMTP id 635B083B2; Fri, 27 Sep 2002 12:32:12 +0200 (MEST) Date: Fri, 27 Sep 2002 12:31:49 +0200 From: Janine C.Buorditez To: Marc Silver Cc: questions@freebsd.org Subject: Re: PostNuke running slow on FreeBSD Message-Id: <20020927123149.513923fe.johann@broadpark.no> In-Reply-To: <20020926112645.GB13753@uk.easynet.net> References: <20020926125918.086c31f4.johann@broadpark.no> <20020926112645.GB13753@uk.easynet.net> X-Mailer: Sylpheed version 0.7.6 (GTK+ 1.2.10; i386-portbld-freebsd4.6) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Hey! The reason I were using IPv6 support was so I could be ready for the future. Silly, huh? I'm now running the normal version. The only thing I can seem to find out is the output of /var/db/mysql/ninja.err: 020926 17:37:09 mysqld started 020926 17:37:10 Warning: setrlimit returned ok, but didn't change limits. Max open files is 496 020926 17:37:11 Warning: Changed limits: max_connections: 100 table_cache: 193 Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add for example, innodb_data_file_path = ibdata1:30M But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html /usr/local/libexec/mysqld: ready for connections I haven't tried the --with-log function yet. The rest of your suggestions were really helpful, though they didn't tell me much. Got any other ideas? Could it be my uptime? Thanks. --janine On Thu, 26 Sep 2002 12:26:45 +0100 Marc Silver wrote: > Hi there, > > Out of interest, why are you using IPv6 support? Are you actually using > it? I've personally had no experience with this, but perhaps that's the > problem? > > A few things I would check: > > 1) See what the value for HostnameLookups is in httpd.conf -- I would > suggest setting this to Off, as leaving it on can cause issues if > your DNS server cannot resolve fast enough/at all. Does > "/usr/local/sbin/apachectl configtest" show anything odd? > > 2) Try running a tcpdump to see if traffic is actually flowing > freely... who knows, maybe you'll notice something odd. > > 3) What's the httpd process doing when it's supposed to be serving this > page? Is something using lots of CPU/RAM while you're waiting for > the page to load? Perhaps look at using truss to find out? > > 4) Have you looked at MySQL during this time? Try outputting MySQL's > output/queries to a log file (--with-log=/tmp/mysql.log for eg iirc) > and see what's going on there. 'show status' within MySQL can > sometimes also provide good information. > > Hope this helps in some way. > - Marc > > On Thu, Sep 26, 2002 at 12:59:18PM +0200, Janine C. Buorditez wrote: > > Hi. > > > > I'm running PostNuke 0.72, Apache+IPv6 1.3.26, MySQL 3.23.49 and > > mod_php4 4.2.3. > > > > My machine is a Pentium 120 with 16 MB RAM, so I don't expect much > > from it. > > > > However I would expect it to take less than 15-20 minutes to serve me > > a website, in this case PostNuke (http://www.terrabionic.com/nma). I > > do not know what it is, nor does the PostNuke community. > > > > The installation went fair and fast enough. Once it was complete and I > > wanted to access it, I had to wait 16 minutes for just the topic to > > appear. > > > > > > > tail /var/log/httpd-error.log > > [snip] > > > I haven't done much to configure Apache, MySQL or PHP. That should > > result in this should it? > > > > Thanks > > > > --janine To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message