• The Ryzen 5600X is the best mainstream gaming CPU.  (Tom's Hardware)
  
  It's not even close.  The only Intel chip that beats it at 1080p is an overclocked 10900K.
  
  
  
• Putting the ASRock 4x4 4800U model to the test.  (Tom's Hardware)
  
  It's small, it's fast, it's quiet even at full load, it's not particularly cheap, and it's probably out of stock.
  
  
  
• Chrome is dropping Windows 7 support in January.  (ZDNet)
  
  Oh.  January 2022.
  
  If you're still using that, though, it's high time you upgraded anyway.  I suggest Firefox.
  
  
  
• S3-style object storage is a mess.  (Google Support)
  
  If you expect sane semantics, you're in for a world of hurt.  There is no structure; there's a reason they're called buckets and not directories.
  
  
  
• If I set my RX 580 to power efficiency mode it gets a lot quieter.  Not silent, but much less annoying.
  
  
  

Noisy Neighbour Problem Video of the Day

Squirrel Noises Video of the Day

• Asus has not announced their new Tinkerboard 2 and 2S. (Tom's Hardware)
  
  These are similar to the Raspberry Pi, albeit slower because they only have two A72 cores rather than four.
  
  
  
• I thought the Tinkerboard had a dedicated AI core but I had it confused with another news item: SolidRun has launched their new Arm developer board for low-end AI vision projects. (ZDNet)
  
  These use an NXP i.MX 8M Plus (originally Motorola, then Freescale) which is slower than the Raspberry Pi because it has zero A72 cores rather than four - just the slower A53 core - but it does have a dedicated neural processing unit running at up to 2.3 trillion operations per second.  Boards start at $75.
  
  
  
• Apple says that it's up to Microsoft to make Windows run on Arm Macs. (Tom's Hardware)
  
  Which implies that Windows can run on Arm Macs, at least in theory.  Which would suggest that Linux could in principle run on Arm Macs.  Which would make them something other than shiny paperweights.
  
  Still not going to buy one.
  
  
  
• Twitter seems to have completed its process of wokifying its technical staff. (Tech Crunch)
  
  The new fleets feature supposedly made tweets disappear after 24 hours. However:
  
  
• Twitter's API includes fleets in the requests, so any app that caches the API data will keep the fleets indefinitely.
  
  
• Each fleet has a canonical URL which still works after the fleet has nominally expired.
  
  
• Twitter doesn't actually delete the content for 30 days or longer anyway. The feature is purely cosmetic even when it works, which it currently does not.
  
  
  
• Victoria and South Australia are imposing a mileage tax on electric cars to replace the petrol excise.  (The Driven)
  
  Which means they need to track how far you drive.  
  
  Wonderful.
  
  
  
• Angry Haskell noises.  (Is Apple Silicon Ready)
  
  Well, angry Android Studio and Docker noises too, but Haskell is the only one that gets the double red splat of not working natively at all and also not working under x86 emulation.  At least some parts of Android Studio and Docker sort of work.
  
  There is only one app I use that I know is written in Haskell, but it's really useful.
  
  
  
• Ubuntu Web Remix is ChromeOS only Firefox on Ubuntu.  (Ubuntu Forum)
  
  This isn't being officially announced by Canonical, but the lead developer is an Ubuntu team member.  I can certainly see the value in a ChromeOS-like operating system that isn't controlled by Google's HR department.

Posted by: normal at Monday, November 23 2020 12:40 AM (obo9H)

Posted by: Phil Fraering at Monday, November 23 2020 02:08 AM (Clxcy)

Posted by: Rick C at Monday, November 23 2020 04:48 AM (eqaFC)

Hide Comments | Add Comment

• It seems PayPal doesn't like Australia's largest retailers.  Had a problem placing a grocery order with Woolworths on Thursday.  Went out to the shops, used the same card I use to pay via PayPal, went through just fine.
  
  Paid a hosting bill today, no problem.  Tried to buy a few items from Kmart, goes into compliance review with PayPal and they'll get back to me in three days, maybe.  Not sure what good that will do since the order seems to have been cancelled already.
  
  Fortunately this is just some household things I'd like to get before Christmas, not my next week's worth of food.
  
  
  
• YouTube chat is garbage.  Just an observation.
  
  I mean technically, not the people in it, who are mostly fine.
  
  Except for the Chinese antis, who are very much garbage.
  
  
  
• Sam is coming to Intel and Nvidia.  (Tom's Hardware)
  
  This is AMD's method for direct-mapping all of a video card's RAM into the CPU's address space.  Currently only works for Radeon 6000 series with Ryzen 5000 series CPUs on a 500 series motherboard but in theory it should work for any CPU, GPU, and motherboard combination.
  
  
  
• An Elbrus mini-ITX motherboard.  (Tom's Hardware)
  
  I didn't know they were still making these things.  The chip is on the slow side and the board will be expensive, but if you're interested in that kind of thing, it will make it a lot easier to get a working system.
  
  
  
• Third-party Radeon 6800 cards are on their way unless they're not.  (WCCFTech)
  
  Stock clock speed on this one from PowerColor is 2340 MHz vs. 2250 MHz for the reference design, but they got a stable overclock of 2650 MHz.
  
  
  
• Making your web app run 100x faster means it costs 100x less to host maybe.  (Luke Rissacher)
  
  Just yesterday I found a common API call at my day job that takes about two seconds - but 99.something% of the time is returning the same, public data.  We added some code to the client to hit the API when it needs custom data and the CDN otherwise, and that dropped to 14 milliseconds.
  
  
  
• End-to-end ECC vs. a 0.1¢ surface-mount resistor.  (Kate's Lab Notebook)
  
  0.1¢ on the resistor.
  
  
  
• A Brainfuck IDE and interpreter that fits in a boot sector.  (GitHub)
  
  Ours is not to reason why, ours is but to boot and cry.
  
  
  
• It's always a demarcation dispute with these guys.  (Tech Crunch)
  
  Pakistan: We want to censor the internet!
  
  Twitter, Facebook, Google: Hey!  That's our job!
  
  
  
• Oh, right.  I have Amazon Prime now.

Posted by: Rick C at Sunday, November 22 2020 08:59 AM (eqaFC)

Posted by: The Brickmuppet at Sunday, November 22 2020 11:44 AM (5iiQK)

Posted by: J Greely at Sunday, November 22 2020 12:42 PM (ZlYZd)

Hide Comments | Add Comment

• Twitter's new "fleets" feature, which causes posts to self-destruct after 24 hours, has itself self-destructed after 24 hours.  (The Independent)
  
  It's the 2020est thing ever.
  
  
  
• However bad we thought it was, it's worse.  (Mr Macintosh)
  
  
  • The MacOS Big Sur update would brick the 2013-2014 MacBook Pro beyond any recovery, requiring a whole new logic board.
    
    
  • The repair costs users $500, despite the fact that Apple destroyed your computer themselves.
    
    
  • The replacement logic board is not available anyway.
  
  Good work there, world's richest company.
  
  
  
• Gigabyte finally has a range of Zen 2 NUC's.  (Tom's Hardware)
  
  On the good side, they have 2.5GbE as standard, HDMI, DisplayPort, and two USB-C with DP, one each at the front and back.
  
  On the bad side, the arrangement of the USB ports at the front seems deliberately designed to infuriate people.
  
  
  
• Fonts for developers.  (Devfonts)
  
  
  
• The threat of the leapn't second.  (Dreamwidth)
  
  Every few years on average we need to add a leap second to our clocks to keep them in sync with the Earth's actual rotation, which is very slightly slower than 86400 seconds per day, gradually slowing down, and variable anyway.
  
  Lately the accumulated drift has been holding at just above zero, raising the possibility of a negative leap second, which has never happened and would likely crash every computer in the world.
  
  
  
• The ASRack X570D4U-2L2T-HoldTheMayo.  (Serve the Home)
  
  This is the updated version of what I have in the new server (where Ace is running now, after the old server imploded).
  
  It has two 10GbE ports, two 1GbE ports, and yet another one for IPMI, and both VGA from the management chip and HDMI for an APU.
  
  
  
• IBM's Power 9 has a cache invalidation bug similar to the ones that have affected Intel in recent years.  (Phoronix)
  
  The fix is to flush the L1 cache on every single kernel call.
  
  Fortunately most Power 9s aren't running untrusted code in the first place and can just disable the security patch, because that would be really bad for preformance.
  
  
  
• Buzzfeed is, for some unfathomable reason, acquiring the Huffington Post.  (Business Insider)
  
  Lois McMaster Bujold had a great expression for this in Shards of Honor (which if you haven't read it, you should):

  Put all the rotten eggs in one basket - and then drop the basket.

  
  
  
• The usual suspects are back to demanding more censorship.  (New York Times)
  
  
  
• Arecibo is being decommissioned.  (Science Magazine)
  
  Recent damage has left the radio telescope out of action and repairs are judged too risky.  One cable failed in August, and a backup cable failed last week while engineers were planning repairs.  The cables are nearly four inches thick, and if one failed while a repair crew was on site it could easily lead to fatalities.
  
  
  

Posted by: normal at Saturday, November 21 2020 04:42 AM (LADmw)

Posted by: The Brickmuppet at Saturday, November 21 2020 12:51 PM (5iiQK)

Posted by: Frank at Sunday, November 22 2020 02:53 AM (rglbH)

Posted by: normal at Sunday, November 22 2020 03:40 AM (obo9H)

Posted by: Pixy Misa at Sunday, November 22 2020 08:51 AM (PiXy!)

Hide Comments | Add Comment

• Selected a hosting provider for the new social network.  Our current provider was very good on free speech issues and helped me with a bogus DMCA claim on one occasion, but they got swallowed up by a larger corporation a while ago and I don't know if they'd do the same today.
  
  But I've found a provider that has a good track record, that I've used once before, whose terms of service are essentially:
  
  
  • No illegal content.
  • No illegal activity.
  • No refunds.
  
  And while not the cheapest around they are reasonably priced.  That's all I ask.
  
  
  
• Looking at Big Navi.  (PC Perspective)
  
  Generally speaking these are great cards at 1440p, often beating the more expensive Nvidia models, and good cards at 4k, coming close behind the more expensive Nvidia models.
  
  For ray tracing they are okay.  Noticeably slower than Nvidia but still playable.
  
  Of course, availability is currently zero, but that's just of AMD-branded cards.  Third-party cards are expected to arrive as soon as next week.
  
  
  
• I expected the 6800 XT to be the pick of the RDNA 2 litter, but the 6800 turns out to be a surprisingly good card.
  
  
  
  It's $80 more than the 3070 (in the US) but beats it on every game, sometimes by substantial margins, and has 16GB vs. just 8GB on the 3070.  In Australia they're exactly the same price, making the 6800 the obvious choice unless you need a specific Nvidia-only feature.
  
  
  
• Tame Apple Press says you don't need the thing you need the moment Apple stops providing it.  (Macworld)
  
  No, 16GB of RAM is not enough, thanks all the same.  16GB of main memory and 8GB of video RAM is not enough.  Two computers each with 16GB of main memory and 8GB of video RAM is almost enough.
  
  Please go piss on someone else's leg.
  
  
  
• The internet is being censored.  (University of Michigan)
  
  File this one under no shit, Sherlock.
  
  
  
• And again.
  
  
  
  
  What the hell does Outbrain do, anyway?

  We power the feed experience of the open web helping over 1 billion people discover content, products & services that they may be interested in.

  Oh, spam.
  
  
  

Posted by: Rick C at Friday, November 20 2020 01:48 AM (eqaFC)

Posted by: J Greely at Friday, November 20 2020 03:29 AM (ZlYZd)

Posted by: normal at Friday, November 20 2020 04:58 AM (LADmw)

Posted by: Jay at Friday, November 20 2020 06:47 AM (0jVI9)

Posted by: normal at Friday, November 20 2020 07:44 AM (LADmw)

Posted by: normal at Friday, November 20 2020 11:37 AM (obo9H)

Hide Comments | Add Comment

• Testing the new Mac Mini.  (AnandTech)
  
  The hardware is very good.  The CPU beats Intel on single-threaded tasks and competes well with AMD, and while the integrated GPU can't beat a 580X (as one site claimed) it can beat a 560X.  I wonder how wide the memory bus is - we know it's LPDDR4X-4266, but the performance is surprisingly good if that's just a 128-bit bus.
  
  The software, unfortunately, is MacOS, which these days means you're a perpetual unpaid beta tester.
  
  
  
  If this hardware were generally available and at all open it would be an exciting and potentially market-changing event.  Instead it's a shiny piece of crap.
  
  
  
• Intel is talking up its Ice Lake Xeon processors.  (Serve the Home)
  
  They claim that a 32-core Ice Lake Xeon can beat a 64-core Epyc Rome on AVX512 benchmarks.
  
  The problem here is that (a) they're comparing against Zen 2 cores from last year when Zen 3 Epycs are already shipping to major customers, (b) Epyc doesn't have AVX512, and (c) Ice Lake Xeon doesn't even have a release date yet.
  
  Still, it should be a decent chip.
  
  
  
• Marvell is licensing 112G SerDes for TSMC's 5nm process.  (AnandTech)
  
  But to whom?  Apple is the main customer of TSMC 5nm, and Apple has no use for this.
  
  
  
• Resellee wants to become the Pinduoduo of Southeast Asia.  (Tech Crunch)
  
  I'm sure they do.  Who wouldn't?
  
  
  
• The censorship will continue until morale improves.
  
  
  Natural News is a garbage website populated by alt-med cranks, but Twitter and Facebook are treating it as if it were malware.
  
  Update: Original tweet went away, replaced with a comment about the issue.
  
  
  
• Epic Games is suing Apple under Australia's consumer protection laws.  (ZDNet)
  
  This will be interesting; the ACCC, which manages such things, has real teeth.
  
  
  
• There you go again.
  
  
  We're moving off Ethereum at my day job because it is, not to put too fine a point on things, a complete fucking disaster.
  
  
  
• Twitter has announced that it is adding an edit button.  (Reuters)
  
  Just kidding.  Of course they're not doing anything logical or useful.  They're adding tweets that disappear after 24 hours, leaving behind only a perpetual cryptographically verifiable audit trail and a billion screenshots.
  
  Thanks for leaving the market open for me, anyway.

• Deplatforming is the new blacklist.  (Legal Insurrection)
  
  Only now they come for you if you're not a communist.
  
  
  
• Update: I go, I come back.
  
  
  
  Basically, the Radeon 6000 series does what it needs to do, except that you won't be able to get one.
  
  Plus in Australia, the 6800 is priced the same as a stock 3070, which it beats easily, and the 6800 XT is priced like a moderately overclocked 3070 - over $300 cheaper than the cheapest 3080.
  
  But there are no 3080s to be had, currently no Radeon 6000s either, and there are some 3070s.
  
  
  
  

Except Kiara

Posted by: Phil Fraering at Thursday, November 19 2020 12:06 AM (Clxcy)

Posted by: Pixy Misa at Thursday, November 19 2020 12:15 AM (PiXy!)

Posted by: Rick C at Thursday, November 19 2020 01:56 AM (eqaFC)

Posted by: Rick C at Thursday, November 19 2020 01:58 AM (eqaFC)

Posted by: Pixy Misa at Thursday, November 19 2020 02:09 AM (PiXy!)

Posted by: normal at Thursday, November 19 2020 02:13 AM (LADmw)

Posted by: Rick C at Thursday, November 19 2020 03:03 AM (eqaFC)

Posted by: J Greely at Thursday, November 19 2020 08:52 AM (ZlYZd)

Posted by: normal at Thursday, November 19 2020 10:33 AM (obo9H)

Hide Comments | Add Comment

• GitHub has reinstated Youtube-DL and contributed $1 million to a DMCA defense fund.  (TorrentFeak)
  
  Ably assisted by the EFF.
  
  
  
• The Azure Python library is so large it can't be used from Amazon Lambda.  (GitHub)
  
  What the heck, Microsoft?  What nonsense did you dump in there?  Ten million lines of code seems just a bit excessive for a REST API wrapper.
  
  
  
• Nvidia has launched an 80GB version of their A100 compute card.  (AnandTech)
  
  I think the 40GB version runs around $20k.
  
  
  
• AMD has launched their own next-generation compute card, the MI100.  (Tom's Hardware)
  
  It has 120 compute units - 50% more than the Radeon 6900 XT - but operates at a much lower clock speed to keep heat under control.  And also it has no video output.
  
  It competes evenly with the world's fastest supercomputer from the year 2000.
  
  
  
• There's a 3060 Ti on the way, probably.  (WCCFTech)
  
  80% of a 3070 at 80% of the price.  It uses the same chip as the 3070, so it's an open question of whether its availability will be any better.  The 3070 is at least in stock in some places.
  
  It's almost comforting that unplanned expenses just blew a hole in plans to build myself a new PC any time soon, and I don't have to worry about tracking down components because I can't afford them.
  
  
  
• Intel's first dual-core CPU - from 1977.  (Scary Beasts)
  
  This was used as the disk controller in the BBC Micro, though it was significantly more complex and more expensive than the 6502 CPU.
  
  
  
• DKIM signatures let us prove that emails from crooked politicians are genuine.  So lets ruin that.  (Cryptography Engineering)
  
  How about instead of that you go fuck yourselves?
  
  
  

• The first regular launch of SpaceX's Crew Dragon is on its way.  (Space.com)
  
  Complete with Baby Yoda.
  
  
  
• A list of issues with MacOS Big Sur.  (Mr Macintosh)
  
  Up to and including bricking older Macbooks so hard that they need their logic boards replaced.
  
  
  
• Parler suspends users for trolling and hate speech.  (MSNBC)
  
  The usual suspects are very confused.  This is exactly what they want social networks to do, but the social network that is doing it is the one they are supposed to hate.
  
  
  
• Wordpress suspends sites for, well, whatever.  (The Conservative Treehouse)
  
  
  
  
  At no point did Wordpress actually say why the Treehouse was being kicked off the platform.  The usual excuse for this is that if the tell you what the rules are you will be able to avoid breaking them.
  
  Orwell in one hand, Kafka in the other.
  
  Someone in the comments suggested mu.nu as an alternative platform, but my experience with Wordpress sites is that they always, always get hacked, and I'm already about 400% busy and wouldn't be available to deal with that.
  
  
  
• Update: Comments from a company that specialises in Wordpress hosting.
  
  
  
  
  
  
• And more.
  
  Free Republic is doing an urgent server migration because their hosting provider is, well, atrocious.  (Free Republic)
  
  "We're closing down that datacenter in May of next year, so please plan ahead to migrate all your servers."
  
  "Wait, did we say May?  We meant tomorrow."
  
  
  
• The OnePlus 8T is a great phone with a great camera - about half the time.  (Thurrott,com)
  
  The other half it's a blurry mess.
  
  The camera, that is.
  
  Maybe the phone too.  The review doesn't mention that.
  
  
  
• iPhone app development is a huge pile of poo.  (Medium)
  
  Given what a mess web app development is these days, the fact that developers are fleeing towards it tells you everything you need to know.
  
  
  
• An eight-core Tiger Lake processor has been striped.  (WCCFTech)
  
  Well, the article says it was spotted but that would make it a leopard, and leopards never prosper.
  
  
  

It's An Idol Group Like AKB48 Video of the Day

Hololive En's Sixth Ranger Video of the Day

Posted by: The Brickmuppet at Monday, November 16 2020 08:16 PM (5iiQK)

Posted by: Pixy Misa at Tuesday, November 17 2020 12:08 AM (PiXy!)

Hide Comments | Add Comment

• Okay, my test run on the dev server with everything enabled is four hours, not two.  Still down from ten hours, and no longer overloads the I/O or causes odd latency spikes towards the end of the run.
  
  On the bigger server the performance curve is nice and flat.  The first 50,000 messages pushed through the system averaged 5ms each, and at the 5,000,000 mark it's averaging 8.6ms.
  
  So that's good to go as far as I'm concerned and I can focus entirely on the UI.
  
  Using ZFS with Gzip does put a fair amount of load on the CPU, though the advantage is less I/O and significantly smaller databases (which in turn means that the Linux filesystem cache can hold more data).  So when it's time to give this a dedicated server I'll be looking for something with plenty of CPU.  Fortunately that's pretty cheap these days; going from 6 cores to 10 adds about $25 per month.
  
  I used Vultr for this testing.  It cost me $7.68 to get a dedicated server for two days, and while I just used their default Ubuntu 20.04 setup in this case, you can manually install any Linux distro.  Very handy for ZFS because otherwise you have to add SAN storage at extra cost or jump through hoops resizing your root volume.
  
  
  
• Apple locked down networking in the Big Sur MacOS update so that users can no longer control it.
  
  Unfortunately...
  
  
  
  
  Ijits gonna ij.
  
  
  
• Russian and North Korean state-sponsored hackers are targeting Wuhan Bat Soup Death Plague vaccine makers.  (ZDNet)
  
  That's an act of war.
  
  
  
• Amazon has recalled 350,000 Ring doorbells because they, uh, catch fire.  (People)
  
  That's a pretty neat trick for a fucking doorbell.
  
  
  
• The Fascist People's Front - a.k.a. the American news media - are attacking YouTube for not censoring people in a sufficiently arbitrary way.  (NBC News)

  "Is YouTube unable to contend with this material, meaning they lack resources? Or is it a lack of will?" asked Sarah Roberts, co-director of UCLA's Center for Critical Internet Inquiry.  "Can't we just line them up against the wall and, well, you know?"

  I may have embellished that last sentence slightly.
  
  Fourteen days to flatten the election result.
  
  
  
• Five separate HoloEn Minecraft streams this weekend.  Sure, it doesn't compare with the best television ever made, but it's better than 99.5% of it.
  
  I cancelled my Netflix subscription not as a political protest - this happened a while ago - but because I spent as much time searching for something worth watching as I did actually watching.
  
  I still have my Animelab subscription, and I'll be keeping that.
  
  Also I have new desktop wallpaper.
  
  

Posted by: Rick C at Monday, November 16 2020 05:44 AM (eqaFC)

Posted by: benzeen at Monday, November 16 2020 11:56 AM (JpDcM)

Hide Comments | Add Comment

• 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