The OFFICIAL tech stuff thread
-
@Kilemall said in The OFFICIAL tech stuff thread:
@tigger said in The OFFICIAL tech stuff thread:
@Kilemall said in The OFFICIAL tech stuff thread:
@Hog said in The OFFICIAL tech stuff thread:
One of our servers, probably the main server for most business functions, has 5 terabytes of RAM and is otherwise configured up the wazoo with the most premium disk and CPUs that Azure has to offer.
It runs like shit. It’s always run like shit but we had a software version upgrade and now it’s often unusable. Some of the business functions that used to take 10 minutes (but should have been much less) can take hours now and it’s affecting production.
There’s a 24/7 bridge call set up for the crisis that I get sucked into occasionally that occasionally produces actions like*Hog, explain why this complex application that you’ve never seen before today and is slow and report back in an hour with your recommendations". And they’ll hassle you for updates exactly within the hour if you haven’t reported back because you don’t understand wtf the app is doing functionally let alone technically…
A couple of times it’s looked like I’m going to have to rewrite whole apps or re-architect others while the business bleeds and IT management drums their fingers and hovers over my shoulders.
Thankfully it seems that the penny has dropped that it’s not an app specific problem but something wrong with the system. I’m hearing things like some process or other trying to use 50 gigabytes of cache that’s only been configured to allow 5 megabytes.
Of course, I’m not counting on that so I’m trying to learn as much as I can about the apps and processes I might have to rewrite at no notice.
Fuck me, IT is stressful sometimes. I have some talents but one of them isn’t thinking well and understanding stuff under extreme time pressure.
I just dealt with a server hang that unlike most of ours actually affects patient care. You could have that pressure.
Anything with 5 TB of memory is either a supercomputer modeling climate or Mach 25 missiles, is a central Google AI, or is badly configured and Microsoft is enjoying charging rental on the moron designing the thing.
I’m guessing the latter.
Welcome to 2005 ;)
Hmm, our virtual servers probably have that but not the individual carved ones. Mainframes do similar workloads to Unix or windows business machines but with a lot less memory due to superior I/O.
Storage is Petabytes, but I haven’t heard of petabyte memory.
None of this is on a physical computer. For the way how the data is stored, you can read this: https://static.googleusercontent.com/media/research.google.com/en//archive/bigtable-osdi06.pdf
For how this applies to SQL-like databases, read the design of BigQuery.
As for memory, that is divided between a lot of machines. You cannot simply write a normal binary that uses 5T of memory, you need to write it in a way that you will get 10000 machines, each of which will use 500MB of memory, to process the data.
So typically you’ll use some implementation of MapReduce, the article for that is here.These are all well written and easy to read articles that show how computers work these days and I think carry good didactic value.
-
Plus I think it’s really easy to try out because a lot of these cloud providers give you a small account for free, I believe I have one set up with Oracle…
-
Where’s the P2 call to discuss adding another 5 terabytes of RAM to this forum’s server?
-
Could do with 5 TB for sure!
-
Doesn’t always work though. I downloaded over a TB of ram over the years and still never got more than 30 FPS on WW2OL.
-
@Gators1 said in The OFFICIAL tech stuff thread:
Doesn’t always work though. I downloaded over a TB of ram over the years and still never got more than 30 FPS on WW2OL.
The issue is that the downloaded memory often fills your hard disk before it can be actually installed.
-
@tigger said in The OFFICIAL tech stuff thread:
@Gators1 said in The OFFICIAL tech stuff thread:
Doesn’t always work though. I downloaded over a TB of ram over the years and still never got more than 30 FPS on WW2OL.
The issue is that the downloaded memory often fills your hard disk before it can be actually installed.
Duh, I know that! That’s why I downloaded a NAS first and filled it with downloaded hard drives before I installed the downloaded memory!
-
This was high tech in the 1800s. I guess the French beat Edison kinda.
-
The real reason head-butting became unpopular at the end of the 18th century!
-
I didn’t read most of this crap, but I’m sure that 99% of LOT don’t know how to pronounce MySQL right.
-
“MySQL”
Here, just did it.
-
I call it “My-S-Q-L” but I’ve never heard another human say it so I don’t know what’s correct. “My-see-quell” sounds kinda ghey if that’s how you are supposed to say it.
I’ve never heard a human utter 90% of the tech words I know and, when I get one wrong, it’s years or decades before someone hears me say it and corrects me. I used to pronounce “array” wrong from about 1985 to 2003 until a friend bailed me up on it. I’m still retraining myself to say “cache” correctly but it’s really hard to change after internally pronouncing a word a certain way for so many years.
-
I was trying to figure out how cache could be pronounced differently. But looking at it, if someone is following english language rules, it would almsot look like it’s pronounced “cake”
-
@Hog said in The OFFICIAL tech stuff thread:
I call it “My-S-Q-L” but I’ve never heard another human say it so I don’t know what’s correct. “My-see-quell” sounds kinda ghey if that’s how you are supposed to say it.
I’ve never heard a human utter 90% of the tech words I know and, when I get one wrong, it’s years or decades before someone hears me say it and corrects me. I used to pronounce “array” wrong from about 1985 to 2003 until a friend bailed me up on it. I’m still retraining myself to say “cache” correctly but it’s really hard to change after internally pronouncing a word a certain way for so many years.
Sorry, but the rest of the world picked the ghey way to say it. It’s “my seequel”.
Edit: Actually I take that back. Apparently it’s mixed and Oracle even calls it “My S-Q-L”. I have mostly heard My Seequel though in use in my company and from AWS. I guess my company is ghey.
-
@Stu said in The OFFICIAL tech stuff thread:
I was trying to figure out how cache could be pronounced differently. But looking at it, if someone is following english language rules, it would almsot look like it’s pronounced “cake”
I was pronouncing it kaysh; don’t ask me why because I don’t know / don’t remember (edit: but it’s possibly because of what you said.) At some point I realized the rest of the planet were calling it “cash” so I’ve been trying to remember to pronounce it that way.
I’m just thankful the “e” is silent and it’s not pronounced cash-eh. That would be even gheyer than My See-quell.
-
Maybe the whole word cache is just ghey, no matter how you pronounce it? I mean it is of French origin.
-
@Gators1 said in The OFFICIAL tech stuff thread:
@Hog said in The OFFICIAL tech stuff thread:
I call it “My-S-Q-L” but I’ve never heard another human say it so I don’t know what’s correct. “My-see-quell” sounds kinda ghey if that’s how you are supposed to say it.
I’ve never heard a human utter 90% of the tech words I know and, when I get one wrong, it’s years or decades before someone hears me say it and corrects me. I used to pronounce “array” wrong from about 1985 to 2003 until a friend bailed me up on it. I’m still retraining myself to say “cache” correctly but it’s really hard to change after internally pronouncing a word a certain way for so many years.
Sorry, but the rest of the world picked the ghey way to say it. It’s “my seequel”.
Edit: Actually I take that back. Apparently it’s mixed and Oracle even calls it “My S-Q-L”. I have mostly heard My Seequel though in use in my company and from AWS. I guess my company is ghey.
We support a couple of My S-Q-L systems and as we are not formally trained and certified to do so, we have contracts with the My S-Q-L arm of Oracle and none of the support or sales people we have spoken with ever use MySequel.
I researched this years ago and recognize that the founder originally wanted to call the relational DB “SEQUEL” as explaned below, but the word was already trademarked, so the abreviation SQL came into being.
But that is no excuse for pronouncing it the wrong way, but it does explain the origin and why some people say MySequel.
There are some people who also say other silly things like “Whom came to the door Richard?” ;-)
S.Q.L or Sequel: How to Pronounce SQL?
Dive into the debate: Should SQL be pronounced 'S.Q.L' or 'sequel'? Learn the correct way and explore its impact on the tech industry.
-
In the context of the language I always hear sequel for the most part. Despite the history, people tend to make words out of acronyms and that becomes how the cool kids say it. Have even heard people wondering if people that say S-Q-L are inexperienced.
-
This thread has caused me to realize that I have been misspelling cachet on occasion.
I have always used cache to represent a collection of something such as a cache of weapons and the verb form to cache or to store in both cases pronounced “kash.”
But . . .
When suggesting that Donald Trump has more cachet than he has earned, I’d have spelled it cache as well.
I’m so embarrassed. ;-)
I would bet that it is spelled the same way in French, but in the case of “kashay” it needs an accent?
Lob would know.
-
@Gators1 said in The OFFICIAL tech stuff thread:
Have even heard people wondering if people that say S-Q-L are inexperienced.
I’ve heard people wondering if people that say sequel are baguette-eating surrender monkeys.
Those people are only in my head but I heard them.
The Oldest Voices We Can Still Hear
