Re: Fw: Re: PostNuke running slow on FreeBSD

2002-09-29 Thread Josh Paetzel

On Sat, Sep 28, 2002 at 04:51:24PM +0200, Janine C. Buorditez wrote:
> 
> 
> Begin forwarded message:
> 
> Date: Sat, 28 Sep 2002 16:47:51 +0200
> From: Roman Neuhauser <[EMAIL PROTECTED]>
> To: "Janine C.Buorditez" <[EMAIL PROTECTED]>
> Subject: Re: PostNuke running slow on FreeBSD
> 
> 
> # [EMAIL PROTECTED] / 2002-09-28 13:52:56 +0200:
> > On Fri, 27 Sep 2002 12:51:24 +0200
> > Roman Neuhauser <[EMAIL PROTECTED]> wrote:
> > > please keep the length of lines below 80 chars.
> > > 
> > > # [EMAIL PROTECTED] / 2002-09-26 12:59:18 +0200:
> > > > 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.
> > > 
> > > how do other php applications behave?
> > > what did you do to try to find out what part of your config is the
> > > bottleneck?
> > > what were the results?
> >  
> > phpmyadmin works without any hassle. the php postnuke installation too
> > went fine.
> > 
> > i don't know how to find out what part of my config is the bottleneck.
> > 
> > any ideas?
> 
> unfortunately, no. also, you really should have sent this to the
> list.
> 
> 
> -- 
> begin 666 nonexistent.vbs
> FreeBSD 4.7-RC
> 4:46PM up 11 days, 1 min, 13 users, load averages: 0.12, 0.05, 0.01
> end

It would be helpful to know what the machine is doing in those 15 minutes.  Is 
it swapping, maxing the cpu, or what?

Josh

To Unsubscribe: send mail to [EMAIL PROTECTED]
with "unsubscribe freebsd-questions" in the body of the message



Fw: Re: PostNuke running slow on FreeBSD

2002-09-28 Thread Janine C . Buorditez



Begin forwarded message:

Date: Sat, 28 Sep 2002 16:47:51 +0200
From: Roman Neuhauser <[EMAIL PROTECTED]>
To: "Janine C.Buorditez" <[EMAIL PROTECTED]>
Subject: Re: PostNuke running slow on FreeBSD


# [EMAIL PROTECTED] / 2002-09-28 13:52:56 +0200:
> On Fri, 27 Sep 2002 12:51:24 +0200
> Roman Neuhauser <[EMAIL PROTECTED]> wrote:
> > please keep the length of lines below 80 chars.
> > 
> > # [EMAIL PROTECTED] / 2002-09-26 12:59:18 +0200:
> > > 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.
> > 
> > how do other php applications behave?
> > what did you do to try to find out what part of your config is the
> > bottleneck?
> > what were the results?
>  
> phpmyadmin works without any hassle. the php postnuke installation too
> went fine.
> 
> i don't know how to find out what part of my config is the bottleneck.
> 
> any ideas?

unfortunately, no. also, you really should have sent this to the
list.


-- 
begin 666 nonexistent.vbs
FreeBSD 4.7-RC
4:46PM up 11 days, 1 min, 13 users, load averages: 0.12, 0.05, 0.01
end

To Unsubscribe: send mail to [EMAIL PROTECTED]
with "unsubscribe freebsd-questions" in the body of the message



Re: PostNuke running slow on FreeBSD

2002-09-27 Thread Roman Neuhauser

please keep the length of lines below 80 chars.

# [EMAIL PROTECTED] / 2002-09-26 12:59:18 +0200:
> 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.

how do other php applications behave?
what did you do to try to find out what part of your config is the
bottleneck?
what were the results?
 
> /var/log/messages doesn't tell me much. Nor does these:
> 
> > tail /var/log/httpd-error.log
> [Wed Sep 25 20:37:46 2002] [error] [client :::217.84.209.13] File does not 
>exist: 
>/usr/local/www/data/msadc/..%5c../..%5c../..%5c/..Á../..Á../..Á../winnt/system32/cmd.exe

these are IIS attacks. you can ignore them.

> [Wed Sep 25 21:13:43 2002] [error] [client :::195.159.0.90] File does not exist: 
>/usr/local/www/data//

this looks like a misconfiguration of apache, but irrelevant.
 
> > tail /var/db/mysql/ninja.err
> 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.

do what it tells you (again, irrelevant)

-- 
begin 666 nonexistent.vbs
FreeBSD 4.7-RC
12:43PM up 9 days, 19:58, 13 users, load averages: 0.01, 0.07, 0.06
end

To Unsubscribe: send mail to [EMAIL PROTECTED]
with "unsubscribe freebsd-questions" in the body of the message



Re: PostNuke running slow on FreeBSD

2002-09-27 Thread Janine C . Buorditez


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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]
with "unsubscribe freebsd-questions" in the body of the message



Re: PostNuke running slow on FreeBSD

2002-09-26 Thread Marc Silver

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 [EMAIL PROTECTED]
with "unsubscribe freebsd-questions" in the body of the message