Date: Fri, 27 Sep 2002 12:31:49 +0200 From: Janine C.Buorditez <johann@broadpark.no> To: Marc Silver <marc.silver@uk.easynet.net> 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>
next in thread | previous in thread | raw e-mail | index | archive | help
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 <marc.silver@uk.easynet.net> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20020927123149.513923fe.johann>