WORLDGUARD-2257 - Reported by sk89q

Currently, the MySQL support deletes all rows and then re-inserts all of them, which has severe performance concerns. It also does not make use of transactions, and so power failure in the middle of an operation would result in potentially massive data loss.

Comment by DStranger

When this problem will be solved?

Comment by Michael.Schäffer

i hope it will be possible in future. its essential for server with high region count :/

Comment by TheRealB

Slowly it gets on our nerves to find a lot of workarounds because we cant migrate to MySQL.
With more than 4.000 regions in MySQL and 100+ players the server lags like hell. Same configuration in YML without problems...

Comment by wizjany

as the info says, it will be solved whenever 6.x is released
until then, complaining more about it will not speed things up
and no, we don't have ETAs

Comment by Vanwa.Arda

Don't mean to be a pain in the butt here, but we are desperate for a fix for this. Any progress so far?

Comment by sk89q

It's currently pending on my free time, which comes and goes, but it was the last thing that I was working on.

Comment by Vanwa.Arda

Alright, thank you sk. Your plugins are the most loved out of any we use!

Comment by wizjany

the fix is to stick with yml for now -.-

Comment by Vanwa.Arda

I migrated my WG data to SQL already though. Any way to switch back? As far as I know, there is no way to revert to YAML...

Comment by wizjany

same way as yaml to sql, just the other way around

Comment by sk89q

Fixed in the {{region-api-update}} branch.

Note: Do not actually use that branch yet.