Sever lag when posting to remote MySQL server
p0wd3r opened this issue ยท 1 comments
OtherDrops v2.8b.573
iConomy (no version listed, latest)
Vault v1.2.27-b349
When iConomy is tied to a remote MySQL server (on the same network) and OtherDrops is set up to give money for killing mobs the lag is crazy, and makes the world unplayable. Many warnings like this...
[WARNING] Can't keep up! Did the system time change, or is the server overloaded?
Most of the rewards are configured like this one, not very complicated...
ZOMBIE:
- tool: ALL
drop: MONEY
quantity: 0.5
chance: 100
When I change iConomy to use a local mini DB the lag goes away completely. I'm also logging a lot of stats (stats by lolmewn v1.36-69) to the same remote server which sends a lot more data than OtherDrops does. The CPU/RAM/Network Usage do not spike at all.