logo
episode-header-image
Sep 2024
28m 34s

MySQL is having a bumpy journey

Hussein Nasser
About this episode

Fundamentals of Database Engineering udemy course https://databases.win MySQL has been having bumpy journey since 2018 with the release of the version 8.0. Critical crashes that made to the final product, significant performance regressions, and tons of stability and bugs issues. In this video I explore what happened to MySql, are these issues getting fixed? And what is the current state of MySQL at the end of 2024. 0:00 Intro 2:00 MySQL 8.0 vs 5.7 Performance 11:00 Critical Crash in 8.0.38, 8.4.1 and 9.0.0 15:40 Is 8.4 better than 8.0.36? 16:30 More Features = More Bugs 22:30 Summary and my thoughts resources https://x.com/MarkCallaghanDB/status/1786428909376164263 https://www.percona.com/blog/do-not-upgrade-to-any-version-of-mysql-after-8-0-37/ http://smalldatum.blogspot.com/2024/09/mysql-innodb-vs-sysbench-on-large-server.html https://www.percona.com/blog/mysql-8-0-vs-5-7-are-the-newer-versions-more-problematic/

Up next
Sep 11
Caching is a cop-out
In this episode I explore why you should take some time to examine the operation you are caching before doing so. And why caching is a cop-out 
15m 41s
Aug 23
How open ai agents "hacked" hugging face
How open ai agents "hacked" hugging face 
17m 57s
Jul 10
How a query optimization gave birth to infinite scroll
The infinite scroll in social media as we know it today is despised by all. But it always start as a bad idea. It originated as a result of UI change to relief the backend database from inefficient queries. I explore this in this episode of the backend engineering. 0:00 Intro1:00 ... Show More
21m 20s
Recommended Episodes
Oct 2022
Going From Transactional To Analytical And Self-managed To Cloud On One Database With MariaDB
<div class="wp-block-jetpack-markdown"><h2>Summary</h2> <p>The database market has seen unprecedented activity in recent years, with new options addressing a variety of needs being introduced on a nearly constant basis. Despite that, there are a handful of databases that continu ... Show More
52m 4s
Jan 2024
Episode 159 - Select * Wastes Money
Guy and Eitan discuss various practices in SQL Server that hurt performance and possibly waste money, negative VarDecimal numbers, renumbering Identity columns, and the new Azure Database Fleet Manager. Relevant links: SQL Server IN Clause With Multiple Literal Values Performance ... Show More
37m 55s
Jun 2023
Ariga is helping developers define database schema as code
As companies look to update their databases, especially in a cloud native context, with so many different databases out there, it’s a huge challenge for developers when migrating from one environment to another. Learn more about your ad choices. Visit podcastchoices.com/adchoices 
4m 6s
Aug 2024
Episode 166 - DR Planning for SQL Server and Loading Large CSV Files
Guy and Eitan discuss the recent CrowdStrike incident and what it would mean for DBAs, and discuss options to load huge CSV files into SQL Server as fast as possible. Relevant links: 101 of Troubleshooting SQL Server on Linux - Microsoft Community Hub bcp utility - SQL Server | M ... Show More
35m 32s
Nov 2023
ChatGPT's GPT Store is Facing Issues
In this episode, we delve into the recent complications plaguing ChatGPT's GPT Store, analyzing the technical difficulties and user experience concerns. We'll explore potential causes and impacts of these issues on both the platform and its users. Invest in AI Box: https://republ ... Show More
8m 20s
Dec 2019
Rerun: Bad Computer Bugs
Software bugs range from annoying to catastrophic. It's time to explore some of the most famous flaws in computer history! Learn more about your ad-choices at https://www.iheartpodcastnetwork.comSee omnystudio.com/listener for privacy information. 
44m 39s
Apr 2023
Surviving SVB's Collapse & Outsmarting Uber | Kyte's Nick Cobb
<p>It hasn&apos;t been smooth sailing for startups this year. As this week&apos;s guest Nick Cobb puts it &quot;You can add bank runs to the list of things founders have to deal with.&quot; Of course, it hasn&apos;t been easy going for engineering leaders either. <br/><br/>That&a ... Show More
46m 11s
Mar 2023
51: How to Solve Any Data Analytics Error You Face...
<p>Let&#39;s face it; data analytics can sometimes be a real pain in the spreadsheet.</p> <p>You spend hours analysing data, writing code, and crafting reports, only to have one mystery bug stop your work from progressing.</p> <p>I&#39;ll show you my 10-step guide for solving ANY ... Show More
18m 19s
Jul 2020
3 Things That Shouldn't Be Normal in Database Development
Many people use entrenched processes for database development that have been in place so long that it's hard to imagine doing it any other way. In this episode, I share three things that should NOT be normal for database development-- but which are incredibly common. This episode ... Show More
28m 12s