search

PyvesB / advanced-achievements

:fireworks: Popular plugin that adds unique and challenging achievements to Minecraft servers.
https://www.spigotmc.org/resources/83466
GNU General Public License v3.0
199 stars 215 forks source link

Advanced Achievements lagging #567

Closed RJGamers closed 5 years ago

RJGamers commented 5 years ago

Hello. This plugin has been causing lag on my server for quite a few weeks now and i have had no response from anywhere. We only have about 20-30 players.

Do you have any ideas?

We are now running spigot 1.14.4

Thank you

aaa

RJGamers commented 5 years ago

aaaa

supertassu commented 5 years ago

Can you post a link to the full timings report?

RJGamers commented 5 years ago

Are there any achievements i can remove to stop the lag at all?

PyvesB commented 5 years ago

Hello @rosiejane,

What database type are you using?

Cheers,

Pyves

RJGamers commented 5 years ago

@PyvesB

DatabaseType: sqlite

PyvesB commented 5 years ago

I would recommend giving H2 a try, it will probably improve performance quite a bit!

RJGamers commented 5 years ago

Okay thank you i will change it,.

Would MySQL better better than H2 ?

I tried MySQL a long time ago but it would not connect

I will use H2 for now though

Thank you.

PyvesB commented 5 years ago

I wouldn't say that MySQL is better than H2: they're quite different underneath the hood, it depends on the versions used, the configurations, etc.

Do let us know if H2 helps with the performance. 😉

RJGamers commented 5 years ago

Just checking. There is no H2 option in the config. But if i type H2 i assume it will still work correct?

Database type, sqlite, postgresql or mysql. Do a full server restart for this to take effect. DatabaseType: H2

PyvesB commented 5 years ago

Make sure you're using the latest version of Advanced Achievements and specify h2.

RJGamers commented 5 years ago

I am using 5.12.3

I will give it a day or 2 and let you know how it goes.

Thank you

RJGamers commented 5 years ago

@PyvesB

Is there any way to load the old database now im using h2? As currently everyone has to start fresh. ugh!

.db is the old one. (The one we need to use) .mv.dm is the new one.

dat

PyvesB commented 5 years ago

There are probably migration tools available, however, I've never tried using one.

RJGamers commented 5 years ago

I have tried to convert the database but it does not work. Ugh that is so disappointing.

We have over 450 Achievements and so many players have put a ton of effort in to them .Hours and hours.

Using h2 is just not an option, but i will use it for a day or 2, just to see if it lags, i guess its a good test while all players achievmeents have reset.

PyvesB commented 5 years ago

Send the old SQLite database by mail, I can give converting it a quick try. Though I'm not guaranteeing success!

RJGamers commented 5 years ago

I will do this soon. Thank you

RJGamers commented 5 years ago

@PyvesB

Email has been sent

PyvesB commented 5 years ago

Okay, will try it out sometime this week!

PyvesB commented 5 years ago

I sent you my attempt back by mail. It wasn't easy as SQLite and H2 use completely different date formats, but hopefully I've gotten it right. Let me know if it works as expected! 😉

PyvesB commented 5 years ago

How are things looking @rosiejane ?

RJGamers commented 5 years ago

It seems to be looking great so far. Ive ran a couple of timigns reports and they seem fine with acheivements. I will continue to check it when the server is busy as well.

PyvesB commented 5 years ago

It's been roughly a month since since the database type switch and there haven't been any complaints about performance, I believe it's safe to assume things are going well. Closing. 😉