Re: [phpslash-users] phpslash performance questions

[Matt \TrollBoy\ W. <tro...@sh...>]

Here's My experience:
Shoggoth.net averages around 3k hits per day...
(http://www.shoggoth.net/webstats/ ignore january)
at our high point (we where a link of the day on userfriendly) we scored
74021 hits in a matter of two days..
We've 29 on our newsletter list, and it takes a second to process them all..
We running off of a VA Linux box set up for virtual hosting.


Here's what Blake had to say:
well, I can tell you rough stats only
I'm on a huge sun shared server
I get at most 1500 people a day
the newsletter goes to about 1300 people
serve about 3000 pages a day
that's about 11,000 hits a week
I get the ol mysql too many connections error ALOT, every couple days
lately, but it may not be due to me


Matt "TrollBoy" Wiseman
Webmaster: Shoggoth.net
Site Designer: phpslash.org
The oldest and strongest emotion of mankind is fear,
and the oldest and strongest kind of fear is fear of the unknown.
-H.P. Lovecraft
---------------------------------------------------------
Please do not resell my e-mail address
to anyone or send me unsolicited e-mail
---------------------------------------------------------





----- Original Message -----
From: "Joe Stewart" <jo...@be...>
To: "PHPSlash Users List" <php...@li...>
Sent: Thursday, January 17, 2002 8:11 AM
Subject: Re: [phpslash-users] phpslash performance questions


> Hello and Welcome.  Great thread.  Still working on getting enough coffee
> in me.
>
> I've been happy with the performance of phpslash.  I can't give concrete
> traffic numbers, but what range of daily visitors/pageviews are you
> talking about?
>
> On Thu, Jan 17, 2002 at 01:47:32AM -0600, Jimmy wrote:
> > I've been lurking on this list for some time and am now considering
> > using phpslash for a fairly high traffic site (nothing ready yet!)
> > I'm currently using the phpslash-ft and php-lib-stable CVS trees to
> > build my site on FreeBSD/Apache/mod_php.
> >
>
> > Anyway I'm wondering what sort of raw performance numbers people have
> > seen for their phpslash based sites.  How many pages/sec have yall
> > sustained?
> >
> > I'm also curious what the developers think about where the current
> > bottlenecks (if any :) are in phpslash and phplib?
> >
>
> Here are a couple of thoughts:
>
> 1. MySQL table locking.  The "article_updatehits" writes back to the
> psl_story table every page view.  Turn this off for better performance.
> Actually didn't help as much as I thought.
>
> 2. index pages aren't cached.  I've tested some cacheing inside the db,
> but not much increase in speed.  I've been happy with tests on the 0.65
> code of jpcache and phpCache.  Haven't used either on a site with
> appreciable traffic yet, but will be doing so soon.  If you have a recent
> php4, jpcache can work with 0.65 series fairly easily.  I'd like others
> opinion on this, but I set it up to show cached output only if not logged
> in and default skin and language.
> Anybody tested with other caches? APC,PEAR?
>
> 3. Have run out of mysql connections with phpAdsNew, phpSlash, and phorum.
> Tweaking apache and mysql aren't specific to phpslash.
>
> 4. Plenty of memory for apache, mysql, and php.  If you are on a dedicated
> machine it is more likely the apache thread will have a persistent mysql
> connection already.
>
> 5. I've had discussion with others that the phpslash and the phplib
> sessions should scale up to load balanced front ends with a db backend OK.
>
> 6. One apache "trick" to avert a / effect is to assign the page in
> question to a static html for a short period.  Of course any updates (
> comments, revisions, etc) won't be seen till the file is updated but hey.
>
> in .htaccess:
>
>   RewriteEngine On
>   RewriteRule ^/article.php3?story_id=375 /static.html
>
>
> Not really specific to phpslash code, but some observations anyway.
>
> thanks,
>
> Joe
>
>
>
> _______________________________________________
> phpslash-users mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpslash-users
>