Die wunderbare Welt von Isotopp

Fertig gelesen: The Black Count

Kristian Köhntopp - June 5, 2021
Another Monte-Cristo-themed book, Tom Reiss’ The Black Count nicely complements the german sci-fi novel Montecrypto by Tom Hillenbrand. It is a biography of the father of the French write Alexandere Dumas, Thomas-Alexandre Dumas Davy de la Pailleterie. "The Black Count ", by Tom Reiss. Alexandre Dumas, the author of “The Three Musketeers”, “The Count of Monte Cristo” and many other books, is one of the most read French authors. He had it easy coming up with stories, because his father had one of the most unusual and wildest lives imaginable.

NVME is not a hard disk

Kristian Köhntopp - May 25, 2021
So somebody tweeted about the Seagate Mach.2 , a harddisk with two independent heads “combs”, and I commented in german : “It’s two drives in one chassis, even shown as two drives. And it still is rotating rust, so slow with seeks. Linear IO will be fine.” That quickly devolved in a discussion of RAID-0 on a single disk drive : “RAID-0 on a single physical drive. Yeah, you can do that if you do not need your data.

Windows 10 and Umlauts with an english keyboard

Kristian Köhntopp - May 15, 2021
I never wrote this up, and the information online is all referring to older versions of Windows, so let’s fix this. The MS-DOS version of getting Umlauts on a US keyboard is to type the ASCII codes. As I can’t and won’t remember these codes, this won’t work for me. There is a deadkey way to get a “US (International Keyboard)”. On these, you type Double Quotes ", and then the letter that should form the Umlaut, for example o, for an ö.

Fertig gelesen: Linkers

Kristian Köhntopp - May 14, 2021
Ian Lance Taylor is the author of a UUCP program that I have been using for a long time to connect to other USENET systems, long before I had access to the actual Internet. UUCP queues up jobs for remote execution, dials other computers with a moden, exchanges the contents of the queued up work, and after disconnect executes the jobs. The jobs are mostly invocation of “rmail” and “rnews” programs for the exchange of mail and USENET news.

Fertig gelesen: Needle

Kristian Köhntopp - May 14, 2021
Needle and Through the Eye of a Needle are books by Hal Clement. Hal Clement was a Hard Sci-Fi author born in 1922, and “Needle” was written in 1950 as his first book, for Campbell, no less, and sold to Doubleday. The followup was produced almost 30 years later, in 1978. Needle The story begins with two spaceships crashing into planet earth, some time in the 1950’s idea of a future, close to an island in the Pacific ocean.

Fertig gelesen: The Antivirus Hackers Handbook

Kristian Köhntopp - May 14, 2021
The Antivirus Hackers Handbook by Jaxeon Koret and Elias Bachaalany is part book, part a research report, detailing the findings of Jaxeon Koret and Elias Bachaalany in how Antivirus programs work, try to protect themselves and can be attacked and exploited. The Antivirus Hackers Handbook The book assumes that you have some basic knowledge how compilers produce programs, what assembler looks like and how to map that on program statements in the code you write, and have access to IDA Pro free edition, Ghidra, Hopper or some other reverse engineering and analysis tool.

Fertig gelesen: The Witcher

Kristian Köhntopp - May 14, 2021
So, Netflix’ “The Witcher ” was weird, and could not decide what it wanted to be: A “Hercules Legenday Journey’s”-like half-comedy, half-camp series, or something else, darker and denser, with more story and background. It hinted at a better story, better told, that did not make it into the final product, and died somewhere between the scriptwriting and the cutting table. Investigating, I got myself the equivalent of the Witcher Boxed Set on the Kindle and started reading.

Fertig gelesen: Titan

Kristian Köhntopp - May 14, 2021
The story of Heaven’s River , stranding in and then exploring an alien megastructure, is one that has been written before: In Niven’s Ringworld , Clarke’s Rama , and Farmer’s Riverworld . John Varley’s take on this, very seventies, is Titan , Wizard , and Demon , the Gaia Trilogy. Titan , Wizard and Daemon Cirocco Jones is the Commander of the Earth science ship Ringmaster, and is right now approaching the orbit of Saturn, where she and her crew discover a new moon.

A MySQL flight recorder

Kristian Köhntopp - April 22, 2021
Sometimes things go wrong, and it surely would be nice if you at least knew afterwards what happened. Where I work, we are running a shell script older than time itself, once a minute. The script writes files to /var/log/mysql_pl, into a directory named after the current weekday and named after the current hour and minute. So when a box crashes on Thursday at 22:09, as long as I can login to it, I still can try to look at /var/log/mysql_pl/Thu/22_0?

Fertig gelesen: Children of Ruin

Kristian Köhntopp - April 7, 2021
Children of Ruin is the second part of Children of Time by english Sci-Fi author Adrian Tchaikovsky. In “Children of Time”, mankind reached for the stars, almost succeeded and also almost died out. They did manage to create a digital lifeform, though, and also to seed and uplift life from earth on another world - just not the intended one. And so we ended up with a race of intelligent giant jumping spiders that manage to befriend the broken artificial intelligence orbiting their world and to rescue the remnants of humankind from themselves.

Fertig gelesen: Conan, The Barbarian

Kristian Köhntopp - April 7, 2021
Conan, The Barbarian by Robert E. Howard is a collection of all Conan stories. Imaginary Worlds Ep 114: The Man Behind the Sword (Episode Transcript PDF ) discussed Robert E. Howard, his 1930’s character Conan, The Barbarian and how Howard’s Conan is different from the Schwarzenegger character, and a much deeper and more complicated story. Go, and listen to the episode, it is well worth the time. Having seen the Schwarzenegger film, but never actually having read the book I went out and got this complete collection.

Fertig gelesen: Heaven's River

Kristian Köhntopp - April 7, 2021
Heaven’s River is the fourth part of the Bobiverse Trilogy, in which the original Bob finds a decaying alien megastructure, and investigates. Previously in the Bobiverse: We are Legion (We are Bob) For We Are Many All These Worlds Bob Johannson is a successful software developer, and cashes out. Then he dies, becomes a sentient spaceship and von Neumann probe, and then earth is almost destroyed in a war. Bob moves on, doing the von Neumann thing, and plundering the resources of foreign star systems makes more Bobs.

Fertig gelesen: Masters of Doom and The Game Engine Black Book: Doom

Kristian Köhntopp - April 7, 2021
Masters of Doom: How Two Guys Created an Empire and Transformed Pop Culture by David Kushner is the story of the two Johns: Carmack and Romero, and the early video game culture and the genre of the 3D first person shooter. A lot of todays “hard core” and somewhat toxic video game culture was defined by the two Johns and the company they built, as well as the culture that followed.

Fertig gelesen: Other Minds

Kristian Köhntopp - April 7, 2021
Peter Godfrey-Smith writes Other Minds: The Octopus and the Evolution of Intelligent Life , a book about the body, the mind and the life of Octopi. Octopi are creatures that are across the tree of life about as different as can be from humans. How different are they? Their blood is not based on iron, as ours, but uses copper to transport Oxygen, and consequently is not red from hemoglobin, but blueish from hemocyanin.

Fertig gelesen: Terry Jones' Barbarians

Kristian Köhntopp - April 7, 2021
Terry Jones’ Barbarians: An Alternative Roman History by Alan Ereira is the writeup to the BBC series “Terry Jones’ Barbarians ”. Terry Jones, who sadly died in early 2020, was not only a member of Monty Pythons Flying Circus, but among many other things a TV author and presenter for a number of BBC series on medieval and ancient history. In many cases, he takes the controversial position and presents a view of history that challenges the popular view.

Fertig gelesen: The Vanishing Middle Class

Kristian Köhntopp - April 7, 2021
The Vanishing Middle Class: Prejudice and Power in a Dual Economy by Peter Temin analyzes the economical and political structure of the USA. Temin does this through the lens of the “Dual Economy ” Model. Dual Economies are normally prevalent in colonial societies of “less developed” countries. These countries usually have local production and production for a global export market, and besides economical and income structures around this separation, there are also social segration and a certain degree of isolation of the social groups from each other - in politics as well as attempts to prevent social migration into the higher ranked group.


Kristian Köhntopp - April 6, 2021
In ALTER TABLE for UUID we discuss currently proper way to store and handle UUID in MySQL. Currently it works, even in a performant way, but it still hurts. It should not. Definition of UUID The RFC 4122 defines various types of UUID, and how they are being formatted for presentation and as a bit field on the wire. As this document was written bei Leach and Salz, among others, RFC 4122 UUIDs are also called “Leach-Salz UUIDs” (for example in the Java Documentation ).

Making an unexpected leap with interval syntax

Kristian Köhntopp - April 2, 2021
(based on a find by Ruud van Tol, and several Twitter contributions) Ruud commented on our DST discussion with mysql> SELECT '2019-02-28 12:34:56'+ INTERVAL 1 YEAR + INTERVAL 1 DAY as a, '2019-02-28 12:34:56'+ INTERVAL 1 DAY + INTERVAL 1 YEAR as b\G a: 2020-02-29 12:34:56 b: 2020-03-01 12:34:56 2019 is a year before a leap year. Adding (left to right) a year brings us to 2020-02-28, and then adding a day makes this 2020-02-29, because it’s a leap year.

Things you didn't know about MySQL and Date and Time and DST

Kristian Köhntopp - March 29, 2021
(based on a conversation with a colleague, and a bit of Twitter ) A Conundrum A developer colleague paged me with this: mysql> select UNIX_TIMESTAMP("2021-03-26 03:07:00" + INTERVAL 2 YEAR) - UNIX_TIMESTAMP("2021-03-26 02:07:00" + INTERVAL 2 YEAR) as delta\G delta: 420 It is obviously wrong, and weirdly so. It only works for “2 year”, not with other values: mysql> select UNIX_TIMESTAMP("2021-03-26 03:07:00" + INTERVAL 1-11 year_month) - UNIX_TIMESTAMP("2021-03-26 02:07:00" + INTERVAL 1-11 year_month) as delta\G delta: 3600 mysql> select UNIX_TIMESTAMP("2021-03-26 03:07:00" + INTERVAL 1-12 year_month) - UNIX_TIMESTAMP("2021-03-26 02:07:00" + INTERVAL 1-12 year_month) as delta\G delta: 3600 mysql> select UNIX_TIMESTAMP("2021-03-26 03:07:00" + INTERVAL 1-13 year_month) - UNIX_TIMESTAMP("2021-03-26 02:07:00" + INTERVAL 1-13 year_month) as delta\G delta: 3600 It has to be exactly 730 days (2 * 365 days, 2 years):

That's a lot of databases

Kristian Köhntopp - March 24, 2021
Where I work, we are using MySQL a lot. The databases are being organized in replication hierarchies, and each hierarchy is a tree topology with a single primary and a number of intermediate replicas. Replication is a tree managed by Orchestrator We are using MySQL orchestrator to manage the replication topology. MySQL Orchestrator shows a typical replication hierarchy. Each color indicates a different data center/availability zone. Replication is a tree, from the primary to per-AZ intermediate replicas for fan-out to leaf replicas.