search

Zarius / Bukkit-OtherBlocks

OtherBlocks (now known as OtherDrops) plugin for Bukkit (dev build: https://www.mediafire.com/?i6ows1g6kus2o0l)
http://dev.bukkit.org/server-mods/otherdrops/
GNU General Public License v3.0
17 stars 17 forks source link

Sever lag when posting to remote MySQL server #295

Closed p0wd3r closed 8 years ago

p0wd3r commented 10 years ago

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:

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.

Zarius commented 8 years ago

OtherDrops just uses the Vault API and then Vault just uses the economy plugin's API so I presume the lag would be from the economy plugin (as OtherDrops doesn't have any DB code in it at all). Closing this issue for the above reason and as it's quite old.