State of the Server: LAGAGEDDON

Discussion in 'State of the Server' started by akalen4u, Apr 16, 2013.

State of the Server: LAGAGEDDON
Thread Status:
Not open for further replies.
  1. akalen4u Developer

    XP:
    19,840xp
    We think we figured out what was causing it.
    It is being fixed now, so hopefully the lag will be gone again.
    Sorry for the issues over the past few days.
    TheFlurp and Zuergner like this.
  2. HighlifeTTU Network Owner

    XP:
    62,181xp
    It actually should be running a lot better. The issue we found was huge, but because there was lag it made us look at a lot of things. The database is now running a ton better, and that should overall increase performance for everything. In addition, I did some heap optimization as well as TCP stack optimization on the box.
    TheFlurp, casey49 and Zuergner like this.
  3. Xvslol Gold

    XP:
    37,504xp
    Thank you very much for the update! We all appreciate it :D
  4. HattoWolf Regular Member

    XP:
    10,550xp
    This is great to hear!
  5. Masacz Platinum

    XP:
    15,694xp
    Ahh great news :D Can't wait to test it out tonight.
  6. i360GFX Gold

    XP:
    890xp
    Awesome.
  7. Zuergner HCF Watcher

    XP:
    51,578xp
    Thanks! We appreciate your hard work and some of us understand that issues can't immediately be fixed. If you don't mind me asking, what was the database issue causing all the lag?
    GDMemories likes this.
  8. HighlifeTTU Network Owner

    XP:
    62,181xp
    A missing index causing a ton of full table scans. A full table scan isn't normally a bad thing, but you guys have a very stats intensive website. It was processing like 450,000 rows a second. This is down to almost zero now. Basically, the database would spike during heavy usage and begin impacting the actual box. Databases are meant to take some heavy load if setup properly. However, you have to make sure all your queries are optimized. Things are fixed now and even very heavy web load won't have any effect on the server.
    TheFlurp likes this.
  9. qazzy1122 Gold

    XP:
    47,185xp
    Thanks for fixing that!
  10. antelopeking Silver

    XP:
    31,401xp
Thread Status:
Not open for further replies.