arkaz.org

Hum, it seems to always be a Death making it go down. I'm going to start looking at the DB tables.

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.

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.

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.

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

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)

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.

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