Hiveworkshop slow

[Anachron]

It will never disappear!

Its the new Forum FEATURE!

 

[Etzer]

yay.....

 

[Legend_Dk]

Nice feature..

Another feature there could be implemented maybe to ease the server load could be to make somekind restriction to guest, or something like that..
Just an idea, idk if its possible or a good idea ;P

 

[Samuraid]

To those who are talking about deleting posts/uploads:

First off, even if we purged old posts and uploads from time to time, the site gets far more posts and uploads every day. We would be fighting a losing battle as the amount of content on the site would still be increasing. And even if it helped now, the problem would return soon enough.

Secondly, it actually won't make much of a difference if we delete the material or not. The database is meant to scale as linearly as possible, meaning that it performs at roughly the same speed* regardless of whether there are 10,000 items or 1,000,000 items in it. So deleting a few things isn't going to make a notable difference.

* So long as indexes fit within RAM, and all queries are optimized to properly use indexes.

 

[MGCǂSpectre]

I think it is rather the number of uploads than the number of members online that is causing it. Whether it is the main prob or not, the sections need some filtering or clearing. There are like 1000 (many) sword models, 1000 staves, shields and such and such. Well, it's from different members but really, slow down modeling

 

[Anachron]

OH well, I think the biggest problem is the amount of low-quality maps that are uploaded everyday.

 

[Legion_King]

I also hate this:
The Hive Workshop is currently backing up the database, please stand by!

 

[ap0calypse]

OH well, I think the biggest problem is the amount of low-quality maps that are uploaded everyday.

That's true... in fact: in general, there are more uploaded maps than uploaded models (surprises me as well, since - no offense - mapping takes longer than modelling).
Those 'noob-maps' do not get deleted (Ralle doesn't want that ^^) and even if the user clicks the 'delete'-button, everyone with map mod powers can still download, rate, comment on it - so they're not deleted, it's just a sort of rejection, but worse.

also hate this:
The Hive Workshop is currently backing up the database, please stand by!

Yeah, but you should be happy they're backing up the database ^^

 

[Anachron]

That's true... in fact: in general, there are more uploaded maps than uploaded models (surprises me as well, since - no offense - mapping takes longer than modelling).

Yes, but most noobs do not know how to make models so they just open the editor, make something in 15 minutes and want the users to share the map.

Those 'noob-maps' do not get deleted (Ralle doesn't want that ^^) and even if the user clicks the 'delete'-button, everyone with map mod powers can still download, rate, comment on it - so they're not deleted, it's just a sort of rejection, but worse.

Yes, maybe some sort of "Update_or_delete" mechanism would be good. So it cleans maps that are rejected and older as 4 weeks or such without an update.

also hate this:
The Hive Workshop is currently backing up the database, please stand by!
Yeah, but you should be happy they're backing up the database ^^

Yes, but this really isn't a 'I don't like this at HWS, so I might post it here'-Thread, its more a discussion why hive is that slow.

 

[Pyritie]

As far as I know there are no plans to "clean" the resource sections.

 

[Anachron]

Whats the suppose of rejected and old not-used maps anyway?
Btw, your avatar is kind of annoying.

 

[Deleted member 157129]

It's not a matter of high activity or high database usage, but a lack of server capacity. More users -> more income from Ads -> upgraded hardware -> the forum remains functional. There really is no other, working solution. You just can't start banning guests in order to reduce the activity. Servers need to adjust according to activity, not the other way around.

 

[Tleno]

Hmmm... well I'm not sure if deleting maps will increase the Hive's efficincy, but if yes I'll definetly delete that my "Need fix" map for the name of Hive... or whatever...

 

[Deleted member 157129]

Really, I doubt the amount of content on the site is slowing down the server. The server cannot handle the high amount of requests coming in. Of course people downloading from THW slows down this process as well, but the amount of content should not have a significant impact.

 

[Pyritie]

It's a RAM problem, not a processor problem or hard drive space problem IIRC

 

[Miss_Foxy]

I don't get it.

 

[thelifelessone]

Constant "Server Busy" Message.

Why is the server always saying "Server Busy"? It's given me this message a half-dozen times in the past hour or so.

Is there a problem with your host or something?

 

[CHA_Owner]

No clue but i keep getting it also

 

[thelifelessone]

Hmm. I'm also getting really high ping:

C:\Documents and Settings\*********>ping hiveworkshop.com

Pinging rallejack.dyndns.org [91.100.6.230] with 32 bytes of data:

Reply from 91.100.6.230: bytes=32 time=167ms TTL=40
Reply from 91.100.6.230: bytes=32 time=230ms TTL=40
Reply from 91.100.6.230: bytes=32 time=173ms TTL=40
Reply from 91.100.6.230: bytes=32 time=157ms TTL=40

Ping statistics for 91.100.6.230:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 157ms, Maximum = 230ms, Average = 181ms

It's not a problem with my ISP. I know that, because I pinged my website. It's on shared hosting, and it gets a better ping.

C:\Documents and Settings\*********>ping gamercraft.org

Pinging gamercraft.org [207.182.145.231] with 32 bytes of data:

Reply from 207.182.145.231: bytes=32 time=58ms TTL=49
Reply from 207.182.145.231: bytes=32 time=77ms TTL=49
Reply from 207.182.145.231: bytes=32 time=67ms TTL=49
Reply from 207.182.145.231: bytes=32 time=68ms TTL=49

Ping statistics for 207.182.145.231:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 58ms, Maximum = 77ms, Average = 67ms

 

[Gyrosphinx]

I'm getting a lot of "Server too busy" too...

 

[Azeroc]

I am getting it nearly every 3 hours for 10-20 mins x_x

 

[Panda]

We have talked about this problem already, it is the awesome amount of users online at once that is making the server go crazy.

 

[thelifelessone]

Then THW should get a better server...

 

[Teelo]

Solution: Have the admins do something crazy to the site to drive away all the users.

Ideas:
- Reset everyones reputation
- Make the map database only accessable if you have over 1000 posts
- Change the forum theme to shades of pink
- Close registrations, and ban anyone who join from the day after whenever I joined.

 

[TriggerHappy]

Ralle runs his own server, so there is no "host".

 

[Traxamillion]

Do we honestly need this many threads about this?

 

[thelifelessone]

Ralle runs his own server, so there is no "host".

Please, tell me your kidding.

 

[Traxamillion]

hes not kidding.

 

[Samuraid]

The slow server speed is NOT due to:

• Too many maps/models/skins/posts.
• Lack of RAM.
• Lack of storage space.

For whatever reason, be it increased traffic or a software problem, the server's CPU is running near 100% for the greater part of each day.

Based on what we know so far, the server's CPU seems to be the limiting factor.

As time allows, all of us with administrative access to the server are keeping an eye out for possible solutions.

 

[thelifelessone]

Get a new processor?

Edit: Any chance you could share the specs on the server (RAM, HDD, processor, OS)?

 

[Belgarath]

they actually are in the new server announcement

 

[Samuraid]

Get a new processor?

Edit: Any chance you could share the specs on the server (RAM, HDD, processor, OS)?

Athlon X2 2.8GHz (brisbane)
4GB ECC DDR2 RAM @ 667MHz
2x500GB 7200RPM drives in RAID-1
1.5TB backup drive

We cannot get a newer processor, because this motherboard, although AM2, does not support the latest generation of Phenom II/Athlon II CPUs.
Any significant upgrade would require replacement of most of the core components.

EDIT: http://www.hiveworkshop.com/forums/site-discussion-97/new-server-pictures-52961/

 

[Teelo]

Brisbane eh? Guess that explains my low latency to this site.

 

[Anachron]

Athlon X2 2.8GHz (brisbane)
4GB ECC DDR2 RAM @ 667MHz
2x500GB 7200RPM drives in RAID-1
1.5TB backup drive

Holy crap.
What about getting Quadcore 3,2 GHZ with 8GB ram and 1TB?
Ofcourse a backup drive of 2 TB then.

I would help (donate) for it.

 

[Deleted member 157129]

4GB RAM isn't exactly impressive for a server.

 

[Ralle]

and now it starts again Server is to bussy at mom. WTF! goes on my nervs mst be some realy error in the site. I hope ralle fix this! Ralle bud go fix this pls. www.gogetskillz.com hehehe jk

Just read what ralle says. Whats the problem is the site so huge?. Why not make such thing as. After 50 threads in everytopic the others get deleted. Like on KVR. So very old post get deleted from the server. Dont need to read same post 150 times. No point. Just save the important ones liek tutorials etc.

For example. I post request in request forum.
Save all posts behind 50-100 and dlete the rest behind that. ANd it should be solved. U dont need to see 5 years old post i dont know if its allready like that but its a good point. KVR use that u know the music site KVR big as hell.

Also delete all crap old skins that sucks. Make higher rating point for modells and skins.

Like skin must be 3-4+ or higher. And also for maps and such so many sucky maps out there like no terraining skillz or not even a clue what to do in it. Tested alot of the old lotr maps they where realy just garbage. They can go upload it on Epicwar if they want. Keep the site clean for this kind of stuff. Thats just my point and opinion. Hope u get my idea ralle cheers bud.....

Also some of us could help u in this deep work. As me and other in here i can check out uggly old skins thats no even close to good. And stuff like that old bad maps. That should have been removed.

Deleting stuff would not matter at all. It would just make people spam more.

yay.....

When people spam it also adds load on the server. I suggest only using the site for useful purposes.

OH well, I think the biggest problem is the amount of low-quality maps that are uploaded everyday.

No.

I also hate this:
The Hive Workshop is currently backing up the database, please stand by!

So let's stop backing up and hope the site doesn't die.

It's a RAM problem, not a processor problem or hard drive space problem IIRC

No.

Why is the server always saying "Server Busy"? It's given me this message a half-dozen times in the past hour or so.

Is there a problem with your host or something?

It is not a problem. It is a feature to keep the server running instead of crashing.

Then THW should get a better server...

I agree.

Solution: Have the admins do something crazy to the site to drive away all the users.

Ideas:
- Reset everyones reputation
- Make the map database only accessable if you have over 1000 posts
- Change the forum theme to shades of pink
- Close registrations, and ban anyone who join from the day after whenever I joined.

No.

Ralle runs his own server, so there is no "host".

Please, tell me your kidding.

It has worked fine so far.

Get a new processor?

Edit: Any chance you could share the specs on the server (RAM, HDD, processor, OS)?

Yes.

Brisbane eh? Guess that explains my low latency to this site.

Brisbane is the model not the location.

Holy crap.
What about getting Quadcore 3,2 GHZ with 8GB ram and 1TB?
Ofcourse a backup drive of 2 TB then.

I would help (donate) for it.

What about donating the cost for it. We would need a xeon processor and an intel motherboard and I think the current 4 GB RAM would be fine.

4GB RAM isn't exactly impressive for a server.

It's enough. As earlier said. The CPU is the issue.

 

[Pyritie]

Would lowering the amount of time sessions are kept alive for make any difference?

 

[Shanghai]

give ralle some money and he can go buy better processor. Hmm actually i wana give a donation but its my mom stopping me all the time. I dont know how to make internet payment if i could do it at the bank it would be great i wil ltalk to ralle about this give some for hes hard work on this imba site.

 

[Hakeem]

SC2 beta influx overload?

 

[Anachron]

Hmm, so lets collect money?!

 

[Tleno]

Hmmm... I'm quite curious Ralle, so why it had the same problem earlier and why it happened again after you updated the website... is there is any connection between these two accidents and why now again?

 

[Deleted member 157129]

I didn't check the thread about upgrades, but you didn't actually upgrade to a CPU that was still too weak? :\

 

[Ralle]

It's fixed!

 

[Anachron]

What was it?
Btw, did you set the logged in time to 5 minutes or so?
A few hours later I got logged out every few minutes without action.

 

[Ralle]

What was it?
Btw, did you set the logged in time to 5 minutes or so?
A few hours later I got logged out every few minutes without action.

I haven't touched the settings no.

 

[Tleno]

So what you did? Went to church and removed The Curse of Epicwar? Stole a super-computer from Aliens? Found a spy who zapped your computer? Because I don't see any logical explanation here...

 

[The Reborn Devil]

He cleared some cache stuff I think.
Look at the news page


Edit:

For those interested the problem lies in a database table containing cached searches for the resource sections. A cached search is deleted after 60 seconds but after months of deleting searches without using the optimize function of MySQL the table was 900 MB big which is a lot for a table containing 100 rows at peak times. A single select query took >5 seconds to run. After an optimize it ran fine again. We have added a optimize query to the daily scheduled tasks so it should never happen again.

 

[GIANT_CRAB]

I Have join this talking! sg no lagg

/..... Stupid Fb said i dced from the website! Lame sia Fb got problem GMT+ 0800 now is 2320 in sg GMT = Global marketing time? lol we use the britain time as a "SI" unit ( this is what i learnt today at the geography class

 

[Tleno]

Pall, don't double-post. Thats against the rules. And this was like last month before you joined us...

 

[ap0calypse]

/..... Stupid Fb said i dced from the website! Lame sia Fb got problem GMT+ 0800 now is 2320 in sg GMT = Global marketing time? lol we use the britain time as a "SI" unit ( this is what i learnt today at the geography class

GMT = Greenwich Mean Time.
Greenwich is a place is England, so if you're really from Britain you should know this (I'm not saying you're not from Britain, just that you don't really know your own country and 'general' things).
And England is indeed GMT + 0, so it would be the "SI" unit, if you know that, then why don't you know GMT?

Also, the hive is not a noobish forum: people speak English here (preferably not facebookian).
We do not necro-post here ('reviving' a thread: saying something in a thread that isn't relevant anymore).
We do not multi-post here (post 2 or more things quickly behind eachother with no other comment between it), you can use the "edit" button.


Once you got all of this, you're ready to post something on the hive.