IntegraMOD

IM141 and IM3 VPS hosting needs [ cpu / mem]

Ok Im about to give up and just move the main forum to its own VPS.
They said it was out of date software bla bla bla but Im seein CPU spikes well beyond what i have seen before the 141 forum upgrade. They are gonna shut us down again soon. [ I see spikes well over 50% cpu load, never seen over 40% with the old software.]

I want to know if you think a VPS account of
CPU 1.13 GHZ
RAM 768 MB
Disk Space30 GB
Bandwidth 500 GB

Will be plenty for a active 141 and when it happens a IM3 forum???
[disc space n bandwith is fine]

Its the most reasonable I can get for $40 and still have it semi-managed.

under normal circumstances that should be 5 times what you would need.
I have seen on occasion though where a 132, 140 or 141 site had an issue I could not trace down where the cpu use was out of control.
This is rare though because I have dealt personally with close to 100 member sites and had maybe 5 of them exhibit this behavior.
Since all of them were basically stock, im inclined to think it has more to do with the server setup than the software as all of the out of control sites ran fine on my server. This is not to say that IM140/141 is not a resource hog, because it is a known fact that it uses alot of resources.

Im using hostgator, which resells ThePlanet
but I really don't expect to make it through the weekend, unless I turn it off every time Im away from the PC, where I can watch the cpu load n kill the forum if it goes above 25% for more then 90sec [which is the rules].

Though I wish they would just come up with a hard block or wall limit for shared, where I could never cause the server to run slow, my site would just run slower or not respond.
I wouldn't care.

the site has been around since 03

Number of posts: 196976 Posts per day: 72.28
Number of topics: 20796 Topics per day: 7.63
Number of users: 12720 Users per day: 4.67
Board started: Tue Apr 01, 2003 1:22 pm
Database size: 275.57 MB

300 active members in a 36hr peroid

here is another suggestion
http://www.siteground.com/integramod-hosting.htm
They are a large company and familiar with the requirements of integramod.

Well my host has sent this suggestion.

not sure how to do that, did the search rebuild but the search word match list is still near 175megs itself.



"The conversion takes lots of SQL time, but at present here are the MySQL stats for your user. The MySQL time for your user is actually 5 times higher than any other user. | xvnetwor_batman | 1 | 14035 | 5306 | 152431 | 84666 | 54168 | 21537 | 228802876 | 2147483647 | I would check into the search functions in each site. This, actually, is where we see most of the SQL usage with phpBB sites. I would make sure to mark common words out and make other changes to reduce the size of this table. "

starting to think that is it, I disabled the search n hide all the search links and we got 10+ folks online and IM not seeing hugh cpu spikes.

how do I taper off the search problems with out deleting years of post with valuable info???

I could easily set up a google search box have users use them to search the site right?

But id hate to lose the search for new post function.

Well search and banners are problem.

used to have about 30 in rotation in the top right.

turned about 10 on, didn't take many users or long to spike the cpu.

im testing this on one of my 141 site atm.
if you try this pay close attention to the stopwords edit.

overwrite your current files. It gives much more control over your search tables

Will do soon as I get back from dinner, just follow the install.txt ehy?

really appreciate all your help.

where does it output the most common words?
it ran fine but dunno where to find what it found?

## If you want to find your most commonly used words, so you can put some of them into this blacklist,
## you can run the following db query in phpmyadmin, before running this mod :
##
## SELECT swl.word_id, swl.word_text, COUNT(swm.word_id) as total
## FROM `phpbb_search_wordlist` swl, `phpbb_search_wordmatch` swm
## WHERE swl.word_id = swm.word_id
## GROUP BY swm.word_id
## ORDER BY total
## DESC LIMIT 0,50

add the words you found that you dont want included in your searches to language/lang_english/search_stopwords.txt
then go to acp and rebuild the search index. It will remove all the words you added to search_stopwords.txt from the search table

Yo guy does the search stopword list have to be in alph order abc 123.....

just wonder a user found the stopword list google uses and it has allot of ones not in the default list but will be work to merge them if they gotta be in alph order.

I guess that the dummest question thus far <img>

ill try n get someoe to combin the two list for me.
the google list is long

I can post it, if you want to see it. the google one.