Jean-François Gagné
@jfg956.bsky.social
System / Infrastructure Engineer and MySQL Expert, blogger, tech. speaker, cyclist, runner, scuba-diver instructor, Québécois, French, and Canadian.
Montréal Area, Québec, Canada
https://linktr.ee/jfg.mysql
Montréal Area, Québec, Canada
https://linktr.ee/jfg.mysql
Reposted by Jean-François Gagné
MySQL Belgian Days 2026 - registration is now open 🐬🇧🇪✍️ eventreg.oracle.com/profile/web/... #MySQLCommunity #MySQL
December 4, 2025 at 5:14 PM
MySQL Belgian Days 2026 - registration is now open 🐬🇧🇪✍️ eventreg.oracle.com/profile/web/... #MySQLCommunity #MySQL
Reposted by Jean-François Gagné
preFOSDEM ⚙️ #MySQL 🐬 Belgian Days 🇧🇪 📆 Call for Papers is now open: sessionize.com/prefosdem-my... #MySQLCommunity #CfP
November 27, 2025 at 10:32 AM
preFOSDEM ⚙️ #MySQL 🐬 Belgian Days 🇧🇪 📆 Call for Papers is now open: sessionize.com/prefosdem-my... #MySQLCommunity #CfP
Reposted by Jean-François Gagné
Save the dates 📆 the #MySQL Belgian Days 🐬 🇧🇪 2026 will take place in Brussels, 29 & 30 January 2️⃣0️⃣2️⃣6️⃣ - Stay tuned for more info and CfP 📄 #MySQLCommunity
October 31, 2025 at 5:42 PM
Save the dates 📆 the #MySQL Belgian Days 🐬 🇧🇪 2026 will take place in Brussels, 29 & 30 January 2️⃣0️⃣2️⃣6️⃣ - Stay tuned for more info and CfP 📄 #MySQLCommunity
Thanks to @mcrauwel.bsky.social for becoming a Gold member of Planet for the MySQL Community on Buy Me a Coffee !
buymeacoffee.com/planetmysqlc...
buymeacoffee.com/planetmysqlc...
Planet for the MySQL Community is a blog / news aggregator for the MySQL Community / Ecosystem.
(also the temporary support page for Planet for the Valkey Community, see below)Thanks for your interest in Planet for the MySQL Community: a blog / news aggregator for the MySQL Community / Ecosystem
buymeacoffee.com
October 27, 2025 at 1:25 PM
Thanks to @mcrauwel.bsky.social for becoming a Gold member of Planet for the MySQL Community on Buy Me a Coffee !
buymeacoffee.com/planetmysqlc...
buymeacoffee.com/planetmysqlc...
Bi-Yearly reminder that Europe and North America are not changing time on the same date. 1 of 3
October 26, 2025 at 9:13 PM
Bi-Yearly reminder that Europe and North America are not changing time on the same date. 1 of 3
In my latest blog post series, I explain the source a #MySQL crash, reference bugs that would have made things better, and mention a feature of #MariaDB which avoids that crash and improves performance (another feature would have made recovery quicker).
jfg-mysql.blogspot.com/2025/06/inte...
jfg-mysql.blogspot.com/2025/06/inte...
Interesting Troubleshooting of a MySQL Crash : filling then freeing the disk
I recently troubleshoot an interesting MySQL crash, and I think it is worth sharing (with the related bugs). MySQL crashed when the disk wa...
jfg-mysql.blogspot.com
June 5, 2025 at 8:19 PM
In my latest blog post series, I explain the source a #MySQL crash, reference bugs that would have made things better, and mention a feature of #MariaDB which avoids that crash and improves performance (another feature would have made recovery quicker).
jfg-mysql.blogspot.com/2025/06/inte...
jfg-mysql.blogspot.com/2025/06/inte...
I used Bitly (free) in the past to provide short URLs, but I am now disappointed to see they are not as transparent as before (showing a preview, probably mostly promoting themselves). I am now moving to TinyURL.
June 4, 2025 at 12:45 PM
I used Bitly (free) in the past to provide short URLs, but I am now disappointed to see they are not as transparent as before (showing a preview, probably mostly promoting themselves). I am now moving to TinyURL.
If you are running #MySQL 8.0, you might want to consider setting innodb_doublewrite_pages to 128 (it is the new default in 8.4). My latest blog post explains why.
jfg-mysql.blogspot.com/2025/04/perf...
jfg-mysql.blogspot.com/2025/04/perf...
Performance Regression in MySQL 8.0, Fixed in 8.4, Easy Workaround (innodb_doublewrite_pages)
While doing benchmarks on 5.7 and 8.0, I came across a performance regression in MySQL 8.0 over 5.7 and opened a bug ( Bug #111353 : 3x Perf...
jfg-mysql.blogspot.com
April 30, 2025 at 2:17 PM
If you are running #MySQL 8.0, you might want to consider setting innodb_doublewrite_pages to 128 (it is the new default in 8.4). My latest blog post explains why.
jfg-mysql.blogspot.com/2025/04/perf...
jfg-mysql.blogspot.com/2025/04/perf...
I recently submitted a #MySQL Contribution for adding Counters for Slow InnoDB Sync Reads, and I wrote a RFC Blog Post about it. I welcome feedback in the post of in the Contrib / RFC Fake PR (link in the post).
jfg-mysql.blogspot.com/2025/03/cont...
jfg-mysql.blogspot.com/2025/03/cont...
Contrib RFC: Counters for Slow InnoDB Sync Reads
I just submitted a MySQL Contribution and I would like to gather feedback about it. Depending on the received feedback, I might submit an u...
jfg-mysql.blogspot.com
March 25, 2025 at 3:52 PM
I recently submitted a #MySQL Contribution for adding Counters for Slow InnoDB Sync Reads, and I wrote a RFC Blog Post about it. I welcome feedback in the post of in the Contrib / RFC Fake PR (link in the post).
jfg-mysql.blogspot.com/2025/03/cont...
jfg-mysql.blogspot.com/2025/03/cont...
Reposted by Jean-François Gagné
Reposted by Jean-François Gagné
The agenda for the preFOSDEM MySQL Belgian Days is now available! 🗓️ 🐬 🇧🇪 buff.ly/3PtLvUh #MySQL #MySQL30 🎂 #MySQLDays
January 9, 2025 at 4:48 PM
The agenda for the preFOSDEM MySQL Belgian Days is now available! 🗓️ 🐬 🇧🇪 buff.ly/3PtLvUh #MySQL #MySQL30 🎂 #MySQLDays
If Canada becomes part of the US, like the orange-hair bozo is repeating ad nauseam, ex-Canadians living abroad will have to pay taxes to Washington (currently not paying to Ottawa) and thick the box "US Citizen" in bank forms and more, which complicates everything ! #NotAGoodDeal
January 8, 2025 at 8:51 PM
If Canada becomes part of the US, like the orange-hair bozo is repeating ad nauseam, ex-Canadians living abroad will have to pay taxes to Washington (currently not paying to Ottawa) and thick the box "US Citizen" in bank forms and more, which complicates everything ! #NotAGoodDeal
If you will attend your first #FOSDEM this year, or want to know more about this Open Source Conference happening on the 1st weekend of February each year in Brussels, this is a good summary (from 2017, but mostly still accurate).
lwn.net/Articles/715...
lwn.net/Articles/715...
Reflections on FOSDEM [LWN.net]
lwn.net
January 8, 2025 at 8:20 PM
If you will attend your first #FOSDEM this year, or want to know more about this Open Source Conference happening on the 1st weekend of February each year in Brussels, this is a good summary (from 2017, but mostly still accurate).
lwn.net/Articles/715...
lwn.net/Articles/715...
Reposted by Jean-François Gagné
Added descriptions of the SQL isolation level anomalies P0, P1, P2, and P3 to the phenomena page: https://jepsen.io/consistency/phenomena#sql
December 22, 2024 at 9:03 PM
Added descriptions of the SQL isolation level anomalies P0, P1, P2, and P3 to the phenomena page: https://jepsen.io/consistency/phenomena#sql
It was reminded to me, via @lefredbe.bsky.social interview on ODBMS.org, that #MySQL will be 30 years-old in 2025. I think I still have the t-shirt from 10 years ago, I will try bringing it in Brussels for FOSDEM.
www.odbms.org/2024/11/on-m...
www.odbms.org/2024/11/on-m...
On MySQL Belgian Days 2025. Q&A with Frederic Descamps – ODBMS.org
www.odbms.org
November 29, 2024 at 4:22 PM
It was reminded to me, via @lefredbe.bsky.social interview on ODBMS.org, that #MySQL will be 30 years-old in 2025. I think I still have the t-shirt from 10 years ago, I will try bringing it in Brussels for FOSDEM.
www.odbms.org/2024/11/on-m...
www.odbms.org/2024/11/on-m...
Reposted by Jean-François Gagné
Hurry up! Tomorrow is the last day to submit your talk for #FOSDEM #MySQL Devroom 2025 www.mysqlandfriends.eu/post/fosdem-... #MySLCommunity 🐬 ✉️ 🏃♀️
November 29, 2024 at 11:46 AM
Hurry up! Tomorrow is the last day to submit your talk for #FOSDEM #MySQL Devroom 2025 www.mysqlandfriends.eu/post/fosdem-... #MySLCommunity 🐬 ✉️ 🏃♀️