Slow mariadb with Luckperms
msmanui opened this issue ยท 0 comments
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