41554 blogs · [ { "id": "01a0878d-adc6-7127-b3c0-b3d1412597b0", "title": "MySQL 8.0.17 GTID Crash Safety Improvement", "url": "https://jfg-mysql.blogspot.com/2026/08/mysql-8017-gtid-crash-safety-improvement.html", "published_at": "2026-08-04T22:22:16+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b916d8ffc", "title": "Understanding MySQL Replication \"fatal error 1236\": \"Replica has more GTIDs than the source has, using the source's SERVER_UUID\"", "url": "https://jfg-mysql.blogspot.com/2026/08/understanding-mysql-replication-fatal-error-1236.html", "published_at": "2026-08-03T22:12:29+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b91c8437d", "title": "MySQL Best Practice : not using date / time types, nor ENUM", "url": "https://jfg-mysql.blogspot.com/2026/07/best-practice-no-timestamp-nor-enum.html", "published_at": "2026-07-30T15:46:44+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b91f2bb00", "title": "Do not uselessly grant CREATE and ALTER TABLE", "url": "https://jfg-mysql.blogspot.com/2026/06/do-not-uselessly-grant-create-and-alter-table.html", "published_at": "2026-06-20T22:52:52+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b92179a63", "title": "Inserting in Two Tables in a Single Round-Trip with JSON Duality Views in MySQL 9.7", "url": "https://jfg-mysql.blogspot.com/2026/06/inserting-in-two-tables-in-single-round-trip.html", "published_at": "2026-06-04T14:17:32+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b92fd4aeb", "title": "Symlinks are Unsafe since MySQL 8.0.39 (and maybe even before)", "url": "https://jfg-mysql.blogspot.com/2026/04/symlinks-are-unsafe-in-mysql.html", "published_at": "2026-04-14T19:53:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b9373aca4", "title": "Thanks AWS Open Source", "url": "https://jfg-mysql.blogspot.com/2026/04/thanks-aws-open-source.html", "published_at": "2026-04-07T20:11:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b93b89589", "title": "Binary Log Compression is Safe since MySQL 8.0.34", "url": "https://jfg-mysql.blogspot.com/2026/03/binlog-compression-now-safe.html", "published_at": "2026-03-26T20:41:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b93c7c6e9", "title": "Row Deletion Jobs Done Right", "url": "https://jfg-mysql.blogspot.com/2026/03/row-deletion-jobs-done-right.html", "published_at": "2026-03-05T13:39:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b9429c793", "title": "Mind the InnoDB Purge on Queue / Row Deletion Job (else slow queries)", "url": "https://jfg-mysql.blogspot.com/2026/03/mind-the-innodb-purge-on-queue-or-row-deletion-job-else-slow-queries.html", "published_at": "2026-03-02T19:47:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b943e430a", "title": "More than Flushing (also Caching) for innodb_flush_method, and Missing Release Candidate", "url": "https://jfg-mysql.blogspot.com/2026/02/more-than-flushing-also-caching-for-innodb-flush-method-and-missing-release-candidate.html", "published_at": "2026-02-25T20:57:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b94e36b10", "title": "Undo Log Truncation Bug in 8.0 leads to Data Corruption", "url": "https://jfg-mysql.blogspot.com/2026/01/undo-log-truncation-bug-in-80-leads-to-data-corruption.html.html", "published_at": "2026-01-05T22:23:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b95c51ee4", "title": "Slack is a Suboptimal Feed Reader (RSS / Atom)", "url": "https://jfg-mysql.blogspot.com/2025/11/slack-suboptimal-feed-reader.html", "published_at": "2025-11-25T13:33:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b95cd81b7", "title": "Interesting Troubleshooting of a MySQL Crash : filling then freeing the disk", "url": "https://jfg-mysql.blogspot.com/2025/06/interesting-troubleshooting-crash-filling-then-freeing-disk.html", "published_at": "2025-06-04T12:08:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b9624b886", "title": "Interesting Binary Logging Optimization in MariaDB", "url": "https://jfg-mysql.blogspot.com/2025/05/interesting-binlog-optimization-in-mariadb.html", "published_at": "2025-05-26T22:50:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b96e7821b", "title": "Performance Regression in MySQL 8.0, Fixed in 8.4, Easy Workaround (innodb_doublewrite_pages)", "url": "https://jfg-mysql.blogspot.com/2025/04/performance-regression-in-mysql-80-fixed-in-84-easy-workaround.html", "published_at": "2025-04-28T19:41:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b97c12cda", "title": "Contrib RFC: Counters for Slow InnoDB Sync Reads", "url": "https://jfg-mysql.blogspot.com/2025/03/contrib-rfc-counters-for-slow-innodb-sync-reads.html", "published_at": "2025-03-18T15:16:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b983a134d", "title": "InnoDB Tablespace Duplicate Check Threads (and EBS Volumes for MySQL Startup with Many Tables)", "url": "https://jfg-mysql.blogspot.com/2024/11/innodb-tablespace-duplicate-check-threads.html", "published_at": "2024-12-03T15:29:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b9918ea3c", "title": "Problematic Improved Offline Mode Error in MySQL 9", "url": "https://jfg-mysql.blogspot.com/2024/12/problematic-improved-offline-mode-error-in-mysql-9.html", "published_at": "2024-12-02T19:03:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b99b6515e", "title": "The Light MySQL Startup Optimization on EBS Volumes", "url": "https://jfg-mysql.blogspot.com/2024/11/the-light-mysql-startup-optimization-on-ebs-volumes.html", "published_at": "2024-11-26T15:44:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b9aa72240", "title": "Understanding InnoDB Tablespace Duplicate Check (MySQL Startup with Many Tables)", "url": "https://jfg-mysql.blogspot.com/2024/11/understanding-innodb-tablespace-duplicate-check.html", "published_at": "2024-11-19T16:53:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b9ac41857", "title": "Long and Silent / Stressful MySQL Startup with Many Tables", "url": "https://jfg-mysql.blogspot.com/2024/11/long-and-silent-stressful-mysql-startup.html", "published_at": "2024-11-11T21:20:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b9b161bf8", "title": "Impressed by Disabling InnoDB Redo Logging for Creating Tables as Fast as Possible", "url": "https://jfg-mysql.blogspot.com/2024/10/impressed-by-disabling-innodb-redo-logs.html", "published_at": "2024-10-28T19:50:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b9b920d1b", "title": "Faster MySQL Startup with Many Tables (1M+)", "url": "https://jfg-mysql.blogspot.com/2024/09/blog-post.html", "published_at": "2024-09-03T15:39:00+00:00" }, { "id": "01a0878d-adc7-73ae-a551-ec2b9c030dd5", "title": "Trick to Simulate Higher Latency IOs on Linux", "url": "https://jfg-mysql.blogspot.com/2024/06/trick-to-simulate-higher-latency-ios-on-linux.html", "published_at": "2024-06-28T18:52:00+00:00" } ] posts Claim your blog

Back to jfg-mysql.blogspot.com

Blog · corpus.blog/blogs/jfg-mysql.blogspot.com/posts

jfg-mysql.blogspot.com

jfg-mysql.blogspot.com

2026

MySQL 8.0.17 GTID Crash Safety Improvement original ↗

4 Aug 2026

Understanding MySQL Replication "fatal error 1236": "Replica has more GTIDs than the source has, using the source's SERVER_UUID"original ↗

3 Aug 2026

MySQL Best Practice : not using date / time types, nor ENUM original ↗

30 Jul 2026

Do not uselessly grant CREATE and ALTER TABLE original ↗

20 Jun 2026

Inserting in Two Tables in a Single Round-Trip with JSON Duality Views in MySQL 9.7 original ↗

4 Jun 2026

Symlinks are Unsafe since MySQL 8.0.39 (and maybe even before)original ↗

14 Apr 2026

Thanks AWS Open Source original ↗

7 Apr 2026

Binary Log Compression is Safe since MySQL 8.0.34 original ↗

26 Mar 2026

Row Deletion Jobs Done Right original ↗

5 Mar 2026

Mind the InnoDB Purge on Queue / Row Deletion Job (else slow queries)original ↗

2 Mar 2026

More than Flushing (also Caching) for innodb_flush_method, and Missing Release Candidate original ↗

25 Feb 2026

Undo Log Truncation Bug in 8.0 leads to Data Corruption original ↗

5 Jan 2026

2025

Slack is a Suboptimal Feed Reader (RSS / Atom)original ↗

25 Nov 2025

Interesting Troubleshooting of a MySQL Crash : filling then freeing the disk original ↗

4 Jun 2025

Interesting Binary Logging Optimization in MariaDB original ↗

26 May 2025

Performance Regression in MySQL 8.0, Fixed in 8.4, Easy Workaround (innodb_doublewrite_pages)original ↗

28 Apr 2025

Contrib RFC: Counters for Slow InnoDB Sync Reads original ↗

18 Mar 2025

2024

InnoDB Tablespace Duplicate Check Threads (and EBS Volumes for MySQL Startup with Many Tables)original ↗

3 Dec 2024

Problematic Improved Offline Mode Error in MySQL 9 original ↗

2 Dec 2024

The Light MySQL Startup Optimization on EBS Volumes original ↗

26 Nov 2024

Understanding InnoDB Tablespace Duplicate Check (MySQL Startup with Many Tables)original ↗

19 Nov 2024

Long and Silent / Stressful MySQL Startup with Many Tables original ↗

11 Nov 2024

Impressed by Disabling InnoDB Redo Logging for Creating Tables as Fast as Possible original ↗

28 Oct 2024

Faster MySQL Startup with Many Tables (1M+)original ↗

3 Sept 2024

Trick to Simulate Higher Latency IOs on Linux original ↗

28 Jun 2024