Advertise with Googlier.com Comments for Jeremy Cole https://blog.jcole.us Geek, electronics nerd, database nerd, aviation nerd, father of three. Fri, 02 Jan 2026 07:15:33 +0000 hourly 1 http://wordpress.com/ Comment on A guide to cleaning up in Seattle (and elsewhere) by Reflections on a year of biking for 2025 – Jeremy Cole https://blog.jcole.us/2023/04/02/a-guide-to-cleaning-up-in-seattle-and-elsewhere/#comment-58890 Fri, 02 Jan 2026 07:15:33 +0000 http://blog.jcole.us/?p=1539#comment-58890 […] I went out on at least 30 different days and spent a total of around 130 hours doing various cleanup work by bike, picking up litter, removing/taming vegetation, cleaning up leaves, and otherwise making Seattle […]

]]> Comment on Reflections on a year of biking for 2024 by Reflections on a year of biking for 2025 – Jeremy Cole https://blog.jcole.us/2025/01/01/reflections-on-a-year-of-biking-for-2024/#comment-58889 Fri, 02 Jan 2026 07:15:29 +0000 http://blog.jcole.us/?p=1646#comment-58889 […] year I wrote up a summary of my biking for 2024, and I thought I’d continue that nascent tradition by writing a similar post for 2025, so […]

]]> Comment on Page management in InnoDB space files by Rahul Sisondia https://blog.jcole.us/2013/01/04/page-management-in-innodb-space-files/#comment-58884 Fri, 04 Apr 2025 09:48:20 +0000 http://jcoledotus.wordpress.com/?p=855#comment-58884 Hi Jeremy,

This is excellent work that folks keep on referring to understand Innodb.
I believe there is a little typo in the last diagram.
The forward pointer must be from extent#4 not extent#5.
The reasons for that are –
Otherwise the list gets disconnected.
the backpointer is pointing from extent#0 to extent#4 that indicates there must be a mistake in the forward pointer.

]]> Comment on The MySQL “swap insanity” problem and the effects of the NUMA architecture by Week 3 of January 2025 – Last Week I Learned https://blog.jcole.us/2010/09/28/mysql-swap-insanity-and-the-numa-architecture/#comment-58882 Sun, 19 Jan 2025 19:56:49 +0000 http://jcole.us/blog/?p=522#comment-58882 […] The MySQL “swap insanity” problem and the effects of the NUMA architecture – I love this article because it is illustrates the fact that even with AI, we must understand our own systems. I worry that with the rise of AI and “no code” tools, we will lose our ability to understand critical trade offs. We will forget how our systems actually work and thus how to optimize them. People who understand tech from the ground up are only going to get more valuable.  […]

]]> Comment on A guide to cleaning up in Seattle (and elsewhere) by Reflections on a year of biking for 2024 – Jeremy Cole https://blog.jcole.us/2023/04/02/a-guide-to-cleaning-up-in-seattle-and-elsewhere/#comment-58881 Fri, 03 Jan 2025 02:27:34 +0000 http://blog.jcole.us/?p=1539#comment-58881 […] went out on 29 different days and spent a total of around 120 hours doing various cleanup work by bike, picking up litter, removing/taming vegetation, cleaning up leaves, and otherwise making Seattle […]

]]> Comment on A brief update on NUMA and MySQL by xiaopeng https://blog.jcole.us/2012/04/16/a-brief-update-on-numa-and-mysql/#comment-58865 Wed, 19 Jun 2024 06:06:14 +0000 http://blog.jcole.us/?p=763#comment-58865 Hi Jeremy,

We have a MySQL 8.0.32,with 16C 64G on centos7,the load will spike every 7 hours with low IO and low CPU.I suspect it’s related with numacal,Could you please help

available: 1 nodes (0)node 0 cpus: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15node 0 size: 63096 MBnode 0 free: 9245 MBnode distances:node 00: 10

]]> Comment on Visualizing the impact of ordered vs. random index insertion in InnoDB by Understanding internals of MapDB | siddharth's space https://blog.jcole.us/2014/10/02/visualizing-the-impact-of-ordered-vs-random-index-insertion-in-innodb/#comment-58861 Thu, 21 Mar 2024 23:20:00 +0000 http://blog.jcole.us/?p=1278#comment-58861 […] inserts. I would have expected BTreeMap might be faster at least for sequential inserts based on this (since MySQL primary index is backed by a B+ tree; at least that’s what I […]

]]> Comment on Efficiently traversing InnoDB B+Trees with the page directory by hjjscofield https://blog.jcole.us/2013/01/14/efficiently-traversing-innodb-btrees-with-the-page-directory/#comment-58860 Fri, 08 Mar 2024 09:49:09 +0000 http://jcoledotus.wordpress.com/?p=940#comment-58860 page directory design is like cache of sparse index

]]> Comment on Upgrading a Giant Explore E+ 2 with the Rohloff Speedhub 500/14 by One year on the Giant Explore E+ 2 with a Rohloff Speedhub 500/14 – Jeremy Cole https://blog.jcole.us/2023/02/20/upgrading-a-giant-explore-e-2-with-the-rohloff-speedhub-500-14/#comment-58858 Sun, 18 Feb 2024 05:48:18 +0000 http://blog.jcole.us/?p=1480#comment-58858 […] thought since it’s been exactly a year since I upgraded my Giant Explore E+ to a Rohloff Speedhub 500/14 internal gear hub, that it’s a good time for an update. As for stats: I have put 5,180+ miles on this bike […]

]]> Comment on A guide to cleaning up in Seattle (and elsewhere) by Molly https://blog.jcole.us/2023/04/02/a-guide-to-cleaning-up-in-seattle-and-elsewhere/#comment-58856 Fri, 16 Feb 2024 04:54:59 +0000 http://blog.jcole.us/?p=1539#comment-58856 This is so heartening!

Thank you for your work.

]]>