Lags ~WorldGuard adding regions

Hey,
just settings up my server,
about 15-20connected at the same time (i setup for 40slots)
i've 2*2.4Ghz Xeon, and 4Gb of RAM (+2go burst), runing CentOS 64bits.

every time I add a new region using WorldGuard, a lot of lags happend, and many people are deconnected
WorldGuard uses MySQL database, which is on the same server as mine Bukkit serv.

Can anyone help me ?

thanks !!

PS : french user, not the best english ^^

Plugins running :
AutoMessages
ChatManager
ChestShop
Essentials
iConomy
Lockette
MobArena
Modifyworld
NoCheat
PermissionsEx
PluginMetrics
Simple Player List
SimpleRegionMarket
StopTalkingAutoBan
WorldEdit
WorldGuard
xAuth

Launching by :
java -Xms1800M -Xmx5800M -jar craftbukkit.jar nogui

 

Try using flat file to see if it's a MySQL issue?

 

Yep, but every data stored in MySQL wont be in the file :x
and it's risky for my server

or i've to run it with whitelist, but maybe it won't happended with few people online.


PS:
xAuth/iConomy are using MySQL too, without any problems I think, but WorldGuard uses more queries !

 

What was the last change you did to the server before this started to happen?

 

i didn't change anything,
just more regions created, and more and more people joining my server !

PS : i've some "can't keep up" warnings sometimes...

 

To me it sounds like it's a MySQL issue.

I really would try without MySQL for a bit for WG. I would imagine MySQL would support even more regions than flat file thought. I've had hundreds of regions in flat file without issues. So I don't think it's the amount.

I know iConomy had issues with /money top (it would lag the server badly) a few versions ago, but I don't think that's related.

 

hmmm, ok i'll try to give a try haha

but why here's this MySQL issue :/ ?
have to found out why !

 

Could it be a bug in WG, have you seen if anything familiar been reported by anyone else in WG's bug tracker?

Ate you definitely sure that your MySQL DB is on the same machine as your Minecraft server?

 

only this :
http://forum.sk89q.com/threads/sql-worldguard-facepalm.1292/

it only happened when using /rg define !


EDIT : PEX uses MySQL too, without any problems ...

(about 160regions defined !)

 

Sure it's not a bukkit build >2136 issue?

(fixes entity clipping issues and causes increased CPU load which might generate lots of can't keep up warnings)

 

No, it's a MySQL issue i think,
but i don't know where does it came from ...

up

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Still continue...

"end of stream" every player disconnect ...
really, really annoying.

 

As much as I hate to say this, if you can't seem to find the issue and it's that severe, redefine your regions using flat files and see if that helps.

 

Hi,

I'm having the same issue, so I tested Worldguard + MySQL on an empty server with only WorldEdit and WorldGuard and it's running fine.

I'm still looking for the issue, but it might be a conflict or so with another plugins, and I have those in common with you : ChestShop, iConomy, NoCheat (but I'm using NoCheat+), xAuth.

Edit: tested again with all plugins seems to be normal now, maybe the mysql server was lagging or something, weird :\

Edit : Tested on my second server, much more powerful, and it's lagging, it takes 3-4 secs to define a region, with flat-file it's immediate

Edit : Lags are back on the first server >_>

 

soo....

shall i try with flat file :x ? (even with 270regions)

 

Problem solved with a flat file.

 

Is 1,200 regions too much for one world? WorldGuard is getting 25% of my plugin timings and I thought maybe this is why...