15.05.2014, 15:03
Ah ok.
Was just looking at my mysql server's 'Status' for the last 17 Days:
Gets an average of 31 Queries a minute at the moment, so im sure an extra (MAX 64) few more per minute wont do any harm.
Calculated average player count for the server over the last 4 months at anytime to be 7.1 ( I record player count every 5 minutes )
My only concern, is if i'm recording say 20 players a minute average ( In the future
), that's 892,800K Records a month, but this kind of data is not really needed to be kept at a one minute accuracy for more than a month, so I may instead have a cron to take 10 min averages of the data in a separate table, then a cron to remove all minute data that's older than a month. Any suggestions for a better implementation welcome and appreciated xD
Was just looking at my mysql server's 'Status' for the last 17 Days:
Gets an average of 31 Queries a minute at the moment, so im sure an extra (MAX 64) few more per minute wont do any harm.
Calculated average player count for the server over the last 4 months at anytime to be 7.1 ( I record player count every 5 minutes )
My only concern, is if i'm recording say 20 players a minute average ( In the future
), that's 892,800K Records a month, but this kind of data is not really needed to be kept at a one minute accuracy for more than a month, so I may instead have a cron to take 10 min averages of the data in a separate table, then a cron to remove all minute data that's older than a month. Any suggestions for a better implementation welcome and appreciated xD