How much does the database weigh for an example 1000 players/accounts/characters

[BeMajestiX]

How much does the database weigh for an example 1000 players/accounts/characters ??

 

[iNux]

10 kg

 

[Fjorda]

It all depends, the longer your server is alive, the more items people have in their depots/inboxes/houses. So there are a lot of variables to consider.

Most rows have a specified amount of bytes reserved calculated by adding up the defined sizes of each column plus some potential overheads, so even just a very large amount of rows can add up, this is why tables related to items such as player depots/tile store contain the highest amount of data, especially with the addition of any attributes blob data. And therefore....server longevity is pretty much the main factor in the equation. The more players signed up and the longer the server has been alive, the more data...

I have a stripped backup here of 7800 players and 5200 accounts. However, there are some custom tables and I may have stripped some tables/data. Also, no idea at this point how long the server has been alive so also bear that in mind.


At 7200 players (on this specific server), you could avg it out at 50mb/1000 players.

 

[BeMajestiX]

Thank You!