PingDB Record Plugin - Keep a statistic of the players ping each second and log to database.

Status
This thread has been locked.

JasmeowTheCat

Systems Administrator
Supreme
Feedback score
36
Posts
563
Reactions
267
Resources
0
NO SERVICE TEAMS. YOU WILL BE REPORTED. IT CLEARLY SAYS INDIVIDUAL.
Hello! Looking to get a simple plugin that reports the players ping into database each second it updates. You know how TAB plugins update each second with the players ping? I would like that stored into a database so I can then do data averages and a graph to find out when the ping spikes happen.

Before telling me, I understand this will do heavy statistics and will be stupid to track when having many players online, but when there's 5-10 with ping issues, we want to take every second a "ping" of the player.

See the GIF below. See how each second it updates? Yep, I basically want to log this to a database with the players IP, their name, their UUID, their ping value at the time, and a Unix timestamp. 5 columns.
gsyuDd.gif


Some FAQ's already been asked that I can answer here:
Q: will the plugin only put the players ping in a database, or will it also handle the statistics side of things
A: It will only add the data to the database. MySQL preferred, then we can pull that data into Grafana later on or do Excel charts.

Q: will the plugin be responsible for dropping rows after a certain period of time? the growth of this database will likely be crazy fast, no?
A: I appreciate you asking, so perhaps a purge system like /pingdb purge or something, like /pingdb start, /pingdb stop and then /pingdb purge? That sounds like a smart idea and I didn't think that far ahead lmfao.
 
Type
Requesting
Provided by
Individual
PebbleHost
High performance, consistent uptime and fast support. Minecraft hosting that just works.

Function

Minecraft Plugin Developer
Supreme
Feedback score
38
Posts
936
Reactions
333
Resources
0
NO SERVICE TEAMS. YOU WILL BE REPORTED. IT CLEARLY SAYS INDIVIDUAL.
Hello! Looking to get a simple plugin that reports the players ping into database each second it updates. You know how TAB plugins update each second with the players ping? I would like that stored into a database so I can then do data averages and a graph to find out when the ping spikes happen.

Before telling me, I understand this will do heavy statistics and will be stupid to track when having many players online, but when there's 5-10 with ping issues, we want to take every second a "ping" of the player.

See the GIF below. See how each second it updates? Yep, I basically want to log this to a database with the players IP, their name, their UUID, their ping value at the time, and a Unix timestamp. 5 columns.
gsyuDd.gif


Some FAQ's already been asked that I can answer here:
Q: will the plugin only put the players ping in a database, or will it also handle the statistics side of things
A: It will only add the data to the database. MySQL preferred, then we can pull that data into Grafana later on or do Excel charts.

Q: will the plugin be responsible for dropping rows after a certain period of time? the growth of this database will likely be crazy fast, no?
A: I appreciate you asking, so perhaps a purge system like /pingdb purge or something, like /pingdb start, /pingdb stop and then /pingdb purge? That sounds like a smart idea and I didn't think that far ahead lmfao.
still looking?
 
Status
This thread has been locked.
Top