Clean Database.

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...

Spoiler:

creating 7 more characters (total 8) [and not even logging them in at all] literally increased the dbdata directory by 4,096 bytes

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.

Quote:

---

Originally Posted by Jonatas

upgrade my mysql with the information of all the characters takes about 50 minutes.

---

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 343

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...

Spoiler:

creating 7 more characters (total 8) [and not even logging them in at all] literally increased the dbdata directory by 4,096 bytes

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.

---

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)

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.

Quote:

---

Originally Posted by Jonatas

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 code

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.

Quote:

---

Originally Posted by ivanaivana

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

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.

---

Which is negligible, which I've stated to him so many times...

Quote:

---

Originally Posted by ivanaivana

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.

---

Quote:

---

Originally Posted by das7002

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...


/facepalm

It doesn't work like that...

---

.....

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.