Sub Menu
Links Menu
Online Users

In total there are 236 users online :: 2 registered, 0 hidden and 234 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

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

PostAuthor: Helter » Tue Sep 21, 2010 11:54 am

im not sure if it matters, but the google list will be generic and the list you get from the mods db queries come from your own db
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 23, 2010 9:46 am

Yea I messed all that up, I was not getting an output list of words, was running the query in the wrong place. So I totaly missed out on grabbing a whole bunch of words to exclude.

only got to like 10,000 post done when I stopped it as the table grew just as large, then figured it out to run that on the sql tab, not the queary tab.

So I only had 1 page of results to grabs n add new words.

gonna really suck as it takes so long as I must go slow.
150 post every 60 sec so not to blow up the cpu load. it may take only 20-22 sec to do it, but I must have a nice delay between CPU spikes or they wil get pissed.
rules are no more then 25% cpu load for 90 sec.
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 23, 2010 9:54 pm

brain fart, dummy me, though I was smart enough that when I did the upgrade to 141 I used a copy of the DB, the old DB is still up and is only maybe 100 post smaller then it. I can run that and get a word list from it. DOH

thought id end up running it many times to get more word.
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 23, 2010 11:29 pm

I ran the ocde but change it to "DESC LIMIT 0,3000"
And got one monster of a list, which I wanted but it took over an hr just to browse through n remove the words I don't want.

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: viragotech » Fri Sep 24, 2010 1:28 pm

Should you remove forum usernames from the stop list?

Or will the forum find their post on a user search its own way?
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 24, 2010 4:27 pm

you should probably remove them, though the search post by user function uses user_id instead of username.
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 24, 2010 7:51 pm

WOW

Our search stop list is near 4000 words long now, and as such I have to lower the limits al lthe way do to only doing 5 threads per process, with a 60sec pause between to stop from blowing up the server.
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 » Sat Sep 25, 2010 1:14 am

that is alot of words. If your trying to completely stop searching your forum there are better ways to disable it. I would think 4000 words would make searching impossible.
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 » Sat Sep 25, 2010 10:33 am

"HelterSkelter" wrote:that is alot of words. If your trying to completely stop searching your forum there are better ways to disable it. I would think 4000 words would make searching impossible.


Well I used that SQL queary to gather all the words I could form the DB.

Then removed all the words that were important to search our motorcycle forum.

All those left that are not needed, is near 4000 of them.

-------
HelterSkelter

Question, IM starting to think it would be best to use one of the mysql/php programs that will run on my computer to "fake" a server.

Could I then rebuild the search on my computer and run it full tilt so it doen't take a month to do on the real server???

Also will it matter if I have say all the images n files uploaded by users in the copy I would be using on my PC???

just want to make sure, we got allot of user uploads.

IM kinda up creek here right now, users want to search back but can't have it getting us shut down again.
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 » Sat Sep 25, 2010 3:54 pm

yes, you can do the sql work on your desktop with xamp, winamp or other similar local LAMP. You do not need to import any images or attachments to your desktop install. Just dont use a few of the acp/general admin/db tools functions that check attachments and such.
Make sure the php and mysql versions are the same as the server so you wont have any trouble viewing it.

btw what is your domain?
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 » Sat Sep 25, 2010 6:40 pm

"HelterSkelter" wrote:yes, you can do the sql work on your desktop with xamp, winamp or other similar local LAMP. You do not need to import any images or attachments to your desktop install. Just dont use a few of the acp/general admin/db tools functions that check attachments and such.
Make sure the php and mysql versions are the same as the server so you wont have any trouble viewing it.

btw what is your domain?



Kinda don't matter now, I guess just disabling the 1 search.php file was not enough. someone did a end run around it or there must be other places to make a search command and blew the server up today.

we are getting the boot.

And that siteground place you suggest who says they do IM hosting will not answer or reply to any of my question. Been trying to call n email all day.
[can't be to great of a site if they can't even be around on a Sat afternoon]

Only gonna cost $20 the min to move there but are they really ready for the load the forum will need for $4 a month.
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 » Sat Sep 25, 2010 10:18 pm

$4 or $24 a month?
The problem with shared servers is they are strictly for low use recreational sites. It looks like your site outgrew that type of server a long time ago.

I can set you up a temp site here so you can do all your modding. If you choke this server then there is a major snafoo in your db. This server is a monster for a webserver.
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 » Sat Sep 25, 2010 10:48 pm

Awful nice of ya, but gotta get the site live, members are startin to get itchy already.

Problem is we are to big for shared, but to small for anything real $$$.


and it $4 a month for IntegraMOD hosting at siteground but it cost a min of $20 to get started.
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 » Sat Sep 25, 2010 11:08 pm

Oh Thank GOD, no really.

I had to smooth things over with the host as they went from hey lets help you fix it, to get all your stuff and leave. [ prob my fault, not a people person]

I have been spared and given time.

here is what IM looking at I guess.

$50 a month for fully managed,
could get it for $40 but only semi managed n no CP.
http://www.hostgator.com/vps-hosting/
CPU
1.13 GHZRAM
768 MBDisk Space
30 GBBandwidth
500 GB

http://www.siteground.com/semi_dedicated_hosting.htm
I will still ask siteground what they offer.
Page just says 2x shared cpu lvls and useage allowed.
for $30 a month free, CP
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 » Sat Sep 25, 2010 11:38 pm

Oh and if you wanna check up on us its

ViragoTechForum.com

kinda of an easy guess <img>
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

PreviousNext

Return to IntegraMOD 141

Who is online

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

cron