Schedule Outage

Read me first before posting anywhere!

Moderators: Dungeon Masters, Hala DM

terryrayc
lord of all I prevail
lord of all I prevail
Posts: 4646
Joined: Wed Jun 22, 2005 12:00 am
Location: Florida
Contact:

Re: Schedule Outage

Post by terryrayc » Tue Sep 11, 2012 2:27 am

Hum, it seems to always be a Death making it go down. I'm going to start looking at the DB tables.
Visit the Arkaz Wiki at http://www.arkaz.com/lore

terryrayc
lord of all I prevail
lord of all I prevail
Posts: 4646
Joined: Wed Jun 22, 2005 12:00 am
Location: Florida
Contact:

Re: Schedule Outage

Post by terryrayc » Tue Sep 11, 2012 2:53 am

The DB looked fine, however there were a ton of VERY old entries in the Death Tables from like 07 so I removed those. Let's see if that helps.
Visit the Arkaz Wiki at http://www.arkaz.com/lore

terryrayc
lord of all I prevail
lord of all I prevail
Posts: 4646
Joined: Wed Jun 22, 2005 12:00 am
Location: Florida
Contact:

Re: Schedule Outage

Post by terryrayc » Fri Sep 14, 2012 12:47 pm

I'm taking the servers down for a bit to do some detailed testing. I'll try to keep them down for only a short time but I want to try and figure out the lag issue.
Visit the Arkaz Wiki at http://www.arkaz.com/lore

User avatar
struldbruggian
Lost One
Lost One
Posts: 81
Joined: Thu Jun 28, 2012 2:39 am

Re: Schedule Outage

Post by struldbruggian » Fri Sep 14, 2012 12:51 pm

was on nuvar with a newbie char, they died by worg about, 5:30am ish? EST. the death caused the server to crash, it came back up after a few minutes, and i logged into thessala's and continued from there.

been doing some of the lowbie dungeons around old hamlet this morning, and noticed several significant, but not prolonged, lag spikes happening.

Brayon
Site Admin
Site Admin
Posts: 2477
Joined: Fri Mar 10, 2006 12:00 am
Location: Florida

Re: Schedule Outage

Post by Brayon » Fri Sep 14, 2012 2:02 pm

Yes, when dieing and headed into the Death Travel area, where the item strip happens, that is when it seems to lag the most. It also seems that depending on who died, and how much gear/inventory they have, is how bad the lag is.

1st level Squishy = Lag spike, but no crash in most cases.
40th level Epic = Total Server Kill

terryrayc
lord of all I prevail
lord of all I prevail
Posts: 4646
Joined: Wed Jun 22, 2005 12:00 am
Location: Florida
Contact:

Re: Schedule Outage

Post by terryrayc » Fri Sep 14, 2012 2:51 pm

dying uses like 4 tables....might be an issue with several. I'm going to do some testing. But right now it looks like it's a DB issue.

I've cleared out the Death Table so at this moment I'm leaving toward the blueprint table (It stores a hash of every item so we can handle custom items that are not in the palette)
Visit the Arkaz Wiki at http://www.arkaz.com/lore

terryrayc
lord of all I prevail
lord of all I prevail
Posts: 4646
Joined: Wed Jun 22, 2005 12:00 am
Location: Florida
Contact:

Re: Schedule Outage

Post by terryrayc » Fri Sep 14, 2012 5:09 pm

mods are back up. I updated the underlying vmware platform while I had the servers down. We were running ESXi 3.5.4 we are now running 4.0.4. Little more stable.

Things seems to be better. I've been optimizing the database as well. The only issue is that if we have a issue with the blueprint table repairing it might cause some issues. The hash's in this table are what allow you to put custom items in pchests and get them back out still custom.

I'm going to go through the table and try and find anything that looks funny but when dealing with data blobs it's hard to spot funny.
Visit the Arkaz Wiki at http://www.arkaz.com/lore

User avatar
terror2001
The One
The One
Posts: 3809
Joined: Wed Jan 25, 2006 12:00 am
Location: GMT -7(-6)

Re: Schedule Outage

Post by terror2001 » Fri Sep 14, 2012 5:57 pm

I am also looking at optimizing the death scripts to perform more efficiently.

Post Reply