server lag because of cmi

xPoyraz commented 4 days ago

Description of Issue

At certain intervals the server lags and whenever I examine the spark I see that the cmi has a very high consumption, this problem did not exist in the past, it has just started to happen

https://spark.lucko.me/tEdBti1YKZ

Version Information

[20:22:31 INFO]: --------------------------------------------------
[20:22:31 INFO]: CMI: 9.7.4.1 BungeeCord CMIB  MySQL
[20:22:31 INFO]: CMILib: 1.5.0.3
[20:22:31 INFO]: Sunucu: Purpur(1171) 1.16.5-R0.1-SNAPSHOT-
[20:22:31 INFO]: CMI ekonomisi: Devre dışı Kasa: 1.7.3-CMI CMI sohbeti: Etkin
[20:22:31 INFO]: Modüller -> 35 Etkin 31 Devre dışı: spawnerProximity, cuffed, customMessages, mirror, tablist, moneyCheque, skin, noTarget, elytraBoost, cmiPlaytime, bossBarCompass, playerCombat, votifier, shulkerBackpack, headDrop, spawnerCharge, namePlates, timedCommands, homeInteractions, launchPad, anvilRenameColor, jail, spawners, paintingEditor, kits, flightCharge, deathMessages, worldLimitsElytra, worldLimits, ranks, firstJoinMessages
[20:22:31 INFO]: --------------------------------------------------

Errors

No response

Relevant Config Sections

No response

Relevant Plugins

No response

Agreements

[X] My server is supported by CMI.
[X] My version of CMI at the time of this report is up to date.
[X] I have searched the github and asked around before making this report.

Zrips commented 4 days ago

From timings it looks like you have ForceLoadOnLogIn enabled, this could cause lag spikes if your database is slower, especially if its located on a remote server. In that case, do not use it.

AhmHkn0 commented 4 days ago

If this setting is turned off, will the data be lost if the server is forcibly shut down? Does this have an autosave feature?

Zrips commented 4 days ago

This setting is meant to be used on bungee servers, to force data loading on player join. As comment above it states, its a experimental thing and could cause some issues. For regular use you will not need to force save or load, data is being saved on regular basis

xPoyraz commented 4 days ago

the database is located on the local host, but I will turn off this setting and try it anyway

Zrips commented 2 days ago

Closing ticket for now.

Zrips / CMI