WorldGuard

WorldGuard

8M Downloads

Major Lag with Region in MySQL

LadyCailinBot opened this issue ยท 8 comments

commented

WORLDGUARD-2349 - Reported by typhoonwes

When someone does anything with a Region it lag the server for about 10 sec or more.
What is the cause of this.
Is it the MySQL database? if so, how can i convert it back to a flat file.

[WorldGuard] Loading WorldGuard v725-2e7ecc5
This server is running CraftBukkit version git-Bukkit-1.4.2-R0.2-27-gba31ee7-b2478jnks (MC: 1.4.5) (Implementing API version 1.4.5-R0.1-SNAPSHOT)

Thank

commented

Comment by Dark_Arc

Yes it is the MySQL database, command should be on the wiki :|

commented

Comment by typhoonwes

Thanks for getting back to me. I can not find a command to convert MySQL database to the flat file per world.
If there is, and i am missing it. Please provide the link.

Thanks.

commented

Comment by Dark_Arc

/rg migratedb

commented

Comment by snake2_cz

I have the same problem with the regions. But I need to use MySQL because of the use of the site. Is there any solution to this problem? Or it will be fixed in the near future updates?
Pastebin with console: http://pastebin.com/16B86DAd
I use CB Spigot 1.4.5 R0.3 and WG 5.6.5.
Thank you. And sorry for my english :)

commented

Comment by sk89q

It's going to be fixed in the next major version.

But I will likely not be very available until around Christmas time so I won't have much time to work on it until after Christmas.

commented

Comment by typhoonwes

Thank you Sk89q, I have switch over to the defalt file. Beside its very easy view and make changes with out having to be in game.

Your plugin is the best. with out it. MineCraft would be stupid, always having to fix stuff.

commented

Comment by DStranger

Is there any solution to solve that problem using Mysql?Flat file isn't an option.craftbukkit-1.4.5-R1.0,mysql 5.5.29,WG 5.7

commented

Comment by Vanwa.Arda

I'm still having this problem, and it's kicking all players from the server, with no errors on console. It didn't happen until I started using MySQL, and I cannot go back now.
Running CraftBukkit 1.4.6-R0.3, WG 5.7