• rumba@lemmy.zip
    link
    fedilink
    English
    arrow-up
    0
    ·
    15 hours ago

    Unless I’m misreading it which is possible it’s awfully late, he said he processed 60,000 rows didn’t find what he was looking for but his hard drive overheated on the full pass.

    Discs don’t overheat because there was load. Even if he f***** up and didn’t index the data correctly (I assume it’s a relational database since he’s talking about rows) The disc isn’t just going to overheat because the job is big. It’s going to be lack of air flow or lack of heatsink.

    I guarantee you he was running on an external NVMe, and one of those little shitty-ass Chinese enclosures. Or maybe one of those self immolating SanDisk enclosures. Hell, maybe he’s on a desktop and he slept a raw NVMe on his motherboard without a heatsink

    There are times when you want a brilliant college student on your team, But you need seasoned professionals to help them through the things they’ve never seen before and never done before.

    • ameancow@lemmy.world
      link
      fedilink
      English
      arrow-up
      0
      ·
      edit-2
      2 hours ago

      There are times when you want a brilliant college student on your team, But you need seasoned professionals to help them through the things they’ve never seen before and never done before.

      Honestly, any sweet, white-haired old lady who keeps pictures of her dogs and grandkids on her desk who’s been doing data entry for 15 years could do circles around these clowns.

      But she might also have the wisdom and perception to know we’re not supposed to be doing this “work” at all, which is why he recruits naive teenagers and college kids who are still emotionally immature to think that this is going to be their “destiny” or their opportunity to get into the big leagues of business.

    • Deathray5@lemmynsfw.com
      link
      fedilink
      arrow-up
      0
      ·
      11 hours ago

      Somehow I feel over clicking without understanding of the consequences sounds like something a techbro would do

    • exu@feditown.com
      link
      fedilink
      English
      arrow-up
      0
      ·
      13 hours ago

      Can’t be a relational database, Musk said the government doesn’t use SQL.

  • BenLeMan@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    15 hours ago

    You’re not supposed to place your laptop directly in the lap of your fur suit. Always leave an air gap for ventilation, smh.

  • nonentity@sh.itjust.works
    link
    fedilink
    arrow-up
    0
    ·
    15 hours ago

    Either she knows something novel, where processing data using voice coils is somehow beneficial, or is someone who calls their computer a ‘hard drive’, which summarily negates any legitimacy of technical competence.

  • LillyPip@lemmy.ca
    link
    fedilink
    arrow-up
    0
    ·
    16 hours ago

    This cannot be real, wtf. This is cartoon levels of ineptitude.

    Or sabotage by someone heading out? Please let this be resistance sabotage they haven’t noticed yet.

    • turnip@lemm.ee
      link
      fedilink
      English
      arrow-up
      0
      ·
      edit-2
      15 hours ago

      You guys arent running your software off raspberry pi’s with sdcards from the gas station?

      My allowance is 5$ a month!

      • Bytemeister@lemmy.world
        link
        fedilink
        English
        arrow-up
        0
        ·
        6 hours ago

        I think my Pi could process 60k rows without overheating. And the poor thing is dangling behind my bookshelf from its power cord with a fine layer of dust coating every inch of it.

  • KillingTimeItself@lemmy.dbzer0.com
    link
    fedilink
    English
    arrow-up
    0
    ·
    edit-2
    17 hours ago

    i mean…

    If you’re running a pcie nvme ssd, one of the modern ones, and you’re doing a SHIT ton of reads, like threadripper level amount of reads, i guess “overheating” isn’t unexpected? Shouldn’t do much other than slow down the SSD though?

    dumbass probably loaded them into memory, and OOM’d, and thought it was the drive.

    • T156@lemmy.world
      link
      fedilink
      English
      arrow-up
      0
      ·
      10 hours ago

      Out of memory/overheating in 60k rows? I’ve had a few multi-million row databases that could fit into a few gigs of memory, and most modern machines have that much in RAM. A 60k query that overheats the machine might only happen if you’re doing something weird with joins.

      Plus a lot of reads is nothing really, for basically all databases, unless you’re doing an unsmart thing with how you’re reading it (like scanning the whole database over and over). If you’re not processing the data, it’d be I/O bottlenecked.

    • lefaucet@slrpnk.net
      link
      fedilink
      arrow-up
      0
      ·
      16 hours ago

      NVMEs will throttle if they are inadequately cooled. Pretty much only folks who are new at buiding computers and don’t adequately cool their NVMEs experience this.

      Either way it shows what a clown show this is. I’m pretty sure they’re doing some babuki theatre to distract us and then if the scheme being done here is found, they’ll point fingers at the dipshit kid and he’ll be punished for whatever the con is.

      Either way the billionaires will be better off for it, barring judicial, congressional, or military revolt; which is looking less likely by the day.

      Bunch of traitors forgot their oath is to the constitution. The constitution IS the soul of the country and is to be respected. The country was founded by the constitution and it defines the system to be decentralized power giving control to the populace through three different branches of government. Not some false idol king or an evil oligarchy propped up by foreign and domestic robber barrons

  • Professorozone@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    17 hours ago

    I didn’t know hard drive overheating was a thing. Should I be worried that my 5 year old hard drive is about to overheat. I mean is this actually a floppy disk or something?

    • melpomenesclevage@lemmy.dbzer0.com
      link
      fedilink
      English
      arrow-up
      0
      ·
      15 hours ago

      it is a thing, but any competently designed computer should have things in place to prevent this.

      unless you’re an arrogant dipshit and disable all the hardware safeties on your computer to make it go faster and wear harder.

    • ChaoticNeutralCzech@feddit.org
      link
      fedilink
      English
      arrow-up
      0
      ·
      edit-2
      15 hours ago

      When an HDD works continuously it can heat up to above 60 °C if proper air circulation is not allowed, which can cause a very premature failure. In fact, it should be kept under 40 °C to achieve the intended lifespan. Unfortunately, PC cases are usually not great at removing heat from the HDD by default.

      As for your drive, it most likely has a temperature sensor so it can be displayed by various utilities.

      • Estebiu@lemmy.dbzer0.com
        link
        fedilink
        arrow-up
        0
        ·
        8 hours ago

        I have a 12v fan running at 5v spitting air on my hdds, and that’s enough for them to go from 55°C to 29°C, lol.

        • ChaoticNeutralCzech@feddit.org
          link
          fedilink
          English
          arrow-up
          0
          ·
          edit-2
          7 hours ago

          I did that too, the tiny fan is pretty much silent at 5V. The HDD has so much surface area it only needs a little air circulation.

        • KillingTimeItself@lemmy.dbzer0.com
          link
          fedilink
          English
          arrow-up
          0
          ·
          16 hours ago

          no. but generally spinning things that spin at several thousands of RPM that are spinning on a bearing, that no longer have a bearing usually sort of uh, tend to be VERY noisy.

          • Professorozone@lemmy.world
            link
            fedilink
            arrow-up
            0
            ·
            16 hours ago

            Ok, but do you know anyone this has happened to? I don’t and I have some pretty old drives I still use. I tend to just buy more. Also most drives these days are solid state aren’t they? This just feels like a low probability event to me. Overheating RAM or the CPU or GPU, sure, but hard drive?

            • melpomenesclevage@lemmy.dbzer0.com
              link
              fedilink
              English
              arrow-up
              0
              ·
              15 hours ago

              hard disk drives do still exist, and are useful for some stuff. mostly they’re cheaper. I think better for stuff you write to often?

              SSD’s can overheat. but, again, there are usually sensors to throttle them when you’re in danger of this, and this idiot probably disabled those. because safety is for cucks i guess.

            • KillingTimeItself@lemmy.dbzer0.com
              link
              fedilink
              English
              arrow-up
              0
              ·
              16 hours ago

              not personally, i may have seen a video or two of it happening, but it’s hard to tell whether the head is dragging against the platter, or it’s the bearing, either one of those makes horrendous noise.

              If you’re worried about it happening on a drive you own, you should copy that data somewhere else as a backup, ideally sooner rather than later. If you’re curious about the health of the drive you do stuff like SMART tests as well.

              Yeah, most drives are solid state now, unless you’re buying hdds for archival purposes, still cheaper and denser in most cases. It’s a low probability failure, until the drive meets EOL, in which case it’s a mechanical wear part, either the motor or the bearing fails. One of them will fail first, probably the bearing.

              The bearing failing would likely result in the HDD overheating as a result. Assuming the platter still spins, but that’s the only scenario i can think of where that would happen, unless you dump a very specific amount of continuous current into the read arm coils. That might also cause it, but it’s not likely at all.

              An ssd “overheating” is more likely, but it shouldn’t cause too many issues, maybe premature degradation over long term use, and slowing of read/write speeds, or in some cases, an improvement, but other than that it should be business as normal. You would have to hit it with like a heat gun, to get a hardware failure or something like that.

              • Professorozone@lemmy.world
                link
                fedilink
                arrow-up
                0
                ·
                16 hours ago

                I’m not actually worried about my drives. In fact that was kind of the point. I was kidding around because this excuse that the hard drive overheated sounds a little like a car running out of blinker fluid.

            • vaultdweller013@sh.itjust.works
              link
              fedilink
              arrow-up
              0
              ·
              16 hours ago

              I had it happen to a random hard drive I bought, old bastard found in a bin at a local thrift store. Anyways had a big dent in it and while it started up, even booting into windows XP it cooked itself made a screeching noise and was hot to the touch. Don’t think I need to explain that the big dent was probably the source of the overheating, anyways had to use an oven mitt to relocate it to a metal bucket of water where it boiled for a minute.

  • jkercher@programming.dev
    link
    fedilink
    English
    arrow-up
    0
    ·
    18 hours ago

    60k rows of anything will be pulled into the file cache and do very little work on the drive. Possibly none after the first read.

  • GreenKnight23@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    18 hours ago

    I smell something, but it’s not overheating electronics.

    I’ve processed over 5 million records on a laptop that’s almost 10 years old. it took two days to get my results.

    there’s no way 60,000 records overheated ANYTHING.

    • wewbull@feddit.uk
      link
      fedilink
      English
      arrow-up
      0
      ·
      17 hours ago

      Doesn’t actually say that 60k overheated his drive. He says that he ran a run on 60k, and that he couldn’t do the whole database due to overheating. Two unrelated statements except that 60k is the lower bound for what he could process.

      Doesn’t mean he knows what he’s doing though, as pretty huge datasets are processable on quite modest hardware if you do it right.

      • GreenKnight23@lemmy.world
        link
        fedilink
        arrow-up
        0
        ·
        15 hours ago

        that’s somehow worse.

        a “data analyst” couldn’t cut up the work into a parallel processes and run them synchronously? what the actual fuck?

        “sorry, I can only do 60k at a time.”

        just fucking split them up into 6 parallel batch processes running 10k at a time. it’s fucking math, not rocket science. I’m not even an analyst and I could fucking do that much.

        • sniggleboots@lemm.ee
          link
          fedilink
          arrow-up
          0
          ·
          2 hours ago

          I don’t want to take away from the valid point of your comment, but rocket science is almost exclusively math

  • inclementimmigrant@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    edit-2
    19 hours ago

    What in the fuck is this idiot doing? I’ve process datasets far larger than that and never once have I run into a hard drive “overheat”. I mean what level of incompetence do you have to have to get a hard drive to overhead processing a measley 60K rows of data?