WORLDGUARD-3055 - Reported by fastlockel

MySQL is intended for large servers, and I would NOT say that mine is large , however because of people protecting their houses I came to have about 3000 cuboids protected with an average of 3 flags.
My server was lagging, and crashing... (OutOfMemoryError) And I finally realized that just adding a flag (like rg flag regionID USE ALLOW) took about 4 seconds with full server lag (25 person frozen) and about 300K memory !
I came back as suggested on forums (google search) to flat yaml files : all issues disappeared !

How could it take 4 seconds to add an entry of one row and 5 columns ito a database ? My guess is that on every change it reloads everything.

I am using latest version of bukkit craftbukkit-1.7.9-R0.1-20140501.232444-18.jar, latest worlguard : WorldGuard 5.9, a fast MySQL DB (Coreprotect has 80x more data than worlguard) (rented dedicated server)

Or at least put a warning that MySQL implementations is for small amount of cuboids (<500)
Best regards.

Comment by sk89q

It is a known issue. It's third party code and I don't know who actually accepted it, but it should never have been.

Comment by sk89q

Download a test version with the fix:
http://forum.enginehub.org/threads/worldguard-6-0-beta-build.15666/