phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

Getting too popular for it's own good!
1 members found this topic helpful
Goto page Previous  1, 2, 3, 4  Next
 
Search this topic... | Search phpBB2 Discussion... | Search Box
Register or Login to Post    Index » phpBB2 Discussion  Previous TopicPrint TopicNext Topic
Author Message
drathbun
Board Member



Joined: 24 Jul 2008

Posts: 666
Location: Texas


flag
PostPosted: Sun Feb 15, 2009 9:54 pm 
Post subject: Re: Getting too popular for it's own good!

The time estimate is simply that, how long it is estimated (guessed) it will take to install a MOD.

The other suggestion just makes sense. If you install 10 new MODs before testing anything, how will you know where to look for what is wrong? Install a MOD, make sure it works, then move on to the next.

_________________
phpBBDoctor Blog
Back to top
RMcGirr83
Board Member



Joined: 02 Dec 2008

Posts: 53
Location: East Lyme, CT


flag
PostPosted: Tue Feb 17, 2009 10:35 pm 
Post subject: Re: Getting too popular for it's own good!

drathbun wrote:
Install a MOD, make sure it works, then move on to the next.


Should be cast in stone somewhere because not following this very simple piece of advice is just asking for additional, not needed work by the modificator (is that a word?).

_________________
Rich McGirr
Back to top
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Wed Feb 18, 2009 7:15 am 
Post subject: Re: Getting too popular for it's own good!

Nah, that is not a word, but you are right anyway! icon_lol.gif
Back to top
Daz
Board Member



Joined: 17 Dec 2008

Posts: 32
Location: Yorkshire, England


flag
PostPosted: Wed Feb 18, 2009 9:42 am 
Post subject: Re: Getting too popular for it's own good!

Hi,

Maybe it is

Daz
Back to top
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Wed Feb 18, 2009 9:55 am 
Post subject: Re: Getting too popular for it's own good!

icon_biggrin.gif
Cool! icon_mrgreen.gif
Back to top
RMcGirr83
Board Member



Joined: 02 Dec 2008

Posts: 53
Location: East Lyme, CT


flag
PostPosted: Wed Feb 18, 2009 10:09 am 
Post subject: Re: Getting too popular for it's own good!

wOOt for me!! icon_mrgreen.gif
_________________
Rich McGirr
Back to top
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 556
Location: North West UK


flag
PostPosted: Sat Feb 28, 2009 3:21 pm 
Post subject: Re: Getting too popular for it's own good!

I feel that after two weeks of testing/observations that it would be fair to make some comments.

Remember the issue was extremely slow page delivery due to excessive server loads mainly caused by a single site on what should be a server (VPS) capable of handling lots of boards. The server owners assured me and produced statistics to show that it was this single site generating the load. It moves near 300GB of data per month.

We have made 3 changes.
1) The change to search that Dave suggested earlier.
2) The removal of the Nav links mentioned in this topic.
3) The addition of the Cached Posts mod.

At each step there was some noticeable difference in speed but the telling thing is that when I check daily the CPU/Memory/Mysql usage via the WHM panel his site shows in a Yellow bar every day when previously it was red every day.

Figures now are
xxxxx xxxxxx.com %CPU 11.05 %Memory 4.66 Mysql Processes 0.7

Previously the %CPU had been as high as 30 with memory also higher than at present.

Conclusion is that these changes have had a positive effect.
Anything else that we might do Dave?

Jim
Back to top
drathbun
Board Member



Joined: 24 Jul 2008

Posts: 666
Location: Texas


flag
PostPosted: Sat Feb 28, 2009 3:53 pm 
Post subject: Re: Getting too popular for it's own good!

How do your database stats look?

There are other tuning options that can be suggested but a lot of it depends on where your main problem is. For example, I spent months tuning database queries and setting up caching for template data, smilies data, and so on, only to find out that the main drag on my site was the template engine.

_________________
phpBBDoctor Blog
Back to top
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 556
Location: North West UK


flag
PostPosted: Sat Feb 28, 2009 4:17 pm 
Post subject: Re: Getting too popular for it's own good!

Hi Dave
Where am I looking and at which data?

Jim
Back to top
drathbun
Board Member



Joined: 24 Jul 2008

Posts: 666
Location: Texas


flag
PostPosted: Sat Feb 28, 2009 4:31 pm 
Post subject: Re: Getting too popular for it's own good!

At your server command line, try typing mysqladmin variables. That will dump out how your database is currently configured. If you are not using up your RAM, you might be able to tweak either your database or apache to use more. The secret is you want to use everything you have icon_smile.gif but not one bit more. Unused RAM goes to waste.

You can also use mysqladmin status to get a one-line summary of your database activity. One of the items to look for is how many "slow queries" you have. If you have slow queries, then you need to ensure that the slow query log is turned on so you can go find out what's being logged.

Finally, if you want more detail about what's happening on your database, type mysqladmin extended-status instead. One of the indicators of how effective your database is is the ratio of "key reads" to "key read requests". For MySQL to be operating at its most effective level, you want most (if not all) of the indexes to be cached in RAM. The ratio of key reads / key read requests should be extremely low. If the number is zero, then that means 100% of your index read requests were served from RAM rather than disk. If you subtract this ratio from 100 you get the cache hit rate. For example, here are some of the stats from the site that hosts my busy board:
Code:
Key Reads/Key Read Requests = 0.000047  (Cache hit = 99.999953%)
Key Writes/Key Write Requests = 0.400796
Connections/second = 1.753 (/hour = 6312.147)
KB received/second = 0.197 (/hour = 710.043)
KB sent/second = 0.197 (/hour = 710.043)
Temporary Tables Created/second = 1.808 (/hour = 6509.453)
Opened Tables/second = 0.000 (/hour = 1.634)
Slow Queries/second = 0.000 (/hour = 1.462)
% of slow queries = 0.001%
Queries/second = 34.380 (/hour = 123769.035)
MySQL Query Cache hits = 137534790/222072208(62%)

The last line shows the success rate of the MySQL query cache, which some folks don't think helps much. It seems to help in my case. I should note that the queries per hour is about half what it was before I started caching tables like phpbb_config, themes, ranks, flags, styles, and so on. Every single page view hits the phpbb_config table, and the table rarely ever changes, so it makes sense to cache it. In my case that dropped about an hour's worth of database activity spread over the entire day.

My "slow queries" are invariably from the database backup that is performed every night. It takes a long time to backup the search word index tables. icon_smile.gif

_________________
phpBBDoctor Blog
Back to top
Jim_UK
Board Member



Joined: 19 Nov 2008

Posts: 556
Location: North West UK


flag
PostPosted: Sat Feb 28, 2009 5:01 pm 
Post subject: Re: Getting too popular for it's own good!

Hi Dave - You are making an assumption there. That being that I have ever used command line on the server. icon_wink.gif
I take it that you are talking here about SSH connection?

Jim
Back to top
drathbun
Board Member



Joined: 24 Jul 2008

Posts: 666
Location: Texas


flag
PostPosted: Sat Feb 28, 2009 5:16 pm 
Post subject: Re: Getting too popular for it's own good!

Yeah, sorry, that would be run from the command line...

I have a web version I can post. I would not put it in a normal web-enabled folder; put it inside your admin folder or somewhere that you have .htaccess protection in place. I can't do it right now but will try to remember later.

Better to be done via command line though.

_________________
phpBBDoctor Blog
Back to top
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Thu Mar 19, 2009 9:48 am 
Post subject: Re: Getting too popular for it's own good!

Tell me more about caching phpbb_config! icon_biggrin.gif
Back to top
Red Dog
Board Member



Joined: 06 Mar 2009

Posts: 41


flag
PostPosted: Thu Mar 19, 2009 11:29 am 
Post subject: Re: Getting too popular for it's own good!

SQL Cache (Cached Generation)
- Caches SQL Queries (faster forum)
- Ads Page generation time (in overall_footer.php)
- Ads SQL querie counter (in overall_footer.php)
- This page generation MOD is highly effecient for forum speed

This sound really really good. Too bad I didn't test it. Yet! icon_biggrin.gif
Back to top
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Thu Mar 19, 2009 12:04 pm 
Post subject: Re: Getting too popular for it's own good!

Ah, it is a mod? icon_eek.gif
Back to top
Display posts from previous:   
Register or Login to Post    Index » phpBB2 Discussion  Previous TopicPrint TopicNext Topic
Page 3 of 4 All times are GMT
Goto page Previous  1, 2, 3, 4  Next
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0290 seconds using 15 queries. (SQL 0.0028 Parse 0.0010 Other 0.0253)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo