Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Lag caused by amount of queries #977

Open
martijnpu opened this issue Jan 30, 2019 · 1 comment
Open

Lag caused by amount of queries #977

martijnpu opened this issue Jan 30, 2019 · 1 comment

Comments

@martijnpu
Copy link

martijnpu commented Jan 30, 2019

Hi,

We need to restart the server we use every 3-4 hours because the amount of lagg.
I've found the command /lwc admin report wich shows this:

30.01 13:34:55 [Server] INFO Version: 2.1.3-dev-e9744bb
30.01 13:34:55 [Server] INFO Running time: 1 hour 10 minutes 29 seconds
30.01 13:34:55 [Server] INFO Players: 5/50
30.01 13:34:55 [Server] INFO Item entities: 12/586
30.01 13:34:55 [Server] INFO Permissions API: VaultPermissions
30.01 13:34:55 [Server] INFO Currency API: VaultCurrency
30.01 13:34:55 [Server] INFO ==== Modules ====
30.01 13:34:55 [Server] INFO LWC v2.1.3-dev-e9744bb -> 49 registered modules
30.01 13:34:55 [Server] INFO ==== Database ====
30.01 13:34:55 [Server] INFO Engine: MySQL
30.01 13:34:55 [Server] INFO Protections: 28,741
30.01 13:34:55 [Server] INFO Queries: 2,359,738 | 557.99 / second
30.01 13:34:55 [Server] INFO ==== Cache ==== 
30.01 13:34:55 [Server] INFO Usage: 99.90%  ( 10050/10060 [10000+60] )
30.01 13:34:55 [Server] INFO Profile: 
30.01 13:34:55 [Server] INFO isKnownNull: 13,638,985 (3225.11 / second)
30.01 13:34:55 [Server] INFO getProtection: 9,750,181 (2305.55 / second)
30.01 13:34:55 [Server] INFO addKnownNull: 41,876 (9.90 / second)
30.01 13:34:55 [Server] INFO addProtection: 10,106 (2.39 / second)
30.01 13:34:55 [Server] INFO removeProtection: 26 (0.01 / second)

I'm suprised by the amount af queries, speceficly the 'isKnowNull'.
Is here a solution for this?

martijnpu

@pop4959
Copy link

pop4959 commented Jul 17, 2019

Friendly reminder that this is the repository for the original plugin which is dead. Also, the version you posted seems to be for a different fork of the plugin, and outdated at that. You should probably update, and post on the correct repository for support if you have problems.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants