EVE Search - Database overload time to delete inactive accounts

All Channels

EVE General Discussion

Database overload time to delete inactive accounts

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Pages: [1] 2 3 4 :: one page
Author	Thread Statistics \| Show CCP posts - 5 post(s)
smeggy Minmatar	Posted - 2006.09.03 20:17:00 - [1] Ive always wondered about this little thing that the devs said about 2 years ago. We will not delete any player account that is inactive in the foreseeable future unless it becomes absolutely necessary. Well I know many accounts that have been inactive for over 2 years and a few for more than 3 years. Would CCP consider deleting some of these accounts and freeing up some valuable database space. Many of these accounts I am sure have bookmarks in place as well as all the items they own. If someone hasnt activated their account in over 18 months I am sure they will never be played again. The items of that players account can be inherited by their corp and those corps that are active will use in some way those items turning them into something else thats going to be used or mins etc. Those who are in npc corps the items will just be deleted. I would have thought that would clear out a large and significant amount of database resources that are being wasted. So is it time for ccp to delete these old non active accounts? This could also happen to corps that have died and have 0 members in them.
Ediz Daxx FinFleet Lotka Volterra	Posted - 2006.09.03 20:18:00 - [2] Providing facts on what you claim is a good start.
The Enslaver Shinra Lotka Volterra	Posted - 2006.09.03 20:21:00 - [3] I don't think the number of inactive accounts is having any sort of significant effect on server performance... --------
Resolve	Posted - 2006.09.03 20:27:00 - [4] Databse entries does not equal less performance. If someone's been inactive, they're just an entry in the database that does not get accessed. Accessing the DB is what takes CPU time. Non-active players do not cause lag or decrease performance, no matter how many items or BMs they have. Many people take breaks from EVE and some come back after a year+ to see what's changed and to try again. Deleting their accounts helps no-one. And just deleting items from NPC corp members is so not an option. Just because someone left their corp before taking a break doesn't mean they should be targeted for deletion, give me a break. No it is not time to delete the inactive accounts.
Ardent Glory	Posted - 2006.09.03 20:39:00 - [5] Originally by: Resolve Removing inactive corps to free up some corp names may be an option, but that also has ramifications, namely Employment History. Actually that makes no difference. My old corp doesn't exist anymore, but it still appears in my employment history....
Resolve	Posted - 2006.09.03 20:45:00 - [6] Edited by: Resolve on 03/09/2006 20:46:02 Originally by: Ardent Glory Originally by: Resolve Removing inactive corps to free up some corp names may be an option, but that also has ramifications, namely Employment History. Actually that makes no difference. My old corp doesn't exist anymore, but it still appears in my employment history.... It does make a difference. Say you worked for Corp X, then it gets removed and another Corp X is formed and you join it. How can anyone tell which is which? You'll have two entries for Corp X in your history, even though they're totally different. Seeing who has done what will become a PITA, looking at which corp a player has been with and checking which dates Corp X has been active/reformed.

Valar	Posted - 2006.09.03 20:47:00 - [7] I've looked into deleting old accounts. The benefit, in terms of freeing up items and getting rid of their bookmarks is less then the weekly amount of itemIDs that go to the trash locations. So, nothing is really gained from doing it. ------ Valar Database admin - Server operations team CCP Games How to write a good bugreport

Resolve	Posted - 2006.09.03 20:49:00 - [8] Edited by: Resolve on 03/09/2006 20:56:22 Thanks Valar, that confirms what I was thinking. Yes, it takes up space, but doesn't cause lag or a decrease in performance. If space is an issue, sure things can be done. Deleting accounts/items from 'inactive' people would be a last resort IMO. If CCP has some spare HD space (I'm sure they do), it is just not an issue.
Bazman Caldari The Establishment Establishment	Posted - 2006.09.03 20:50:00 - [9] Originally by: Valar I've looked into deleting old accounts. The benefit, in terms of freeing up items and getting rid of their bookmarks is less then the weekly amount of itemIDs that go to the trash locations. So, nothing is really gained from doing it. Can you trash all my noob ships for me? Seriously, going through my assets list, those are bound to cause at least 50% of the server lag. yeegads ----- Sig removed, maximum allowed image dimensions are 400x120 and maximum allowed size is 24,000 bytes. Please contact [email protected] for more info (including a copy of your picture!) -wystler Hi TUXFORD! Blasterboat for tier 3 Gallente battleship please! Make it look cool too. Thanks. I am a
Resolve	Posted - 2006.09.03 20:55:00 - [10] Originally by: Bazman Originally by: Valar I've looked into deleting old accounts. The benefit, in terms of freeing up items and getting rid of their bookmarks is less then the weekly amount of itemIDs that go to the trash locations. So, nothing is really gained from doing it. Can you trash all my noob ships for me? Seriously, going through my assets list, those are bound to cause at least 50% of the server lag. yeegads They'll maybe cause lag when/if you check your assets. Back to the OP, just having those entries in the DB won't cause lag. If you check your assets every 5 seconds sure, that'll probably cause lag, but that's YOUR fault, not EvE's.
MadGaz Finite Horizon	Posted - 2006.09.03 21:09:00 - [11] Does the amount of abandoned noob ships/shuttles/drones in space take up much resources? Makes my scanner lag alot --------------------------- What can I put here without getting banned? Tell me you luv me, and it will all be okay - Immy Make me a sig and I will.
Skawl GeoTech	Posted - 2006.09.03 21:10:00 - [12] Originally by: Bazman Can you trash all my noob ships for me? Seriously, going through my assets list, those are bound to cause at least 50% of the server lag. yeegads You know you can trash stuff remotely from the assests window right?
Shadowsword Gallente COLSUP Tau Ceti Federation	Posted - 2006.09.03 21:22:00 - [13] Originally by: MadGaz Does the amount of abandoned noob ships/shuttles/drones in space take up much resources? Makes my scanner lag alot I think it lag out your initial load, as the client's graphic engine charge the ship models, position, textures... and, after that, does absolutely nothing. I'd be very surprised if an empty ship were taking even a quarter of the ressources a player ship takes. ------------------------------------------ Nuhwall: Why are some Amarr ships warping backward? Shadowsword: whatever happen, if they need to flee they can honestly say the faced the enemy.
Norath84 Gallente Idle Haven	Posted - 2006.09.03 22:26:00 - [14] Originally by: Valar I've looked into deleting old accounts. The benefit, in terms of freeing up items and getting rid of their bookmarks is less then the weekly amount of itemIDs that go to the trash locations. So, nothing is really gained from doing it. Another benefit is all the names it woud free upp... I had to pick a difrent name for my main as the name i wanted to use was taken.. Later (3 mnd) I rememberd that the char holding my name was a trial i made 2,5 years ago... Ps. if that ever gets fixed is there a chance i can have my name change back to norath ---------------------------------------------------------- New Ship Idea: Small Freighters (100k m¦) in EVE
Mrmuttley House of Tempers	Posted - 2006.09.03 23:20:00 - [15] Originally by: Norath84 Another benefit is all the names it woud free upp... I had to pick a difrent name for my main as the name i wanted to use was taken.. Later (3 mnd) I rememberd that the char holding my name was a trial i made 2,5 years ago... Ps. if that ever gets fixed is there a chance i can have my name change back to norath Thats actually a good reason not to delete accounts and therefore their characters IMHO. Aside from the opportunities to mis-use a name that was well known but has now retired theres alsowhat you might call sentimental reasons. A good RL friend of mine died at the tail end of last year. If you decided to delete accounts after a say a year or somesuch and the characters went with it then in theory at least someone could end up flying around with my freinds avatars name. Meeting that new pilot would be freaky tosay the least. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I am Dyslexic of Borg. Your ass will be laminated. Originally by: Rod Blaine Eve is not supposed to be fair
DropZone 187	Posted - 2006.09.03 23:20:00 - [16] First off, thanks for the clarification Valar. Nice to see a dev respond and hopefully it will happen more often. (Then again I would expect the extinction of forum trolls, but that is a high hope in itself) Secondly, out of curiosity, and also to put to bed the myths/rumors of bm impacts, roughly how much space as a percentage would be freed up if bms were all deleted? I think that would be big question. I got an idea, ban forum trolls!
Duban Banned	Posted - 2006.09.03 23:23:00 - [17] i'd say delete all old trial accounts, THAT at least has to be taking up a lot of space.

Valar	Posted - 2006.09.04 00:46:00 - [18] Originally by: DropZone 187 First off, thanks for the clarification Valar. Nice to see a dev respond and hopefully it will happen more often. (Then again I would expect the extinction of forum trolls, but that is a high hope in itself) Secondly, out of curiosity, and also to put to bed the myths/rumors of bm impacts, roughly how much space as a percentage would be freed up if bms were all deleted? I think that would be big question. I got an idea, ban forum trolls! Deleting the bookmarks table, not counting the vouchers and items that are created when bookmarks are made into items, we would save around 14% of the current database size. EDIT: I'd like to add that the bookmarks table is the biggest table in the whole database. ------ Valar Database admin - Server operations team CCP Games How to write a good bugreport

PKlavins Caldari eXceed Inc. Ascendant Frontier	Posted - 2006.09.04 00:50:00 - [19] Originally by: Valar Originally by: DropZone 187 First off, thanks for the clarification Valar. Nice to see a dev respond and hopefully it will happen more often. (Then again I would expect the extinction of forum trolls, but that is a high hope in itself) Secondly, out of curiosity, and also to put to bed the myths/rumors of bm impacts, roughly how much space as a percentage would be freed up if bms were all deleted? I think that would be big question. I got an idea, ban forum trolls! Deleting the bookmarks table, not counting the vouchers and items that are created when bookmarks are made into items, we would save around 14% of the current database size. would that improve performance by any noticable amount? Quote: "Meanwhile, in CCP-HQ, BoB and their fanboys plotted domination of jovian teletubbies first -eris Woot right behind Eris \o/ - Xorus In Soviet Russia, Signature Mods You! -Ivan K ^YEA! Pffffftttt - Immy
Thrawntl Caldari Research Associates	Posted - 2006.09.04 00:51:00 - [20] Thats really big, delete all the BM's! Put in warp to 2km to target, but still allow bks to be made but now allow them to be made near 15km of a stargate.
MysticNZ Solstice Systems Development Concourse	Posted - 2006.09.04 00:52:00 - [21] Damm... forgot what I was going to say... Oh yeah, why does it take so much cpu when copying bms? What is going on? Could they not be placed in a bm queue type system where it is only executed when the load of the server is low? -=====- Xorus is teh nub :D I heard that beats player with big stick now be a good carebear and mine me some veldspar - Xorus
Tsavong Lah Caldari Solar Storm Axiom Empire	Posted - 2006.09.04 00:58:00 - [22] Originally by: MysticNZ Damm... forgot what I was going to say... Oh yeah, why does it take so much cpu when copying bms? What is going on? Could they not be placed in a bm queue type system where it is only executed when the load of the server is low? This is because BMs aren't stored as a normal item type (like, say, a ship or module) they're stored as being related to the character. When you copy a BM, it gets copied into a real item, then back in to a bookmark and moved. That is more operations than trading modules/minerals across. I won't speak about my opinions of bookmarks, but I do sincerely hope that whatever solution/fix the developers choose is one that does a good job of reducing system load. I'm sure people could live without the ability to copy instas if it meant an extra few hours' uptime every week. I got a jar of dirt!

Valar	Posted - 2006.09.04 00:58:00 - [23] Originally by: PKlavins Originally by: Valar Deleting the bookmarks table, not counting the vouchers and items that are created when bookmarks are made into items, we would save around 14% of the current database size. would that improve performance by any noticable amount? Well, deleting the bookmarks from the database certainly would lighten the load on it, especially around startup when so many people are logging in while their systems are loading. And over all it would give a performance increase because the server would not have to hand the bookmarks between nodes when a person with 50k bookmarks jumps or dock or decides to open his bookmark list. So the performance increase would not only be on the database size but will also impact performance on the EVE servers themselfes quite alot. I'm too tired to post properly, going to bed now. Good night everyone. Major Gormur or Foggy will be watching the server tonight. ------ Valar Database admin - Server operations team CCP Games How to write a good bugreport

PKlavins Caldari eXceed Inc. Ascendant Frontier	Posted - 2006.09.04 01:04:00 - [24] Originally by: Valar Originally by: PKlavins Originally by: Valar Deleting the bookmarks table, not counting the vouchers and items that are created when bookmarks are made into items, we would save around 14% of the current database size. would that improve performance by any noticable amount? Well, deleting the bookmarks from the database certainly would lighten the load on it, especially around startup when so many people are logging in while their systems are loading. And over all it would give a performance increase because the server would not have to hand the bookmarks between nodes when a person with 50k bookmarks jumps or dock or decides to open his bookmark list. So the performance increase would not only be on the database size but will also impact performance on the EVE servers themselfes quite alot. I'm too tired to post properly, going to bed now. Good night everyone. Major Gormur or Foggy will be watching the server tonight. seems that deleting BM's would be a godsend... devs, time to push the Big Red Button...delete the BM's!!! Quote: "Meanwhile, in CCP-HQ, BoB and their fanboys plotted domination of jovian teletubbies first -eris Woot right behind Eris \o/ - Xorus In Soviet Russia, Signature Mods You! -Ivan K ^YEA! Pffffftttt - Immy

Valar	Posted - 2006.09.04 01:09:00 - [25] Originally by: PKlavins Originally by: Valar Originally by: PKlavins Originally by: Valar Deleting the bookmarks table, not counting the vouchers and items that are created when bookmarks are made into items, we would save around 14% of the current database size. would that improve performance by any noticable amount? Well, deleting the bookmarks from the database certainly would lighten the load on it, especially around startup when so many people are logging in while their systems are loading. And over all it would give a performance increase because the server would not have to hand the bookmarks between nodes when a person with 50k bookmarks jumps or dock or decides to open his bookmark list. So the performance increase would not only be on the database size but will also impact performance on the EVE servers themselfes quite alot. I'm too tired to post properly, going to bed now. Good night everyone. Major Gormur or Foggy will be watching the server tonight. seems that deleting BM's would be a godsend... devs, time to push the Big Red Button...delete the BM's!!! Yes, deleting the bookmarks table will make me very happy. When I look at database traces, all I see are bookmarks loading, being insterted, copied or changing owners. Nothing else in the database takes such a long time, so it doesn't show up in my traces, well except for the odd standing update and one lsc(large scale chat) proc. ------ Valar Database admin - Server operations team CCP Games How to write a good bugreport

PKlavins Caldari eXceed Inc. Ascendant Frontier	Posted - 2006.09.04 01:11:00 - [26] Originally by: Valar Originally by: PKlavins Originally by: Valar Originally by: PKlavins Originally by: Valar Deleting the bookmarks table, not counting the vouchers and items that are created when bookmarks are made into items, we would save around 14% of the current database size. would that improve performance by any noticable amount? Well, deleting the bookmarks from the database certainly would lighten the load on it, especially around startup when so many people are logging in while their systems are loading. And over all it would give a performance increase because the server would not have to hand the bookmarks between nodes when a person with 50k bookmarks jumps or dock or decides to open his bookmark list. So the performance increase would not only be on the database size but will also impact performance on the EVE servers themselfes quite alot. I'm too tired to post properly, going to bed now. Good night everyone. Major Gormur or Foggy will be watching the server tonight. seems that deleting BM's would be a godsend... devs, time to push the Big Red Button...delete the BM's!!! Yes, deleting the bookmarks table will make me very happy. When I look at database traces, all I see are bookmarks loading, being insterted, copied or changing owners. Nothing else in the database takes such a long time, so it doesn't show up in my traces. this wil probably be answered tomorrow since its dead of the night in iceland...but... is there ANY chance of BM's being deleted? we have a dev on our side... Quote: "Meanwhile, in CCP-HQ, BoB and their fanboys plotted domination of jovian teletubbies first -eris Woot right behind Eris \o/ - Xorus In Soviet Russia, Signature Mods You! -Ivan K ^YEA! Pffffftttt - Immy
Yipeekahyay Gallente TribalWar Inc EVE Animal Control	Posted - 2006.09.04 01:12:00 - [27] Edited by: Yipeekahyay on 04/09/2006 01:12:42 Originally by: DropZone 187 First off, thanks for the clarification Valar. Nice to see a dev respond and hopefully it will happen more often. And that's why Eve has my monthly subscription. Regardless of how many people whine about the devs or Eve itself, it's obvious the devs actually take the time to feel out the community. "Making a speech on economics is a bit like ing down your leg. It seems hot to you but never to anyone else." Lyndon B Johnson

Valar	Posted - 2006.09.04 01:17:00 - [28] Originally by: PKlavins Originally by: Valar Originally by: PKlavins Originally by: Valar Originally by: PKlavins Originally by: Valar Deleting the bookmarks table, not counting the vouchers and items that are created when bookmarks are made into items, we would save around 14% of the current database size. would that improve performance by any noticable amount? Well, deleting the bookmarks from the database certainly would lighten the load on it, especially around startup when so many people are logging in while their systems are loading. And over all it would give a performance increase because the server would not have to hand the bookmarks between nodes when a person with 50k bookmarks jumps or dock or decides to open his bookmark list. So the performance increase would not only be on the database size but will also impact performance on the EVE servers themselfes quite alot. I'm too tired to post properly, going to bed now. Good night everyone. Major Gormur or Foggy will be watching the server tonight. seems that deleting BM's would be a godsend... devs, time to push the Big Red Button...delete the BM's!!! Yes, deleting the bookmarks table will make me very happy. When I look at database traces, all I see are bookmarks loading, being insterted, copied or changing owners. Nothing else in the database takes such a long time, so it doesn't show up in my traces. this wil probably be answered tomorrow since its dead of the night in iceland...but... is there ANY chance of BM's being deleted? we have a dev on our side... Something will be done about bookmarks. Game design is working on something, I don't know the details of it. But they sure as hell know what I, the development DBA, PapaSmurf the network programmer and Fuhry the lead programmer think about bookmarks. ------ Valar Database admin - Server operations team CCP Games How to write a good bugreport

PKlavins Caldari eXceed Inc. Ascendant Frontier	Posted - 2006.09.04 01:21:00 - [29] Originally by: Valar Originally by: PKlavins Originally by: Valar Originally by: PKlavins Originally by: Valar Originally by: PKlavins Originally by: Valar Deleting the bookmarks table, not counting the vouchers and items that are created when bookmarks are made into items, we would save around 14% of the current database size. would that improve performance by any noticable amount? Well, deleting the bookmarks from the database certainly would lighten the load on it, especially around startup when so many people are logging in while their systems are loading. And over all it would give a performance increase because the server would not have to hand the bookmarks between nodes when a person with 50k bookmarks jumps or dock or decides to open his bookmark list. So the performance increase would not only be on the database size but will also impact performance on the EVE servers themselfes quite alot. I'm too tired to post properly, going to bed now. Good night everyone. Major Gormur or Foggy will be watching the server tonight. seems that deleting BM's would be a godsend... devs, time to push the Big Red Button...delete the BM's!!! Yes, deleting the bookmarks table will make me very happy. When I look at database traces, all I see are bookmarks loading, being insterted, copied or changing owners. Nothing else in the database takes such a long time, so it doesn't show up in my traces. this wil probably be answered tomorrow since its dead of the night in iceland...but... is there ANY chance of BM's being deleted? we have a dev on our side... Something will be done about bookmarks. Game design is working on something, I don't know the details of it. But they sure as hell know what I, the development DBA, PapaSmurf the network programmer and Fuhry the lead programmer think about bookmarks. w00t proof that devs listen to us is here people... any ETA on the 'fix'? and i dont mean the 5-copy-at-a-time thing... Quote: "Meanwhile, in CCP-HQ, BoB and their fanboys plotted domination of jovian teletubbies first -eris Woot right behind Eris \o/ - Xorus In Soviet Russia, Signature Mods You! -Ivan K ^YEA! Pffffftttt - Immy
MysticNZ Solstice Systems Development Concourse	Posted - 2006.09.04 01:50:00 - [30] Good to hear... I really don't understand what is wrong with this idea. Warp to gate option and allowing bubbles to be placed in low sec with a larger sec hit than normal (.5). Solves all problems IMO. -=====- Xorus is teh nub :D I heard that beats player with big stick now be a good carebear and mine me some veldspar - Xorus

Pages: [1] 2 3 4 :: one page
First page \| Previous page \| Next page \| Last page

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.