Quote:
Originally Posted by Rikon
I wasn't paying attention when I necro'd a thread about Loot lag in the Windows server section. Considering I am running Linux, I thought having it's own thread here would be wise. Here are some the pertinent info.
Server: Linux Debian 8.1
MySQL: 5.5.43-0+deb8u1
Symptom::
When users go to loot corpses, they can only loot one or two items before it lags out and they have to re-loot. A similar, and probably related, issue occurs when dealing with vendors.
The source I compiled from was taken from direction followed HERE on the Wiki. I.E. git://github.com/EQEmu/Server.git
My DB was populated from PEQ ( http://peqtgc.com/releases)
I've been busy with work, but I can try to get a video capture if it would even help.
|
There is a rule that pertains to discovered items, if this rule is enabled this can slow looting down as each item loot is a hit to the DB because it wasn't written the best (Sorry Trevius I love you man). I'm not sure if he added memory caching to each of the lookups or not. This can definitely do it.
It wouldn't hurt to enable MySQL query debugging to see what is actually taking up the most query time.
Example:
http://wiki.eqemulator.org/p?Logging...gging-to-gmsay