News for hackers. Stuff that matters.
Re:Why Your SSD (Probably) Sucks and What Your Database Can ... by wtallis on Wednesday June 19, 2024 @01:11PM (#40730196)
Even when there are enterprise SSDs that are mechanically and electrically compatible with the bays/slots in a laptop, they're often untenable due to the lack of idle power management features on enterprise SSDs (because sleeping when idle kills the latency metrics). Consider that the 480GB DC1000B is officially rated for 1.9W at idle and in practice I wasn't able to get it below 1.2W. Consumer SSDs with working power management would idle under 10mW.
Re:Why Your SSD (Probably) Sucks and What Your Database Can ... by kjkjadksj on Wednesday June 19, 2024 @03:22PM (#40731546)
Thats hardly untenable. Most computers draw a lot more watts where you wouldn't miss 1.2W imo. Even these "low watt" computers are drawing like 5-7 watts at idle and once you do anything on them its a lot more than that.
Re:Why Your SSD (Probably) Sucks and What Your Database Can ... by wtallis on Wednesday June 19, 2024 @05:27PM (#40732563)
You wouldn't miss the 1.2-1.9W on a gaming laptop with a discrete GPU. But for more mainstream systems with just integrated graphics, 5W is on the high end for idle power and even Intel's latest mid-range laptop parts can get down to about 3W if you don't have Windows doing dumb shit in the background constantly.

Also, on modern laptops you can't trust that components will be powered off when you close the lid, because Microsoft and Intel have been at war with ACPI S3 suspend for years now. So that 1.2W could easily be the minimum power draw of the SSD any time you haven't hibernated or shut down the system.

Re:Why Your SSD (Probably) Sucks and What Your Database Can ... by kjkjadksj on Wednesday June 19, 2024 @08:24PM (#40733719)
You got a source for the 3w? Is this for the cpu or measured at the wall? Seems low. I believe intel n100 can get to 7w but only after heavy tweaking of c states and only with some mobo. A lot of users more in practice from my forum searching on this cpu last year when i almost bought it. Macbook can go down to 5w but again thats idle with nothing running. I don’t think many people leave a laptop computer idling like they might their workstation.
Re:Why Your SSD (Probably) Sucks and What Your Database Can ... by kldx on Wednesday June 19, 2024 @08:58PM (#40733868)
Trusting the Thinkpad spec sheet numbers, an AMD T14s lasts >15hrs in one of the benchmarks on a 57Wh battery. That's less than 4W. Perhaps on Linux and with some tuning, it seems plausible to get to 3W?
Re:Why Your SSD (Probably) Sucks and What Your Database Can ... by kjkjadksj on Thursday June 20, 2024 @02:02AM (#40735424)
Trusting battery estimates? I believe apple claims my m3 mac is capable of 15 hours or so. If I’m lucky I will get like 7 hours with a basic documentation webpage open and the terminal connected to ssh.
Re:Why Your SSD (Probably) Sucks and What Your Database Can ... by justinclift on Thursday June 20, 2024 @10:34AM (#40739220)
Third party reviewers seem to say the M3 mac does pretty well:

https://www.tomsguide.com/news/macbook-pro-m3-and-m3-max-bat...

Maybe yours is a lemon and/or should be replaced?

Re:Why Your SSD (Probably) Sucks and What Your Database Can ... by kldx on Monday June 24, 2024 @03:03PM (#40779522)
The estimates appear to match what notebookcheck[0] reports on their measurements - 4.4W idle average. With some tuning[1] and turning off unused peripherals, I expect to go below 4W idle.

[0] https://www.notebookcheck.net/Lenovo-ThinkPad-T14s-G3-AMD-la... [1] https://docs.kernel.org/admin-guide/pm/amd-pstate.html

Re:Why Your SSD (Probably) Sucks and What Your Database Can ... by ColonelPhantom on Thursday June 20, 2024 @05:36PM (#40743673)
My laptop (a Dell Latitude 5490, i5-8350u) with the screen backlight off and at idle goes down to 2.5w power consumption according to the battery statistics. An SSD idling at 1.9w would nearly double it!
Re:Why Your SSD (Probably) Sucks and What Your Database Can ... by justinclift on Wednesday June 19, 2024 @01:41PM (#40730562)
Interesting, haven't seen mention of that aspect of enterprise ssds at all.
Re:Why Your SSD (Probably) Sucks and What Your Database Can ... by timschmidt on Wednesday June 19, 2024 @03:17PM (#40731503)
I usually have to tweak my home rackmount equipment over IPMI to set the fan settings to idle when temps are low instead of 24/7/365 jet engine mode which the local university datacenter seems to prefer. I imagine running the fans full blast all the time results in slightly more reliable performance and reliability, but I don't have the luxury of a soundproof HVAC controlled room to lock everything away in, so the lower noise at lower utilization matters to me. This trade-off definitely happens all over the place in enterprise gear.
Re:Why Your SSD (Probably) Sucks and What Your Database Can ... by justinclift on Wednesday June 19, 2024 @03:23PM (#40731557)
You've been through all the stuff like setting max device power for the NVMe drives and similar yeah?

https://nvmexpress.org/resource/technology-power-features/

Re:Why Your SSD (Probably) Sucks and What Your Database Can ... by timschmidt on Wednesday June 19, 2024 @03:38PM (#40731704)
I just upgraded my main server to an https://www.supermicro.com/products/archive/motherboard/x9dr... with dual Xeon E5-2680v2s. $15 for 20c/40t and 256gb ECC from the local university surplus. Unfortunately, it's still a little too old to offer NVME. That doesn't matter too much to me, since it's connected via 6gbps SAS to several 24 bay NetApp disk shelves (also $15 ea!) full of disks. I have dealt with PCIe ASPM (https://en.wikipedia.org/wiki/Active_State_Power_Management) which similarly trades off between performance, power consumption, and latency.

I am not hugely concerned with power consumption as I have solar panels. But noise and excess heat matter to me. My whole stack is consuming around 650W currently. Wildly removed from the days I was running off a creatively overprovisioned OpenWRT wireless router using < 20W. But I'm happy to have the increased capacity for my use cases. Gigabit synchronous fiber to the home is a dangerous drug :)

Re:Why Your SSD (Probably) Sucks and What Your Database Can ... by justsomehnguy on Wednesday June 19, 2024 @03:48PM (#40731782)
Just use PCI-E converter for NVMe.

You wouldn't be able to boot from it, but it would work just fine.

Re:Why Your SSD (Probably) Sucks and What Your Database Can ... by timschmidt on Wednesday June 19, 2024 @03:55PM (#40731828)
A good suggestion, but it's a 1U server with both available PCIe slots populated between the external SAS controller and a dual 10gbE CNA. I boot from SATA SSDs currently. Could upgrade to enterprise SAS SSDs, but haven't noticed a need for my current uses. The boot drive is rarely touched, as most data terminates at the NetApp disk shelves, which have been a far more reliable way to connect unholy amounts of storage to a machine than any of the consumer direct attached storage options I've tried in the past. There's a mix of SSDs and spinning rust in the disk shelves - SSDs for web server stuff and spinning rust for low cost bulk storage.
Re:Why Your SSD (Probably) Sucks and What Your Database Can ... by justinclift on Wednesday June 19, 2024 @04:14PM (#40731964)
> with both available PCIe slots populated between the external SAS controller and a dual 10gbE CNA.

Interestingly, there do appear to be PCIe cards that do both external SAS and high speed networking in one card:

https://forums.servethehome.com/index.php?threads/unique-oem...

Looks like a bunch of mucking around is needed to get things setup, but seems like it works ok from that point onwards:

• https://www.ebay.com/itm/314150370285

Have been considering grabbing one to try in a HP Microserver Gen 8 that runs Proxmox. Not a lot of free time at the moment though. ;)

Re:Why Your SSD (Probably) Sucks and What Your Database Can ... by timschmidt on Wednesday June 19, 2024 @04:22PM (#40732040)
Neat! And affordable! Thanks! I will definitely look further into them. I got the 10gbE CNA from another university surplus find where a half dozen were being used as 16gb fibre channel adapters with SFP fibre modules. A little digging revealed that they could be switched to 10gbE CNA mode which is a lot more useful for my purposes. Enterprise gear is full of surprises :D

Only potential downside I see is the included pcie switch chip. It's dividing up 8gbps between three devices which could independently consume all of that bandwidth. Probably not a huge issue for my uses, but worth considering if you plan on transferring large amounts of data over network and storage simultaneously.

Re:Why Your SSD (Probably) Sucks and What Your Database Can ... by sgarland on Wednesday June 19, 2024 @07:05PM (#40733336)
You can, with caveats. You can use Clover [0] to bootstrap from a USB key (or anything else) that then hands off to an NVMe drive. Or you can mod your BIOS [1]. I have personally done this on a Supermicro 9th gen, and it works great. YMMV, especially with Dells or HPs which tend to be far more picky about everything.

[0]: https://github.com/CloverHackyColor/CloverBootloader

[1]: https://winraid.level1techs.com/t/howto-get-full-nvme-suppor...