[phpa] Re: PHPA and PostNuke
- From: "Jeff Barr" <jeff@xxxxxxxxxxxxx>
- To: <james.simmons@xxxxxxxxx>, <choke@xxxxxxxxxxx>
- Date: Tue, 11 Jun 2002 11:37:44 -0700
Before going to the trouble to move MySQL, I would recommend
doing some simple analysis to make sure that it is truly the
bottleneck.
On the MySQL side, the command "show full processlist" (run
from within mysql) is very, very valuable. When I am optimizing
a site I run it in a shell loop. It will show all running queries. If
you watch it for several seconds and see that a single query is
taking a long time, this is a prime candidate for optimization.
Often, adding an index to a single field of a single table can make
a huge difference in performance. It is also possible to tell
MySQL to log "slow" queries to a special log file. The information
in this file can also be used as a guide to find out where more
indexing might be helpful.
The performance changes can be dramatic. On www.syndic8.com
I did a press release announcing the site and within two hours
the site had slowed to a crawl and the load average was something
like 20. I did the analysis noted above, added one index, and
brought the load average to less than 1, even as the traffic increased.
Jeff;
----- Original Message -----
From: "James Simmons" <james.simmons@xxxxxxxxx>
To: <choke@xxxxxxxxxxx>
Cc: <phpa@xxxxxxxxxxxxx>
Sent: Tuesday, June 11, 2002 11:04 AM
Subject: [phpa] Re: PHPA and PostNuke
>
> Maybe look at bandwidth if he's also running an FTP server. SNMP and MRTG
> can give you some stats. I'm probably going to move my MySQL server to a
> separate box. Your buddy might look at doing the same if his MySQL server
> is eating too many resources.
>
> I recompiled MySQL with some custom configuration options to improve
> performance. Check out the MySQL web site or the readme included with the
> source for recommendations for low, medium and high server load
> configurations.
>
> James.s
>
>
> > Thanks for the reply!
> >
> > I believe it's an Athlon 750, w/ 512mb. MySQL is by far the biggest
> > pig, but the minimal eyeballing I didi (with top), the mysql load
> > seemed to go up when the
> > cache module was turned on, if that makes any sense. It's a really
> > really active system as well, lots of ftp traffic, an icecast server, a
> > bunch of stuff, so I'm sure that would come into play. I just found it
> > odd that it barely helped at all. It's not my system, so I'm not that
> > familiar with it.. But i'm fairly sure he's got a lot of bandwidth to
> > work with...
> >
> > -adam
> >
> > On Tue, 11 Jun 2002, James Simmons wrote:
> >
> >>
> >> Post some system specs. That would be helpful. I run PHP-Nuke 5.5 on
> >> a server with 40 000 members and as many unique visitors each day. I
> >> use PHPA along with mod_giz and have noticed a sizeable speed
> >> increase. My users on dialup have also commented about the noted
> >> improvement in performance. My system runs Mandrake-Linux 8.1. 933
> >> Mhz PIII and 512 MB Ram.
> >>
> >> Bandwidth could be a bottleneck. mod_gzip can help in this regard.
> >> The biggest resource hog on my system is MySQL thanks to unoptimized
> >> sql queries that do silly things like SELECT * FROM WHATEVER and have
> >> to parse through a few hundred thousand records. I' working on that
> >> :)
> >>
> >> You might also do a 'top' on the server to get an idea of your server
> >> load and what is eating up your system resouces.
> >>
> >> James.s
> >>
> >>
> >> > Just curious if anyone out there runs a semi high volume site with
> >> > Post or PHPNuke and PHPA? I'm trying to help a friend out with
> >> > performance on his site, and PHPA (and actually, all the other mods)
> >> > had almost 0 effect on the performance of the site..
> >> >
> >> > thanks!
> >> > -adam
> >> >
> >> > ------------------------------------------------------------------------
> >> > www.php-accelerator.co.uk Home of the free PHP
> >> > Accelerator
> >> >
> >> > To post, send email to phpa@xxxxxxxxxxxxx
> >> > To unsubscribe, email phpa-request@xxxxxxxxxxxxx with subject
> >> > unsubscribe
> >>
> >>
> >>
> >> ------------------------------------------------------------------------
> >> www.php-accelerator.co.uk Home of the free PHP Accelerator
> >>
> >> To post, send email to phpa@xxxxxxxxxxxxx
> >> To unsubscribe, email phpa-request@xxxxxxxxxxxxx with subject
> >> unsubscribe
>
>
>
> ------------------------------------------------------------------------
> www.php-accelerator.co.uk Home of the free PHP Accelerator
>
> To post, send email to phpa@xxxxxxxxxxxxx
> To unsubscribe, email phpa-request@xxxxxxxxxxxxx with subject unsubscribe
>
>
------------------------------------------------------------------------
www.php-accelerator.co.uk Home of the free PHP Accelerator
To post, send email to phpa@xxxxxxxxxxxxx
To unsubscribe, email phpa-request@xxxxxxxxxxxxx with subject unsubscribe
Other related posts:
