• Fired up the Mana test environment this morning - an E3-1270 v6 with 32GB of RAM and two 256GB SSDs.  Been working on performance since around 7AM.  I never get up that early on the weekend, but there were back-to-back Hololive En Minecraft streams.
  
  So far the biggest improvement (apart from the fact that the server itself is faster) is confirming that timeline queries are now efficient and I don't need to maintain default stacks anymore.  That cut the time for a scaling test run - creating ten thousand users and a million messages, then reading them back via various combinations of API methods and parameters - from four hours to two.  Still single-threaded; the API is fine with multi-threading but the test suite doesn't do it yet.
  
  I have a third run of the scaling test about 80% complete now, with the default stacks disabled, and some new InnoDB and ZFS tuning.  So far it's still trucking along at around 120 messages per second, which is five times faster than the dev environment.
  
  I can get a server with twice the everything of this test system - so eight cores, 64GB RAM, and 1TB+ of NVMe storage - for under $100 per month.  That should handle things nicely.
  
  
  
• One thing I still need to check is the load generated by the search indexes.  Going over the MariaDB documentation while things were running and I was waiting for the next Minecraft stream, I was reminded that they support the Federated storage engine - or rather, the rewritten version called FederatedX.
  
  That would let me put the search indexes on their own server should the need arise, with no code changes at all.  And in theory other tables as well, but search is the top candidate for this because it's an isolated function - if search breaks, everything else keeps on running until you get around to fixing it.
  
  (Unless developers write their apps to use search all the time instead of the more specific and efficient API methods designed for them.  Not that that ever happens.)
  
  
  
• No, you idiots, Apple's M1 GPU is not faster than an RX580.  (Tom's Hardware_
  
  Ugh.  Seriously.
  
  
  
• X-NAND is NAND only X.  (Tom's Hardware)
  
  It seems to be QLC flash with pseudo-SLC caching, but with a lot more internal parallelism than typical flash dies, so you can read or write an order of magnitude faster.   In terms of throughput; latency is comparable to existing chips.
  
  
  
• Target said "sorry, we fucked up" and unbanned the book they banned yesterday.
  
  
  Outrage cancelled.
  
  
  
• Latest scaling run just completed.  Only shaved another 15 minutes off the run time - about 12% - but it cut the write amplification issue drastically.  That turned out to be a clash between the InnoDB and ZFS block sizes.
  
  (I did set that up correctly previously, but then forgot about it because with TokuDB it makes no difference and works just fine at the default settings.)
  
  Database size for this run was 3.7GB before compression, 2.1GB compressed.
  
  I'm going to re-run it now with GZip compression instead of LZ4.  Percona recommend this tradeoff if you have a fast CPU, not so much because it saves space, as because it improves performance by reducing I/O.
  
  The nice thing with ZFS is that you can change compression algorithms and block sizes on the fly.  The changes only take effect on new block writes, but it works just fine with a random mix of different sizes and compression methods.
  
  Making the database and filesystem block sizes match already reduced I/O utilisation by 60%, so let's see what GZip can do to help.
  
  Update: GZip is the way to go.  Only shaved 6 minutes - 5% - off the previous run, but it cut the database size nearly 40% from 2.1GB to 1.3GB.  Faster and smaller is good.
  
  These times and sizes are all with temporal tables enabled as well.  That's been painless so far.
  
  
  
• I've applied the same tweaks to my test environment now as well, and we'll see how that goes.  If I can do the beta launch on a $24 per month VPS, with the ability to scale it up as needed, all the better.
  
  Update: Short test run down from 17 minutes to 11.  Long test run is, well, running.  With these changes, performance looks like it will in fact be fine starting out on a $24 VPS.
  
  Update: Yes, full test suite is down from 633 minutes to 123 minutes on the dev server.  Which is running all sorts of other crap apart from Mana.
  
  That is more than fast enough; that's over 10 million messages a day.  Well, until it hits the next performance cliff and dives over it.
  
  Update: Oops, that run was without the search index.  So 10 million messages per day if the search index is on another server.  Running it again with search active.
  
  

Terraria Roller Coaster Video of the Day

Posted by: cxt217 at Sunday, November 15 2020 08:28 AM (4i7w0)

Posted by: Phil Fraering at Sunday, November 15 2020 11:20 AM (Clxcy)

Posted by: Rick C at Sunday, November 15 2020 02:17 PM (eqaFC)

Posted by: Pixy Misa at Sunday, November 15 2020 04:40 PM (PiXy!)

Posted by: Phil Fraering at Tuesday, November 17 2020 01:54 AM (Clxcy)

Hide Comments | Add Comment

• I tried out the Aria storage engine to see if it worked better than InnoDB for large working sets relative to memory, and it turned out the answer is no. 
  
  Which is good because I didn't want to use it anyway.  While Aria (unlike MyISAM) is at least crash safe, it doesn't improve on MyISAM's write lock behaviour, which is frankly terrible.
  
  It's not a problem for the search index, because by design that uses a single asynchronous writer.
  
  
  
• I'll run a scaling test on a 32GB dedicated server today.  It's really nice that I can spin one up for 18¢ an hour and then just shut it down when the test is done.
  
  
  
• Now that the US election is all over bar the screaming, Facebook is permitting political ads again LOL J/K.  (The Guardian)
  
  Facebook is extending its ban on political advertising for another month, because it was never about protecting the integrity of the election.
  
  
  
• Nvida is also planning to release a feature like AMD's SAM.  (Tom's Hardware)
  
  This lets you map all of video card's VRAM into the CPU's address space rather than using a 256M window, and boosts performance by a few percent.  Why this wasn't done before I'm not sure; it seems a no-brainer on 64-bit systems.
  
  
  
• Third-gen Epyc is on its way, at clock speeds up to 3.5GHz.  (Tom's Hardware)
  
  That's nearly as fast as my existing desktop, and has around 40% better IPC.  And eight times as many cores.
  
  
  
• AMD just announced a new Ryzen Embedded lineup so where are the systems based on them oh there they are.  (Tom's Hardware)
  
  Pretty nice systems too.  Six or eight cores, up to 64GB RAM with ECC support, room for one each M.2 and 2.5" drives, DisplayPort and HDMI, 1GbE and 2.5GbE network ports, two USB 3.2 Gen 2 Type A (that is, 10Gb), two USB 3.2 Gen 2 Type C with DisplayPort - though these are on the front so not ideal for connecting monitors, four USB 2.0, and optional WiFi.  And a serial port, because these are for embedded applications.
  
  And it's passively cooled.
  
  They also offer the motherboards, which are NUC-sized 4"x4", if you want to build your own.
  
  No retail pricing because again these are for embedded applications.
  
  
  
• MacOS Big Sur is out.  (Apple)
  
  How long before they manage to fuck everything up?
  
  
  
• Less than a day, as it turns out.  (Tech Crunch)
  
  Apple's Gatekeeper back-end broke down, which meant that Macs running recent versions of MacOS (I've frozen updates on mine for over a year now) could not start third-party applications.  Any third-party applications.
  
  Response of the world's richest company:
  
  
  If you rebooted your Mac during this outage the problem would go away because the operating system would never finish rebooting.
  
  Apple's ongoing infantilisation of their operating system is why I'm never going to buy another Mac.
  
  
  
• So, if you can't run third-party Apps because an Apple online service broke, that means that Apple is tracking every third-party app you run, right?
  
  And that's not the half of it.  (Sneak.Berlin)
  
  They transmit all this information through a third-party CDN - Akamai - UNENCRYPTED.
  
  Previously, you could monitor and even block this nonsense with apps like Little Snitch.  Big Sur no longer allows Little Snitch to run.  And while it still supports VPN software, Apple apps and operating system functions will simply bypass the VPN.
  
  Oh, and those new Arm-based Macs?  You have no option to run anything but Big Sur.  Because fuck you, that's why.
  
  
  
• We now live in a timeline so thoroughly messed up that Microsoft are the good guys.
  
  

• The 6800XT is an overclocking monster unless it isn't.  (WCCFTech)
  
  Reportedly it can hit 2.5GHz while keeping within stock TDP.
  
  
  
• It were ever thus.
  
  
  

Totally Not Tech News

Pizza on Pineapple Video of the Day

Hololive Alignment Chart of the day

Posted by: Rick C at Saturday, November 14 2020 12:54 AM (eqaFC)

Posted by: normal at Saturday, November 14 2020 01:41 AM (LADmw)

Posted by: Pixy Misa at Saturday, November 14 2020 02:00 AM (PiXy!)

Posted by: J Greely at Saturday, November 14 2020 06:38 AM (ZlYZd)

Posted by: Rick C at Saturday, November 14 2020 07:42 AM (eqaFC)

Posted by: J Greely at Saturday, November 14 2020 10:24 AM (ZlYZd)

Posted by: normal at Saturday, November 14 2020 10:31 AM (obo9H)

Posted by: Rick C at Saturday, November 14 2020 12:10 PM (eqaFC)

Posted by: Rick C at Saturday, November 14 2020 12:26 PM (eqaFC)

Posted by: J Greely at Sunday, November 15 2020 06:17 AM (ZlYZd)

Posted by: Rick C at Sunday, November 15 2020 08:30 AM (eqaFC)

Posted by: J Greely at Sunday, November 15 2020 12:40 PM (ZlYZd)

Hide Comments | Add Comment

Tech News

• Looks like that new computer purchase just got pushed back a few months.  Sigh.
  
  
  
• On the other hand, some progress:
  
  
  
  
  
  (Click for full size version, because the scaled version looks terrible.)
  
  Needs work, clearly, but on its way and loads very quickly with the unnecessary crap removed.
  
  
  
• TSMC's board has approved $3.5 billion to construct a 5nm fab in Arizona.  (Tom's Hardware)
  
  This is the first step in a planned $12 billion in construction in Arizona over the next decade.
  
  At least something useful is getting created from all those iPhones.
  
  
  
• Intel has launched their H3 XG310 server graphics card.  (WCCFTech)
  
  The board has four separate Xe GPUs each with its own memory.  I was expecting slightly more advanced packaging than that.
  
  
  
• Adtech needs to do more to silence everyone to doesn't follow every last letter of leftist doctrine or something.  (Branded)
  
  It's censorship all the way down, and they are absolutely convinced they are the good guys.
  
  
  
• Twitch is run by idiots.  (Twitch)
  
  I find it amazing that a site that big was only getting 50 DMCA notices on music per year, but in any case that has changed and the number is now thousands per week.  Hence the recent chaos.

To Serve Hololive Video of the Day

• 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!)

Hide Comments | Add Comment

• I got the new platform - it's called Mana - working with MariaDB and temporal tables.
  
  The switch to MariaDB only really required changing table collations, because the lists of collations supported by MySQL 8 and MariaDB 10 have diverged.  And of course switching from TokuDB over to InnoDB.
  
  Temporal tables required a little fiddling with my test suite, because when you run the full test it starts by truncating all the tables, and you can't truncate a temporal table.  You have to drop versioning, truncate it, and enable versioning again.
  
  Result: The first run was three times slower than before, but I quickly tracked this down to the stack table, which is the container for mentions, notifications, and other collections of messages.  Every time a message is posted, it's dropped into the stacks of all that user's followers, and the count on the stack record is updated.
  
  Turned off versioning for that one table and run time dropped back down to within 5% of an unversioned database.
  
  The resulting database is 25% bigger, partly because it's creating extra records, and partly because it needs to add timestamps to all the index entries so that you can go back in time.  
  
  Is it really working?  Yep.  The test I ran created 100 users, and there are a total of 10,100 records in the user table if you scan across all history.
  
  Also, the MariaDB hot backup utility can in fact capture system versioning, so I probably don't need to worry about bitemporal tables.
  
  This is good.  This is really good.  Not only does it automatically track intentional edits to every record (I had code set up to handle that for messages), but it provides a magical undo mechanism for accidental deletes or data-mangling bugs.
  
  I think there's a mechanism in there to zap the history for a record should I need that, for example, to comply with GDPR.
  
  
  
• Micron has delivered their new 176-layer 3D flash, sort of.  (Tom's Hardware)
  
  One minor catch: It's actually two 88-layer dies nano-stacked on top of each other.  I'm not sure if that matters.
  
  It's shipping in products right now, though Micron didn't specify which ones.
  
  
  
• Looking for a rather chunky portable gaming device?  Look no further - the Aya Neo Founder Edition is here.  (Tom's Hardware)
  
  It has a Ryzen 5 4500U, 16GB of RAM, a 512GB or 1TB SSD, and....  A 7" 1280x800 display, which is a crime given the rest of the hardware stats.
  
  
  
• A wild Ryzen 7 5700U appeared!  (Tom's Hardware)
  
  It used SMT.
  
  The 5700U appears to be essentially a 4800U.  That means it will be around 25% faster than the 4700U on multi-threaded workloads.  (CPUBenchmark)
  
  If the price is the same as before, that's a respectable generational bump.
  
  The 5800U, when it arrives, is expected to be Zen 3 and will offer a similar performance boost over the current 4800U.
  
  
  
• Zoom lied to users about end-to-end encryption.  (Ars Technica)
  
  Yeah, no shit.
  
  
  
• Et tu, Tame Apple Press.  (ZDNet)
  
  Even they expect the upcoming Arm-based Macbooks to suck to start with.

Bonus Hololive Opening Theme Video of the Day

Posted by: Rick C at Wednesday, November 11 2020 12:23 AM (eqaFC)

Posted by: Jay at Wednesday, November 11 2020 03:01 AM (0jVI9)

Posted by: Wonderduck at Wednesday, November 11 2020 03:37 AM (vNkOW)

Posted by: Pixy Misa at Wednesday, November 11 2020 02:08 PM (PiXy!)

Hide Comments | Add Comment

• Facebook has declared war on conservative groups spreading information.  (Mashable)
  
  This is being done for their own protection.  (CNet)
  
  Slashdot are gleefully pro-censorship in all this, because fuck principles.
  
  
  
• Sites relying on LetsEncrypt certificates will become inaccessible from older versions of Linux starting in September next year.  (LetsEncryt)
  
  Anything older than Android 7.1 will stop working...  Unless you download Firefox, because whatever their their faults the folk at Mozilla actually know how to write a web browser.
  
  
  
• Putting things where they shouldn't be, part one: Running VMWare ESXi on a Raspberry Pi.  (Serve the Home)
  
  
  
• Putting things where they shouldn't be, part two: Running BGP on a Lego brick.  (Cynthia.re)
  
  
  
• MSI's upcoming RTX 3090 reportedly has a boost clock 16% higher than the Founder's Edition cards.  (Tom's Hardware)
  
  
  
• In unrelated news their factory caught fire.  (Tom's Hardware)
  
  
  
• Calli and Kiara restarted yesterday's failed Minecraft stream, Kiara died, respawned at the default start point miles from where they had been playing, made her way back, fell off a cliff and died again, and then Minecraft died too, so they spent the rest of a stream talking about their spa date.
  
  
  

• Got Object Desktop renewed so I could install Multiplicity everywhere (slightly tricky because when you renew it issues it to the original email, not the email you enter - and doesn't mention that anywhere), got Multiplicity installed, updated Rally Vincent to Windows 2010 or whatever they're calling this latest release, updated VirtualBox because the latest Windows 10 breaks VirtualBox 5, found that somewhere along the line my GitLab server had gotten hosed, patched it up long enough to copy everything over to a brand new Ubuntu 20.10 instance running ZFS - which works very nicely - and am currently digging into MariaDB temporal tables as originally planned.
  
  Some testing has shown at least that there's no longer any reason to avoid InnoDB so long as you are using ZFS.  The tables are much bigger than TokuDB, but about as fast, and ZFS LZ4 compression brings the size down to within about 20% of TokuDB.
  
  And rather importantly, it's unlikely to be suddenly abandoned and force me to convert all my tables.
  
  
  
• I was thinking Tohru - the older of my two Dell all-in-ones - might have had a hardware issue because the fan noise is noticeably louder than it used to be.  So I installed Multiplicity and now I'm running both Tohru and Rally rather than Rally being mostly dormant as just serving as a monitor.
  
  And now they're making exactly the same amount of fan noise.
  
  I guess it's just the number of apps and browser tabs and virtual machines I have running all the time.  And ever-increasing Windows bloat.
  
  
  
• Got locked out of Twitter today for posting a link discussing the application of Benford's Law to election results.  As did quite a few other people.  (Instapundit)
  
  No warning, no explanation, just "You broke one of the seven million rules and must be punished."
  
  Apparently the reason is that the site that hosted that link also reported on the contents of Hunter Biden's laptop.  Twitter doesn't care - and doesn't tell you.  You're just kicked off the platform.
  
  
  
• And if you're locked out of Twitter, you also can't use Twitter OAuth to log into other platforms, like Disqus.  So the censorious fuckheads have killed that as well.
  
  
  
• In ENTIRELY UNRELATED NEWS Parler is the top free app on the App Store right now.
  
  ...
  
  How do you embed one of those things?  Can you embed one of those things?  I'll look into that.  Also the same for mee.ms, of course.
  
  
  
• Uber, fresh from a victory over AB5, vows to take on similar laws worldwide.  (Tech Crunch)
  
  What, I have to like Uber now?
  
  Also, the voting map for Prop 22 looks exactly as you would expect.  California may be a standard deviation to the left of the US average, but it still has a group two standard deviations to the left of that, trying to control everything.
  
  
  
• ZeroSSL does everything that LetsEncrypt does but seems to be a little more flexible.  (ZeroSSL)
  
  95% of the websites at my day job went down for fifteen minutes last week after an issue with LetsEncrypt rate limits cascade-crashed our proxy servers.  Not blaming anyone; the latest version of the software fixes this but I haven't had time to update.
  
  
  
• The most popular thumbnail in the world.
  
  
  
  Kiara and Calli had a Minecraft stream planned, but it's a weekend for technical issues and it all fell over.  15,000 people in chat giving them money anyway.
  
  Rescheduled for tomorrow now.
  
  
  
• Which is something of a relief because I would have had to tear myself away for Coco's Minecraft stream which starts in twenty minutes.  Just after she finished her earlier Terraria stream.
  
  Update: Diamonds!
  
  

Posted by: StargazerA5 at Monday, November 09 2020 01:46 AM (1ZQzH)

Posted by: Rick C at Monday, November 09 2020 07:17 AM (eqaFC)

Posted by: Rick C at Monday, November 09 2020 07:20 AM (eqaFC)

Posted by: Rick C at Monday, November 09 2020 07:23 AM (eqaFC)

Posted by: kwan3217 at Monday, November 09 2020 07:57 AM (Api9H)

Posted by: Rick C at Monday, November 09 2020 09:02 AM (eqaFC)

Posted by: Pixy Misa at Monday, November 09 2020 09:12 AM (PiXy!)

Posted by: The Brickmuppet at Monday, November 09 2020 09:51 AM (5iiQK)

Posted by: Rick C at Monday, November 09 2020 10:02 AM (eqaFC)

Hide Comments | Add Comment

Posted by: Pete Zaitcev at Monday, November 09 2020 11:25 AM (LZ7Bg)

Posted by: Pixy Misa at Monday, November 09 2020 11:41 AM (PiXy!)

Posted by: Mauser at Tuesday, November 10 2020 11:33 AM (Ix1l6)

Hide Comments | Add Comment

• Working on the UI of the new social platform today.  I licensed a Bootstrap theme that has designs for pretty much everything I need - social newsfeeds, blogs, forums, photo galleries, videos and streams, profile pages, all that stuff.  But it was also visually busy and slow to load.
  
  I've slimmed it down and sped it up, and made the content load dynamically into a static frame.  There's still a small issue with the initial page load, it's now fast enough that you have to know what you're looking for to notice it.
  
  Tomorrow I'm going to implement MariaDB bitemporal tables.  These are interesting beasts: They version-track your data.  You can run a query to show you what your blog looked like last Tuesday before you messed it up, or to show all the edits to a post.  Handled entirely by the database server.
  
  I plan to use bitemporal tables rather than simply temporal tables because if you  dump and load a temporal table all the history vanishes, and likewise you can't import history from an existing source.  A bitemporal table tracks history both by system time and application time.
  
  I checked on a couple of details tonight, and it looks pretty good.  You can partition a temporal table so that the live data is in one file and the history in another (or several others), you can drop old history partitions if you don't need them and the disk is full, and you can add new columns to a temporal table.  That's not what the SQL:2011 standard says, and it's not correct from an auditing perspective, but I'm glad they did it because I doubt I could use this feature if it meant never changing my database definitions after launch.
  
  Update: Ugh, they've deprecated TokuDB.  It doesn't work with temporal tables anyway, but it was a really solid database engine.  InnoDB is supposedly the gold standard but it uses far more storage and offers worse performance.
  
  
  
• Facebook has gone all-in on censorship.  (Vice)
  
  The usual suspects are still complaining that they aren't silencing people fast enough.
  
  Orwellian doesn't begin to cover it.
  
  
  
• Scientists have discovered a planet where it rains rocks and the oceans are lava.  (CBS)
  
  Sounds like SMOD went to the wrong address.
  
  
  
• The Xbox Series X vs. The Good God That Thing Is Ugly.  (Tom's Hardware)
  
  The Xbox is faster, uses less power, and is quieter than the GGTTIU, but not by a huge amount in any category.  For a proper head-to-head test we'll need multiple cross-platform titles optimised for each system, and so far there aren't any.
  
  
  
• "><SCRIPT SRC=HTTPS://MJT.XSS.HT> LTD has been forced to change its name.  (The Guardian)
  
  Yes, someone Little Bobby Tablesed the agency responsible for registering business names in the UK.
  
  
  
• Okay, I don't think that chilli was as gluten-free as the label suggested.  Gotta go.

1 OH! 

I was envisioning something like Twitter, Parler, or Pawoo. This sounds rather more impressive. Will we be able to migrate our Mee.nu blogs there or is this activating additional options in the mee.nu dashboard menu?

 

Posted by: The Brickmuppet at Sunday, November 08 2020 01:52 AM (5iiQK)

Posted by: normal at Sunday, November 08 2020 05:35 AM (obo9H)

Posted by: Mauser at Sunday, November 08 2020 01:44 PM (Ix1l6)

Hide Comments | Add Comment