LuckPerms

LuckPerms

905k Downloads

Slow mariadb with Luckperms

msmanui opened this issue ยท 0 comments

commented

Description

Hello! Hoping you having a good one!
Basically, there are certain hours where users don't have certain permissions. For example, yestarday a vip told me that he hadnt some cosmetics permissions and now today is fixed.

My luckperm's database is almost 2GB size. Using mariadb

Here is a slow query log of 5s. I have like 30 databases, and only LuckPerms appear in these logs.
https://gist.github.com/msmanui/89405c94bec3ca3cc512427bd29d1b02

Reproduction Steps

I'm not so sure. It's simply happening

Expected Behaviour

Not to happen

Server Details

1.17.1 Paper, as well happens in 1.19.3 paper, as i have 2 survivals

LuckPerms Version

v.5.4.117

Logs and Configs

https://gist.github.com/msmanui/2bb12542dd6accdaa09a950800c2210e

Extra Details

No response