Printable View
I wonder if anyone has or if it is possible to develop a script to delete those unwanted accounts on our server stops.
Example:
Delete character that does not connect to X months and has level less than 100.
For servers with a lot of players believe it would help a lot. Does anyone have or know how?
Yes, it is possible. There is field in char's xml, where stored info about logins. Just need script for iweb/pwadmin + db which inspect database and game server for such a chars, and if whole account is "old" - deletes it from gameserver and database.
There is no need to delete in-actives except for maybe once a year, or once every OTHER year (every two years -or- 730 days). So there's no real reason to have it automated/'scripted' (unless you're that fucking lazy).
You could manually enter your database once a year (hell even while the servers are "up") and sort by date and manually delete any accounts that have not logged in in over 365 days or 730 days. Or whatever period you determine. I would personally recommend 730 days because everyone is different and has different playing habits/styles.
what a problem with non active account? :mellow: you are using 10Gb hdd? :huh:
Actually even a 10GB HDD could probably hold a bajillion accounts... he must be using like a 1GB drive !
:pound::pound::pound::pound:Quote:
Originally Posted by 343
Indeed 16GB of ram, but a long process of consultations to update's rank and other information. You have 500k characters created, and almost half are secondary, not logam, convey and are insignificant. It is still a utility. Another issue is less chance of corrupting files with less information.
You must have a 1 mhz cpu if you think 500k queries to mysql and a small bit of processing is something to worry with...Quote:
Originally Posted by Jonatas
/facepalmQuote:
Originally Posted by Jonatas
It doesn't work like that...
Who said anything about mysql? Mysql delete accounts does not change anything, I mean the characters in dbd.
Characters in game dbd still don't take up squat for space ...
Quote:
Originally Posted by Jonatas
Quote:
Originally Posted by das7002
:mellow:Quote:
Originally Posted by Jonatas
I am willing to bet that you could fit every single players account and character (ALL db data) from official PWi onto a single CD... That is, I am willing to bet that ALL combined database info for even official PWi is 700 MB or less :p
Assuming each character takes up 50 kilobytes (this is a high estimate, more then likely it is lower as what is there to store? really...)Quote:
Originally Posted by 343
You could contain 14,336 uncompressed, tack on some compression and that number is likely to go way down.
Assuming they only take up about 10 kilobytes (which is probably closer to reality) you get 71,680 characters
Going by an account I recently created for PWI which ended up with the ID 5,936,789 and divide that by 8 you get 742,098.625 which pretty much means there is probably about 750,000 accounts for PWE (this is across ALL game due to how they do their registration)
If every single one of those accounts had a moderate 4 characters each occupying 10 kilobytes you'd get a measly 28 gigabytes
Now if you SOMEHOW manage to get more characters then PWE has AND SOMEHOW manage to afford a webhost for a long enough period to occur and that server SOMEHOW doesn't have 30 gigabytes of space on its hard drives you failed at picking a server
I really think you're estimating too high Das. If it was 10 kilobytes per character that would be 10240 bytes -or- 81,920 bits :o
I think it's more like 1 kilobyte per character tops. (1024 bytes -or- 8192 bits)
So if that were to be accurate even 750,000 accounts all with 8 chars would still only be a mere 6GB, and honestly I think that may still be a high estimate. I think if I get the time I will create a character, fully expand his bag and bank and fill it, and blah blah blah and see how much that takes up; do a lil test just to find out...
You are talking very low, the PW LVL UP BR Late last year broke the record with 26k players online. Imagine now how many items / post and similiares. The PWI has much more online. I'm absolutely sure that the PW changed his engine.
But what I'm saying is that to upgrade my mysql with the information of all the characters takes about 50 minutes. Guilt accounts useless, decreasing these accounts would be faster, so the maintenance on the servers would be lower.
Ok well I figured it was time to stop guessing and do some homework (damn -- Das and I were both way off). So I took a fresh server with only ONE character, and maxed everything out that I could think of on him... Here are the evidence photos. I now have my conclusion based off of this research, feel free to draw your own (on how much physical disk space a SINGLE character can take up "max"):
Picture 1)
I maxed out bag(incl fashion)/bank/pet bag/skills/quest log/guild-faction/macros/hot bars etc etc etc...
Picture 2)
The two files compared are: I took the 'raw' XML of this one character and saved it into a file, named 343.prof -- so the file size of 343.prof is all the XML data in it's own file. The directory dbdata is of course the entire dbdata directory for the server (fresh server install with only ONE character creation and maxing out)
I'd personally probably use an estimate of 115,000 bytes PER CHARACTER {//or 920,000 bytes PER ACCOUNT/8chars} accounting for anything I forgot to use as a part of my study, or for things that would normally apply but that I could not apply to this study. Example would be (since he was the ONLY character on the server) the friends list, and black list...
So I guess - all in all - at the final conclusion of this study; I would say a-lot 1 MB per ACCOUNT/8chars (even though not all accounts will make 8 characters, let alone fill them all up like this-necessarily) -or- 1 GB per 1,000 ACCOUNTS/8,000chars -or- 1 TB per 1,000,000 ACCOUNTS/8,000,000chars.Spoiler:
Then like I said, your server is a piece of crap if it can't do lots of database queries (and from what you suggest all its doing is moving some things around from one database to another...)Quote:
Originally Posted by Jonatas
Quite interesting... Eitherway, not much of an issue, you'd 1 million accounts to get over 100 gb (and if anyone tells me their server doesn't have at least that much hard drive space, they need to upgrade their server from the 90s)Quote:
Originally Posted by 343
We are not discussing space size of the database, any server that has huge amount of data as they have official servers dedicated specifically to the same location or the mysql database which work and your network connection is made. We can do it just get a machine in the same datacenter. But we do not need.
The problem is not mysql, but the bdb java, track information in maid of 10 bdb to export to mysql. This is the reason for the delay and also affects large amount.
Well, let's end the discussion, because they will only have an interest who makes constant updates of information and who has a large number of players.
Thank you all.
gamedbd is native codeQuote:
Originally Posted by Jonatas
Java performs just as fast as native code since Java 6
Your argument is invalid
http://img163.imageshack.us/img163/5...ument20is2.jpg
Is not invalid because it does not happen in practice. And if there was no damn delay to update the information I would not open the damn topic.
Makes querying account / character makes query level, consultation is growing, it makes enormous consultations, joint export mysql. So I'll take the garbage from the server bills for this process to be faster.
Another thing, not jdk 6 Platform to work hard on some servers, so that high consumption of CPU over the following days rises too. I'm still behind some of jvm compatible processor architectures and platform game
my dbf 1 years
103 MB (108,445,696 bytes)
:pound::pound::pound:
He talkin about top players and other statistics via sql db and server java. In fact it is true, than how bigger becames game sql bd and serverside store of accs info, the longer time to refresh info in top players or etc.
He worries not about hard drive size, but about speed of statistics refresh.
Thank you. Someone finally came to understand.Quote:
Originally Posted by ivanaivana
Which is negligible, which I've stated to him so many times...Quote:
Originally Posted by ivanaivana
Quote:
Originally Posted by ivanaivana
.....Quote:
Originally Posted by das7002
One solution to your problem could be to first do a query to list players who logged in since last update, then fetch only these data. If someone didn't log, his exp, pk, etc won't change. This assuming you know how to/can fetch only partial data.
P.S. to all bright spirits out there, no a bigger server is not the solution to all problems and someone searching to optimise resources consumption is not an idiot.