|
Ugh I hate answering interview questions. Even more so when they are being asked as part of an application.
|
#
?
Feb 20, 2024 21:15
|
|
|
|
| # ? May 27, 2024 13:45 |
|
|
Collateral Damage posted:On the topic of database performance a pitfall I've run into a few times is that your database engine will cache tables in memory and as long as your tables are small enough to stay cached you won't notice how inefficient your queries are because it's still lightning fast as long as they're in RAM. So you load up a few gigs of test data and run your tests and everything passes with flying colors, so you sign off and put it in production. Database and query optimizations are something that scratches the itch for me. I don't know why, and I'm not very good at it, but I love tucking into a performance problem like that. It's not unheard of to see hundreds, even thousands, of times performance increase if you know what knobs to turn.
|
|
#
?
Feb 20, 2024 21:31
|
|
|
Well if you can help the Helldivers devs it would be greatly appreciated. The gamers are getting antsy.
|
|
#
?
Feb 20, 2024 21:34
|
|
|
Internet Explorer posted:Well if you can help the Helldivers devs it would be greatly appreciated. The gamers are getting antsy. Why don't they just scale horizontally? 
|
|
#
?
Feb 20, 2024 21:38
|
|
|
Hughmoris posted:Why don't they just scale horizontally? the gamers have reached the limits of that after the invention of doritos flavor mt dew
|
|
#
?
Feb 20, 2024 21:50
|
|
|
Internet Explorer posted:Well if you can help the Helldivers devs it would be greatly appreciated. The gamers are getting antsy. I’ve trolled the subreddit some because of the “I pAiD $40 I dEsErVe AcCeSs!!!” posts. Capital G Gamers are the absolute worst. poo poo happens. It’s a video game, get over it.
|
|
#
?
Feb 20, 2024 22:06
|
|
|
Remember when the tsunami hit Japan and gamers were pissed that the ff servers were taken off line.
|
|
#
?
Feb 20, 2024 22:24
|
|
|
Internet Explorer posted:Well if you can help the Helldivers devs it would be greatly appreciated. The gamers are getting antsy.  'd pretty hard at the idiot on Twitter telling them to just bring the game to Xbox and get more servers for free. Bing bang boom, so simple it is never simple.So my boss has had me shadowing our netops team since I got my CCNA at the end of last year. They've been great and it's nice just seeing most of the stuff they're doing isn't stupidly overwhelming to me at this point. Though most of them are short timers as they were laid off after our merger went through, and will be leaving the company at some point next month. They're all pretty sanguine about it since they knew well ahead of time and seem to be getting solid severance packages. My division was untouched for whatever reason, but some of these guys seem to think I'm going to be taking over their roles once they leave (network engineer), which lol no, I am still only a desktop support tech. I did have a conversation with my boss about how they did have some patching they had to do late on a Saturday, and I didn't attend/observe because I'm hourly and it's not my job to do so at this point. He agreed, and said that that's certainly not expected of me. I then said half joking/half serious "Yeah I'm not against doing that kind of stuff, but that requires a new job title and pay bump so lol". He laughed and then we moved into other topics. Anyways, he knows I want to pivot into the networking side of things, and has been incredibly supportive of that desire. My only hope is that either that promotion/pay bump happens sooner than later. He hasn't made any concrete promises or anything, but I'm hopeful for the future.
|
|
#
?
Feb 20, 2024 22:30
|
|
|
jaegerx posted:Remember when the tsunami hit Japan and gamers were pissed that the ff servers were taken off line. not really i was in high school at the time
|
|
#
?
Feb 20, 2024 23:33
|
|
|
tokin opposition posted:not really i was in high school at the time
|
|
#
?
Feb 21, 2024 00:54
|
|
|
ilkhan posted:You weren't born for 9/11, were you? No I was born I was in preschool
|
|
#
?
Feb 21, 2024 00:56
|
|
|
I mean saying you couldn't play Final Fantasy because you were in high school seems a little iffy.
|
|
#
?
Feb 21, 2024 00:58
|
|
|
jaegerx posted:Remember when the tsunami hit Japan and gamers were pissed that the ff servers were taken off line. I get your point and who really cares in this context, but why would they set this up with a single point of failure? Final Fantasy was a pretty huge game, was 2011 a dark time before putting failover capacity in different geographic locations to manage pretty much exactly this risk was a thing you did before a production release?
|
|
#
?
Feb 21, 2024 01:10
|
|
|
Gucci Loafers posted:
Anytime I run a meeting I send a recap of what we discussed and decided. This is partly for CYA purposes, so no one can say we didn't talk about x or whatever, but it also helps me keep track of what was discussed, helps anyone who couldn't attend, and gives people something written to refer to so they don't have to rely on their memories. This all seems very basic to me, but most people are extremely disorganized and do absolutely nothing to counteract that disorganization, and I think it really helps the people I work with. I really believe that my greatest contributions are organization, not technical.
|
|
#
?
Feb 21, 2024 02:22
|
|
|
There has to be at least an inch of accountability for that to matter. I'm still looking for an org that has some
|
|
#
?
Feb 21, 2024 02:35
|
|
|
Gucci Loafers posted:
I'm a firm believer in the power of clear and succinct communication, and that the lack of communication is the cause of most headaches. In business and in life, people usually just want to know what to expect and what is expected of them.
|
|
#
?
Feb 21, 2024 02:54
|
|
|
AreWeDrunkYet posted:I get your point and who really cares in this context, but why would they set this up with a single point of failure? Final Fantasy was a pretty huge game, was 2011 a dark time before putting failover capacity in different geographic locations to manage pretty much exactly this risk was a thing you did before a production release? Are you for real? You realize the entire country lost power right? A few thousand people lost their lives.
|
|
#
?
Feb 21, 2024 03:04
|
|
|
jaegerx posted:Are you for real? You realize the entire country lost power right? A few thousand people lost their lives. I’m not suggesting they shouldn’t have shut down the servers. But how do you get to that point without having colos in Korea or something that spin up automatically?
|
|
#
?
Feb 21, 2024 03:12
|
|
|
AreWeDrunkYet posted:I’m not suggesting they shouldn’t have shut down the servers. But how do you get to that point without having colos in Korea or something that spin up automatically? You've heard of once in a century storms right?
|
|
#
?
Feb 21, 2024 03:16
|
|
|
Internet Explorer posted:Well if you can help the Helldivers devs it would be greatly appreciated. The gamers are getting antsy. Coming back to this... I'm watching a stream where the dude has been sitting at the "Servers are at capacity" screen for who knows how long. For any of you nerds playing the game, has there been any word on why they haven't been able to scale up to handle the capacity? Where's the bottleneck?
|
|
#
?
Feb 21, 2024 03:19
|
|
|
They haven't said specifically what the issue is, but it's clearly database issues. They added a max player cap as well as a max logins per minute cap. They recently said they're hosted in Azure. I'm sure they're hitting hard limits in multiple places.
Internet Explorer fucked around with this message at 03:27 on Feb 21, 2024 |
|
#
?
Feb 21, 2024 03:21
|
|
|
They just learned from blizzard launches that if the supply of servers is low then player demand will go up. I learned something similar in econ too
|
|
#
?
Feb 21, 2024 03:29
|
|
|
jaegerx posted:You've heard of once in a century storms right? Right, natural disasters are one of the key reasons you develop and test disaster recovery plans. I think we're talking past each other, I'm not upset or anything they shut down the servers, just surprised that a large company releasing a major product didn't plan for that. If a major earthquake hits San Francisco it would be the last thing that matters, but YouTube and Netflix will probably keep on chugging.
|
|
#
?
Feb 21, 2024 03:30
|
|
|
2011 was also a long time ago in ease of DR terms. And a lifetime in video game infra terms.
|
|
#
?
Feb 21, 2024 03:31
|
|
|
AreWeDrunkYet posted:. If a major earthquake hits San Francisco it would be the last thing that matters, but YouTube and Netflix will probably keep on chugging. This seems optimistic. Also girl have you seen how expensive cross-region network traffic is??
|
|
#
?
Feb 21, 2024 04:23
|
|
Cat Army
|
I have made the required blood sacrifice to Cisco for the data center move to succeed
|
|
#
?
Feb 21, 2024 04:26
|
|
|
BIG FLUFFY DOG posted:It’s going one way. Acquisitions always end in being stripped for parts as the company needs to inflate its balance books to compensate for the debt in acquiring the company There's a small bit of hope. Being acquired by a bigger company in industry sure, it's junkyard time. Being acquired by a PE firm that wants to pivot, grow, and sell can be alright.
|
|
#
?
Feb 21, 2024 05:36
|
|
|
Hughmoris posted:Coming back to this... I'm watching a stream where the dude has been sitting at the "Servers are at capacity" screen for who knows how long. For any of you nerds playing the game, has there been any word on why they haven't been able to scale up to handle the capacity? Where's the bottleneck? Basically what they've said/implied so far is that the bottleneck is in the syncing of all global data. The game is always-online and every mission played contributes to a shared, global war effort to 'liberate' planets bit by bit. From what I can glean from the dev's occasional posts, their databases just cannot keep up with close to a million people simultaneously trying to access them. I'm not a database guy by any means so I could be pretty off base but that's really what it seems like. At one point last week they announced they were turning off a bunch of global stat tracking just to claw back some overhead
|
|
#
?
Feb 21, 2024 05:51
|
|
|
jaegerx posted:Are you for real? You realize the entire country lost power right? A few thousand people lost their lives. it was like 20,000 lol
|
|
#
?
Feb 21, 2024 05:56
|
|
|
kensei posted:I have made the required blood sacrifice to Cisco for the data center move to succeed As someone who superstitiously believes bleeding on her PC builds helps with reliability, huzzah! Also glad it wasn't a worse injury, esp overseas. Make sure that thing is well disinfected...
|
|
#
?
Feb 21, 2024 07:25
|
|
|
AreWeDrunkYet posted:I’m not suggesting they shouldn’t have shut down the servers. But how do you get to that point without having colos in Korea or something that spin up automatically? The tech news segment I watched said it was "lack of optimization, so like IE said probably the fault of databases and/or Java.
|
|
#
?
Feb 21, 2024 08:34
|
|
|
jaegerx posted:You've heard of once in a century storms right? Weird how many of those we get these days. I blame bitcoin
|
|
#
?
Feb 21, 2024 08:34
|
|
|
Dirt Road Junglist posted:As someone who superstitiously believes bleeding on her PC builds helps with reliability, huzzah! Taking chaos engineering to a whole new level 
|
|
#
?
Feb 21, 2024 09:56
|
|
|
If you haven't cut the back of your hand when a molex connector finally gives way, you haven't built a PC or your are basically a baby.
|
|
#
?
Feb 21, 2024 12:13
|
|
|
LochNessMonster posted:Taking chaos engineering to a whole new level Your new computer will be Weak if you don't cut yourself on the lovely stamped steel case.
|
|
#
?
Feb 21, 2024 12:14
|
|
|
johnny park posted:Basically what they've said/implied so far is that the bottleneck is in the syncing of all global data. The game is always-online and every mission played contributes to a shared, global war effort to 'liberate' planets bit by bit. From what I can glean from the dev's occasional posts, their databases just cannot keep up with close to a million people simultaneously trying to access them. I'm not a database guy by any means so I could be pretty off base but that's really what it seems like. This is one of the few times I can feel sympathy for devs. That architecture would probably have held up great if Helldivers 2 had only been twice or even four times as successful as Helldivers. The way it's just exploded in popularity, not so much, but I can understand why this level of success caught them by surprise.
|
|
#
?
Feb 21, 2024 15:42
|
|
|
sinky posted:Your new computer will be Weak if you don't cut yourself on the lovely stamped steel case. Bonus points if you used snips to cut the steel away to make room for your GPU. Did that to an old Dell case I got from someone and hooooh did that have some edges on it. My little murder Inspiron case with a 1080 Ti and a 9700k. Blood for the PC god, skulls for the IT throne  Zorak of Michigan posted:This is one of the few times I can feel sympathy for devs. That architecture would probably have held up great if Helldivers 2 had only been twice or even four times as successful as Helldivers. The way it's just exploded in popularity, not so much, but I can understand why this level of success caught them by surprise. This is exactly why I’ve been super chill about it. There were zero issues with access until Steam users hit like 250k — it’s now 400k. They’ve been giving updates and it seems like they’ve been working 24/7 to get a real solution. Glad I’m not on their infrastructure/DBA team though. tehinternet fucked around with this message at 15:58 on Feb 21, 2024 |
|
#
?
Feb 21, 2024 15:56
|
|
|
Oh my god learning all this Agile Framework jargon.
|
|
#
?
Feb 21, 2024 17:24
|
|
|
Prescription Combs posted:Oh my god learning all this Agile Framework jargon. The joy that is Scaled Agile Framework (enterprise)? 
|
|
#
?
Feb 21, 2024 17:29
|
|
|
|
| # ? May 27, 2024 13:45 |
|
|
Antigravitas posted:If you haven't cut the back of your hand when a molex connector finally gives way, you haven't built a PC or your are basically a baby. Still got visible scars on my fingers from those old fold-out Dell desktop cases that seemed to be nice and round on the outside and then open up to literal plastic razor blades inside
|
|
#
?
Feb 21, 2024 17:30
|
|
