Recently I was asked a question: Why am I getting utf8mb4_0900_ai_ci as the default collation in MySQL 8, despite setting the server to use utf8mb4_general_ci? With the upgrade to MySQL…
The post MySQL 8 utf8mb4_0900_ai_ci collation confusion first appeared on Change Is Inevitable.
In this podcast, we’ll explore the issue of duplicate indexes in MySQL; including redundant index, foreign keys, left-prefixed secondary index /w primary key, and how to tackle the issue at…
The post Podcast: Duplicate Indexes in MySQL first appeared on Change Is Inevitable.
Hello, readers! I’m excited to announce the launch of my latest project: a dedicated MySQL Podcast! As a long-time MySQL enthusiast with extensive hands-on experience in database management, I understand…
The post MySQL Podcast – Practical Learning & Training first appeared on Change Is Inevitable.
In the world of database management, efficiency is key. MySQL’s change buffer is a powerful feature that helps optimize how secondary index changes are managed. The idea of introducing a…
The post MySQL Change Buffer – What When and FAQ first appeared on Change Is Inevitable.
We usually receive and see some questions regarding the charset levels in MySQL, especially after the deprecation of utf8mb3 and the new default uf8mb4. If you understand how the charset works on MySQL but have some questions regarding this change, please check out Migrating to utf8mb4: Things to Consider by Sveta Smirnova. Some of the […]
MySQL is the most popular database server – odds are your website is using MySQL to store its data. Sometimes ...
The post How to Log Into Remote MySQL Server appeared first on RoseHosting.
Learn how to safely change primary keys in MySQL using pt-online-schema-change. This blog highlights tips to avoid data loss during online alter of primary key.
The post How to avoid data loss in MySQL Primary Key change first appeared on Change Is Inevitable.
I encountered this error, “Error in my_thread_global_end(): xx threads didn’t exit“, while working on MySQL benchmarking using sysbench. In this blog I’ll share my experience, reveal the fix, and help…
The post MySQL Benchmarking and error in my_thread_global_end() first appeared on Change Is Inevitable.
MySQL 8 is around us for 5 years now. I believe you’re surely considering an upgrade. But if you’re on AWS and still on an older version of MySQL, this…
The post How to save money in AWS RDS – Upgrade to MySQL 8 first appeared on Change Is Inevitable.
In this blog I share how MySQL binary logs get their unique numbers after noting my observations with MySQL binary logs sequencing. Recently I noted an odd binary log sequencing…
The post How MySQL Binary Log Gets Its Number first appeared on Change Is Inevitable.