Timeout when zoning

[John Adams]

Slight derail here, but let me tell you why I like Angelox' work, too... he doesn't run his own server which only has these changes, so someday when he gets bored and quits, all those cool improvements don't vanish like a fart in a hurricane. They are still here for everyone to enjoy.

I would just like to get to the bottom of the optimization issues globally, because sometimes my zones take 2 secs to load, sometimes almost a full minute. That has to be data (mysql.exe pegged at 90%). This is even on raw PEQ, too (there, got the thread back on track)

[cbodmer]

I think the loot/loot-table takes the longest to load.

Try running a static zone in a command line window, especially when your world is active. "Zone" is very verbose and you can see exactly what it is doing and how long it takes.

-Chris

[Angelox]

Originally Posted by John Adams

I would just like to get to the bottom of the optimization issues globally, because sometimes my zones take 2 secs to load, sometimes almost a full minute. That has to be data (mysql.exe pegged at 90%). This is even on raw PEQ, too

.

Seems to me, the more data you put into a zone is what affects the database. cbodmer mentioned the loot tables are what take longest to load, this makes sense, because I've found a lot of "stray" data in that area, that leads no where. It's like it's there, but the npc's that use it are not there anymore. So if you have a zone full of loots, and you load those loots, plus un- needed loots, then this could make more load than needed.
Trick is, how do you figure out what is the loot in use, and what is not, so it can be removed?

[sesmar]

Originally Posted by Angelox

Trick is, how do you figure out what is the loot in use, and what is not, so it can be removed?

This query will tell you all Loottables that are not assigned to a NPC.

SELECT
  npc_types.id,
  lootdrop.id
FROM
  npc_types
  RIGHT JOIN lootdrop
    ON lootdrop.id=npc_types.loottable_id
WHERE
  npc_types.id IS NULL

Warning this query will take a little bit of time to run, for some reason MySql does not like right joins looking for nulls but it will work and will give you the desired information.

[bufferofnewbies]

Hey, it actually wasnt a dbase error.

It was an MySQL error. I reloaded the drivers, apparently one was corrupted as was causeing an error in packet sending. Once I reloaded them (not sure which one, as I just did them all due to lack of time.), most zones times take about as long as a sneeze again. Of course, my dBase probably DOES need an enima with all the extra stuff in it.

ODBC Driver.exe for the win!

So anyone who is having this problem with something like Angel's dBase (since he usually optimizes his pretty well), try reloading MySql drivers.

[fathernitwit]

loot is stored in shared memory, it is not loaded at zone boot, so that is not your problem.

[bufferofnewbies]

I dont believe my error was about loot
It was about packets not being sent to players at all.
For some reason, whenever they zoned it simply stopped acting upon them.

but then again, I don't really know what all is being done. It could be anything.
All I know is.. The only thing i have changed so far is mysql and now the problem is solved.

[John Adams]

FNW, what's in the Zone debug logs is slightly confusing then:

[10.30. - 16:14:00] [ZONE__INIT] Loading server configuration..
[10.30. - 16:14:00] [ZONE__INIT] Log settings loaded from log.ini
[10.30. - 16:14:00] [ZONE__INIT] Connecting to MySQL...
[10.30. - 16:14:00] [ZONE__INIT] CURRENT_ZONE_VERSION: EQEMu 0.7.0
[10.30. - 16:14:00] [ZONE__INIT] Log settings loaded from ./log.ini
[10.30. - 16:14:00] [ZONE__INIT] Mapping Incoming Opcodes
[10.30. - 16:14:00] [ZONE__INIT] Loading Variables
[10.30. - 16:14:00] [ZONE__INIT] Loading zone names
[10.30. - 16:14:06] [ZONE__INIT] Loading items
[10.30. - 16:14:06] [ZONE__INIT] Loading npc faction lists
[10.30. - 16:14:06] [ZONE__INIT] Loading loot tables
[10.30. - 16:14:06] [ZONE__INIT] Loading guilds
[10.30. - 16:14:06] [ZONE__INIT] Loading factions
[10.30. - 16:14:06] [ZONE__INIT] Loading titles
[10.30. - 16:14:06] [ZONE__INIT] Loading AA effects
[10.30. - 16:14:06] [ZONE__INIT] Loading swarm spells
[10.30. - 16:14:06] [ZONE__INIT] Loading tributes
[10.30. - 16:14:06] [ZONE__INIT] Loading corpse timers
[10.30. - 16:14:06] [ZONE__INIT] Loading commands

This looks like the Items and Loot Tables are loaded into each zone -- tho the memory usage makes me think differently. Wouldn't zone mob loot table be unique to that zone only? Maybe this is getting off topic. Sorry.

[cbodmer]

World does load items into shared memory, but I don't think it does loottables and lootdrops, that wouldn't make much sense. I am not sure what the items are the zone is loading...

-Chris