Description

I'm running luckperms v5.4.71 with ~160 players on 1.19.3 with mysql
And I checked mysql requests, luckperms does a lot of requests to it, so I'm not sure it's normal
(I tried to reduce my iowait, as even with a 13900k and a samsung nvme 980 pro, I got up to 3% iowait, mainly from mysql)

Here are the requests :

Also "luckperms_messenger" is used for what is I got only a single server ?

Reproduction Steps

• use luckperms at (high) player count

Expected Behaviour

Maybe the number of requests should be lowered

Details

LuckPerms version : 5.4.71
Server version : Pufferfishplus-44 1.19.3
Only one server under mysql, on localhost

Extra Details

Someone told on discord :

luckperms shouldnt be making a request to the database every time a permission is checked
when a player joins, it loads their data from storage, and then permission checks are done against what it loaded

So that's why I open this issue

Spark

Here is a spark with Luckperms (took 2 days ago until I update my luckperms version) that was taking a lot, I don't think it helps as it might plugins requesting too much permissions (I fixed antiAC that took 0.08%)

If you only have a single server connected to the database, you can set:

messaging-service: notsql

in your config.yml to disable the messaging service.

Happy to look into the spark but you need to send the link, not screenshots :)

I had

messaging-service: none

So it should be "disabled", will try to change it and check again requets to database

And here are the sparks : https://spark.lucko.me/m3EsB6pXbh
https://spark.lucko.me/B5Pjggc3Q4

Edit :

Here is with messaging-service: notsql
So it's still the same on database requests
I didn't restart server but used /lp reloadconfig

You'll need to restart the server to have the config change take effect (that property is not reloadable :P)