My task is to collect performance data about a single query, using PERFORMANCE_SCHEMA (P_S for short) in MySQL, to ship it elsewhere for integration with other data.
My task is to collect performance data about a single query, using PERFORMANCE_SCHEMA (P_S for short) in MySQL, to ship it elsewhere for integration with other data.
Like I said, I never had much reason to use table compression, and only recently looked into the topic.
MySQL Page Compression looks a lot easier at the database end of things, but relies on hole punching support in the file system.
Let’s have a look at what that means.
For the MySQL Million Challenge, I was going through the server syntax in order to understand what things can be created in the server.
And now my OCD triggered.
DDL is a mess.
A long standing idea that I have is to test the servers limits:
How does it fail and break if there are very many of a thing?
Previously that was too easy, because many structures were constructed in a way that it was obvious they would not scale.
But with MySQL 8 many things were overhauled, so let’s see what we can make many of and see how the server fares.
I never had much reason to use table compression, so I largely ignored the topic in MySQL.
I knew that MySQL had table compression since 5.1, but I also knew the implementation was horribly complicated and double stored all data.
There is also page compression, a feature introduced with 5.7, which replaces table compression and works much better.
We observe a large number of messages of the kind
This 2018 book in some aspects is already outdated: Silicon Valles Techbro Kai-Fu Lee describes what AI is and what he thinks it will do to our future, the nature of work and the job market.
But since then, the worlds view on what AI can and cannot do, what the problems to solve really are and a lot of other things have changed.
Max Gladstone and Amal El-Mohtar co-authored This Is How You Lose The Time-War, not exactly a Science Fiction novel.
The memoir of Brian Kernighan, and the story of how UNIX came to be and what working at Bell Labs was like at that time:
UNIX: A History and a Memoir is required reading for anyone who wants to know where Unix concepts came from and what ideas were behind its inception.
Ram V is a writer, sometimes for comics.
Together with artist Sumit Kumar he wrote a simple story: English Vampires vs. Indian Rakshasa.
“Old Man’s War” is the first “large” works by John Scalzi,
Dave Addey ran a Tumblr once, titled “Typeset in the Future”, in which he dissected the typography of Science Fiction films.
This has been turned into the eponymous book.
I had reason to look into the UNIX Eschaton, the time when the signed 32 bit counter of seconds since Midnight, 1970-01-01 UTC overflows. Going to Wikipedia, I learned we will die two years earlier, because in 2036-02-07, 06:28:16 UTC NTP will kill us all:
Paul Fischer writes “A Kim Jong-Il Production”, a documentary the 1978 abduction of the famous South Korean actress Madam Choi, and her ex-husband, the filmmaker Shin Sang-Ok.
It began with a tweet by Sebastian Bergmann, which made me buy “88 names” by Matt Ruff.
The book is a tour of massive multiplayer online role playing games for people who do not play, and also a discussion of identity on the Internet.
Tommmy Krappweis ist nicht nur der Schöpfer von “Bernd, das Brot”, sondern auch ein Musiker, Stuntman, Filmemacher und Autor diverser Bücher.
In der Trilogie um “Mara und der Feuerbringer” nimmt er uns mit in die Geschichten um die 14-jährige Münchnerin Mara Lorbeer in der Welt der nordischen Sagen.
Charles Stross “The Merchant Princes” series of six books is another “Sliders” type of story, with the usual Stross-like twist.
The story follows Miriam Beckstein, a woman who thinks she is a tech journalist.
Miriam falls off a chair while looking at a strange pattern, and finds herself in a medival parallel earth.
“Outland” is the first book by Dennis E. Taylor, preceding the Bobiverse and also “The Singularity Trap”.
It is a “Sliders” storyline, much like Pratchett’s and Baxter’s “Long Earth”, in which our heroes discover a parallel dimension with a seemingly uninhabited earth, and then need to colonize it.
Somebody needed a job queue in Python:
Multiple writers insert into it in random order, and the jobs are written into the MySQL table jobs.
From the jobs table, multiple consumers claim jobs in batches of n or smaller (n=100), and process them.
After processing, the consumers delete the jobs. We need concurrent job generation and consumption, with proper and efficient locking.
