posted by DGDragon 2014. 11. 7. 21:25

이브의 데이터베이스의 크기는?

https://forums.eveonline.com/default.aspx?g=posts&m=5127199#post5127199

DB is currently around 2.8 TB, 2 weeks ago it was 3 TB...


We do routine archiving to pull old log records, etc... out to separate databases in an attempt to run as lean as possible.


We also have difference services (sso/vgs/images) in different DB's, so while the core DB itself is around 2 TB (2.8 w/ free space in files for growth), the entire stack is closer to 5-6 TB total.

2주 전엔 3TB, 지금은 2.8TB.


주기적으로 오래된 로그 기록들을 삭제하는 등의 노력으로 DB를 최대한 줄이려고 함.


또 우리가 제공하는 다른 서비스(sso/vgs/images)들은 다른 DB에 있는데, 이를 다 합치면 5~6TB 쯤 됨.


https://forums.eveonline.com/default.aspx?g=posts&m=5127322#post5127322

Great effort LoF!


As mentioned, the core DB is 2.8 TB currently, and the image DB is around 1.3 TB.


the inventory system takes up about 250 GB (a single table w/ 2-3 indexes)

the market system takes up around 300 GB (2-3 tables and multiple indexes)

in-game mail system is around 300 GB as well (we delete most of chribba's mail just to annoy him :))


https://forums.eveonline.com/default.aspx?g=posts&m=5127357#post5127357

DB is split across 2 tiers of storage, SSD (enterprise level intel disks in v7000 enclosures) for the heavily accessed stuff and 15k SAS disks for the second 'slower' tier.


I'm not that knowledgeable abuot the SAN side and how the block sizes are handed there, but as the LUN's are given to us, we setup our volumes @ 64K block size as this is the optimal allocation for SQL (64k = 1 extent = 8x8KB pages)


We do 2 full backups per day (written across 8 files for disk melting IO dumps) which take a little over 1 hour each... Hits the disks for around 400 MB/s


DB는 2단계로 저장되는데, 자주 읽히는 데이터는 SSD에, 그렇지 않은 데이터는 15k SAS disk에 저장됨.


https://forums.eveonline.com/default.aspx?g=posts&m=5127541#post5127541

In this market order clean up, we noticed that there is one crazy player that has an open order for 7 years now!!!! Any order expires after 90 days unless you update it...


So this player has been modifying this one order, at least once every 90 days, for the last 7 frickin years!! haha


There are 3 items left in his sell order - I wanted to just go buy them so there wouldn't be such a big gap in ID's :)


I got over ruled on that as well


(i sent a mail to community about this guy saying he (or she?) should get some kinda medal, so we'll see what comes of that)


오더를 최장으로 걸면 90일이 걸리는데, 90일마다 이를 갱신해서 마켓 오더 하나를 7년간 유지한 플레이어가 있음.

까말 내가 가서 그걸 사서 오더를 없애버리고 싶음. 그러면 DB가 존나 깔끔해질 건데.