[phpa] Re: PHPA and PostNuke

> I only get a couple of lines and no useful information except the query and 
> the time.

That's the useful information! I get back a table with eight columns:

Id
User
Host
db
Command
Time
State
Info

Create a little shell script to invoke the command every second or two,
and start to watch for patterns.

Here's what I use:

mysql --user=syndic8 --host=localhost --password=PASS DB --exec="show full 
processlist"

Replace PASS and DB with your password and database name.

Look for things like a pending query list that grows each
time. This often indicates that a whole bunch of queries
are blocked awaiting the completion of a single long-running
query. Watch the status column too.

Jeff;

----- Original Message -----
From: "James Simmons" <james@xxxxxxxxxxxxx>
To: <jeff@xxxxxxxxxxxxx>
Cc: <phpa@xxxxxxxxxxxxx>
Sent: Tuesday, June 11, 2002 1:25 PM
Subject: [phpa] Re: PHPA and PostNuke


>
> Getting off topic for a moment, I don't think the output I'm seeing from
> show full processlist is right.  I only get a couple of lines and no
> useful information except the query and the time.  What command are you
> issueing?  www.mysql.com, here I come :)
> James.s
>
>
> > 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
>
>

------------------------------------------------------------------------
  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: