[phpa] Re: PHPA and PostNuke
- From: "David Campbell" <dave@xxxxxxxx>
- To: <phpa@xxxxxxxxxxxxx>
- Date: Tue, 11 Jun 2002 22:44:42 +0100
> mysql --user=syndic8 --host=localhost --password=PASS DB
> --exec="show full processlist"
>
> Replace PASS and DB with your password and database name.
extended-status or status would be better commands surely.
> -----Original Message-----
> From: phpa-bounce@xxxxxxxxxxxxx [mailto:phpa-bounce@xxxxxxxxxxxxx]On
> Behalf Of Jeff Barr
> Sent: Tuesday, June 11, 2002 10:36 PM
> To: james@xxxxxxxxxxxxx
> Cc: phpa@xxxxxxxxxxxxx
> Subject: [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
>
>
------------------------------------------------------------------------
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:
