Sub Menu
Links Menu
Online Users

In total there are 317 users online :: 2 registered, 0 hidden and 315 guests

Most users ever online was 1091 on Wed Aug 16, 2023 5:27 pm

Registered users: Bing [Bot], Google [Bot] based on users active over the past 60 minutes

IM141 and IM3 VPS hosting needs [ cpu / mem]

Support for IntegraMOD 141

Moderator: Integra Moderator

IM141 and IM3 VPS hosting needs [ cpu / mem]

PostAuthor: viragotech » Thu Sep 16, 2010 6:20 pm

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.
User avatar
viragotech
Sr Integra Member
Sr Integra Member
 
Posts: 292
Likes: 0 post
Liked in: 0 post
Joined: Wed Jul 04, 2007 10:30 am
Cash on hand: 0.00

Re: IM141 and IM3 VPS hosting needs [ cpu / mem]

PostAuthor: Helter » Thu Sep 16, 2010 6:43 pm

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.
Always use Protection
Image


Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4167
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Sat Mar 11, 2006 3:46 pm
Cash on hand: 172.60
Location: Seattle Wa
IntegraMOD version: IM 3

Re: IM141 and IM3 VPS hosting needs [ cpu / mem]

PostAuthor: viragotech » Thu Sep 16, 2010 7:07 pm

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].
Last edited by viragotech on Thu Sep 16, 2010 7:14 pm, edited 1 time in total.
User avatar
viragotech
Sr Integra Member
Sr Integra Member
 
Posts: 292
Likes: 0 post
Liked in: 0 post
Joined: Wed Jul 04, 2007 10:30 am
Cash on hand: 0.00

Re: IM141 and IM3 VPS hosting needs [ cpu / mem]

PostAuthor: viragotech » Thu Sep 16, 2010 7:13 pm

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.
User avatar
viragotech
Sr Integra Member
Sr Integra Member
 
Posts: 292
Likes: 0 post
Liked in: 0 post
Joined: Wed Jul 04, 2007 10:30 am
Cash on hand: 0.00

Re: IM141 and IM3 VPS hosting needs [ cpu / mem]

PostAuthor: viragotech » Thu Sep 16, 2010 7:39 pm

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
User avatar
viragotech
Sr Integra Member
Sr Integra Member
 
Posts: 292
Likes: 0 post
Liked in: 0 post
Joined: Wed Jul 04, 2007 10:30 am
Cash on hand: 0.00

Re: IM141 and IM3 VPS hosting needs [ cpu / mem]

PostAuthor: Helter » Thu Sep 16, 2010 10:18 pm

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


Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4167
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Sat Mar 11, 2006 3:46 pm
Cash on hand: 172.60
Location: Seattle Wa
IntegraMOD version: IM 3

Re: IM141 and IM3 VPS hosting needs [ cpu / mem]

PostAuthor: viragotech » Fri Sep 17, 2010 7:46 am

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. "
User avatar
viragotech
Sr Integra Member
Sr Integra Member
 
Posts: 292
Likes: 0 post
Liked in: 0 post
Joined: Wed Jul 04, 2007 10:30 am
Cash on hand: 0.00

Re: IM141 and IM3 VPS hosting needs [ cpu / mem]

PostAuthor: viragotech » Fri Sep 17, 2010 9:01 am

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.
User avatar
viragotech
Sr Integra Member
Sr Integra Member
 
Posts: 292
Likes: 0 post
Liked in: 0 post
Joined: Wed Jul 04, 2007 10:30 am
Cash on hand: 0.00

Re: IM141 and IM3 VPS hosting needs [ cpu / mem]

PostAuthor: viragotech » Fri Sep 17, 2010 10:31 am

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.
User avatar
viragotech
Sr Integra Member
Sr Integra Member
 
Posts: 292
Likes: 0 post
Liked in: 0 post
Joined: Wed Jul 04, 2007 10:30 am
Cash on hand: 0.00

Re: IM141 and IM3 VPS hosting needs [ cpu / mem]

PostAuthor: Helter » Fri Sep 17, 2010 12:54 pm

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
Always use Protection
Image


Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4167
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Sat Mar 11, 2006 3:46 pm
Cash on hand: 172.60
Location: Seattle Wa
IntegraMOD version: IM 3

Re: IM141 and IM3 VPS hosting needs [ cpu / mem]

PostAuthor: viragotech » Fri Sep 17, 2010 1:21 pm

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

really appreciate all your help.
User avatar
viragotech
Sr Integra Member
Sr Integra Member
 
Posts: 292
Likes: 0 post
Liked in: 0 post
Joined: Wed Jul 04, 2007 10:30 am
Cash on hand: 0.00

Re: IM141 and IM3 VPS hosting needs [ cpu / mem]

PostAuthor: viragotech » Fri Sep 17, 2010 5:15 pm

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
User avatar
viragotech
Sr Integra Member
Sr Integra Member
 
Posts: 292
Likes: 0 post
Liked in: 0 post
Joined: Wed Jul 04, 2007 10:30 am
Cash on hand: 0.00

Re: IM141 and IM3 VPS hosting needs [ cpu / mem]

PostAuthor: Helter » Fri Sep 17, 2010 6:29 pm

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
Always use Protection
Image


Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4167
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Sat Mar 11, 2006 3:46 pm
Cash on hand: 172.60
Location: Seattle Wa
IntegraMOD version: IM 3

Re: IM141 and IM3 VPS hosting needs [ cpu / mem]

PostAuthor: viragotech » Sun Sep 19, 2010 5:20 pm

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.
User avatar
viragotech
Sr Integra Member
Sr Integra Member
 
Posts: 292
Likes: 0 post
Liked in: 0 post
Joined: Wed Jul 04, 2007 10:30 am
Cash on hand: 0.00

Re: IM141 and IM3 VPS hosting needs [ cpu / mem]

PostAuthor: viragotech » Mon Sep 20, 2010 8:20 am

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.
User avatar
viragotech
Sr Integra Member
Sr Integra Member
 
Posts: 292
Likes: 0 post
Liked in: 0 post
Joined: Wed Jul 04, 2007 10:30 am
Cash on hand: 0.00

Next

Return to IntegraMOD 141

Who is online

Registered users: Bing [Bot], Google [Bot]

cron