[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

Other related posts: