Thursday, November 12
This Dispute Is Disputed Edition
- Oh, right. That's why I was using TokuDB in the first place.
InnoDB suffers from significant write amplification issues with large working sets on small systems. Scaling up the numbers on my test suite by 100x took about 400x longer. TokuDB scales nearly linearly.
This is purely a write issue; reads only slow by about 10% with a 100x increase in database size. That doesn't mean that they won't slow down eventually, but it does mean that I don't have any missing indexes or queries that take O(n!) time. (I used to; on the weekend I was able to clear the three remaining #FIXMEs in the code.)
- I use a 4GB dual-core VPS for this testing, where the production server for Mana will be a 64GB eight-core hardware server, but the advantages of TokuDB on write are real.
The recommended replacement for TokuDB is MyRocks, based on Facebook's RocksDB. MyRocks doesn't support temporal tables - but then neither does TokuDB.
One other benefit of MariaDB over MySQL is that I can use the Aria storage engine in place of MyISAM for the search indexes. InnoDB supports full-text search now, but performance is disastrous. I designed the code to replicate messages into MyISAM because keeping two complete copies of everything was an order of magnitude faster than using InnoDB for search.
Problem was that MyISAM isn't crash-safe, so any unexpected reboot would take out the search index requiring a repair at best and a full rebuild at worst. Aria is about as fast as MyISAM but crash safe.
A better solution might be to use Elasticsearch but right now I fucking hate Elasticsearch.
- Apple has announced their first three Arm-based Macs. (AnandTech)
The new MacBook Air, 13" MacBook Pro, and Mac Mini.
All use the new M1 CPU, which is a 4+4 core design. If you're interested in benchmarks, it's four cores; the other four are low-power and much slower.
All also have two USB4 ports - half the number of Thunderbolt ports of the previous models in some cases - and 8GB or 16GB of soldered-in LPDDR4X-4266 RAM.
That's a big step down for the Mac Mini, which was previously user-upgradable to 64GB. Probably for that reason the highest-end Intel Mac Mini is still being offered for sale.
- These models all come with only integrated graphics, but with USB4 and Thunderbolt at least you can add an external lol no fuck you that's why (Apple Insider)
There are no compatible eGPU solutions, and as far as anyone can determine - Apple isn't saying anything, because they're Apple - there are no plans to remedy this.
- As for Apple's M1 CPU it is faster on the Spec benchmark suite than any Intel CPU at least in single-threaded tests. (AnandTech)
Having only four full-size cores it will of course get stomped by any high-end Intel processor.
And interestingly, though it is faster than any Intel CPU on single-threaded tests, that still leaves it slower than the slowest of AMD's new Zen 3 lineup.
- Skeptical Apple press is skeptical. (ZDNet)
Well, that's a change. Not being facetious; it's good to see them raising questions.
- Skeptical Microsoft press is also skeptical of Apple. (Thurrott.com - free registration required to read this article)
Paul Thurrott mentions here that Apple never once spoke about application performance in its presentation. And we know that if application performance were good, they would have said so.
- AMD has updated its Ryzen Embedded range to Zen 2. (Tom's Hardware)
The Ryzen Embedded V2000 family are Ryzen 4000 APUs. The only difference is that AMD guarantees long-term availability for these parts; the hardware itself is identical.
- AMD also says that Zen 4 and RDNA 3 will present similar improvements to Zen 3 and RDNA 2 sort of. (WCCFTech)
The interviewer was rather putting words in AMD's mouth there, but they did not deny or even demur.
Zen 4 expected early 2022, since they're on roughly a 15-month release cycle, rather than 12 month.
- There's a rather nasty local privilege escalation bug in Ubuntu 20.04 desktop releases. (GitHub)
Does not affect the server edition at all, thankfully, and a patch has already been rolled out. So don't ignore that security update message if you're running desktop systems in a shared environment.
- Samsung's new SmartSSD includes a Xilinx FPGA for local processing. (Serve the Home)
Not sure exactly what the target market is for this given the current server ecosystem. When bandwidth and CPU power were limited, this idea made sense, but you can now have a two-socket server with 128 cores and 320GBps of bidirectional I/O.
- Hyundai is in talks with Softbank to buy killer robot dog maker Boston Dynamics. (Bloomberg)
Hyundai is a major maker of industrial robots so this one makes sense.
- Slingbox is dead. (Variety)
Well, will be dead as of November 2022.
- Bethesda added a DOOG Easter egg in honor of Hololive's Korone - and then removed it.
Turns out the removal wasn't the usual big company shittiness but because DOOG is a registered trademark and they decided it wasn't worth the fuss for an Easter egg.
So they sent her a Cacodemon plushie.
- I should start maintaining a list of bullshit censorship by social networks. Might need a bigger blog.
Posted by: The Brickmuppet at Thursday, November 12 2020 04:09 AM (5iiQK)
Posted by: normal at Thursday, November 12 2020 05:33 AM (obo9H)
Posted by: Pixy Misa at Thursday, November 12 2020 09:01 AM (PiXy!)
Posted by: normal at Thursday, November 12 2020 11:33 AM (obo9H)
Posted by: Rick C at Friday, November 13 2020 01:03 PM (eqaFC)
Posted by: Pixy Misa at Friday, November 13 2020 01:08 PM (PiXy!)
58 queries taking 0.3207 seconds, 325 records returned.
Powered by Minx 1.1.6c-pink.