• Lexar has a new PCIe 4.0 M.2 SSD on the way that should be able to hit 7GB per second.  (Tom's Hardware)
  
  At least on reads; 4GB per second on writes.
  
  Current PCIe 4.0 SSDs all use the same controller and are limited to only 5GB per second.
  
  
• ICANN has put the .org TLD sale on hold until all the fuss dies down.  (ICANN)
  
  I mean, they don't explicitly say that, but...
  
  
• Full-text search indexes and ACID databases don't mix: Adding a full-text index to your InnoDB table can dramatically slow down transactions.
  
  But if, rather than indexing the raw fields, you have a specific search content field and populate that once a second, you can speed things up by a couple of orders of magnitude.
  
  And because data is only flushed to disk at the end of the transaction, it achieves this performance while also drastically reducing disk I/O - important if you're on a cloud server and don't have direct access to a fast SSD.
  
  Having an explicit search field has a couple of other advantages: You can add computed values, so that if your post is tagged "news" you can search specifically for tag:news without having to fuss about with multiple indexes.  (Elasticsearch does this automatically.) 
  
  And if you only need to keep the last, say, 90 days of comments searchable you can just null that field after 90 days.  The comments work just as before, but disappear from search.  (Although MySQL also allows you do do search queries without an index if you really want to.)
  
  The big advantage of having search inside your relational database is that you can use search and relations at the same time - that is, you can search only posts by people or blogs you follow, without needing a huge custom search infrastructure to manage it.
  
  
• Speaking of MySQL, if something is unspeakably slow and it's not a full-text index, it's probably a subquery.  Got rid of one of those as well today.
  
  
• Vim 8.2 has killer sheep.  (GitHub)
  
  Someone will now point out that EMACS had killer sheep in 1982.

Got up this morning to find that my air conditioner had had enough of the 100% humidity and had flooded my kitchen.  Not with nice clean water either, oh no.  Had this running through my head all day as a result. 

Posted by: J Greely at Tuesday, December 17 2019 03:50 AM (ZlYZd)

Posted by: Pixy Misa at Tuesday, December 17 2019 09:33 AM (PiXy!)

Posted by: Wonderduck at Tuesday, December 17 2019 06:56 PM (cTMj+)

Posted by: Jay at Wednesday, December 18 2019 02:22 AM (mrlXS)

Hide Comments | Add Comment