TheYeti/mcMMO — Issue #134: Severe Lag on player joins/exits and levelling
Author: Direct1221
Created: 2012-02-09 01:23:37+00:00
State: open

I run a server that has the specs of:

- 8GB RAM
- 100MBit Connection
- Intel 3930K Sandybridge-E Hex-core processors
- CentOS 5.7-x86_64 (Operating System)
- Worlds are situated on SSD Drive
- Multiple Plugins
- mcMMO version 1.2.10
- Craftbukkit 1.1-R3
- Remote MySQL Database (Had it local database with the same problem)

I have noticed that the server has a hangtime of 2-3 seconds when a person logs in/out as well as when a user gains a mcMMO level. I have tried the server ALONE with just mcMMO and the same results pursue.

I thought it was maybe the hosting, so I contacted my host and asked them about it, and they said that they have other servers that run mcMMO as well, that max out their CPU at all times.

As you can see, the server should be able to handle mcMMO easily, but this is not the case.

I have removed mcMMO for the time being, but I would love to have it back, as it is a player favourite amongst our users.

There have been no errors besides the ones pasted below. Help would be greatly appreciated.

Also note, we tried leaving the server with just mcMMO on for 12 hours to make sure it was not just temporary lag, but it lagged even after that elapsed time.

Error:

16:26:06 [INFO] SQLException: Data truncation: Out of range value for column 'woodcutting' at row 1
16:26:06 [INFO] SQLState: 22001
16:26:06 [INFO] VendorError: 1264